DBMS Model Type and Steps in DBMS, Beginner Must Know

Software that manages and maintains logical integration between files, either explicit or implicitly called DBMS (database management system). The first well-known microcomputer-based DBMS is dBASE II, III and IV. DBMS development further focuses on the microcomputer market and has implemented a relational structure. Microsoft Access is an example of a relational database management system for microcomputers.

The database user can be a person or application program. People usually use a database from a terminal and retrieve data and information by using a query language. A query is a request for information from a database, and query language is a user friendly, user-friendly language that allows the computer to answer queries.

Seven steps in the DBMS:

• Data Manipulation Language (DML) determines what DBMS data is required.
• The DBMS checks the schema and subschema to test that the data exists in the database.
• The DBMS forwards the data request to the operating system.
• The DBMS retrieves the data and puts it into a special buffer storage area in primary storage.
• The data is transferred into the application program input area.
• The DBMS returns control to the application program.
• The application program uses data.

DBMS MODEL
Models that show the main elements of the DBMS are:

1. Data Description Language Processor, converts the data dictionary into a database schema. This is the DDL described earlier. all DBMS have DDL.
2. Performance Statistics Processor, maintains statistics that identify what data is being used, who uses it and so on. These statistics are used in managing databases. A microcomputer-based DBMS usually does not include this element.
3. Backup / Recovery Module, periodically created a backup of the database. In the event of a database crash, the database backup reconstructs the database. the backup / recovery module completes the reconstruction.
4. Database Manager, is the most important element because it handles user data requests. Query language and DML are part of the database manager. The database manager also generates performance statistics processed by performance statistics processors and all DBMSs include these elements.

Advertisement

Related Content: