DBMS (Database Management Systems) 💻
Database Management Systems (DBMS) are software systems that store, retrieve, and execute data queries. A database management system (DBMS) acts as a bridge between an end-user and a database, allowing users to create, read, edit, and remove data in the database.
A. Function of DBMS
- Data Definition - The database management system (DBMS) must be able to accept data definitions (external and internal) and mental schemas, as well as any associated mappings) in original form and transform to the proper object form.
- Data Manipulation - The DBMS must be capable of handling user requests to retrieve data and maybe updating existing data in the database or adding new data to the database.
- Data Security and Integrity - The DBMS must be able to monitor user requests and reject inappropriate efforts to circumvent the security and integrity tests outlined in the Administrator of a database.
- Data Recovery and Concurrency - The DBMS must be able to recover from or minimize the
effects of a system crash.
- Data Dictionary - The DBMS must include a system database known as the database dictionary
B. Advantages of DBMS
- Reduced Data Redundancy - Data redundancy is minimized in database systems by preserving a single duplicate of each record.
- Data Integrity - Because the database only stores a single copy of a certain piece of data, you may be confident. Ensure that all future uses of the data will reflect the changes to the data
- Data Independence - The database system's structure requires that data be independent of other data in the database as well as the software used to access the database.
- Data Security - Additional security measures can be implemented as part of a database system. Product for database software.
- Data Consistency - Data consistency is maintained in the database environment.
- Easier use of data - Data is more easily accessible in a database system.
- Less Storage - Because data redundancy is reduced, if not eliminated, the database will take up less space.
C. Disadvantages of DBMS
- Complexity - Databases and their accompanying database management systems (DBMS) are exceedingly complicated.
- Expense - The DBMS and its databases are installed on the current system. Because of the likelihood of the need for more resources, cautious preparation is required.
- Vulnerability - Because data in a database is stored in a central area, it is subject to partial or complete loss. Total destruction occurs when hardware components fail or are in an Error in the software.
- Size - A typical mainframe database is very large
- Training Costs - When a corporation buys a database product, it must first train one or more employees. Individuals to serve as the new product's database administrator.
- Compatibility - One of the disadvantages of most database systems is their interoperability with other systems.
- Locking-in of Technology - What happens if the vendor announces a wish to discontinue the product? There is one. It is possible that they will have to completely rethink their system.


No comments:
Post a Comment