A Framework for Concurrency Control in Mobile Distributed Real-time Database Systems

LEI Xiang-Dong,ZHAO Yue-Long,CHEN Song-Qiao,YUAN Xiao-Li
DOI: https://doi.org/10.3969/j.issn.1002-137X.2007.12.026
2007-01-01
Computer Science
Abstract:Mobile distributed real-database systems (MDRTDBS) are viewed as three-tier architecture. This paper presents DMVOCC-DA-2PLV (Distributed Multiversion Optimistic Concurrency Control with Dynamic Adjustment using Two-Phase Local Validation) protocol for processing mobile distributed real-time transaction in mobile broadcast environments. Mobile real-time transaction processing is performed in two stages. In the first stage transaction processing is performed at MH(Mobile Host). At MHs all mobile transactions perform local partial backward validation of transactions. The local partial validation process is carried out against committed transactions at the server. Such an early data conflict detect detection feature can save processing and communication resources. In the second stage transaction processing is performed at server. Transactions that survive in local partial backward validation must be submitted to server for local final backward validation. The protocol can eliminate conflicts between mobile read-only and mobile update transactions, and resolve data conflicts flexibly using multiversion dynamic adjustment of serialization order to avoid unnecessary restarts of transactions. For a ready-only transaction at the MH, it can be committed locally if it passes all the local partial backward validation in the course of it execution. Respond time of mobile read-only transactions is greatly improved. In global validation distributed update transactions have to do check to ensure distributed serializability in all participants. The protocol presented is compared with DTO-2PC and D HP-2PL by simulation experiments. The results of experiment show that the new protocol proposed offers better performance in terms of miss rate, restart rate, commit rate and throughput.
What problem does this paper attempt to address?