This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Query Processing in a Mobile Computing Environment: Exploiting the Features of Asymmetry
July 2005 (vol. 17 no. 7)
pp. 982-996
With the cutting edge technology advance in wireless and mobile computers, the query processing in a mobile environment involves join processing among different sites which include static servers and mobile computers. Because of the need for energy saving and also 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 three asymmetric features of a mobile environment. Then, in light of these features, we devise query processing methods for both join and query processing. Intuitively, employing semijoin operations in a mobile computing environment is able to further reduce both the amount of data transmission and energy consumption. A semijoin which is initiated by a mobile computer (respectively, the server) and is beneficial to reduce the cost of a join operation is termed a mobile-initiated or MI (respectively, server-initiated or SI) profitable semijoin. According to those asymmetric features of a mobile computing system, we examine three different join methods and devise some specific criteria to identify MI/SI profitable semijoins. For query processing, which refers to the processing of multijoin queries, we develop three query processing schemes. In particular, we formulate the query processing in a mobile computing system as a two-phase query processing procedure that can determine a join sequence and interleave that join sequence with SI profitable semijoins to reduce both the amount of data transmission and energy consumption. Performance of these join and query methods is comparatively analyzed and sensitivity analysis on several parameters is conducted. Furthermore, we develop a systematic procedure to derive the characteristic functions of MI and SI profitable semijoins. It is noted that, given some system parameters, those characteristic functions are very important in determining which join method is the most appropriate one to employ in that configuration. It is shown by our simulation results that, by exploiting the three asymmetric features, these characteristic functions are very powerful in reducing both the amounts of energy consumption and data transmission incurred and can lead to the design of an efficient and effective query processing procedure for a mobile computing environment.

[1] 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.
[2] Applications of Mobile Computing, http://www.nokia.com/3gindex.html, 2005.
[3] D. Barbara, “Mobile Computing and Databases— A Survey,” IEEE Trans. Knowledge and Data Eng., vol. 11, no. 1, pp. 108-117, Jan./Feb. 1999.
[4] S. Ceri and G. Pelagatti, Distributed Databases Principles and Systems. McGraw-Hill, 1984.
[5] 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.
[6] 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.
[7] M.-S. Chen, P.S. Yu, and T.-H. Tang, “On Coupling Multiple Systems with a Global Buffer,” IEEE Trans. Knowledge and Data Eng, vol. 8, no. 2, pp. 339-344, Apr. 1996.
[8] 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.
[9] A. Datta, D.E. Vandermeer, A. Celik, and V. Kumar, “Broadcast Protocols to Support Efficient Retrieval from Databases by Mobile Users,” ACM Trans. Database Systems, vol. 24, no. 1, pp. 1-79, Mar. 1999.
[10] M.H. Dunham, “Mobile Computing and Databases,” Proc. Tutorial Int'l Conf. Data Eng., Feb. 1998.
[11] 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.
[12] M.J. Franklin, B.T. Jonsson, and D. Kossmann, “Performance Tradeoffs for Client-Server Query Processing,” Proc. ACM SIGMOD, pp. 149-160, June 1996.
[13] S. Ganguly, “Design and Analysis of Parametric Query Optimization Algorithms,” Proc. 24th Int'l Conf. Very Large Databases, pp. 228-238, 1998.
[14] 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.
[15] T. Imielinski and S. Goel, “DataSpace— Querying and Monitoring Deeply Networked Collections in Physical Space,” Proc. Int'l Workshop Data Eng. Wireless and Mobile Access, pp. 44-51, 1999.
[16] R. Jain and N. Krishnakumar, “Asymmetric Costs and Dynamic Query Processing in Mobile Computing Environments,” Proc. Fifth WIN-LAB Workshop, Apr. 1995.
[17] R. Jain and N. Krishnakumar, “An Asymmetric Cost Model for Query Processing in Mobile Computing Environments,” Proc. ACM Symp. Applied Computing, pp. 365-372 1996.
[18] 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.
[19] 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.
[20] C.-H. Lee and M.-S. Chen, “Using Remote Joins for the Processing of Distributed Mobile Queries,” Proc. Seventh Int'l Conf. Database Systems for Advanced Applications, pp. 226-233, Apr. 2001.
[21] S.R. Madden, M.J. Franklin, J.M. Hellerstein, and W. Hong, “The Design of an Acquisitional Query Processor for Sensor Networks,” Proc. ACM SIGMOD Int'l Conf. Management of Data, pp. 491-502, June 2003.
[22] “Palm Pilots of 3com,” http:/www.palm.com, 2005.
[23] A.P. Sistla, O. Wolfson, S. Chamberlain, and S. Dao, “Modeling and Querying Moving Objects,” Proc. 13th Int'l Conf. Data Eng., pp. 422-432, Apr. 1997.
[24] 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.
[25] C. Wang and M.-S. Chen, “On the Complexity of Distributed Query Optimization,” IEEE Trans. Knowledge and Data Eng., vol. 8, no. 4, pp. 650-662, Aug. 1996.
[26] “WAP application in Nokia,” http://www.nokia.com/nokia0,,62652,00.html , 2005.
[27] “WAP application in Unwired Planet, Inc.,” http://www. openwave.com/us/products/developer_products/ wap_push_ library index.htm, 2005.
[28] “WAP Forum,” http:/www.wapforum.org, 2005.
[29] 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.
[30] Y. Yao and J. Gehrke, “Query Processing for Sensor Networks,” Proc. Conf. Innovative Data Systems Research., pp. 21-32, 2003.
[31] C.T. Yu and C.C. Chang, “Distributed Query Processing,” ACM Computer Surveys, vol. 16, no. 4, pp. 399-433, Dec. 1984.

Index Terms:
Index Terms- Mobile database, mobile computing, query processing, join method.
Citation:
Wen-Chih Peng, Ming-Syan Chen, "Query Processing in a Mobile Computing Environment: Exploiting the Features of Asymmetry," IEEE Transactions on Knowledge and Data Engineering, vol. 17, no. 7, pp. 982-996, July 2005, doi:10.1109/TKDE.2005.115
Usage of this product signifies your acceptance of the Terms of Use.