what are three levels of data abstraction?


what are three levels of data abstraction?

madhu Doctor Asked on June 8, 2015 in Programmer.
Add Comment
3 Answer(s)

There are three levels of abstraction:

  1. Physical level: The lowest level of abstraction describes how data are stored.
  2. Logical level: The next higher level of abstraction, describes what data are stored in database and what relationship among those data.
  3. View level: The highest level of abstraction describes only part of entire database.


amit Reviewer Answered on June 8, 2015.
Add Comment

Data abstraction is a process of representing the essential features without
including implementation details.
many database-systems users are not computer trained, developers hide the
complexity from users through several levels of abstraction, to simplify users’
interactions with the system:

1) Physical level.
The lowest level of abstraction describes how the data are
actually stored. The physical level describes complex low-level data
structures in detail.

2) Logical level. 
The next-higher level of abstraction describes what data are
stored in the database, and what relationships exist among those data. The
logical level thus describes the entire database in terms of a small number of
relatively simple structures.

3) View level.
 The highest level of abstraction describes only part of the entire
database. The variety of information stored in a large database. Many users
of the database system do not need all this information; instead, they need
to access only a part of the database. The view level of abstraction exists to
simplify their interaction with the system.


alex Reviewer Answered on June 8, 2015.
Add Comment

Data Abstraction

  1. The major purpose of a database system is to provide users with an abstract view of the system.The system hides certain details of how data is stored and created and maintained

    Complexity should be hidden from database users.

  2. There are several levels of abstraction:
    1. Physical Level:
      • How the data are stored.
      • E.g. index, B-tree, hashing.
      • Lowest level of abstraction.
      • Complex low-level structures described in detail.
    2. Conceptual Level:
      • Next highest level of abstraction.
      • Describes what data are stored.
      • Describes the relationships among data.
      • Database administrator level.
    3. View Level:
      • Highest level.
      • Describes part of the database for a particular group of users.
      • Can be many different views of a database.
      • E.g. tellers in a bank get a view of customer accounts, but not of payroll data.


Rohit Reviewer Answered on June 8, 2015.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.