Components of DBMS

Components of DBMS:

DBMS have several components, each performing very significant tasks in the database management system environment. Below is a list of components within the database and its environment.

1. Data:

Data is the most important component of the DBMS. DBMS exists to collect, store, process and access data, the most important component. The database contains both the actual or operational data and the metadata. User Data consists of table of data columns are attribute and rows are record. Metadata means description of structure of database. It means data about data.

2. Hardware:

Consists of a set of physical electronic devices such as computers, I/O devices, storage devices, etc., this provides the interface between computers and the real world systems.

3. Software:

This is the set of programs used to control and manage the overall database. This includes the DBMS software itself, the Operating System, the network software being used to share the data among users, and the application programs used to access data in the DBMS.

4. Users:

The users are the people who manage the databases and perform different operations on the databases in the database system. There are four kinds of people who play different roles in database system.

· DBA (Database Administrator)

· Database Designers

· End Users

·  Application Programmers

      5. Procedures:

Procedures refer to the instructions and rules that help to design the database and to use the DBMS. The users that operate and manage the DBMS require documented procedures on hot use or run the database management system. These may include procedure to install the new DBMS, to log on, to use to make backup copies to change the structure to generate the reports of data retrieved from database, etc.

6.  Database Access Language:

This is used to access the data to and from the database, to enter new data, update existing data, or retrieve required data from databases. The user writes a set of appropriate commands in a database access language, submits these to the DBMS, which then processes the data and generates and displays a set of results into a user readable form.

-profshardulp.patil@gmail.com