CS186: Introduction to Database Systems.
Catalog Description: Access methods and file systems to facilitate data access. Hierarchical, network, relational, and object-oriented data models. Query languages for models.
🗒️Content
- Architecture of DBMS
- Storage of DBMS: Table, File, Page and Record
- B+ Tree
- Buffer Management
- Relational Algebra
- External Sort: Tow Way External Merge Sort, Full External Sort
- External Hash
- Join
- Parallel Query
- Query Optimization