DBMS Database Management System
Definition of DBMS Database Management System – A Database Management System (DBMS) is a collection of Programs that enable user to store, modify, and extract data or information from a large or small database. The data base management systems are used in small personal computers to huge mainframe computers. DBMS is an intermediate layer between programs and the data. Programs access the DBMS, which then accesses the data. A database management system is a piece of software/ program that enable you to accessing a database, while maintaining all the essential features of the data. The Commercially available DBMS in the market are dbase, MySQL, SQL Servers, FoxPro, IMS and Oracle and DB2 etc.
Some of the important examples of DBMS applications are –
- Computerized library systems
- Flight reservation systems
- Computerised inventory machines
- Automated teller machines
- Railway reservation systems
Major Components involved in DBMS Environment
There are five major components which forms Database Management Systems environment. They are Hardware, Software, Data, Users and Procedures.
Hardware is used for keeping and accessing the database like Secondary Storage Device – Hard disks.
Software also called as DBMS Program which exhibits presence between hardware and users. The DBMS allows the users to communicate with their database. Or say it acts as the mediator between user and database. The DBMS is responsible for accessing and maintaining consistency of the data during operation.
The data involve the operational data, Meta data and data about data.
Users are the person who access data in different ways depending upon their access rights. There are no of users who can access or retrieve data on demand using the applications and interface provided by the DBMS. The different types of users are separated in terms of expertise, use and authorization. The different types of users are –
What are the different types of User in DBMS?
- Naïve Users – The naïve users are the end users who are not aware of the presence of the database system and work through a menu driven application program. The user using Automatic Teller Machine (ATM) for withdrawal of money fall under this category.
- Online Users – The users who access database through online terminal, user interface or via application program. These type of user know the presence of database system and have certain knowledge about database.
- Sophisticated Users – The users who interact with the database without writing any programs.
- Specialized Users – Those who write specialized database application that do not fit into the fractional data-processing framework. For example: Computer-aided design systems, knowledge base and expert system, etc.
- Database Administrator – The database administrator (DBA) is a person or group of person who implements the database system of an organization. The DBA has all the system privileges and rights which is allowed by the DBMS and can grant, remove levels of access to or from other users. DBA is responsible for the evaluation, selection and implementation of DBMS applications. DBMS Database Management System is a important concept involved during storing any data in computer hard drive.