What is DBMS?
DBMS stands for Database Management System. DBMS is made up of two words Database and Management System.
DBMS = Database + Management System
Database is a collection of data and Management System is a set of programs to store and retrieve those data.
A DBMS is a software that allows creation, definition and manipulation of database. DBMS is actually a tool used to perform any kind of operation on data in database. DBMS also provides protection and security to database. It maintains data consistency in case of multiple users. A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information. Here are some examples of popular DBMS, MySql, Oracle, Sybase, Microsoft Access and IBM DB2 etc.
Database is a collection of inter-related data which helps in efficient retrieval, insertion and deletion of data from database and organizes the data in the form of tables, views, schemas, reports etc. For Example, university database organizes the data about students, faculty, and admin staff etc. which helps in efficient retrieval, insertion and deletion of data from it. And data is a collection of facts and figures that can be processed to produce information.
There are five major components in the database system environment and their interrelationship are:-
A DBMS has the following characteristics :−
1. Real-world entity
2. Relation-based tables
3. Isolation of data and application
4. Less redundancy
6. Query Language
7. ACID Properties (Atomicity, Consistency, Isolation, and Durability)
8. Multi-user and Concurrent Access
9. Multiple views