Discuss the advantages of a database system.
Database Management System > Introduction to DBMS > Need of a database
1237
Answer:
The main advantage of DBMS is centralized data management where the data are stored at a centralized location and are shared among multiple users. The centralized nature of the database system provides several advantages, which overcome the limitations of the conventional file-processing system. These advantages are as follows:
Controlled data redundancy: During database design, various files are integrated, and each logical data item is stored at a central location. This eliminates replicating the data item in different files, and ensures consistency and saves the storage space.
Enforcing data integrity: In the database approach, enforcing data integrity is much easier. Various integrity constraints are identified by the database designer during the database design.
Data sharing: The data stored in the database can be shared among multiple users or application programs. Due to shared data, it is possible to satisfy the data requirements of the new applications without having to create any additional data or with minimal modification.
Ease of application development: The application programmer develops the application programs according to the needs of the users. The other issues like concurrent access, security, data integrity, etc. are handled by the DBMS itself. This makes application development an easier task.
Data security: The DBMS ensures that the only means of access to the database is through an authorized channel. To ensure security, a DBMS provides security tools such as user codes and passwords.
Multiple user interfaces: DBMS provides different types of interfaces such as query languages, application program interfaces and graphical user interfaces (GUI) that include forms-style and menu-driven interfaces.
Backup and recovery: The DBMS provides a backup and recovery subsystem, which is responsible for recovery from hardware and software failures.
In addition to centralized data management, DBMS also has some other advantages as follows:
Program-data independence: The independence between the programs and the data is known as program-data independence. It allows changing the structure of the database without making any changes in the application programs that use the database.
Data abstraction: The property of DBMS that allows program-data independence is known as data abstraction. Data abstraction allows the database system to provide an abstract view of the data to its users without giving the physical storage and implementation details.
Supports multiple views of the data: A database can be accessed by many users and each of them may have a different perspective or view of the data. A database system provides a facility to define different views of the data for different users. A view is a subset of the database that contains virtual data derived from the database files but it does not exist in physical form.
This Particular section is dedicated to Question & Answer only. If you want learn more about Database Management System. Then you can visit below links to get more depth on this subject.
Join Our telegram group to ask Questions
Click below button to join our groups.
