
ACID properties are used to maintain consistency in the database before and after the transaction.
ACID properties provide stability in database loading and high security of the data.
ACID Properties
ACID Properties stands for-
Atomicity
Consistency
Isolation
Durability
Atomicity
It simply gives that a transaction is either "PASS" or " FAIL". There is no middle state in them like an update in their data. It also refers to the "All or Nothing "
For example :
Suppose, You are transferring money from your bank account to your friend's Bank account. This Transaction involves 'Withdrawal' and 'Deposit' operations. If the deposit operation failed, you don't want the Withdrawal operation to happen either. Otherwise, that money would disappear.
Lumping Both operations into a single atomic transaction ensures integrity. This is what is called the " Atomicity " in DBMS
Isolation
Isolation Property means multiple transactions can occur Concurrently Without any inconsistency in the database state.
- That is when multiple transactions execute at a single unit of time, then the state of the database must be far all over the transaction period.
For example
Suppose you and your friend are booking a train ticket for Delhi and only one seat is available. Now, both of you simultaneously start booking the seat, which should not be allowed by the database management system, or else either of you will land in trouble. Maybe both will end up booking for the same seat or may be both will pay but only one will have the seat confirmed. Thus, the database should either perform your entire transaction first before executing your friend's or vise-versa.
Durability
The durability property ensures that once the transaction has been completed, The modifications and updates in the database are stored and they persist even if there is a system failure.
That is, some common external factors like system crashes or power failures should not affect the data once the transaction is completed
in the server.
For example
Imagine you have a 10 lakh amount of money in your bank account. The bank database server goes down, all data stored on that server is gone and so your money is gone!!.
So you need Durability, a Fault free system. So Durability ensures the update and modification are stored in the database, even if a system failure occurs.
Consistency
In Consistency property, If any type of transaction exists at the user end, that must be conceived into a valid and legal state in the database.
That is, It ensures that the database remains in a consistent state before the start-up operation and after a transaction is over. If a transaction fails, the database must return to its previous state.
For example
Consistency means all is well, There is no Incorrectness anywhere in the system. If all the three mentioned above can be guaranteed then consistency prevails. There is no separate component in database management software that will ensure consistency.
..
Isolation Property means multiple transactions can occur Concurrently Without any inconsistency in the database state.
About the author
I am a Tech Enthusiast having 13+ years of experience in 𝐈𝐓 as a 𝐂𝐨𝐧𝐬𝐮𝐥𝐭𝐚𝐧𝐭, 𝐂𝐨𝐫𝐩𝐨𝐫𝐚𝐭𝐞 𝐓𝐫𝐚𝐢𝐧𝐞𝐫, 𝐌𝐞𝐧𝐭𝐨𝐫, with 12+ years in training and mentoring in 𝐒𝐨𝐟𝐭𝐰𝐚𝐫𝐞 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫𝐢𝐧𝐠, 𝐃𝐚𝐭𝐚 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫𝐢𝐧𝐠, 𝐓𝐞𝐬𝐭 𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐢𝐨𝐧 𝐚𝐧𝐝 𝐃𝐚𝐭𝐚 𝐒𝐜𝐢𝐞𝐧𝐜𝐞. I have 𝒕𝒓𝒂𝒊𝒏𝒆𝒅 𝒎𝒐𝒓𝒆 𝒕𝒉𝒂𝒏 10,000+ 𝑰𝑻 𝑷𝒓𝒐𝒇𝒆𝒔𝒔𝒊𝒐𝒏𝒂𝒍𝒔 and 𝒄𝒐𝒏𝒅𝒖𝒄𝒕𝒆𝒅 𝒎𝒐𝒓𝒆 𝒕𝒉𝒂𝒏 500+ 𝒕𝒓𝒂𝒊𝒏𝒊𝒏𝒈 𝒔𝒆𝒔𝒔𝒊𝒐𝒏𝒔 in the areas of 𝐒𝐨𝐟𝐭𝐰𝐚𝐫𝐞 𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐦𝐞𝐧𝐭, 𝐃𝐚𝐭𝐚 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫𝐢𝐧𝐠, 𝐂𝐥𝐨𝐮𝐝, 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬, 𝐃𝐚𝐭𝐚 𝐕𝐢𝐬𝐮𝐚𝐥𝐢𝐳𝐚𝐭𝐢𝐨𝐧𝐬, 𝐀𝐫𝐭𝐢𝐟𝐢𝐜𝐢𝐚𝐥 𝐈𝐧𝐭𝐞𝐥𝐥𝐢𝐠𝐞𝐧𝐜𝐞 𝐚𝐧𝐝 𝐌𝐚𝐜𝐡𝐢𝐧𝐞 𝐋𝐞𝐚𝐫𝐧𝐢𝐧𝐠. I am interested in 𝐰𝐫𝐢𝐭𝐢𝐧𝐠 𝐛𝐥𝐨𝐠𝐬, 𝐬𝐡𝐚𝐫𝐢𝐧𝐠 𝐭𝐞𝐜𝐡𝐧𝐢𝐜𝐚𝐥 𝐤𝐧𝐨𝐰𝐥𝐞𝐝𝐠𝐞, 𝐬𝐨𝐥𝐯𝐢𝐧𝐠 𝐭𝐞𝐜𝐡𝐧𝐢𝐜𝐚𝐥 𝐢𝐬𝐬𝐮𝐞𝐬, 𝐫𝐞𝐚𝐝𝐢𝐧𝐠 𝐚𝐧𝐝 𝐥𝐞𝐚𝐫𝐧𝐢𝐧𝐠 new subjects.
Comments
Join the discussionNo comments yet. Be the first to comment.


