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
Database Management System: Unit IV: Implementation Techniques
Under Subject
Database Management System
CS3492 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation
Related Subjects
Environmental Sciences and Sustainability
GE3451 ESS 4th Semester | 2021 Regulation | 4th Semester EEE Dept 2021 Regulation
Theory of Computation
CS3452 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation
Artificial Intelligence and Machine Learning
CS3491 4th Semester CSE/ECE Dept | 2021 Regulation | 4th Semester CSE/ECE Dept 2021 Regulation
Database Management System
CS3492 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation
Algorithms
CS3401 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation
Introduction to Operating Systems
CS3451 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation