Training Trains Internship
Student login
← Advanced DBMS learning path
Advanced DBMS · Module 1 of 10

DBMS architecture recap

Revisit how a database system is built inside.

📖 Key ideas

  1. A DBMS has a query processor, storage manager, transaction manager and buffer manager.
  2. Three-schema architecture: external, conceptual, internal.
  3. Data independence: logical and physical.
  4. Catalog (data dictionary) stores metadata.
  5. Advanced topics: optimisation, concurrency, recovery, distribution.
💡 Real-life example: A DBMS is a big library: librarians (query processor), shelves (storage) and a register (catalog).
Query processorParses and executes queries
Buffer managerCaches disk pages in memory
Data dictionaryMetadata store
Data independenceChanging one level without affecting others