Questions tagged [transactions]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
0answers
25 views

Distributed transaction problem

Let's suppose there are two banks, Bank A and Bank B. A transaction needs to happen that transfers money from an account in Bank A to an account in Bank B. Bank A and Bank B have separate banking ...
1
vote
1answer
207 views

Does upgrading after all locks and before all unlocks violate 2PL?

2PL's rule says: Upgrading of lock (from S(a) to X (a)) is allowed in growing phase. But what if upgrading lies after the last lock and before the first unlock? Does it still count "in the ...
1
vote
1answer
29 views

If a user confirmed a booking or transaction on the database system, but it failed and it falls over to the replica, what if the transaction is lost?

This is an overall system design and DBMS question: If the user books a ticket or an item on a website, how do we solve the issue of confirming a ticket is sold to the user, but the main Database ...
0
votes
0answers
9 views

Concept related to transaction? [closed]

I was reading about transactions in DBMS. Just get started with it. But I am super confused with one concept. Suppose initially A=100 For T1 A=100 and doing A = A-50 For T2 temp would be 10 and ...
0
votes
0answers
25 views

Exercise task with main memory

The Exercise is Computer A has a main memory of size HA 2 MiB, and computer B has a main memory of HB = 256 MiB. Both computers process single transactions that have a size of s=84 KiB. Each of the ...
0
votes
0answers
39 views

Lost Update Problem and Recoverability and Commits

Does lost update problem must have Read first? Can Lost-Update problem occur in: 1] Conflict Serializable 2] Strict Recoverable I'm totally confused about basic. R2(X) R1(X) W1(X) C1 W2(X) Does this ...