A framework for designing update objects to improve server scalability in intermittently synchronized databases

We consider the class of mobile computing applications in which clients naturally operate on shared data without a connection to the server. When appropriate, a server connection is made in order to exchange updates. The update server computes and retransmits these updates on a clientby-client basis; consequently, the complexity of these operations is on the order of the number of clients, limiting scalability. We recently proposed exploiting overlap in client data subscriptions by organizing updates to these subscriptions into groups (with less overlap) instead of on a clientby-client basis. By grouping updates, update processing is performed only once per group, irrespective of the number of clients. Additionally, we may gain bandwidth scalability by employing broadcast delivery since, unlike in the case of the per-client approach, multiple clients may be interested in a group's updates. In this work, we model the operations of such database systems and introduce a framework for evaluation of group design. Since such fragmentation algorithms are computationally intractable, a heuristic graphbased group generation algorithm is speci ed. Performance results executed on a prototype developed using commercially available software are presented.

[1]  Tomasz Imielinski,et al.  Mobile wireless computing: challenges in data management , 1994, CACM.

[2]  Mark Deppe,et al.  Sybase replication server , 1994, SIGMOD '94.

[3]  Inderpal Singh Mumick,et al.  Maintenance of Materialized Views: Problems, Techniques, and Applications , 1999, IEEE Data Eng. Bull..

[4]  Michael J. Donahoo,et al.  Application-based enhancement to network-layer multicast , 1998 .

[5]  Nick Roussopoulos,et al.  An incremental access method for ViewCache: concept, algorithms, and cost analysis , 1991, TODS.

[6]  Shamkant B. Navathe,et al.  Grouping techniques for update propagation in intermittently connected databases , 1998, Proceedings 14th International Conference on Data Engineering.

[7]  David Maier,et al.  Maximal objects and the semantics of universal relation databases , 1983, TODS.

[8]  Shamkant B. Navathe,et al.  Minimizing Redundant Work in Lazily Updated Replicated Databases , 2000 .

[9]  Latha S. Colby,et al.  Algorithms for deferred view maintenance , 1996, SIGMOD '96.

[10]  Marvin Theimer,et al.  The Bayou Architecture: Support for Data Sharing Among Mobile Users , 1994, 1994 First Workshop on Mobile Computing Systems and Applications.

[11]  B. R. Badrinath,et al.  Data partitioning for disconnected client server databases , 1999, MobiDe '99.

[12]  Rafael Alonso,et al.  Broadcast disks: data management for asymmetric communication environments , 1995, SIGMOD '95.

[13]  Shamkant B. Navathe,et al.  A Mixed Fragmentation Methodology For Initial Distributed Database Design , 1995 .

[14]  A. Prasad Sistla,et al.  Data replication for mobile computers , 1994, SIGMOD '94.