Data Abstraction in Database

Data Abstraction in Database

Data Abstraction in Database

In an abstract data type(ADT) ,the properties are visible to the user ,but its implemetation details are hidden from the user.A major purpose of a database system is to provide the users with an abstract view of data and hide its internal complexities.To hide the complexity from users database apply theĀ  following levels of abstraction.

  • Physical Level
  • Logical Level
  • View Level

Physical Level
Physical Level is the lowest level of abstraction and it defines the storage structure.The physical level describes complex low level data structures in detail.The database system hides many of the lowest level storage details from the database programmers. Database Administrators may be aware of certain details of physical organization of data.

Logical Level
This is the next higher level of abstraction which describe what data are stored in database, relation between data, types of data etc . Database programmers, DBA etc knows the logical structure of data

View Level
This the highest level of abstraction. It provides different view to different users. At the view level users see a set of application programs that hide details of data types. The details such as data type etc are not available at this level. Only view or Access is given to a part of data according to the users access right