Database Reference
In-Depth Information
Column-Family stores
A Column-Family store is another example of a very task-oriented type of solution.
The data model is a bit more complex than the Key-Value store, as it now includes the
concept of a very wide, sparsely populated table structure that includes a number of
families of columns that specify the keys for this particular table structure. Like the
Dynamosystem,Column-Familystoresalsooriginatedfromaveryspeciicneedofa
veryspeciiccompany(inthiscase,Google),whodecidedtorolltheirownsolution.
Google published their BigTable paper in 2006 at the
Operating Systems Design and
Implementation (OSDI)
symposium. The paper not only started a lot of work within
Google, but also yielded interesting open source implementations such as Apache
Cassandra and Hbase. In many cases, these systems are combined with batch-oriented
systemsthatuseMap/Reduceas the processing model for advanced querying.
Column Family Store
Database
T/SCF: Customers
ID: 1
CF/SC: Name
First Name: Andrew
T/SCF:
Orders
ID: 252
CF/SC: Price
Total: 300 USD
C:
C:
CF/SC: Items
Item 1: 56432
C:
CF/SC: Address
Street_Addr: 123 Main St.
Last_Name: Brust
C:
C:
C:
Item 2: 98726
C:
City: New York
ID: 265
CF/SC: Price
Total: 2,500 EUR
C:
State: NY
C:
CF/SC: Orders
Most recent_order: 252
Zip: 10014
C:
CF/SC: Items
C: Item 1: 86413
Item 2: 77904
C:
ID: 2
CF/SC: Name
First Name: N poleon
C:
C:
a
Last_Name: Bonaparte
C:
CF/SC: Address
Street: 2, Rue de Rivoli
C:
3
City: P ris
C:
a
PostalCode: 75007
C:
C:
CF/SC: Orders
Most recent: 265
Counter: France
C:
A simple Column-Family data model
