Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Explore column-oriented database storage architectures and compression techniques in this 81-minute lecture from Carnegie Mellon University's Introduction to Database Systems course. Learn how column stores differ from traditional row-oriented databases, understand the advantages and trade-offs of columnar storage for analytical workloads, and discover various database compression algorithms and their implementation strategies. Examine real-world applications of column stores in data warehousing and analytics, while gaining insights into how compression can significantly improve storage efficiency and query performance. Access comprehensive slides and detailed notes to reinforce your understanding of these fundamental database storage concepts taught by Professor Andy Pavlo.
