A wide column store is a type of NoSQL database. It uses tables, rows, and columns, but unlike a relational database, the names and format of the columns can vary from row to row in the same table. A wide column store can be interpreted as a two-dimensional key-value store.
As such two-level structures do not use a columnar data layout, wide column stores such as Bigtable and Apache Cassandra are not column stores in the original sense of the term. In genuine column stores, a columnar data layout is adopted such that each column is stored separately on disk. Wide column stores do often support the notion of column families that are stored separately. However, each such column family typically contains multiple columns that are used together, similar to traditional relational database tables. Within a given column family, all data is stored in a row-by-row fashion, such that the columns for a given row are stored together, rather than each column being stored separately. Wide column stores that support column families are also known as column family databases.
Video Wide column store
Example Databases
Some example Wide Column Stores include:
- Bigtable
- Apache Cassandra
- Apache HBase
- Apache Accumulo
- Hypertable
- ScyllaDB
- Sqrrl
- Azure Tables
Maps Wide column store
References
Source of the article : Wikipedia
0 Comments