Skip to content

Latest commit

 

History

History
61 lines (42 loc) · 2.36 KB

03. Database Management System.md

File metadata and controls

61 lines (42 loc) · 2.36 KB

DATABASE MANAGEMENT SYSTEM

DBMS UTILITES

1 DATA ORGANIZATION
Structured approach to store data in tables, rows, and columns
Reduces redundancy and improves data access

2 DATA RETRIEVAL
Powerful querying capabilities using SQL or other languages
Quick and efficient retrieval of specific information

3. DATA STORAGE
Efficient management of data storage on disk or in memory
Optimized storage format to save space and improve retrieval times

4. DATA INTEGRITY AND CONSISTENCY
Enforces data integrity constraints (e
g
, primary keys, foreign keys)
Maintains accurate and reliable data

5. DATA SECURITY
Access control mechanisms to restrict data access to authorized users
Protects sensitive information from unauthorized access

6. CONCURRENT ACCESS
Allows multiple users to access the database simultaneously
Manages concurrent access through locking and transaction management

7. DATA BACKUP AND RECOVERY
Mechanisms for data backup and recovery
Protects data from hardware failures, disasters, or human errors

8. DATA SCALABILITY
Handles large amounts of data efficiently
Scales to accommodate growing data volumes

9. DATA MAINTENANCE
Simplifies data updates, insertion, and deletion
Ensures data remains up-to-date and accurate

10. DATA MODELING
Supports data modeling techniques for designing the database schema
Defines relationships between different data entities

11. DATA PERFORMANCE OPTIMIZATION
Optimizes data retrieval and storage operations
Efficient execution of queries and performance tuning

DIFFERENCE DBMS AND RDBMS

image image image image image image