Explain in short the Columnar database

 Posted by Niladri.Biswas on 12/11/2012 | Category: Others Interview questions | Views: 1735 | Points: 40

Column-oriented NoSQL databases espouses a model where data in stored in a column-oriented way. This contrasts with the row-oriented format in RDBMS. The column-oriented storage allows data to be stored effectively. It avoids consuming space when storing nulls by simply not storing a column when a value doesn’t exist for that column. Each unit of data can be thought of as a set of key/value pairs, where the unit itself is identified with the help of a primary identifier, often referred to as the primary key or Row-Key.Also units are stored in an ordered-sorted manner. The units of data are sorted and ordered on the basis of the row-key.
Column family databases are still extremely scalable but less-so than key-value stores. However, they work better with more complex data sets.
Examples of Column family databases are: Apache HBase,Hypertable,Cassandra, Google’s Bigtable etc.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response