Concurrency Control in Mobile Real-Time Database System (MRTDBS)

Abstract

In mobile environment, transactions are initiated from mobile host and that may be executed at mobile host or fixed host. This system proposes Two-Shadow Speculative Concurrency Control (SCC-2S) with Priority mechanism for Mobile Real Time Database System (MRTDBS). Proposed system is designed for strict deadline nested transactions. Concurrency Control will perform at the Fixed Host and the results are returned back to the mobile hosts. SCC-2S is based on Speculative Concurrency Control (SCC). SCC allows a large number of shadows for each uncommitted transactions in the system to co-exist. SCC-2S uses at most two shadows for each transaction, primary shadow and standby shadow. In order to become new contribution, we add priority control mechanism and solve write/write conflict in existing SCC-2S strategy.