Skip to main content

Design Considerations for Mobile Client-Server Database Applications

  • Conference paper
  • First Online:

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 2538))

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

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. S. Acharya, R. Alonso, M. Franklin, and S. Zdonik. Broadcast disks: Data management for asymmetric communication environments. Proc. SIGMOD, May 1995.

    Google Scholar 

  2. S. Acharya, M. Franklin, and S. Zdonik. Prefetching from a broadcast disk. Proc. ICDE, 1996.

    Google Scholar 

  3. S. Acharya, M. Franklin, and S. Zdonik. Balancing push and pull for data broadcast. In Proc. SIGMOD, May 1997.

    Google Scholar 

  4. D. Aksoy and M. J. Franklin. Scheduling for large-scale on-demand data broadcasting. In Proc. IEEE INFOCOM, 1998.

    Google Scholar 

  5. M. H. Ammar and J. W. Wong. The design of teletext broadcast cycles. Performance Evaluation, 5(4):235–242, December 1985.

    Article  Google Scholar 

  6. Y. Breibart and H. F. Korth. Replication and consistency: Being lazy helps sometimes. In Proc. ACM PODS, 1997.

    Google Scholar 

  7. P. Chrysanthis. Transaction processing in a mobile computing environment. In IEEE Workshop on Advances in Parallel and Distributed Systems, pages 77–82, October 1993.

    Google Scholar 

  8. 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.

    Google Scholar 

  9. 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.

    Google Scholar 

  10. Division of Networking and Communications Research and Infrastructure. Research riorities in wireless and mobile communications and networking. Technical report, National Science Foundation, 1997.

    Google Scholar 

  11. 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.

    Article  Google Scholar 

  12. J. Duran and A. Laubach. Virtual personal computers and the portable network. In Proc. IEEE PCC, 1999.

    Google Scholar 

  13. M. J. Franklin, B. T. Jonsson, and D. Kossman. Performance tradeoffs for clientserver query processing. In Proc. SIGMOD, 1996.

    Google Scholar 

  14. M. J. Franklin and S. Zdonik. Dissemination-based information systems. IEEE Data Eng. Bulletin, 19(3), 1996.

    Google Scholar 

  15. J. Gold. What companies should knowabout the mobile/pervasion revolution. Sybase, Inc. Invited Industry Session, 2001.

    Google Scholar 

  16. A. Gorelik, Y. Wang, and M. Deppe. Sybase replication server. Proc. SIGMOD, 1994.

    Google Scholar 

  17. Bluetooth Special Interest Group. The official bluetooth web site. Web Document, 2001. http://www.bluetooth.com.

  18. Cahners In-Stat Group. Mobile computing devices: A newe ra in personal computing. Technical Report CM00-05MC, Cahners, Inc., November 2000.

    Google Scholar 

  19. B. Hammond. Merge replication in microsoft’s SQL server 7.0. Proc. SIGMOD, 1999.

    Google Scholar 

  20. IEEE. Working group for 802.11. Web Document, 2001. http://www.manta.ieee.org/groups/802.11.

  21. T. Imielinski and B. R. Badrinath. Wireless computing: Challenges in data management. Comm. ACM, October 1994.

    Google Scholar 

  22. 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.

    Article  Google Scholar 

  23. T. Imielinski, S. Viswanathan, and B. R. Badrinath. Energy efficient indexing on air. In Proc. SIGMOD, May 1994.

    Google Scholar 

  24. 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.

    Article  Google Scholar 

  25. 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.

    Google Scholar 

  26. L. Mummert and M. Satyanarayanan. Large granularity cache coherence in the coda file system. In Proceedings of the USENIX Summer Conference, 1994.

    Google Scholar 

  27. Q. Ren and M. H. Dunham. Using semantic caching to manage location dependent data in mobile computing. In Proc. IEEE/ACM MOBICOM, 2000.

    Google Scholar 

  28. 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.

    Google Scholar 

  29. J. Shanmugasundaram, A. Nithrakashyap, R. Sivasankaran, and K. Ramamritham. Efficient concurrency control for broadcast environments. In Proc. SIGMOD, pages 85–96, 1999.

    Google Scholar 

  30. C. J. Su, L. Tassiulus, and V. J. Tsortas. Broadcast scheduling for information distribution. Journal Mobile Networks and Applications, 5, 1999.

    Google Scholar 

  31. Transaction Processing Council. Tpc-c benchmark. Web Document, 1998. http://www.tpc.org.

  32. N. H. Vaidya and S. Hameed. Scheduling data broadcast in asymmetric communication environments. Journal Mobile Networks and Applications, 5:171–182, 1999.

    Google Scholar 

  33. W. Yee, S. B. Navathe, E. Omiecinski, and C. Jermaine. Efficient data allocation over multiple channels at broadcast servers. IEEE Trans. Computers, to appear.

    Google Scholar 

  34. 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.

    Google Scholar 

  35. W. G. Yee, M. J. Donahoo, and S. B. Navathe. Scaling replica maintenance in intermittently synchronized databases. In Proc. ACM CIKM, November 2001.

    Google Scholar 

  36. 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.

    Google Scholar 

  37. 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.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints 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

Publish with us

Policies and ethics