Difference between Row oriented and column oriented database

Database

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

Row oriented database is traditional database like Oracle ,MySql and etc. It stores data table by row and common method of storing a table is to serialize each row of data. Row-based systems are designed to efficiently return data for an entire row, or record.

On the other hand, column based database are "No SQL" database such as HBase and Cassandra. Column oriented databases do not support "traditional" transactional secondary indices. It is the responsibility of the user to maintain "inverted index"

Sr. No.KeyRow Oriented DatabaseColumn Oriented Database

1

Basic 

 It stores data table by row.

It stores data table by column.

2

Data Accessing 

Data accessing happens row by row 

Data accessing happens column by column

3

Storage 

Storage size optimization limited due to reduced ability of data compression in row based systems

Column based systems provide better storage size optimization capabilities.

4.

Performance 

It takes longer time than column oriented database because it requires multiple disk read 

It is faster than row oriented database 

5.

Use Case 

Best suited for OLTP

Best suited for OLAP


raja
Published on 21-Jan-2020 11:54:50
Advertisements