Hello World
Welcome to my blog, it represents all my experiences, and hindsight since my CS career started. P...4. Data Storage
Decomposing tables into pages, pages into slots, slots into fields Variable length content can b...5. Indexes Tress & Hash
Definition Binary search B+ tree indexes Average fanout (i.e., number of child nodes) is 133 trav...7. Operators
TermsQuery Processor Parser: parse query Rewriter: simplify query Query optimizer: generates opti...6. Processing Overview (Buffer Manager)
Decides when to move data between disk and RAM Reduce data movements using heuristics Buffer man...8. Query Optimizer
SQL Query => {Plan Enumeration, Query Optimizer, Cost Prediction} => Query Plan ...9. Transaction Manager
访问(并更新)数据库的一个程序执行单元 Transaction A sequence of updates (or queries) that is “connected” Two ope...Network
Constructing..Programming languages and logics
Constructing..1. DBMS
Database Management System Highlevel Manage data, allows applications to store, update and analy...
