Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Grab it
Explore a comprehensive lecture on database storage models and data layout from Carnegie Mellon University's Advanced Database Systems course. Delve into various storage models, including row storage, decomposition storage, and column stores. Examine page layouts, memory page sizes, and data representation techniques. Learn about handling decimals, floating-point numbers, and fixed-point precision. Discover strategies for storing nulls, implementing updates, and managing delta stores in column-oriented databases. Gain insights from Professor Andy Pavlo's expertise in this in-depth exploration of database storage concepts.
Database Storage Models and Data Layout - Lecture 3