Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Explore the fundamental concepts of database storage architecture in this lecture from Carnegie Mellon University's Introduction to Database Systems course. Delve into the hierarchical organization of database storage, starting with how databases manage files at the operating system level and progressing through the structure of pages as the basic unit of data transfer between disk and memory. Learn about tuple organization within pages, including different storage models and layout strategies that optimize data access patterns. Examine various page layouts, slotted page structures, and how database management systems handle variable-length records and data alignment. Understand the trade-offs between different storage approaches and their impact on query performance, memory utilization, and overall system efficiency. Master the technical details of how modern database systems organize and access data at the lowest levels of the storage hierarchy.
