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:

• Query results returned to User/Application
• Buffer Manager or Index/Record Managers call Concurrency Control
• Separate Table Manager
• Many, many (many!) details...

RedBase architecture:

• 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