Column-Stores vs. RowStores: How Different Are They Really?

There has been a significant amount of excitement and recent work on column-oriented database systems (“Column-stores”). These database systems have been shown to perform more than an order of magnitude better than traditional row-oriented database systems (“Row-stores”) on analytical workloads such as those found in data warehouses, decision support, and business intelligence applications. The elevator pitch behind this performance difference is straightforward: column-stores are more I/O efficient for read-only queries since they only have to read from disk (or from memory) those attributes accessed by a query.

Subscribe to the Data Insider Newsletter

Learn the latest news and best practices about data science, big data analytics, artificial intelligence, data security, and more. Delivered Mondays and Thursdays

Subscribe to the Data Insider Newsletter

Learn the latest news and best practices about data science, big data analytics, artificial intelligence, data security, and more. Delivered Mondays and Thursdays

Resource Details

Provided by:
Association for Computing Machinery
Topic:
Data Management
Format:
PDF