This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Processing Distributed Mobile Queries with Interleaved Remote Mobile Joins
October 2002 (vol. 51 no. 10)
pp. 1182-1195

Abstract—The query processing in a mobile computing environment involves join processing among different sites which include static servers and mobile computers. Because of the presence of asymmetric features in a mobile computing environment, the conventional query processing for a distributed database cannot be directly applied to a mobile computing system. In this paper, we first explore some unique features of a mobile environment and then, in light of these features, devise query processing methods for both join and query processing. Remote mobile joins are said to be effectual if they are, when being interleaved into a join sequence, able to reduce the amount of data transmission cost required for distributed mobile query processing. Since mobile relations are employed as reducers in our proposed query processing cost model, more mobile joins in the query processing lead to less data transmitted through the network. With proper scheduling, interleaving effectual remote mobile joins into a query scheduling can significantly reduce the total amount of data transmission among different sites. A simulator is developed to evaluate the performance of algorithms devised. Our results show that the approach of interleaving the processing of distributed mobile queries with effectual remote mobile joins is not only efficient, but also effective in reducing the total amount of data transmission cost required to process distributed mobile queries.

[1] 3GPP,http:/www.3gpp.org/, 2002.
[2] S. Acharya, R. Alonso, M. Franklin, and S. Zdonik, “Broadcast Disks: Data Management for Asymmetric Communication Environments,” Proc. ACM SIGMOD, pp. 199-210, May 1995.
[3] D. Aksoy and M.J. Franklin, Scheduling for Large-Scale On-Demand Data Broadcasting Proc. IEEE INFOCOM Conf., pp. 651-659, Mar. 1998.
[4] I.F. Akyildiz, J. McNair, J.S.M. Ho, H. Uzunalioglu, and W. Wang, “Mobility Management in Next Generation Wireless Systems,” Proc. IEEE, vol. 87, no. 8, pp. 1347-1385, Aug. 1999.
[5] R. Alonso and S. Ganguly, “Query Optimization in Mobile Environments,” Proc. Fifth Workshop Foundations of Models and Languages for Data and Objects, pp. 1-17, Sept. 1993.
[6] “Applications of Mobile Computing,” http://www.nokia.com/3gindex.html, 2002.
[7] D. Barbara, “Mobile Computing and Databases—A Survey,” IEEE Trans. Knowledge and Data Eng., vol. 11, no. 1, pp. 108-117, Jan./Feb. 1999.
[8] P.A. Bernstein, N. Goodman, E. Wong, C. Reeve, and J.B. Rothnie, “Query Processing in a System for Distributed Databases,” ACM Trans. Database Systems, vol. 6, no. 4, pp. 602-625, Dec. 1981.
[9] G. Bojan and M.M. Qutaibah, “Combinatorial Optimization of Distributed Queries,” IEEE Trans. Knowledge and Data Eng., vol. 7, no. 6, pp. 915-927, Dec. 1995.
[10] P. Bonnet, J.E. Gehrke, and P. Seshadri, "Querying the Physical World," IEEE Personal Comm., vol. 7, no. 5, Oct. 2000, pp. 10-15.
[11] J. Cai and D.J. Goodman, “General Packet Radio Service in GSM,” IEEE Comm. Magazine, pp. 122-131, Oct. 1997.
[12] S. Ceri and G. Pelagatti, Distributed Databases: Principles and Systems.New York: McGraw-Hill, 1984.
[13] M.-S. Chen and P.S. Yu, “Interleaving a Join Sequence with Semijoins in Distributed Query Processing,” IEEE Trans. Parallel and Distributed Systems, vol. 3, no. 5, pp. 611-621, Sept. 1992.
[14] M.-S. Chen and P.S. Yu, “Combining Join and Semijoin Operations for Distributed Query Processing,” IEEE Trans. Knowledge and Data Eng., vol. 5, no. 3, pp. 534-542, June 1993.
[15] M.-S. Chen and P.S. Yu, “A Graph Theoretical Approach to Determine a Join Reducer Sequence in Distributed Query Processing,” IEEE Trans. Knowledge and Data Eng., vol. 6, no. 1, pp. 152-165, Feb. 1994.
[16] M.-S. Chen, P.S. Yu, and T.-H. Yang, “On Coupling Multiple Systems with A Global Buffer,” IEEE Trans. Knowledge and Data Eng., vol. 8, no. 2, pp. 339-344, Apr. 1996.
[17] M.-S. Chen, P.S. Yu, and K.-L. Wu, “Optimization of Parallel Execution for Multi-Join Queries,” IEEE Trans. Knowledge and Data Eng., vol. 8, no. 3, pp. 416-428, June 1996.
[18] M.H. Dunham, “Mobile Computing and Databases,” Tutorial Int'l Conf. Data Engi., Feb. 1998.
[19] M.H. Dunham, A. Helal, and S. Balakrishnan, “A Mobile Transaction Model That Captures Both the Data and Movement Behavior,” ACM J. Mobile Networks and Applications, vol. 2, pp. 149-162, 1997.
[20] M.H. Dunham and V. Kumar, “Location Dependent Data and its Management in Mobile Databases,” Proc. Ninth Int'l Workshop Database and Expert Systems Applications, pp. 26-29, Aug. 1998.
[21] B. Vasudevan et al., LFSR Based Deterministic Hardware for At-Speed BIST Proc. VLSI Test Symp., pp. 201-207, 1992.
[22] M.J. Franklin, B.T. Jonsson, and D. Kossmann, “Performance Tradeoffs for Client-Server Query Processing,” Proc. ACM SIGMOD, pp. 149-160, June 1996.
[23] S. Ganguly, “Design and Analysis of Parametric Query Optimization Algorithms,” Proc. 24th Int'l Conf. Very Large Data Bases, pp. 228-238, 1998.
[24] D. Gardy and C. Puech, “On the Effect of Join Operations on Relation Sizes,” ACM Trans. Database Systems, vol. 14, no. 4, pp. 574-603, Dec. 1989.
[25] N. Gupta, J.R. Haritsa, and M. Ramanath, “Distributed Query Processing on the Web,” Proc. 2000 Int'l Conf. Data Eng., 2000.
[26] J.C. Haartsen, “The Bluetooth Radio System,” IEEE Personal Comm., vol. 7, no. 1, pp. 28-36, Feb. 2000.
[27] P. Haas and A. Swami, “Sequential Sampling Procedures for Query Size Estimation,” Proc. ACM SIGMOD, pp. 341-350, June 1992.
[28] T. Hara, “Effective Replica Allocation in Ad Hoc Networks for Improving Data Accessibility,” Proc. IEEE INFOCOM Conf., Apr. 2001.
[29] T. Imielinski and B.R. Badrinath, “Querying in Highly Mobile and Distributed Environment,” Proc. 18th Int'l Conf. Vary Large Data Bases, pp. 41-52, Aug. 1992.
[30] T. Imielinski, S. Viswanathan, and B.R. Badrinath, Data on Air: Organization and Access IEEE Trans. Knowledge and Data Eng., vol. 9, no. 9, pp. 353-372, June 1997.
[31] J. Jannink, D. Lam, N. Shivakumar, J. Widom, and D. Cox, “Efficient amd Flexible Location Management Techniques for Wireless Communication Systems,” ACM J. Wireless Networks, vol. 3, no. 5, pp. 361-374, 1997.
[32] J. Jing, A. Helal, and A. Elmagarmid, “Client-Server Computing in Mobile Environments,” ACM Computing Surveys, vol. 31, no. 2, pp. 117-157, June 1999.
[33] P. Krishnamurthy, K. Pahlavan, and A. Hatami, “Handoff in Hybrid Mobile Data Networks,” IEEE Personal Comm., vol. 7, no. 2, Apr. 2000.
[34] J.M. Kahn, R.H. Katz, and K.S.J. Pister, “Next Century Challenges: Mobile Networking for 'Smart Dust',” Proc. Conf. Mobile Computing MOBICOM, pp. 271-278, 1999.
[35] A. Kahol, S. Khurana, S.K.S. Gupta, and P.K. Srimani, “A Strategy to Manage Cache Consistency in a Disconnected Distributed Environment,” IEEE Trans. Parallel and Distributed Systems, vol. 12, no. 7, pp. 686-700, July 2001.
[36] S. Kapp, “802.11: Leaving the Wire Behind,” IEEE Internet Computing, vol. 6, no. 1, Feb. 2002.
[37] D.N. Knisely, S. Kumar, S. Laha, and S. Nanda, “Evolution of Wireless Data Services: IS-95 to cdma2000,” IEEE Comm. Magazine, pp. 140-149, Oct. 1998.
[38] D. Kossmann, “The State of the Art in Distributed Query Processing,” ACM Computing Surveys, Sept. 2000.
[39] W.-C. Lee, Q.L. Hu, and D.L. Lee, “A Study on Channel Allocation for Data Dissemination in Mobile Computing Environments,” ACM/Baltzer Mobile Networks and Applications, vol. 4, no. 5, pp. 117-129, May 1999.
[40] R. Mase and S. Nogami, “An Internet Paradigm and Scheduling Algorithm for Quaranteeing End-to-End QoS,” Proc. Internet Workshop 1999 (IWS '99), pp. 107-111, 1999.
[41] P. Mishra and M.H. Eich, "Join Processing in Relational Databases," ACM Computing Surveys, vol. 24, no. 1, pp. 64-113, Mar. 1992.
[42] K.J. Negus, A.P. Stephens, and J. Lansford, “HomeRF: Wireless Networking for the Connected Home,” IEEE Personal Comm., vol. 7, no. 1, pp. 20-27, Feb. 2000.
[43] E. Pacitti, P. Minet, and E. Simon, “Fast Algorithms for Maintaining Replica Consistency in Lazy Master Replicated Databases,” Proc. 1999 Int'l Conf. Very Large Data Bases, pp. 126-137, 1999.
[44] Palm Pilots of 3com,http://www.3com.com/palmindex.html, 2002.
[45] W.-C. Peng and M.-S. Chen, “Exploiting the Features of Asymmetry for Query Processing in a Mobile Computing Environment,” Proc. Fifth IFCIS Conf. Cooperative Information Systems (CoopIS 2000), 2000.
[46] E. Pitoura and G. Samaras, “Locating Objects in Mobile Computing,” IEEE Trans. Kowledge and Data Eng., vol. 13, no. 4, July/Aug. 2001.
[47] Q. Ren and M.H. Dunham, “Using Clustering for Effective Management of a Semantic Cache in Mobile Computing,” Proc. First ACM Int'l Workshop Data Eng. for Wireless and Mobile Access, pp. 94-101, Aug. 1999.
[48] Q. Ren and M.H. Dunham, “Using Semantic Caching to Manage Location Dependent Data in Mobile Computing,” Proc. Sixth ACM/IEEE Int'l Conf. Mobile Computing and Networking, pp. 210-221, Aug. 2000.
[49] N. Roussopoulos and H. Kang, “A Pipeline N-Way Join Algorithm Based on the 2-Way Semijoin Program,” IEEE Trans. Knowledge and Data Eng,m vol. 3, no. 4, pp. 461-473, Dec. 1991.
[50] A.Y. Seydim, M.H. Dunham, and V. Kumar, “Location Dependent Query Processing,” Proc. Second ACM Int'l Workshop Data Eng. for Wireless and Mobile Access, pp. 47-53, May 2001.
[51] N. Shivakumar and J. Jannink, J. Widom, “Per-User Profile Replication in Mobile Environments: Algorithms, Analysis and Simulation Results,” ACM J. Mobile Networks and Applications, vol. 2, pp. 129-140, 1997.
[52] T.M. Siep, I.C. Gifford, R.C. Braley, and R.F. Heile, “Paving the Way for Personal Area Network Standards: An Overview of the IEEE P802.15 Working Group for Wireless Personal Area Networks,” IEEE Personal Comm., pp. 6-13, Feb. 2000.
[53] P.A. Sistla, O. Wolfson, S. Chamberlain, and S. Dao, Modeling and Querying Moving Objects Proc. Int'l Conf. Data Eng., pp. 422-432, 1997.
[54] N.R. Sollenberger, N. Seshadri, and R. Cox, “The Evolution of IS-136 TDMA for Third-Generation Wireless Services,” IEEE Personal Comm., pp. 8-18, June 1999.
[55] K. Stathatos, N. Roussopoulos, and J.S. Baras, “Adaptive Data Broadcast in Hybrid Networks,” Proc. 23rd Int'l Conf. Very Large Data Bases, pp. 326-335, 1997.
[56] M. Stemm and R.H. Katz, “Vertical Handoffs in Wireless Overlay Networks,” ACM Mobile Networks and Applications, vol. 3, no. 4, pp. 319-334, 1998.
[57] A.B. Stephens, Y. Yesha, and K.E. Humenik, “Optimal Allocation for Partially Replicated Database Systems on Ring Networks,” IEEE Trans. Knowledge and Data Eng., vol. 6, pp. 975-982, 1994.
[58] “WAP Application in Nokia,” http://www.nokia.com/corporate/wapfuture.html , 2002.
[59] WAP Forum,http:/www.wapforum.org/, 2002.
[60] O. Wolfson, S. Chamberlain, S. Dao, L. Jiang, and G. Mendez, “Cost and Imprecision in Modeling the Position of Moving Objects,” Proc. 14th Int'l Conf. Data Eng., pp. 588-596, Feb. 1998.
[61] Z. Xie and J. Han, “Join Index Hierarchies for Supporting Efficient Navigations in Object-Oriented Databases,” Proc. 1994 Int'l Conf. Very Large Data Bases, pp. 522-533, Sept. 1994.
[62] B. Xu, O. Wolfson, S. Chamberlain, and N. Rishe, “Cost Based Data Dissemination in Satellite Networks,” ACM Mobile Networks and Applications, vol. 7, no. 1, Jan. 2002.
[63] J.L. Xu, Q.L. Hu, D.L. Lee, and W.-C. Lee, “SAIU: An Efficient Cache Replacement Policy for Wireless On-Demand Broadcasts,” Proc. Ninth ACM Int'l Conf. Information and Knowledge Management, pp. 46-53, Nov. 2000.
[64] C.T. Yu and C.C. Chang,“Distributed query processing,” ACM Computing Surveys, vol. 16, pp. 399-433, 1984.
[65] C.T. Yu and W. Meng, Principle of Database Query Processing for Advanced Applications. San Francisco: Morgan Kaufmann, 1997.
[66] T.B. Zahariadis, K.G. Vaxevanakis, C.P. Tsantilas, and N.A. Zervos, “Global Roaming in Next-Generation Networks,” IEEE Comm., vol. 40, no. 2, Feb. 2002.
[67] Z. Zhang and W. Perrizo, “Distributed Query Processing Using Active Networks,” Proc. 2000 ACM Symp. Applied Computing, pp. 374-380, 2000.
[68] B. Zheng and D.L. Lee, “Processing Location-Dependent Queries in a Multi-Cell Wireless Environment,” Proc. Second ACM Int'l Workshop Data Eng. for Wireless and Mobile Access, pp. 54-65, May 2001.

Index Terms:
Distributed query processing, mobile computing, remote mobile joins, query scheduling.
Citation:
Chang-Hung Lee, Ming-Syan Chen, "Processing Distributed Mobile Queries with Interleaved Remote Mobile Joins," IEEE Transactions on Computers, vol. 51, no. 10, pp. 1182-1195, Oct. 2002, doi:10.1109/TC.2002.1039844
Usage of this product signifies your acceptance of the Terms of Use.