Database Storage Models and Data Layout - Lecture 3

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.

Syllabus

Introduction
Agenda
Storage Models
Page Layout
Row Storage
Decomposition Storage Models
Fixed Length All Sets
Column Store History
Pros Cons
Partition Attributes Across
Horizontal Partition
Memory Page Sizes
Huge Pages
Transparency Pages
TLB
Representation
Decimals
Floating Point Numbers
Fixed Point Precision Numbers
Fixed Point Project
Postgres
Extra Source Code
Add Function
Nulls
Storing Nulls
Display
MemSQL
Updates
Fraction Mirrors
Mirror Copy
Delta Store
Column Store