Level of Data Abstraction | Lowest level | Middle level |
Description of Data Storage | Describes how data is actually stored in the database | Describes what data is stored in the database |
Detail of Data Structures | Describes complex low-level data structures in detail | Describes the structure of the whole database and hides details of physical storage structure |
User Awareness of Complexity | User is not aware of the complexity of the database | User is not aware of the complexity of the database |
User Procedures | User is not required to write procedures | User is not required to write procedures |
Data Representation | Gives an abstract view of data, hiding details | Gives an abstract view of data, hiding details |
Crash Recovery Mechanism | Provides a crash recovery mechanism, protecting data from system failure | No crash recovery mechanism, data may be lost in case of system failure |
Protection Mechanism | Provides a good protection mechanism | It is very difficult to protect a file |
Efficiency in Data Storage and Retrieval | Can efficiently store and retrieve data | Cannot efficiently store and retrieve data |
Concurrent Access | Takes care of concurrent access using some form of locking | Concurrent access has many problems like redirection, deletion, or updating without proper mechanisms |