- Real World Entity.
- Self Explaining Nature.
- Atomicity of Operations (Transactions)
- Concurrent Access without Anomalies.
- Stores Any Kind of Structured Data.
- Integrity.
- Ease of Access (The DBMS Queries)
- SQL and No-SQL Databases.
DBMS adheres to the concepts of Atomicity, Consistency, Isolation, and Durability, or ACID Properties. These concepts are applied to transactions, which operate and play around with data in a database. In multi-transactional environments, ACID properties help the database stay healthy in case of failure.
Self-Describing Nature
Before DBMS, a traditional file management systemwas used for storing information and data Support Acid Properties
Any DBMS is able to support ACID (Accuracy, Completeness, Isolation, and Durability) properties 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 Insulation Between Data and Program
Program-data independenceprovides a big relief to database users. In traditional file management system Transactions
Transactions are bunch of actions that are done to bring database from one consistent state to new consistent state Data Persistence
Persistence means if the data is not removed explicitly then all the data will be maintained in DBMS Backup and Recovery
There are many chances of failure of the whole database Data Integrity
This is one of the most important characteristics of database management system. Integrity ensures the quality and reliability of database system Multiple Views
Users can have multiple views of database depending on their department and interest. DBMS support multiple views of database to the users Here are the characteristics and properties of a Database Management System:
- Provides security and removes redundancy
- Self-describing nature of a database system
- Insulation between programs and data abstraction
- Support of multiple views of the data
More items
Characteristics of Database Management System are:
- Provides security and expels excess
- Self-portraying nature of a database framework
- Insulation among projects and information deliberation
More items