CoderFunda
  • Home
  • About us
    • Contact Us
    • Disclaimer
    • Privacy Policy
    • About us
  • Home
  • Php
  • HTML
  • CSS
  • JavaScript
    • JavaScript
    • Jquery
    • JqueryUI
    • Stock
  • SQL
  • Vue.Js
  • Python
  • Wordpress
  • C++
    • C++
    • C
  • Laravel
    • Laravel
      • Overview
      • Namespaces
      • Middleware
      • Routing
      • Configuration
      • Application Structure
      • Installation
    • Overview
  • DBMS
    • DBMS
      • PL/SQL
      • SQLite
      • MongoDB
      • Cassandra
      • MySQL
      • Oracle
      • CouchDB
      • Neo4j
      • DB2
      • Quiz
    • Overview
  • Entertainment
    • TV Series Update
    • Movie Review
    • Movie Review
  • More
    • Vue. Js
    • Php Question
    • Php Interview Question
    • Laravel Interview Question
    • SQL Interview Question
    • IAS Interview Question
    • PCS Interview Question
    • Technology
    • Other

04 April, 2022

Three schema Architecture

 Programing Coderfunda     April 04, 2022     DBMS     No comments   

 

Three schema Architecture

  • The three schema architecture is also called ANSI/SPARC architecture or three-level architecture.
  • This framework is used to describe the structure of a specific database system.
  • The three schema architecture is also used to separate the user applications and physical database.
  • The three schema architecture contains three-levels. It breaks the database down into three different categories.

The three-schema architecture is as follows:

DBMS Three schema Architecture

In the above diagram:

  • It shows the DBMS architecture.
  • Mapping is used to transform the request and response between various database levels of architecture.
  • Mapping is not good for small DBMS because it takes more time.
  • In External / Conceptual mapping, it is necessary to transform the request from the external level to the conceptual schema.
  • In Conceptual / Internal mapping, DBMS transforms the request from the conceptual to the internal level.

Objectives of Three schema Architecture

The main objective of the three-level architecture is to enable multiple users to access the same data with a personalized view while storing the underlying data only once. Thus it separates the user's view from the physical structure of the database. This separation is desirable for the following reasons:

  • Different users need different views of the same data.
  • The approach in which a particular user needs to see the data may change over time.
  • The users of the database should not worry about the physical implementation and internal workings of the database such as data compression and encryption techniques, hashing, optimization of the internal structures, etc.
  • All users should be able to access the same data according to their requirements.
  • DBA should be able to change the conceptual structure of the database without affecting the user's
  • The internal structure of the database should be unaffected by changes to physical aspects of the storage.

1. Internal Level

DBMS Three schema Architecture
  • The internal level has an internal schema that describes the physical storage structure of the database.
  • The internal schema is also known as a physical schema.
  • It uses the physical data model. It is used to define how the data will be stored in a block.
  • The physical level is used to describe complex low-level data structures in detail.

The internal level is generally is concerned with the following activities:

  • Storage space allocations.three levels
    For Example B-Trees, Hashing, etc.
  • Access paths.
    For Example Specification of primary and secondary keys, indexes, pointers, and sequencing.
  • Data compression and encryption techniques.
  • Optimization of internal structures.
  • Representation of stored fields.

2. Conceptual Level

DBMS Three schema Architecture
  • The conceptual schema describes the design of a database at the conceptual level. The conceptual level is also known as the logical level.
  • The conceptual schema describes the structure of the whole database.
  • The conceptual level describes what data are to be stored in the database and also describes what relationship exists among those data.
  • At the conceptual level, internal details such as an implementation of the data structure are hidden.
  • Programmers and database administrators work at this level.

3. External Level

DBMS Three schema Architecture
  • At the external level, a database contains several schemas that are sometimes called subschema. The subschema is used to describe the different views of the database.
  • An external schema is also known as a view schema.
  • Each view schema describes the database part that which a particular user group is interested and hides the remaining database from that user group.
  • The view schema describes the end-user interaction with database systems.

Mapping between Views

The three levels of DBMS architecture don't exist independently of each other. There must be a correspondence between the three levels i.e. how they actually correspond with each other. DBMS is responsible for correspondence between the three types of schema. This correspondence is called Mapping.

There are basically two types of mapping in the database architecture:

  • Conceptual/ Internal Mapping
  • External / Conceptual Mapping

Conceptual/ Internal Mapping

The Conceptual/ Internal Mapping lies between the conceptual level and the internal level. Its role is to define the correspondence between the records and fields of the conceptual level and files and data structures of the internal level.

External/ Conceptual Mapping

