Typical DBMS Component Modules Flashcards
This Language is used by the DBA and the database designers to specify the description of the database.
Data Definition Language
This Language is used to specify database retrievals and updates.
Data Manipulation Language
What does CRUD stand for in the DML?
Create, Retrieve, Update, Delete
This language is used to control and provide levels of access privileges and authorization to database objects
Data Control Language
It is an interface that has the following feature:
- Stand-alone query language interfaces
- Programmer interfaces for embedding DML in programming languages
- User friendly Interface
- Menu based, popular for browsing the web
- Forms based, designed for naive users
- Graphics-based
- Natural language, requests written in english
- Combinations of above
- Speech as Input and Output
- Parametric interfaces, e.g., bank tellers using function keys
- Interface for the DBA
DBMS Interface
It processes DDL statements and stores databased description in the DBMS catalog
DDL Compiler
Its command is used only by the DBA or the DBA staff. These includes command for creating accounts, granting account authorization, changing database description
Privileged Commands
This compiler parses queries, analyzes queries for correctness of operations and names of data elements, and compiles them into an internal form.
Query Compiler
Concerned with the arrangement of possible reordering of operations, elimination of redundancies and use of correct algorithms during execution. This also generates executable code and makes call on the runtime processor
Query Optimizer
This extracts DML commands from an application program
Precompiler
This compiler parses DML statements and translates them into an object code.
DML Compiler
This compiler parses and compiles host language statements
Host Language Compiler
Canned transactions that is based on the object codes produced by the DML and the host language compiler
Compiled Transaction
It executes privilege commands, executable query plans, and canned transaction with runtime processors
Runtime Database Processor
Controls access to the information stores on the disk. It also interacts with the OS to carry put low-level inout/output operations between the disk and the main memory.
Stored Data Manager
