Now, this concept is not specific to relational database, but it must be known as it's a basic principle applied practically on all kinds of databases. So, here we go. Let's discuss some ACIDic properties of a database.
Well just to have a clear start, we are not talking about stuff which somehow relates to "this".
The four letters of the word ACID denote the set of four properties.
[You can click on them to see more on each properties in my other posts.]
Well just to have a clear start, we are not talking about stuff which somehow relates to "this".
The four letters of the word ACID denote the set of four properties.
[You can click on them to see more on each properties in my other posts.]
- Atomicity It means that a database is said to be atomic if each transaction on the database follows "all or none" rule.
- Consistency It means that a database is consistent (in a valid state) before and after each transaction with respect to the rules and constraints applied on the database.
- Isolation Any two or more transactions on a database are isolated from each other. i.e. they don't interfere with each other.
- Durability This property ensures that any transaction committed on the database is not lost in case of events like error, power crash, etc.
No comments:
Post a Comment