Databases Flashcards
Learn about databases and consistency models
What does A.C.I.D. stand for?
Atomicity - the interaction happens all at once, or not at all.
Consistency - the interaction should be consistent before and after the transaction.
Isolation - multiple interactions occur simultaneously without affecting each other.
Durability - the changes of a successful transaction occur even if there is a system failure.
What does B.A.S.E. stand for?
Basically Available - the system is guaranteed to be available even in the event of a failure.
Soft state - the state of the data could change without application interactions due to eventual consistency model.
Eventual consistency - the system would be eventually consistent after the application input. The data will be replicated out to different nodes and will eventually reach a consistent state, but the consistency is not guaranteed at a transaction level.
What database type does a BASE model lend itself to?
The BASE model lends itself best to databases that provide less assurance than the ACID model. It scales very well and reacts well to rapid data changes. NoSQL would be the best type of database in this case.
