|
You are here |
architecturenotes.co | ||
| | | | |
www.ahmed-ibrahim.com
|
|
| | | | | What is the Database transaction? A transaction is a single logical unit of work which accesses and possibly modifies the contents of a... | |
| | | | |
johnjr.dev
|
|
| | | | | When we study transactions in relational databases, one of the first things we learn are the guarantees that a transaction must provide. ACID(Atomicity, Consistency, Isolation, Durability) are the properties that we desire. Here, I will discuss the Isolation level in more detail and show that atomicity alone is not enough when handling concurrency. One classic example of the importance of atomicity is moving money between accounts. So, imagine that we have two accounts and we would like to transfer the total amount from one account to another one. In a relational database, what we need to do is three steps: | |
| | | | |
my-it-notes.com
|
|
| | | | | Databases - how they work under the hood?Key takeaways from brilliant book "Designing data intensive application" - to quickly recap core concepts. DB engines classifications Type of load: OLTP (transaction processing) vs OLAP (data warehousing and analytics) Relational vs NoSQL, document vs columnar, graph vs triple-store (semantic facts storage) Even within NoSQL camp you can ... | |
| | | | |
highscalability.com
|
|
| | | Sorry, the content for this post apparently did not make the transition from the old HighScalabili... | ||