Question 4 (15 pts) Below you can find the component modules of a DBMS and their interactions. (1) In your own words, explain the role of query compiler, query optimizer and runtime database processor. (2) Explain the functionality of System Catalog/Data Dictionary and why the metadata are important for query and transaction execution. Users: DBA Staff Casual Users Parametric Users Application Programmers DDL Statements Privileged Commands Interactive Query Application Programs DDL Compiler Query Compiler Precompiler Host Language Compiler Query Optimizer DML Compiler Compiled Transactions DBA Commands, Queries, and Transactions Runtime Database Processor Stored Data Manager System Catalog/ Data Dictionary Concurrency Control/ Backup/Recovery Subsystems Stored Database Input/Output from Database Query and Transaction Execution: Question 5 (15 pts) Most DBMS have database utilities that help database administration staff manage databases. List five database utility tool functionalities. Find real examples for each of these utility tools and provide links to those tools. Question 4 (15 pts) Below you can find the component modules of a DBMS and their interactions. (1) In your own words, explain the role of query compiler, query optimizer and runtime database processor. (2) Explain the functionality of System Catalog/Data Dictionary and why the metadata are important for query and transaction execution. Users: DBA Staff Casual Users Parametric Users Application Programmers DDL Statements Privileged Commands Interactive Query Application Programs DDL Compiler Query Compiler Precompiler Host Language Compiler Query Optimizer DML Compiler Compiled Transactions DBA Commands, Queries, and Transactions Runtime Database Processor Stored Data Manager System Catalog/ Data Dictionary Concurrency Control/ Backup/Recovery Subsystems Stored Database Input/Output from Database Query and Transaction Execution: Question 5 (15 pts) Most DBMS have database utilities that help database administration staff manage databases. List five database utility tool functionalities. Find real examples for each of these utility tools and provide links to those tools
