AlgoPlus//structures / dbms-architecture
Read the theory

DBMS Architecture

The three-level (ANSI-SPARC) architecture and the data independence it buys.

Step
1/1
Legend
External (views)
Conceptual (logical)
Internal (physical)
AI Tutor Workspace
In a nutshell
A database management system is organised in three layers so different people can work without tripping over each other. The external level is the tailored view each user or app sees; the conceptual level is the single complete logical design — all the tables, fields, and rules; the internal level is how that data is actually stored on disk. Mapping the layers to each other means the design can change without breaking views, and storage can change without breaking the design.
Ready
Press play to begin the cinematic walkthrough.
The three-level architecture separates external views, one conceptual (logical) schema, and one internal (physical) schema. The two mappings give logical data independence (change logic, keep views) and physical data independence (change storage, keep logic).
Key terms
Go deeper in the lesson
Read the full theory, intuition & complexity for DBMS Architecture.