A column-oriented DBMS stores data tables by column rather than by row, allowing for more efficient access to data when querying a subset of columns and providing more options for data compression. However, they are typically less efficient for inserting new data. Both columnar and row databases can be used with traditional database query languages like SQL and can serve as the backbone in a system for ETL and other tools.
Carnegie Mellon University
Fall 2016
This course introduces databases, data models, SQL, database design, query optimization, indexing, and transaction management. It aims to impart understanding of when and how to use database management systems. The course is heavily based on the textbook "Database Management Systems" by Raghu Ramakrishnan and Johannes Gehrke.
No concepts data
+ 20 more conceptsUC Berkeley
Fall 2021
A graduate survey of systems managing computation and information. Topics include volatile and persistent memory management, system support for networking, security infrastructure, extensible systems, APIs, and large software system performance analysis. Students are expected to engage in quality systems research, culminating in a publishable group project.
No concepts data
+ 31 more concepts