Hamish Burke | 2025-04-03

Related to: #databases

DBMS

• Contains
  • Transactions Mangaer
  • Query processor
    • Evaluation engine
    • Query Optimiser
    • Parser
  • Storage Manager

1. Query

SELECT name
FROM Person
WHERE age=21;

• Goes into parser
• Turned into Relational Algebra expression
• Then into query optimiser