Summary of Wide-Column Databases

Some of wide-column databases advantages and disadvantages.

Compared to row-oriented databases, wide columnar stores show the following advantages:

Don't use plagiarized sources. Get Your Custom Essay on
Summary of Wide-Column Databases
Just from $13/Page
Order Essay

• A better data compression: this is because, wide-column databases stores the repeated column values as a single column value and stores columns in the most used format.

• An enhanced use of bandwidth and cache: unlike relational databases, wide-column databases only read the required data from the disk. So, no extra data or columns are read. In addition, only the required data is put in the cache locality.

• A better code pipelining: wide-column databases consume the CPU cycle performance only for the required data attributes.

However, wide columnar stores show the following weaknesses when compared to row-oriented databases:

• A bigger disk seek time: This is because large number of columns is read in parallel.

• An increased time for small inserts: in fact, wide-column databases need to update multiple values in multiple columns.

• An expanded time for tuple reconstructions: wide-column databases translate value position information into disk locations to reconstruct tuples. However, because they were not designed to reconstruct rows from multiple columns, this may compromise their advantages.


and taste our undisputed quality.