What is a Database Management System - What is DBMS - Introduction of DBMS
What is Database Management System (DBMS)?
- A database management system (DBMS) is system software designed for the creation and administration of databases.
- It enables end users to perform operations like creating, securing, reading, updating, and deleting data within a database.
- As the predominant form of data management platform, the DBMS functions as an intermediary between databases and users or application programs, ensuring consistent organization of data and facilitating easy accessibility.
![sql-intro](https://wikitechy.com/cdn/tutorials/sql/dbms.png)
What does a DBMS do?
- DBMS manages data
- Database engine enables data access, locking, and modification
- Database schema defines logical structure
- Ensures concurrency, security, and data integrity
- Facilitates standardized data administration procedures
- Manages tasks like change management, performance monitoring, security, and backup and recovery
- Handles automated rollbacks, restarts, and logs and audits activities
- Maintains consistency in both databases and connected applications