Lect#10 Three-Level Architecture of DBMS | 3 level schema in DB

Опубликовано: 26 Май 2022
на канале: Learning Point

12,418

287

In this lecture we will discuss three-level architecture in detail as external level , conceptual level and internal level or physical level architecture.
what is three level architecture of dbms,three level architecture in dbms,three level schema,what is 3 level schema,three tier architecture,three tier schema,what three tier architecture in dbms,three level architecture in database,2 tier vs 3 tier architecture in dbms,database management system,exteranal level architecture,conceptual level architecture,internal level architecture,what is external conceptual and intenal level architecture,educational video,dbms,db
#dbms #databasemanagementsystem #learningpoint

External level architecture:
It is also called view level. The reason this level is called “view” is because several users can view their desired data from this level which is internally fetched from database with the help of conceptual and internal level mapping.
The user doesn’t need to know the database schema details such as data structure, table definition etc. user is only concerned about data which is what returned back to the view level after it has been fetched from database (present at the internal level).
External level is the “top level” of the Three Level DBMS Architecture.

Conceptual Level Architecture:
It is also called logical level. The whole design of the database such as relationship among data, schema of data etc. are described in this level.

Database constraints and security are also implemented in this level of architecture. This level is maintained by DBA (database administrator).

Internal Level Architecture/Schema
This level is also known as physical level. This level describes how the data is actually stored in the storage devices. This level is also responsible for allocating space to the data. This is the lowest level of the architecture.