Loading, please wait...

Database Management System

The following are the main components of the DBMS are very large and typically divided into modules:-

DDL Compiler-: The DDL statements are sent to DDL compiler that interprets DDL statements to a set of tables containing metadata stored in a data dictionary that can be used by other components of the DBMS.

 

DML Compiler and Query Optimizer-: DML compiler interprets the Data Manipulation Languages into query Engine instructions. If the DML statements include the queries then it goes to query optimizer. Query optimizer translates statements in a query language into low-level instructions which the database manager understands easily.

 

Data Manager-: The data manager is the central software component of the Database management system. It is used to control the database. It provides the communication between the database and the application programs. Data manager convert the users request coming from directly through the query processor or through the application programs to a physical file system.

 

Data Dictionary-: It is a repository of description of knowledge in the database. A data dictionary contains a listing of all files within the database, the amount of records in each and every file and also the names and kinds of each field. Most database management systems keep the information dictionary hidden from users to stop them from accidentally destroying its content. Some of its functions like it defines the data element and helps in the scheduling and controlling.

 

Data Files-: It is used to store the database and it is an actual physical files which store the data or information.

 

Telecommunication System-: A modern client server is implemented via sophisticated network. It is the transmission of signs, signals, messages, words, writings, and images etc.

 

End user-: End Users are those people who interact with the database through applications.