Database Management System (DBMS) / DBMS Architecture

What is Abstraction?

🧠 What is Abstraction

In DBMS (Database Management System), abstraction means hiding the complex details of how data is stored and maintained, and instead providing users with a simplified view of the data.

This is achieved through three levels of data abstraction, also called the Three-Schema Architecture.



📘 Summary Table:

Level

Description

Audience

View Level

What users see (custom views)

End users

Logical Level

What data is stored and relationships

Programmers, DB admins

Physical Level

How data is stored on disk

System/database engineers