Week 02 Lectures
Storage Manager
Storage Management
Views of Data in Query Evaluation
Storage Management
Storage Technology
Storage Technology
Cost Models
File Management
DBMS File Organisation
Single-file DBMS
Single-file Storage Manager
Example: Scanning a Relation
Single-File Storage Manager
Ex1: Relation Scan Cost
DBMS Parameters
Multiple-file Disk Manager
PostgreSQL Storage Manager
Relations as Files
Ex2: PostgreSQL Files
File Descriptor Pool
File Manager
Buffer Pool
Buffer Pool
Page Replacement Policies
Effect of Buffer Management
Ex3: Buffer Cost Benefit (i)
Ex4: Buffer Cost Benefit (ii)
PostgreSQL Buffer Manager
Produced: 12 Jun 2019
![[index]](icon/up.gif){kind=icon}