Database Management System (DBMS) – Components, Advantages, and Disadvantages
A Database management system (DBMS) is software designed to manage and maintain large quantities of data. The DBMS serves as the mediator between the user and the database. The database structure itself is stored as a collection of files. The data in these files can only be accessed through the DBMS. A single, integrated view of the data in the database is shown to the user by the DBMS. All application requests received by the DBMS are translated into complex operations required to fulfill these requests. The database’s internal complexity is hidden by the DBMS from the application programs and users. The application program might be written by a computer programmer using a programming language, such as Visual Basic, NET, Java, or C#, or it might be created through a DBMS utility program. Components of a Database Management System A data definition language (DDL) allows users to define the database. Continue reading