CS346 Lecture Notes
DBMS Architecture Review, RedBase Overview
General picture of where a DBMS sits:
What you'll build in this class:
Closer look at DBMS, File System, and Disk:
Components of DBMS:
Missing from figure:
- Query results returned to User/Application
- Buffer Manager or Index/Record Managers call Concurrency Control
- Separate Table Manager
- Many, many (many!) details...
RedBase architecture:
Legend:
- PF: Paged File
- RM: Record Management
- IX: Indexing
- SM: System Management (DDL, utilities)
- QL: Query Language
- EX: Extension
Correspondence between RedBase and DBMS components:
- PF = Storage Manager + Buffer Manager
- RM = Record Manager
- IX = Index Manager
- SM = DDL Processor (+ misc. utilities)
- QL = Query Checker, Query Optimizer (simple), Execution Engine
- Command parser = Query Parser
Not in RedBase:
- Transaction Manager, Concurrency Control, Recovery, System Log
- Statistics, real query optimization