The external/Conceptual Mapping lies between the external level and the Conceptual level. Its role is to define the correspondence between a particular external and conceptual view.

  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Email ThisBlogThis!Share to XShare to Facebook

Related Posts:

  • Fifth normal form (5NF) Fifth normal form (5NF)A relation is in 5NF if it is in 4NF and not contains any join dependency and joining should be lossless.5NF is satisfied… Read More
  • Fourth normal form (4NF) Fourth normal form (4NF)A relation will be in 4NF if it is in Boyce Codd normal form and has no multi-valued dependency.For a dependency A → B, … Read More
  • Multivalued Dependency Multivalued DependencyMultivalued dependency occurs when two attributes in a table are independent of each other but, both depend on a third att… Read More
  • Relational Decomposition Relational DecompositionWhen a relation in the relational model is not relationship normal form then the decomposition of a relation is required… Read More
  • Join DependencyJoin DependencyJoin decomposition is a further generalization of Multivalued dependencies.If the join of R1 and R2 over C is equal to relation R, then… Read More
Newer Post Older Post Home

0 comments:

Post a Comment

Thanks

Meta

Popular Posts

  • Vue3 :style backgroundImage not working with require
    I'm trying to migrate a Vue 2 project to Vue 3. In Vue 2 I used v-bind style as follow: In Vue 3 this doesn't work... I tried a...
  • SQL ORDER BY Keyword
      The SQL ORDER BY Keyword The ORDER BY keyword is used to sort the result-set in ascending or descending order. The ORDER BY keyword sorts ...
  • Enabling authentication in swagger
    I created a asp.net core empty project running on .net6. I am coming across an issue when I am trying to enable authentication in swagger. S...
  • failed to load storage framework cache laravel excel
       User the export file and controller function  ..         libxml_use_internal_errors ( true ); ..Good To Go   public function view () : ...
  • Features CodeIgniter
    Features CodeIgniter There is a great demand for the CodeIgniter framework in PHP developers because of its features and multiple advan...

Categories

  • Ajax (26)
  • Bootstrap (30)
  • DBMS (42)
  • HTML (12)
  • HTML5 (45)
  • JavaScript (10)
  • Jquery (34)
  • Jquery UI (2)
  • JqueryUI (32)
  • Laravel (1017)
  • Laravel Tutorials (23)
  • Laravel-Question (6)
  • Magento (9)
  • Magento 2 (95)
  • MariaDB (1)
  • MySql Tutorial (2)
  • PHP-Interview-Questions (3)
  • Php Question (13)
  • Python (36)
  • RDBMS (13)
  • SQL Tutorial (79)
  • Vue.js Tutorial (68)
  • Wordpress (150)
  • Wordpress Theme (3)
  • codeigniter (108)
  • oops (4)
  • php (853)

Social Media Links

  • Follow on Twitter
  • Like on Facebook
  • Subscribe on Youtube
  • Follow on Instagram

Pages

  • Home
  • Contact Us
  • Privacy Policy
  • About us

Blog Archive

  • September (100)
  • August (50)
  • July (56)
  • June (46)
  • May (59)
  • April (50)
  • March (60)
  • February (42)
  • January (53)
  • December (58)
  • November (61)
  • October (39)
  • September (36)
  • August (36)
  • July (34)
  • June (34)
  • May (36)
  • April (29)
  • March (82)
  • February (1)
  • January (8)
  • December (14)
  • November (41)
  • October (13)
  • September (5)
  • August (48)
  • July (9)
  • June (6)
  • May (119)
  • April (259)
  • March (122)
  • February (368)
  • January (33)
  • October (2)
  • July (11)
  • June (29)
  • May (25)
  • April (168)
  • March (93)
  • February (60)
  • January (28)
  • December (195)
  • November (24)
  • October (40)
  • September (55)
  • August (6)
  • July (48)
  • May (2)
  • January (2)
  • July (6)
  • June (6)
  • February (17)
  • January (69)
  • December (122)
  • November (56)
  • October (92)
  • September (76)
  • August (6)

  • Failed to install 'cordova-plugin-firebase': CordovaError: Uh oh - 9/21/2024
  • pyspark XPath Query Returns Lists Omitting Missing Values Instead of Including None - 9/20/2024
  • SQL REPL from within Python/Sqlalchemy/Psychopg2 - 9/20/2024
  • MySql Explain with Tobias Petry - 9/20/2024
  • How to combine information from different devices into one common abstract virtual disk? [closed] - 9/20/2024

Laravel News

  • Simplify API Responses with Fluent Methods - 6/6/2025

Copyright © 2025 CoderFunda | Powered by Blogger
Design by Coderfunda | Blogger Theme by Coderfunda | Distributed By Coderfunda