What are the three levels of
architecture in Database management system?
There are three levels of architecture in DBMS. Database Management
system divided into three types of categories. The three levels of architecture
are uses to better understanding with their different levels in the DBMS models.
These three levels are explained in a short description.
The three levels are categorized of DBMS model following below.
- External level
- Conceptual Level
- Internal level
External Level
- This is the level is also known as View level.
- This level interacts with users directly.
- It is the closest level to the users.
- Users can understand with this level about the DBMS model.
- It is also called Graphical interface level.
- In database, data are observed by the individuals.
- There are so many views in a view level category. Every viewer can
observe only their own database about their information or personal information
of the user.
How do you understand by
View level in the DBMS?
- The external level can show of the user database interface from the database
management system model.
- The user or client can understand their data or information from the
whole database.
- Client view their only own information from the database of the system
or organization.
- The viewer can control their own information or database from the system
which the user or viewer has taken the permission from the system. Such as change
their user identity name and password etc.
- Viewer have an authority to deactivate your identity from the system as
system and their under of terms and conditions.
- The terms and conditions is also a part of view level or external level
of the database for the client, user or viewer. These terms and conditions
cannot be changed without the permission of the admin of the database
management system of organization or system.
Conceptual level
- It is also known as logical view level of database.
- It describes the different types of data are stored in a database.
- The level of indication is to show their relationships between data.
- This concerned about what are the information stored in the database in
any model of the database.
Internal level
- It is known as physical level of the database.
- You can stores the database in the storage devices.
- It is the level is very closest to the storage devices.
- You can stores the database in the devices such as Hard disk, SSD, Pen drive
etc.
Comments
Post a Comment