- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Difference between Row oriented and column oriented 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. | 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 |
- Related Questions & Answers
- Differentiate between block-oriented and character-oriented devices in UNIX
- Difference between Connection-oriented and Connection-less Services
- Character - Oriented Framing and Bit - Oriented Framing
- Differences between Procedural and Object Oriented Programming.
- Distinguish between Connection-Oriented and Connectionless Service
- Differences between Connection-oriented and Connection-less Services.
- What is the difference between Object oriented programming and Object based programming?
- Object Oriented language v/s Procedure oriented programming language.
- Connection-Oriented Services
- Object-Oriented Databases
- Comparison between E-R Model and Object Oriented Model
- Object-oriented Data Model
- Object Oriented Programming in Python?
- Synchronous Connection-Oriented (SCO) Link
- Implementation of connection-oriented services