A database management system (DBMS) is a software system used to facilitate the management of databases. A DBMS allows operations such as initializing, modifying, updating and deleting information stored in databases. Chapter 6 The key points in explaining the topic of Database Management System (DBMS) are:
- Database and DBMS Terminology: Database: It is an organized collection of data, eg: customer information, sales data. DBMS: Software used to manage databases. Examples: MySQL, Oracle, Microsoft SQL Server, PostgreSQL.
- Requirement of DBMS: To facilitate data archive and retrieval. More secure data management. Multiuser support. Reducing data redundancy. Maintaining data integrity and data consistency.
- DBMS Humor: Hardware: Servers and storage devices. Software: DBMS Applications. Data: Information generated by users. Users: Data Administrator: Database management. Application Programmer: Develops applications that use the DBMS. Enduser: User of information.
- DBMS Organizational Dimensions: Data Models: Hierarchical Model. Network Model. Relational Model. Object-Oriented Model (Object-Oriented Model).
- Relational DBMS: Stores data into tables. Primary Key and Foreign Key elements. Using SQL (Structured Query Language) for data management.
- Types of DBMS: Personal DBMS: For small database management. Enterprise DBMS: Large Scale Data Management. Distributed DBMS: Distributed data management across multiple locations.
- DBMS Facilities: Data Security: Protection from data theft and unauthorized access. Data Backup and Recovery: Quick recovery in case of data damage. Centralized Control: An administrator is assigned to control the data.
- Challenges of DBMS: High cost. The need for training. Big data increases the complexity to manage.
Conclusion:
DBMS software plays an important role in today’s digital age. It is the best solution for data security, quick decision making and adequate data management.