Standard Article

Transaction Processing in Mobile, Heterogeneous Database Systems

  1. J. B. Lim1,
  2. A. R. Hurson2,
  3. Y. Jiao2

Published Online: 15 JAN 2008

DOI: 10.1002/9780470050118.ecse503

Wiley Encyclopedia of Computer Science and Engineering

Wiley Encyclopedia of Computer Science and Engineering

How to Cite

Lim, J. B., Hurson, A. R. and Jiao, Y. 2008. Transaction Processing in Mobile, Heterogeneous Database Systems. Wiley Encyclopedia of Computer Science and Engineering. .

Author Information

  1. 1

    MJL Technology, Seoul, South Korea

  2. 2

    The Pennsylvania State University, State College, Pennsylvania

Publication History

  1. Published Online: 15 JAN 2008

Abstract

The rapid explosion in the use of wireless devices, combined with the simultaneous infrastructure expansion required to suport a massive number of users, has made ubiquitous access to data a reality. When a large number of users simultaneously accesses global data in a mobile computing environment, an efficient means to manage a large amount of concurrent transactions is required. Current multi-database concurrency control schemes do not address the limited bandwidth and frequent disconnections associated with wireless networks. This article describes a new hierarchical concurrency control algorithm, v-lock, that addresses the shortcomings of existing multi-database concurrency control schemes. The algorithm uses global locking tables created with semantic informantion contained within a hierarchy to serialize global transactions, and remove global deadlocks.

Additionally, wireless transmission of data is subject to weak or frequent disconnection. With the increased amount of local memory available at the mobile unit, data replication can be used to provide local data availability, limiting the restrictions imposed by a wireless mobile environment. In a mobile, multi-database environment, local autonomy restrictions prevent the use of a page-or-file-based data replication scheme. This article describes a new data replication scheme to address to limited bandwidth and local autonomy restrictions. Consistency is maintained by using a parity-based invalidation scheme of data cached at the mobile unit. Additionally, a simple prefetching scheme is used to further improve the effectiveness of the proposed scheme. Finally, simulated results of the concurrency control and replication algorithms are presented and discussed.

Keywords:

  • mobile database;
  • ubiquitous;
  • transaction processing;
  • concurrency control;
  • caching and prefetching;
  • replication