The Art and Science of Transaction Coordination: Navigating the Complex Web of Transactions