Introduction To DBMS

What is DBMS?

DBMS is a Database Management System. As the name suggests, it is a system used for the management of databases. A database is a collection of data belonging to an organization. For example, a company database might include data related to its Employees, Departments, Payroll, etc.

A Database Management System is a general-purpose software system that allows the users to construct the database, analyze the data, maintain the data in the database, share the database among various users and applications, and much more. In short, DBMS allows us to create, define and manipulate the database. Examples of DBMS: Microsoft SQL Server, Microsoft Access, MySQL, Oracle, IBM DB2, etc.

In the above diagram, there are 4 components: Queries, DBMS, Operating System, and Database.

The queries are the user's or application's requests to get some data from the database or modify some data in the database.

The queries are not directly communicated to the database. DBMS acts as an intermediate agent which communicates the queries to the database via the operating system.

Benefits of using DBMS over traditional file management systems:

1. A DBMS allows us to maintain a centralized repository of data; the data is integrated. In the case of a traditional file management system, the data is not that integrated. The data may be stored in Hierarchical Files.  
2. The management of data is much more easier and convenient in the DBMS.  
3. The data can be accessed across multiple locations at the same time, and concurrency conflicts can be effectively handled in DBMS.  
4. Traditional files have unnecessary redundant data, while the redundant data is reduced in the DBMS due to centralized storage and access control.  
5. The update, deletion and retrieval of data is much faster in DBMS. Also, the Database structure can be easily altered. In case of File System, the alteration of the structure is not that easy.