[go: up one dir, main page]
Scribd
Upload
96 views4 pages

Explain Three-Schema Architecture of Database

The document discusses the three-schema architecture of databases. It includes a physical level describing the physical storage structure, a conceptual level describing the overall database structure for users, and an external level related to how individual users view the data. The physical level stores data as bits on storage devices, while the conceptual level hides internal details and the external level includes user views and hides other data. Mapping transforms requests between these schema to retrieve and store data.

Uploaded by

Puneet Purohit
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
96 views4 pages

Explain Three-Schema Architecture of Database

The document discusses the three-schema architecture of databases. It includes a physical level describing the physical storage structure, a conceptual level describing the overall database structure for users, and an external level related to how individual users view the data. The physical level stores data as bits on storage devices, while the conceptual level hides internal details and the external level includes user views and hides other data. Mapping transforms requests between these schema to retrieve and store data.

Uploaded by

Puneet Purohit
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

8/17/2021 Explain Three-Schema Architecture of database

(/)

 (/local/search/page/) Ask (/p/new/post/) Login (/site/login/?next=/p/20356/explain-three-schema-architecture-of-database/)

Explain Three-Schema Architecture of database


written 4.0 years ago by •  
modified 21 months ago


meghalikalyankar (/u/14607/meghalikalyankar/) ♦ 560

0 -27%

8.2k
views

MamaEarth

database management system (/t/database management system/)

ADD COMMENT
FOLLOW
SHARE
EDIT (/p/edit/20356/)

1 Answer

written 4.0 years ago by


meghalikalyankar (/u/14607/meghalikalyankar/) ♦ 560

Three levels of database architecture:


 Following are the three levels of database architecture,

3 1. Physical Level

77 2. Conceptual Level
views
3. External Level

https://www.ques10.com/p/20356/explain-three-schema-architecture-of-database/ 1/4
8/17/2021 Explain Three-Schema Architecture of database

Fig: Three levels database architecture

In the above diagram,

It shows the architecture of DBMS.

Mapping is the process of transforming request response between various database levels of architecture.

Mapping is not good for small database, because it takes more time.

In External / Conceptual mapping, DBMS transforms a request on an external schema against the conceptual schema.

In Conceptual / Internal mapping, it is necessary to transform the request from the conceptual to internal levels.

1. Physical Level :

Physical level describes the physical storage structure of data in database.

This level is very close to physical storage of data.

At lowest level, it is stored in the form of bits with the physical addresses on the secondary storage device.

At highest level, it can be viewed in the form of files.

The internal schema defines the various stored data types.

It uses a physical data model.

2. Conceptual Level

Conceptual level describes the structure of the whole database for a group of users.

It is also called as the data model.

Conceptual schema is a representation of the entire content of the database.

These schema contains all the information to build relevant external records.

It hides the internal details of physical storage.

3. External Level

External level is related to the data which is viewed by individual end users.

https://www.ques10.com/p/20356/explain-three-schema-architecture-of-database/ 2/4
8/17/2021 Explain Three-Schema Architecture of database

This level includes a no. of user views or external schemas.

This level is closest to the user.

External view describes the segment of the database that is required for a particular user group and hides the rest of the
database from that user group.

ADD COMMENT
SHARE
EDIT (/p/edit/20357/)

Please log in (/site/login/?next=/p/20356/explain-three-schema-architecture-of-database/) to add an answer.

Continue reading...

The best way to discover useful content is by searching it.

 Search (/local/search/page/)

(market://details?

id=com.ques10&utm_source=global_co&utm_medium=prtnr&utm_content=Mar2515&utm_campaign=PartBadge&pcampaignid=MKT-
Other-global-all-co-prtnr-py-PartBadge-Mar2515-1)

Engineering in your pocket


Now study on-the-go. Find useful content for your engineering study here. Questions, answers, tags - All in
one app!

COMMUNITY CONTENT COMPANY


Users (/user/list/) All posts (/t/latest) About (/info/about/)
Levels (/info/levels/) Tags (/t/) Team (/info/team/)
Badges (/b/list/) Subjects (/subjects/) Terms (/info/terms/)
Earn points (/info/points/) For Business (/info/business/) Privacy (/info/privacy/)

(https://www.youtube.com/playlist?list=UUH-lr-oL_apReZzPeFGJopg)

(https://in.linkedin.com/company/ques10)
(https://wa.me/919503733731)

https://www.ques10.com/p/20356/explain-three-schema-architecture-of-database/ 3/4
8/17/2021 Explain Three-Schema Architecture of database

Get Started   (/p/1/)

https://www.ques10.com/p/20356/explain-three-schema-architecture-of-database/ 4/4

You might also like