Database management system is a computer program that controls the creation, maintenance, and use of a database. With the help of this system different user application programs can access the same database. In large systems, a DBMS allows users and other software to store and retrieve data in a structured way. A DBMS also provides the ability to logically present database information to users.
There are several components which makes up the DBMS and those are given below:
The Database Engine is used for storing, processing, and securing data. It also has controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming applications. Database engine can be used to create relational databases for online transaction processing which includes creating tables for storing data, and database objects such as indexes, views, and stored procedures for viewing, managing and securing data.
Data Definition Subsystem
This helps the users to create and maintain the data dictionary and define the structure of the files in a database. A data dictionary is a set of table and views which can only be read and these can’t be altered. A data dictionary stores the information related to the organization.
Data Manipulation Subsystems
This helps the users to add, change and delete information in a database and query it for valuable information. It allows the user to specify its logical information requirements.
Application Generation Subsystems
It helps the users to develop transaction intensive applications in a business and also it facilitates easy to use data entry screens, programming languages and interfaces.
Data Administration Subsystems
These subsystems provides facilities for backup and recovery, security management, query optimization, concurrency control, and change management and helps the users to manage overall database environment.
It is a program that is used to extract information from one or more files and presents the information in a specified format. These allow the users to select records that meet certain conditions and to display selected fields in rows and columns.
Database management system is very important for a business. This system eases all the data related functions of the organization.