A database is defined as an organized collection of related data and data is a collection of facts and figures that can be processed to produce information.
Database Management System or DBMS in short refers to the technology of storing and retrieving user’s data with utmost efficiency along with appropriate security measures. This tutorial explains the basics of DBMS such as its architecture, data models, data schemas, data independence, E-R model, relation model, relational database design, and storage and file structure, and much more. A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information.
The characteristics of DBMS are as follows.
Provides security and removes redundancy
Self-describing nature of a database system
Insulation between programs and data abstraction
Support of multiple views of the data
Sharing of data and multiuser transaction processing
DBMS allows entities and relations among them to form tables.
It follows the ACID concept (Atomicity, Consistency, Isolation, and Durability).
DBMS supports a multi-user environment that allows users to access and manipulate data in parallel.
Advantages of DBMS
DBMS offers a variety of techniques to store & retrieve data
DBMS serves as an efficient handler to balance the needs of multiple applications using the same data
Uniform administration procedures for data
Application programmers never exposed to details of data representation and storage.
A DBMS uses various powerful functions to store and retrieve data efficiently.
Offers Data Integrity and Security
The DBMS implies integrity constraints to get a high level of protection against prohibited access to data.
A DBMS schedules concurrent access to the data in such a manner that only one user can access the same data at a time
Reduced Application Development Time
Disadvantage of DBMS
The cost of Hardware and Software of a DBMS is quite high which increases the budget of your organization.
Most database management systems are often complex systems, so training for users to use the DBMS is required.
In some organizations, all data is integrated into a single database which can be damaged because of electric failure or the database is corrupted on the storage media.
