18
Functionality of a DBMS
•The programmer sees SQL, which has two components:
•Data Definition Language - DDL
•Data Manipulation Language - DML
–query language
•
•Behind the scenes the DBMS has:
•Query optimizer
•Query engine
•Storage management
•Transaction Management (concurrency, recovery)