Saturday, July 20, 2019

Characteristics of DBMS

Characteristics of DBMS

1) Data stored in table
2) Reduced Redundancy
3) Data consistency
4) Support multiple user and concurrent access
5) Query language
6) Security
7) Transaction (DML Command)

1) Data Stored in Table: -

Data is never stored directly into the database, It Stored in the table format.
DBMS also allowed to have relationship between tables, which makes the data more meaningful and correct.
We can easily understand what type of data is stored in the database, by looking at all the tables which created in the database.

2) Reduced Redundancy (Repetition): -

In a present time, hard drives are the lowest however earlier when hard drives were too expensive unnecessary repetition of data in a Database was a big drawback but DBMS follows normalization which divides the data in a way that Repetition is minimum.

3) Data Consistency: -

Data that is being continuously updated and added maintaining the consistency of the data can become a challenge. But DBMS handle it all by itself.

4) Support Multiple user and concurrent Access: -

DBMS (Database Management System) allows multiple users to work on it (It means update, insert, delete data). At the same time and still manages the data consistency.

5) Query Language: -

DBMS (Database Management System) provides users with a simple query language using which data can be easily fetched inserted, delete and updated in a database.

6) Security: -

The DBMS also takes care of the security of data protecting the data from unauthorized access. In a typical DBMS, we can create user account with the different access permission. Using which we can easily secure a data by restricting user access.

7) Transactions: -

DBMS support transaction which allows us to better handle and manage data integrity in a real-world application where multithreading is extensively used.

Next Topic ➧ Database Models