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
Database Management System
CS3492 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation