Week 02 Lecture
Storage Management
Storage Management
Views of Data
Storage Management Topics
Storage Manager Interface
From Symbolic to Internal
Ex1: Table Statistics
Ex2: Extracting a Schema
Ex3: More accurate tuple counts
Storage Manager
DBMS Storage Manager
Storage Technology
Disk Management
File Management
DBMS File Organisation
Single-file DBMS
Single-file Disk Manager
Example: Scanning a Relation
Ex4: Relation Scan Cost
PostgreSQL Storage Manager
Relations as Files
Ex5: PostgreSQL Files
File Descriptor Pool
File Manager
Buffer Pool
Buffer Pool
Ex6: Buffer Pool Functions
Produced: 7 Mar 2016