Database Management Software is a package of software that has the ability to control computer programs that involves creation, maintenance as well as use of the database. It permits numerous group to create and develop databases for several applications. The database can be collaborated with data record, files and other objects. It permits multiple users to spontaneously access the same database. There are several database models namely relational model and object model. It can provide solution for query languages since it is also designed as high level programming languages. It also gives solution in controlling data access, enforcing data integrity, managing concurrency control and ability in recovering the database after several failures. It has the ability to restore back up file and maintain the security and privacy of the database.
The DBMS is located at the core of most database applications. There are database servers that can hold the actual databases and run only the application as well as related software. DBMS is usually built around the custom multi tasking kernel that can support numerous networks.
The software is composed of DBMS engine wherein it has the ability to accept request from the subsystems and change then into physical equivalent. Data definition subsystem is the component in which it helps the users to generate and maintain data dictionary and define the composition of the file in a certain database. Data manipulation subsystem allows the users to add, change, delete information in the database and question it to gain information.
