What is Database Management System? Explain the DBMS architecture with a diagram. What is data independence?

Question

Suresh Chand · Accepted Answer

Database Management Systems (DBMS) are software systems used to store, retrieve, and run queries on data. A DBMS serves as an interface between an end-user and a database, allowing users to create, read, update, and delete data in the database. DBMS Architecture: The Database Management System (DBMS) architecture shows how data in the database is viewed by the users. It is not concerned about how the data are handled and processed by the DBMS. It helps in the implementation, design, and maintenance of a database to store and organize information for companies. The concept of DBMS depends upon its architecture. The architecture can be designed as centralized, decentralized, or hierarchical. The architecture of DBMS can be defined at three levels as follows − External levels. Conceptual levels. Internal levels. The main objective of the three-level architecture is nothing but to separate each user view of the data from the way the database is physically represented. The database's internal structure should be unaffected while changes to the physical aspects of storage. The DBA should be able to change the conceptual structure of the database without affecting all other users. External level/ View level: The external level describes a part of the database that is relevant to each user. This level insulates the users from the details of the conceptual and the internal level. Conceptual level/ logic level: The conceptual level describes what data is stored in the database and the relationship among the data. It represents the following − All the entities, attributes, and relationships. The constraints on the data. Security and integrity information. Internal level/ storage level: The internal level is the physical representation of the database on the computer. This level describes how the data is stored in the database. It covers the data structure and file organization used to store the data on storage devices. The levels in the architecture of DBMS are shown below in diagram form − Data independence Definition: Data Independence is defined as a property of DBMS that helps you to change the Database schema at one level of a database system without requiring you to change the schema at the next higher level. Data independence helps you to keep data separated from all programs that make use of it.

What is Database Management System? Explain the DBMS architecture with a diagram. What is data independence?

Leave your Answer:

Hits Counter

Question

What is Database Management System? Explain the DBMS architecture with a diagram. What is data independence?

Leave your Answer: