14 Characteristics of Database Management System
Characteristics of Database Management System: At the end of this article you will be able to understand what are the basic Characteristics of Database management systems? There are numerous characteristics of database management system but few of them are very important that are given below.
Also See: Features of Database Management System
Characteristics of Database Management System
1. Real World Entity
DBMS these days is very realistic and real-world entities are used to design its architecture. Also behavior and attributes are used by DBMS. To simplify it we can take an example of an organization database where employee is an entity and his employee id is an attribute.
2. Self-Describing Nature
Before DBMS, traditional file management system was used for storing information and data. There was no concept of definition in traditional file management system like we have in DBMS. A DBMS should be of Self- Describing nature as it not only contains the database itself but also the metadata. A metadata (data about data) defines and describes not only the extent, type, structure and format of all data but also relationship between data. This data represent itself that what actions should be taken on it.
3. Support ACID Properties
Any DBMS is able to support ACID (Accuracy, Completeness, Isolation, and Durability) properties. It is made sure in every DBMS that the real purpose of data should not be lost while performing transactions like delete, insert and update. Let us take an example; if an employee name is updated then it should make sure that there is no duplicate data and no mismatch of employee information.
4. Concurrent Use of Database
There are many chances that many users will be accessing the data at the same time. They may require altering the database system concurrently. At that time, DBMS supports them to concurrently use database without any problem. With the help of concurrency, economy of the system can be increased. For Example, employees of railway reservation system can book and access tickets for passengers concurrently. Every employee can see on his own interface that how many seats are available or bogie is fully booked.
Also See: 9 Disadvantages of Database management system
5. Insulation Between Data and Program
Program-data independence provides a big relief to database users. In traditional file management system, structure of data files was defined in the application programs so user had to change all the programs that are using that particular data file.
But in DBMS, structure of data files is not stored in the program but it is stored in system catalogue. With the help of this, internal improvement of data efficiency or any changes in the data do not have any effect on application software.
Transactions are bunch of actions that are done to bring database from one consistent state to new consistent state. Traditional file-based system did not have this feature. Transaction is always atomic that means it can never be further divided. It can only be completed or uncompleted.
For example, A person wants to credit money from his account to another person’s account. Then transaction will be complete if he sends money and other guy receives his money. Anything other than this can lead to an inconsistent transaction.
7. Data Persistence
Persistence means if the data is not removed explicitly then all the data will be maintained in DBMS. If any system failure happens then life span of data stored in the DBMS will be decided by the users directly or indirectly. Any data stored in the DBMS can never be lost. If system failure happens in between any transaction then it will be rolled back or fully completed, but data will never be at risk.
Also See: What is Database?
8. Backup and Recovery
There are many chances of failure of whole database. At that time no one will be able to get the database back and for sure company will be in a big loss. The only solution is to take backup of database and whenever it is needed, it can be stored back. A database must have this characteristic to enable more effectiveness.
Also See: Examples Of Database Management System
9. Data Integrity
This is one of the most important characteristics of database management system. Integrity ensures the quality and reliability of database system. It protects unauthorized access of database and makes it more secure. It brings only consistence and accurate data into the database.
10. Multiple Views
Users can have multiple views of database depending on their department and interest. DBMS support multiple views of database to the users. For example, a user of teaching department will have different view and user of hostel department will have different. This feature helps users to have somewhat security because users of other department cannot access their files.
Also Read: Explained Types and Classifications of DBMS
11. Stores Any Kind of Data
A database management system should be able to store any kind of data. It should not be restricted to employee name, salary and address. Any kind of data that exists in the real world can be stored in DBMS because we need to work with all kinds of data that is present around us.
DBMS provides security to the data stored in it because all users have different rights to access database. Some of the user can access the whole database while other can access a small part of database. For example, a computer network lecturer can only access files that are related to computer subjects but HOD of the department can access files of all subject that are related to their department.
13. Represents Complex Relationship Between Data
Data stored in a database is connected with each other and a relationship is made in between data. DBMS should be able to represent the complex relationship between data to make efficient and accurate use of data.
14. Query Language
Queries are used to retrieve and manipulate data but DBMS is armed by a strong query language that make it more effective and efficient. Users have the power to retrieve any kind of data they want from database by applying different set of queries. File-Based system has not this luxury of query language.
Also Read: Applications and Uses of DBMS
So it was all about Characteristics of Database Management System. If you have any problem in these characteristics then please comment below.
- What Is DBMS
- Relational Data Model: Concept, Constraints, Advantages
- What is data Extraction and Tools in DBMS?
- 10 Differences between SQL Vs MySQL in Tabular Form
- 25 Difference Between DBMS and RDBMS: DBMS Vs RDBMS
- Complete Guide: Denormalization in Database (DBMS)