Can someone explain column-oriented databases in simple terms?

[Charles joneУчастник]

For those who are new to data architecture, your first question is: What are columnar databases and why are they used? In other words, they only store values for the same field in the same record in the same place in the record set. In this way, all the ages of the customers could be stored in one list, and the names stored in another list. This is a good structure if, say, analytical queries require just a few columns from very large data sets. Can decrease the amount of data to read, often enhancing compression. These are, therefore, frequently used in analytics, reporting and data warehouse applications.

[Автор]

Сообщения