lec 3 Storing Data.pptVIP

* * * * * * * * * * * * * * * * * * Page Formats: Variable Length Records Can move records on page without changing rid; so, attractive for fixed-length records too. Page i Rid = (i,N) Rid = (i,2) Rid = (i,1) Pointer to start of free space SLOT DIRECTORY N . . . 2 1 20 16 24 N # slots Data Area Free Space slot’s format: record offset, record length 0 8 16 24 Slotted page: a detailed view What’s the biggest tuple you can add? Needs 2 bytes of slot space x bytes of storage 4 8 0 4 2 13 Pointer to start of free space Slot directory # of slots System Catalogs For each