/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

cleverheap.com
| | martin.kleppmann.com
4.3 parsecs away

Travel
| | [AI summary] The author explains the confusion surrounding database transaction isolation levels, analyzes inconsistencies across major databases, and introduces Hermitage, a new test suite designed to rigorously compare these guarantees.
| | pgdba.org
3.6 parsecs away

Travel
| | [AI summary] This technical article explains the Multi-Version Concurrency Control (MVCC) and transaction isolation levels in PostgreSQL, including how XIDs work and common concurrency issues.
| | johnjr.dev
2.7 parsecs away

Travel
| | 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:
| | www.talend.com
28.1 parsecs away

Travel
| Data modeling is the process of creating a diagram that represents your data system & defines the structure, attributes, and relationships of your entities.