DBMS
- A high-level design goal of the DBMS is to support databases that exceed the amount of memory available.
- SQL Client
- Parsing & Database Query Optimization
- Relational Operators
- Purpose: Execute a dataflow by operating on records and files
- Files and Index Management
- Purpose: Organize tables and Records as groups of pages in a logical file
- DB File Management
- Buffer Management
- Provide the illusion of operating in memory
- Disk Space Management
- Translate page requests into physical bytes on one or more device(s)
- B+ Tree
- Database Index
Links
- External Sort
- Hashing
- SQL JOIN
- Database Query Optimization
- ACID
- Relational Database
- Document Database
- ORM
- Database Scheduling
- ER Model
- Database Architecture
- Postgresql
- SQL Window Function
- Database Transaction
- Database Buffer Pool
- Time Series Database
- Google F1
- Volcano Model
- Amplification
- CRDT
- Zipf Law