N-ary Storage Model: Page and Record Formats

This lecture covers the N-ary Storage Model (NSM) focusing on page and record formats. It explains the concept of pages as collections of slots, each storing a record. The lecture delves into fixed-length and variable-length record formats, discussing the storage of schema in the system catalog and the use of field offsets for direct access. Additionally, it explores the challenges of managing free space and moving records within a page, highlighting the implications of record size exceeding page size. The storage hierarchy and the trade-offs between different storage technologies are also discussed.