To ensure integrity of the data, we require that the database system maintain the following properties of the transactions(these properties are also called ACID properties of a transaction.)
Atomicity: Either all operations of the transaction are reflected properly in the database, or none are.
Consistency Execution of a transaction in isolation (that is, with no other transaction executing concurrently) preserves the consistency of the database.
Isolation Even though multiple transactions may execute concurrently. Each transaction is unaware of other transactions executing concurrently in the system.
Durability After a transactions completes successfully, the changes it has made to the database persist, even if there are system failures.
Creating Understanding and Educating Programmers, Developers and Technical Communities, one post at a time.
Subscribe to:
Post Comments (Atom)
Follow the latest update on twitter.com/Programming360
ReplyDeleteI read that Post and got it fine and informative. Please share more like that... ProbioLite Golden After 50
ReplyDeleteYour work is very good and I appreciate you and hopping for some more informative posts ProbioLite Golden After 50
ReplyDelete