Learn online DBMS “What is Database Management System (DBMS)” Lesson 3
Database Management System (DBMS)
A database management system is a collection of programs that enables users to create, maintain and use a database.It can be viewed as a repository of data that is defined once and then accessed by different users as per their requirements. In the Database approach,there is a single repository of data which is accessed by all the application programs as shown in the example below:
The various operations that need to be performed on a database are as follows:
1. Defining the database – It involves specifying the data type of data that will be stored in the database and also any constraints on that data.
2. Populating the database – It involves storing the data on some storage medium that is controlled by DBMS.
3. Manipulating the database – It involves modifying the database, retrieving data or querying the database, generating reports from the database etc.
4. Sharing the database – Allow multiple users to access the database at the same time.
5. Protecting the database – To protect the database from software and hardware failures and also protecting it from unauthorized access.
6. Maintain the database – Adapt to the changing requirements.
Some examples of DBMS are – MySQL, Oracle, DB2, IMS, IDS etc.