What is DBMS?
DBMS (database management system) refers to a software application used to access, create, and manage databases. Organizations use a large amount of data. DBMS makes it possible to organize data in a database, store and transform them into valuable information, and support making strategic decisions. The main functions provided by DBMS are:
- Data Dictionary Management: DBMS stores definitions of the data elements and their relationships (metadata) in a data dictionary.
- Data Store Management: DBMS system provides storage not only for the data but also for related data entry forms or screen definitions, report definitions, data validation rules, procedural code, structures to handle video and picture formats, etc.
- Data Transformation and Presentation: DBMS transforms entered data into the required data structures.
- Security Management: Security rules to determine the access rights of users and enforce security and data privacy.
- Backup and Recovery Management: Processes to back-up the data regularly and recover data if a problem occurs to ensure safety and integrity.
- Multiuser access control: DBMS ensures access to the database to multiple users concurrently, guaranteeing the database’s integrity.
- Data Integrity Management: DBMS enforces database structure and integrity rules.