Row Store and Column Store Databases.md 1.1 KB
Title: "Row Store and Column Store Databases" Date: 2016-12-16 16:55:00 Categories: [data base] tags: [row store, column store]
Authors: sedlav
Row Store and Column StoreIn this blog post, we’ll discuss the differences between row store and column store databases... For some applications, a columnar database is a great choice; for others, you should stick with the tried and true row-based option.
At a basic level, row stores are great for transaction processing. Column stores are great for highly analytical query models. Row stores have the ability to write data very quickly, whereas a column store is awesome at aggregating large volumes of data for a subset of columns.
One of the benefits of a columnar database is its crazy fast query speeds. In some cases, queries that took minutes or hours are completed in seconds. This makes columnar databases a good choice in a query-heavy environment. But you must make sure that the queries you run are really suited to a columnar database.