- Tech know how online

columnar database

In the column-oriented database system, data is stored in columns instead of rows. The goal of this arrangement is to efficiently write data to and read data from a hard disk. The columnar arrangement can increase read and write speed

, and database queries can be accelerated. In a columnar database

, the column contents are directly comparable and belong to each other row by row. Individual terms can be assigned to the columns. For example, the product name, the price, the delivery time, etc. An advantage offered by such a columnar representation is that the data can be compressed, for example, by means of mathematical functions such as the sum, the maximum, the minimum, the mean value and many other functions. In addition, columnar storage requires less memory than a relational database.

Informationen zum Artikel
Englisch: columnar database
Updated at: 11.11.2016
#Words: 89