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.
