Database Management System Introduction
This tutorial is a start about the introduction to database management system and acid properties. Database management is a process to store the data, retrieve the data, and perform the manipulations on the data with proper security. Traditionally data is stored in the file formats, but it is hard to obtain the data from the file and to perform the operations. To solve the problem with data storage, database management has come into play as an effective data storage system.
Database Terminologies
Database
It is the electronic storage point where the data is stored in database management system. It is a vast store point.
Entity
It is an object and can be recognizable in an easy way. If a university database is considered the professors, hods, students, etc are known as the entity. An entity set is the combination of all the entities is a single set.
Attributes
It is the characteristic of describing the entities in database management system. The attributes have a special character and are similar to all the entities. For the university database, the professor as an entity attributes like age, name, gender, etc are the attributes and have the specific values to be stored.
Database Applications – DBMS
- Airlines
- Banking
- Universities
- Credit Card Transactions
- Telecommunication
- FInances
- Management
And much more…
ACID Properties – DBMS
Atomicity
It is the property of completing the transactions, completely in database management system. This property of the database makes the actions to be performed completely or left as uncompleted. If any database transaction is stopped in the middle, without completion, due to power problems, errors, and crashes, it is very important to update the state of the transaction. So, this property of atomicity makes the transactions as successful if all the actions are performed correctly, else mark as a failure, and do not proceed with any changes in the transaction.
Consistency
This property ensures that the data storage transaction is done accordingly, without affecting the constraints and any changes to the database relationship. This ensures that the data written to the database is done properly by maintaining all the rules and constraints and as a legal transaction.
Isolation
This is an important property of the database management ensures that if multiple transactions are done to the database at the same time, isolation property applies them one after the other sequentially, thus makes the database stable and secured with proper transactional changes.
Durability
This property ensures that the changes done by the transactions to the database are to be committed if any power failures or crashes happen. This shows that the storage of data in non-volatile memory with the transactional changes ensures durability.
SQL – DBMS
SQL stands for Structured Query Language, used as the computer database language for the relational database management system. SQL can be used as a communication protocol for the data storing, retrieving, and manipulations on the database.
In the further tutorials, the commands in the SQL programming to work on the database systems are discussed briefly with working explanations. Work on these tutorials, to complete the working on the Relational Databases with Mysql, PL SQL, and much more. For any kind of doubts in this tutorial, can type them below in the comment box and further continue to another tutorial.