Characteristics of DBMS

by anupmaurya
0 comment

Characteristics of DBMS are as follows:

A modern DBMS has the following characteristics :

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

You may also like