Characteristics of DBMS are as follows:
A modern DBMS has the following characteristics :
- Less redundancy –
DBMS follows the rules of normalization which is a mathematically rich and scientific process that reduces data redundancy.
- Consistency –
DBMS helps to achieve consistency as compared to earlier forms of data storing applications like file-processing systems.
- Query Language –
It is more efficient to retrieve and manipulate data. Traditionally it was not possible where file-processing system was used.
- Isolation of data and application –
DBMS also stores metadata, which is data about data, to ease its own process.
- Relation-based tables –
DBMS allows entities and relations among them to form tables.
- Multiuser and Concurrent Access –
DBMS supports multi-user environment and allows them to access and manipulate data in parallel.
- ACID Properties –
DBMS follows the concepts transactions, i.e., ACID properties : Atomicity, Consistency, Isolation, and Durability.
- Multiple views –
DBMS offers multiple views for different users for same table or group of tables.
- Security –
DBMS offers many different levels of security features, which enables multiple users to have different views with different features.