Abstract
In this paper, we discuss the impact of wirelessness on the client-server model of database usage. Given the potential range of wireless connectivity, we envision applications involving hundreds or thousands of clients across a large geographic area. The focus of our work is partially replicated mobile databases that are connected and synchronized only intermittently. This is the prevalent architecture in sales automation and has applications in real estate, financial advising, and insurance. We take up the issues of synchronization performance and scalability, and describe the impact of mobility on server, network, and client design. A survey of relevant research is used to motivate our discussion.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
S. Acharya, R. Alonso, M. Franklin, and S. Zdonik. Broadcast disks: Data management for asymmetric communication environments. Proc. SIGMOD, May 1995.
S. Acharya, M. Franklin, and S. Zdonik. Prefetching from a broadcast disk. Proc. ICDE, 1996.
S. Acharya, M. Franklin, and S. Zdonik. Balancing push and pull for data broadcast. In Proc. SIGMOD, May 1997.
D. Aksoy and M. J. Franklin. Scheduling for large-scale on-demand data broadcasting. In Proc. IEEE INFOCOM, 1998.
M. H. Ammar and J. W. Wong. The design of teletext broadcast cycles. Performance Evaluation, 5(4):235–242, December 1985.
Y. Breibart and H. F. Korth. Replication and consistency: Being lazy helps sometimes. In Proc. ACM PODS, 1997.
P. Chrysanthis. Transaction processing in a mobile computing environment. In IEEE Workshop on Advances in Parallel and Distributed Systems, pages 77–82, October 1993.
D. Daniels, L. B. Doo, A. Downing, C. Elsbernd, G. Hallmark, S. Jain, B. Jenkins, P. Lim, G. Smith, B. Souder, and J. Stamos. Oracle’s symmetric replication technology and implications for application design. Proc. SIGMOD, 1994.
A. Demers, K. Petersen, M. Spreitzer, D. Terry, M. Theimer, and B. Welch. The bayou architecture: Support for data sharing among mobile users. Proc. MCSA Workshop, 1994.
Division of Networking and Communications Research and Infrastructure. Research riorities in wireless and mobile communications and networking. Technical report, National Science Foundation, 1997.
M. H. Dunham, A. Helal, and S. Balakrishnan. A mobile transaction mobel that captures both the data and movement behavior. Journal Mobile Networks and Applications, 2:149–162, 1997.
J. Duran and A. Laubach. Virtual personal computers and the portable network. In Proc. IEEE PCC, 1999.
M. J. Franklin, B. T. Jonsson, and D. Kossman. Performance tradeoffs for clientserver query processing. In Proc. SIGMOD, 1996.
M. J. Franklin and S. Zdonik. Dissemination-based information systems. IEEE Data Eng. Bulletin, 19(3), 1996.
J. Gold. What companies should knowabout the mobile/pervasion revolution. Sybase, Inc. Invited Industry Session, 2001.
A. Gorelik, Y. Wang, and M. Deppe. Sybase replication server. Proc. SIGMOD, 1994.
Bluetooth Special Interest Group. The official bluetooth web site. Web Document, 2001. http://www.bluetooth.com.
Cahners In-Stat Group. Mobile computing devices: A newe ra in personal computing. Technical Report CM00-05MC, Cahners, Inc., November 2000.
B. Hammond. Merge replication in microsoft’s SQL server 7.0. Proc. SIGMOD, 1999.
IEEE. Working group for 802.11. Web Document, 2001. http://www.manta.ieee.org/groups/802.11.
T. Imielinski and B. R. Badrinath. Wireless computing: Challenges in data management. Comm. ACM, October 1994.
T. Imielinski, S. Vishwanath, and B. R. Badrinath. Data on air: Organization and access. IEEE Trans. Knowledge and Data Eng., 9(3):353–372, May/June 1997.
T. Imielinski, S. Viswanathan, and B. R. Badrinath. Energy efficient indexing on air. In Proc. SIGMOD, May 1994.
W. C. Lee, Q. Hi, and D. L. Lee. A study on channel allocation for data dissemination in mobile computing environments. Journal Mobile Networks and Applications, 4:117–129, 1999.
S. Mahajan, M. J. Donahoo, S. B. Navathe, M. Ammar, and S. Malik. Grouping techniques for update propagation in intermittently connected databases. Proc. ICDE, February 1998.
L. Mummert and M. Satyanarayanan. Large granularity cache coherence in the coda file system. In Proceedings of the USENIX Summer Conference, 1994.
Q. Ren and M. H. Dunham. Using semantic caching to manage location dependent data in mobile computing. In Proc. IEEE/ACM MOBICOM, 2000.
M. Satyanarayanan. Coda: A highly available file system for a distributed workstation environment. In Proceeding of the IEEE Workshop on Workstation Operating Systems, September 1989.
J. Shanmugasundaram, A. Nithrakashyap, R. Sivasankaran, and K. Ramamritham. Efficient concurrency control for broadcast environments. In Proc. SIGMOD, pages 85–96, 1999.
C. J. Su, L. Tassiulus, and V. J. Tsortas. Broadcast scheduling for information distribution. Journal Mobile Networks and Applications, 5, 1999.
Transaction Processing Council. Tpc-c benchmark. Web Document, 1998. http://www.tpc.org.
N. H. Vaidya and S. Hameed. Scheduling data broadcast in asymmetric communication environments. Journal Mobile Networks and Applications, 5:171–182, 1999.
W. Yee, S. B. Navathe, E. Omiecinski, and C. Jermaine. Efficient data allocation over multiple channels at broadcast servers. IEEE Trans. Computers, to appear.
W. G. Yee, M. J. Donahoo, and S. Navathe. Framework for server data fragment grouping to improve scalability in intermittently synchronized databases. Proc. ACM CIKM, November 2000.
W. G. Yee, M. J. Donahoo, and S. B. Navathe. Scaling replica maintenance in intermittently synchronized databases. In Proc. ACM CIKM, November 2001.
W. G. Yee and S. B. Navathe. The design and management of database publications for client side replication. Technical report, Georgia Institute of Technology, 2001.
W. G. Yee, S. B. Navathe, E. Omiecinski, and C. Jermaine. Bridging the gap between response time and energy efficiency in broadcast schedule design. In Proc. EDBT, March 2002.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Gen Yee, W., Navathe, S.B. (2002). Design Considerations for Mobile Client-Server Database Applications. In: König-Ries, B., Makki, K., Pissinou, N., Makki, S., Scheuermann, P. (eds) Developing an Infrastructure for Mobile and Wireless Systems. IMWS 2001. Lecture Notes in Computer Science, vol 2538. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-36257-6_8
Download citation
DOI: https://doi.org/10.1007/3-540-36257-6_8
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-00289-5
Online ISBN: 978-3-540-36257-9
eBook Packages: Springer Book Archive