Principles Of Distributed Database Systems Exercise Solutions Direct
The key principle: force log before write (WAL). Without it, distributed commit cannot guarantee atomicity.
+---------------+ | Fragment 3 | | (Products) | +---------------+ | | v +---------------+ +---------------+ | Site A | | Site B | | (Replica 1) | | (Replica 2) | +---------------+ +---------------+ The key principle: force log before write (WAL)
Given TS(T1)=10, TS(T2)=20. At site X, data item D has write_TS=5 , read_TS=5 . T2 issues write(D) . T1 issues write(D) later. Apply basic timestamp ordering (TO) rules. TS(T2)=20. At site X
Describe how the system ensures autonomy and distribution. data item D has write_TS=5
Consider a distributed database system that stores information about customers and orders. The database is fragmented and replicated across multiple sites. Describe how the system provides transparency.
