Three Level Architecture of DBMS
The generalized architecture of a database system is called ANSI/SPARC model. Many commercial systems and research database models fit within this framework. This architecture is also called Three-Level Architecture of DBMS.
The Three Level Architecture of DBMS is shown below:
It can divided into the following three levels :
External or View level:
The external or view level of the architecture of a Database system is the level closest to the users. This level is concerned with how the data are observed, So, most of the users of the database are not concerned with all the information contained in the database.
It describes that different types of data stored in a database. This level also includes the relationships existing among data items. At this level, a database is also described logically rather than physically in terms of data structure. However, users of this level are not concerned with how these logical data structures will be implemented at the physical level. Rather, they are only concerned about what information would be kept in a database.
The lowest level of abstraction is the internal level. It is the one closest to the physical storage device. So, it is also termed as physical level, because it describes how data are stored on the storage medium such as hard disk, magnetic tape, etc.
1. Types of DBMS
2. Role of Database Administrator
3. Three Level Architecture
4. Comparison Between Hierarchical model Network model Relational model
5. Entity Relationship Diagram | ER Model
6. Codd’s Rules
7. Different Types of Keys in DBMS
8. Normalization in DBMS: 1NF, 2NF, 3NF and BCNF
9. Relational Algebra
10. Transaction States in DBMS
11. ACID Properties of Transactions
12. Armstrong’s Axioms