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. | Key | Row Oriented Database | Column 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 |