October 24, 2019
Amitraj
Components of DBMS
DBMS can be divided into five major components:-
1. Hardware
2. Software
3. Data
4. Procedures
5. Database Access Language
Diagram to see how they all fit together to form a database management system.
1. Hardware -
Hardware is the one of the most important component of DBMS system. It refers to all of the system’s physical devices like computers (PCs, workstations, servers, and supercomputers), storage devices, printers, network devices (hubs, switches, routers, fiber optics),and other devices (automated teller machines, ID readers, and so on).
2. Software -
This is the main component, as this is the program which controls everything. The DBMS software is more like a wrapper around the physical database, which provides us with an easy-to-use interface to store, access and update data.
The DBMS software is capable of understanding the Database Access Language and intrepret it into actual database commands to execute them on the DB.
3. Data -
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.
4. Procedures -
Procedures refer to general instructions to use a database management system. This includes procedures to setup and install a DBMS, To login and logout of DBMS software, to manage databases, to take backups, generating reports etc.
5. Database Access Language -
Database Access Language is a simple language designed to write commands to access, insert, update and delete data stored in any database.
A user can write commands in the Database Access Language and submit it to the DBMS for execution, which is then translated and executed by the DBMS.
User can create new databases, tables, insert data, fetch stored data, update data and delete the data using the access language.
DBMS can be divided into five major components:-
1. Hardware
2. Software
3. Data
4. Procedures
5. Database Access Language
Diagram to see how they all fit together to form a database management system.
1. Hardware -
Hardware is the one of the most important component of DBMS system. It refers to all of the system’s physical devices like computers (PCs, workstations, servers, and supercomputers), storage devices, printers, network devices (hubs, switches, routers, fiber optics),and other devices (automated teller machines, ID readers, and so on).
2. Software -
This is the main component, as this is the program which controls everything. The DBMS software is more like a wrapper around the physical database, which provides us with an easy-to-use interface to store, access and update data.
The DBMS software is capable of understanding the Database Access Language and intrepret it into actual database commands to execute them on the DB.
3. Data -
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.
4. Procedures -
Procedures refer to general instructions to use a database management system. This includes procedures to setup and install a DBMS, To login and logout of DBMS software, to manage databases, to take backups, generating reports etc.
5. Database Access Language -
Database Access Language is a simple language designed to write commands to access, insert, update and delete data stored in any database.
A user can write commands in the Database Access Language and submit it to the DBMS for execution, which is then translated and executed by the DBMS.
User can create new databases, tables, insert data, fetch stored data, update data and delete the data using the access language.
