What is Locking-Committing Conflict

Advancing the distributed real-time database systems (DRTDBS) performance requires critical consideration of the reasons for data inaccessibility (i.e., predictability and consistency, scheduling and conflict resolution schemes, and commit process). Traditionally, execute-commit conflict is handled through the two-phase commit protocol to ensure the consistency of the database by blocking an incoming cohort intending to access the data item(s) already locked by other prepared cohort. Such blocking makes the transaction execution time of incoming cohort unpredictable due to unbounded waiting time. This chapter proposes an early data lending-based real-time commit (EDRC) protocol that increases data accessibility by providing the means to start the lending process early. Furthermore, lender is permitted to lend its uncommitted data items just after the completion of data processing task. The EDRC protocol outperforms state-of-the-art distributed commit protocols particularly PROMPT, 2SC, and SWIFT under all load conditions.