Column-Oriented Veri Tabanı

Giriş

Açıklaması şöyle. Column-Oriented Veri Tabanı örneklerinden bazıları Apache Cassandra ve Apache HBase

There are two types of data storage databases one is a row-oriented database and another one is a column-oriented database.

Row-Oriented (ACID Transactions): They are databases that organize data by the record, keeping all of the data associated with a record next to each other in memory. Row-oriented databases are the traditional way of organizing data and still provide some key benefits for storing data quickly. They are optimized for reading and writing rows efficiently.

Common row-oriented databases:

- PostgreSQL

- MySQL

Column-Oriented (Analytics): They are databases that organize data by field, keeping all of the data associated with a field next to each other in memory. Columnar databases have grown in popularity and provide performance advantages to querying data. They are optimized for reading and computing on columns efficiently.

Common column-oriented databases:

- AWS RedShift

- Google BigQuery

- HBase

İlişkisel veri tabanı eklen şöyle. 

Ama Column-Oriented veri tabanı şeklen şöyle. Kısaca her bir sütünün tüm değerlerini bir satırda topluyor gibi düşünülebilir. 

Şeklen şöyle