WalMart cannot commit if someone else committed previously, they have to try again.
Atomicity is precisely what it is. There is no fuzziness there, you either do it or you don't.
The problem with current database designs is the idea of BeginTransaction, that function is the core of the problem.
"Transactions" in the real world are NOT completed until everyone agrees.
Consider you yourself enter into a transaction with your landlord, you BeginTransaction..
However during the negotiation you choose to disagree and back away from the deal.
That transaction, even though it took three months to decide was rejected (by either party).
The only "transaction" is the committed transaction.