7 Column Stores

A row store is a row-oriented relational database as it was reviewed in Section 2.1. That is, data are stored in tables and on disk the data in a row are stored consecutively. This row-wise storage is currently used in most RDBMSs. In contrast, a column store is a column-oriented relational database. That is, data are stored in tables but on disk data in a column are stored consecutively.

This chapter discusses column stores and shows that they work very well for certain queries – for example queries that can be executed on compressed data. In such cases, column stores have the advantage of both a compact storage as well as efficient query execution. Conversion of nested records into columnar representation is a further topic ...

Get Advanced Data Management now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.