Components of Database Management Ssystem

Database Management System (DBMS) have several components, each performing very significant task in the database management system environment. Following are the component of DBMS and its environment

Software
Hardware
Data
Database Access Language
Query processor
Run time database Manager/Database control system
Data manager
Database engine
Data dictionary
Report writer/ generator

Table of Contents

Software

This is a set of program used to control and mange the overall database. This includes the DBMS software itself, the operating system itself, the network software used to share the data among users and application program used to access data in the DBMS.

Hardware

It consist of a set of physical electronic device such as computers ,I/O devices, storage devices etc. this provide the interface between computer and the real world system.

Data

The database contains both actual/operational data and the metadata.

Database access language

These is used to access the data to and form the database, to enter new data, update existing data and retrieve required data from database. the user write a set of appropriate commands in a database access language , submit these to the DBMS, which then process the data and generates and display as set of results into a user readable form. Example: SQL

Query Processor

This transforms the user queries into to a series of low level instructions. This reads the online user’s query translate it into an efficient series of operations in a form capable of being sent to the run time data manager for execution.

Run Time Database Manager/ Database control system

It is the central software component of the DMBS that interfaces with user-submitted application programs and queries and handle database access at run time. It provides control to maintain the consistency, integrity and security of the data.

Data Manager

The role of data manager is to handling of data in the database, providing a recovery to the system that allows it to recover the data after a failure.

Database Engine

The core service for storing , processing and securing data, this provides control access and rapid transaction processing to address the requirements of the most demanding data consuming application.

Data dictionary

This is a reserved space within a database used to store information about the database itself. A data dictionary is a set of read only table and views, containing a different information about the data used in the enterprises to ensure that database representation of the data follow one standard as defined in the dictionary.