KEMBAR78
Data abstraction in DBMS | PPTX
The process of hiding
certain details from
user is called Data
Abstraction.
Data
Abstraction
VIEW-1 VIEW-2 VIEW-n
VIEW LEVEL
LOGICAL LEVEL
PHYSICAL LEVEL
Three Levels Of Data Abstraction
Representati
on
Structur
e
What is Schema
?
1 Papan 18
Roll Name Age
Papan
1
8
1
VIEW-1 VIEW-2 VIEW-n
External Level
Conceptual Level
Internal Level
User-1 User-2 User-n
Database
Three Schema Architecture
VIEW LEVEL
LOGICAL
LEVEL
PHYSICAL
LEVEL
Theoretical
Model
Web, Mobile
Application
Data Transparency
VIEW-1 VIEW-2 VIEW-n
External Level
Conceptual Level
Internal Level
User-1 User-2 User-n
Database
VIEW LEVEL
LOGICAL
LEVEL
PHYSICAL
LEVEL
VIEW-1 VIEW-2 VIEW-n
LOGICAL LEVEL
PHYSICAL LEVEL
VIEW LEVEL
1. This is the highest level of abstraction.
2. Users does not need all kind of data, they
need to access a part of the database and view
level provides that.
3. It simplifies interaction with the user and
provide multiple
views.
User-1 User-2 User-n
VIEW-1 VIEW-2 VIEW-3
LOGICAL LEVEL
PHYSICAL LEVEL
VIEW LEVEL
1. This level describes
what data are stored in
the database.
2. what relationship
amongst those data.
3. it also describes entire
database in terms of small
no of relatively simple
structures.
VIEW-1 VIEW-2 VIEW-3
LOGICAL LEVEL
VIEW LEVEL
1.The lowest level of
abstraction.
2. It describes how the
data are actually
stored.
3. it also describes the
complex low level
data structure in
detail.
PHYSICAL
LEVEL
Database
VIEW LEVEL
LOGICAL
LEVEL
PHYSICAL LEVEL
VIEW-1 VIEW-2 VIEW-n
Data Independence
Video
Information
Gathering
Designing, Voice Over
User viewing
Error
Database Moved

Data abstraction in DBMS

  • 1.
    The process ofhiding certain details from user is called Data Abstraction. Data Abstraction
  • 2.
    VIEW-1 VIEW-2 VIEW-n VIEWLEVEL LOGICAL LEVEL PHYSICAL LEVEL Three Levels Of Data Abstraction
  • 3.
    Representati on Structur e What is Schema ? 1Papan 18 Roll Name Age Papan 1 8 1
  • 4.
    VIEW-1 VIEW-2 VIEW-n ExternalLevel Conceptual Level Internal Level User-1 User-2 User-n Database Three Schema Architecture VIEW LEVEL LOGICAL LEVEL PHYSICAL LEVEL Theoretical Model Web, Mobile Application
  • 5.
    Data Transparency VIEW-1 VIEW-2VIEW-n External Level Conceptual Level Internal Level User-1 User-2 User-n Database VIEW LEVEL LOGICAL LEVEL PHYSICAL LEVEL
  • 6.
    VIEW-1 VIEW-2 VIEW-n LOGICALLEVEL PHYSICAL LEVEL VIEW LEVEL 1. This is the highest level of abstraction. 2. Users does not need all kind of data, they need to access a part of the database and view level provides that. 3. It simplifies interaction with the user and provide multiple views. User-1 User-2 User-n
  • 7.
    VIEW-1 VIEW-2 VIEW-3 LOGICALLEVEL PHYSICAL LEVEL VIEW LEVEL 1. This level describes what data are stored in the database. 2. what relationship amongst those data. 3. it also describes entire database in terms of small no of relatively simple structures.
  • 8.
    VIEW-1 VIEW-2 VIEW-3 LOGICALLEVEL VIEW LEVEL 1.The lowest level of abstraction. 2. It describes how the data are actually stored. 3. it also describes the complex low level data structure in detail. PHYSICAL LEVEL
  • 9.
    Database VIEW LEVEL LOGICAL LEVEL PHYSICAL LEVEL VIEW-1VIEW-2 VIEW-n Data Independence Video Information Gathering Designing, Voice Over User viewing Error Database Moved