Database Management System: Unit IV: Implementation Techniques

Column Oriented Storage

Implementation Techniques - Database Management System

Column oriented storage which is also called as columnar database management system that stores data in columns rather than rows.

Column Oriented Storage

Column oriented storage which is also called as columnar database management system that stores data in columns rather than rows.

The advantage of column oriented storage is to retrieve the result of query very efficiently.

It also improves disk I/O performances.

Example –

As column oriented database store data by columns instead of rows, it can store more data in smaller amount of memory.

The data retrieval is done column by column only the columns that need to be required are retrieved. This makes it possible for efficient retrieval of data. Also, large amount of data can be handled.

It is mainly used in data analytics, business intelligence and data warehousing.

Database Management System: Unit IV: Implementation Techniques : Tag: : Implementation Techniques - Database Management System - Column Oriented Storage