请输入您要查询的百科知识:

 

词条 Column (data store)
释义

  1. Usage

  2. Differences from a relational database

  3. Examples

  4. See also

  5. References

A column of a distributed data store is a NoSQL object of the lowest level in a keyspace. It is a tuple (a key–value pair) consisting of three elements:[1]

  • Unique name: Used to reference the column
  • Value: The content of the column. It can have different types, like AsciiType, LongType, TimeUUIDType, UTF8Type among others.
  • Timestamp: The system timestamp used to determine the valid content.

Usage

A column is used as a store for the value and has a timestamp that is used to differentiate the valid content from stale ones. According to the CAP theorem, distributed data stores cannot guarantee consistency, as availability and partition tolerance are more important issues. Therefore, the data store or the application programmer will use the timestamp to find out which of the stored values in the backup nodes are up-to-date.

Some data stores, like Riak, may use the more sophisticated vector clock instead of the timestamp to resolve stale information.

Differences from a relational database

In relational databases, a column is a part of a relational table that can be seen in each row of the table. This is not the case in distributed data stores, where the concept of a table only vaguely exists. A column can be part of a ColumnFamily that resembles at most a relational row, but it may appear in one row and not in the others. Also, the number of columns may change from row to row, and new updates to the data store model may also modify the column number. So, all the work of keeping up with changes relies on the application programmer.

Examples

In JSON-like notation, three column definitions are given:

{
    street: {name: "street", value: "1234 x street", timestamp: 123456789},    city: {name: "city", value: "san francisco", timestamp: 123456789},    zip: {name: "zip", value: "94107", timestamp: 123456789},

}

See also

  • Super column

References

1. ^{{cite web |url=http://www.sinbadsoft.com/blog/cassandra-data-model-cheat-sheet/ |title=Cassandra’s data model cheat sheet § Column |last=Nakhli |first=Chaker |date=May 2, 2010 |website=Sinbadsoft |accessdate =October 28, 2017 |quote=A name value pair (contains also a time-stamp, not represented here for the sake of clarity).}}

1 : NoSQL

随便看

 

开放百科全书收录14589846条英语、德语、日语等多语种百科知识,基本涵盖了大多数领域的百科知识,是一部内容自由、开放的电子版国际百科全书。

 

Copyright © 2023 OENC.NET All Rights Reserved
京ICP备2021023879号 更新时间:2024/11/11 8:27:29