3K
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.