Data Models and Architecture of a DBMS
Jagdish Chandra Patni, Hitesh Kumar Sharma, Ravi Pratap Singh Tomar, Avita Katal · 2021
A database architecture is a graphical depiction of a database management system (DBMS) design. It aids in the design, development, implementation, and upkeep of the DBMS. A DBMS design allows the database system to be divided into distinct components that may be adjusted, changed, replaced, and altered individually. It also aids in comprehending the components of a database. A database contains vital information and allows for rapid and safe data access. As a result, picking the proper DBMS architecture facilitates simple and effective data administration. The data model shows how the final system will look when it has been fully implemented. It defines the data pieces as well as the relationships between them. Data models are used to demonstrate how data is stored, linked, accessed, and changed in a DBMS. The chapter not only covers the history of data models but also covers the use of different data modes. The chapter covers the in-depth details about the different types of data models, its advantages and disadvantages, and the three-tier architecture of the database and concludes with the discussion of different languages used in a database.