Skip to main content
Home
  • Tutorials
    • Quality Assurance
    • Software Development
    • Machine Learning
    • Data Science
  • About Us
  • Contact
programsbuzz facebook programsbuzz twitter programsbuzz linkedin
  • Log in

Main navigation

  • Tutorials
    • Quality Assurance
    • Software Development
    • Machine Learning
    • Data Science
  • About Us
  • Contact

DBMS: Three Level Architecture

Profile picture for user arilio666
Written by arilio666 on 06/02/2021 - 10:10

In this article, we are going to learn about an architecture for database systems called the three-level/schema architecture that helps achieve the characteristics of the database approach.

With the help of three schema architecture, we will also learn the concept of data independence.

DBMS Three Level Architecture Diagram

DBMS Three Level Architecture Diagram

  • The goal of these three schema/level architecture is to separate the user applications and physical database.
  • The user application is at the topmost level of the database system.
  • And the physical database is at the lowest level.

The database schemas are represented in 3 levels

  1. The first level is the Internal level.
  2. The Second level is the Conceptual level.
  3. The first level is the External level.

1. Internal Level

  • This internal level has an internal schema and this schema describes the physical storage structure of the database.
  • This internal schema uses one of the categories of data models that is the low level or the physical data models.
  • It uses that physical data model to describe complete details of how data is stored and the access paths for the database.

2. Conceptual Level

  • This describes the structure of the database.
  • This schema hides the details of the physical storage structure of the database and concentrates or focuses more on describing entities, data types, relationships, constraints, attributes.
  • So that is about the conceptual level.

3. External Level

  • The topmost level that we have in our three schema architecture is the external level.
  • The external level has several external schemas or external views and each external schema describes the part of the database that a user is interested in and hides the rest of the database from the user group.
  • An external schema or view contains only that data which a user group is interested in and hides the remaining database from that particular user group.
  • so this level has a view for each user group.
  • so this is about the three levels and because it has three levels it is called three schema architecture here in the three schema architecture each user refers to its external schema so any request specified in the external schema is sent to the conceptual schema by the DBMS and further that request is sent to the internal schema for processing
  • if the request from the user is the retrieval of data from the database then data is extracted from the stored database this process of transforming requests and results between these three levels is called mapping.

To conclude, The three schema architecture breaks the database down into three different categories, describes the structure of a specific database system, and the three schema architecture is used to separate the user applications and physical database.

Tags
DBMS
  • Log in or register to post comments

Choose Your Technology

  1. Agile
  2. Apache Groovy
  3. Apache Hadoop
  4. Apache HBase
  5. Apache Spark
  6. Appium
  7. AutoIt
  8. AWS
  9. Behat
  10. Cucumber Java
  11. Cypress
  12. DBMS
  13. Drupal
  14. GitHub
  15. GitLab
  16. GoLang
  17. Gradle
  18. HTML
  19. ISTQB Foundation
  20. Java
  21. JavaScript
  22. JMeter
  23. JUnit
  24. Karate
  25. Kotlin
  26. LoadRunner
  27. matplotlib
  28. MongoDB
  29. MS SQL Server
  30. MySQL
  31. Nightwatch JS
  32. PactumJS
  33. PHP
  34. Playwright
  35. Playwright Java
  36. Playwright Python
  37. Postman
  38. Project Management
  39. Protractor
  40. PyDev
  41. Python
  42. Python NumPy
  43. Python Pandas
  44. Python Seaborn
  45. R Language
  46. REST Assured
  47. Ruby
  48. Selenide
© Copyright By iVagus Services Pvt. Ltd. 2023. All Rights Reserved.

Footer

  • Cookie Policy
  • Privacy Policy
  • Terms of Use