On-Mobile Query Processing Incorporating Multiple Non-Collaborative Servers

Mobile technology is currently growing rapidly and mobile information services have also becoming more critical in the world of mobile technology. It allows mobile users to download useful data, possibly from multiple sources. In this paper, we propose several techniques in processing information downloaded from multiple non-collaborative servers onto a mobile device. The proposed techniques are divided into two main classifications: (i) mobile device side processing, and (ii) server side processing. We also introduce the extended versions utilizing a block-based processing that helps reducing transfer costs and adapts to the memory limitation of mobile devices. Each of these proposed techniques comes in various versions. Walkthrough examples are also illustrated. Implementation and performance evaluation of these various techniques are investigated and critically analyzed.

[1]  David Taniar,et al.  A taxonomy of broadcast indexing schemes for multi channel data dissemination in mobile databases , 2004, 18th International Conference on Advanced Information Networking and Applications, 2004. AINA 2004..

[2]  Jianliang Xu,et al.  Performance Analysis of Location-Dependent Cache Invalidation Schemes for Mobile Environments , 2003, IEEE Trans. Knowl. Data Eng..

[3]  Yan Jia,et al.  Efficient Non-Blocking Top-k Query Processing in Distributed Networks , 2006, DASFAA.

[4]  Ronald Fagin,et al.  Comparing top k lists , 2003, SODA '03.

[5]  Ye-In Chang,et al.  A Hybrid Approach to Query Sets Broadcasting Scheduling for Multiple Channels in Mobile Information Systems , 2002, J. Inf. Sci. Eng..

[6]  Ming-Syan Chen,et al.  Design and performance studies of an adaptive cache retrieval scheme in a mobile computing environment , 2005, IEEE Transactions on Mobile Computing.

[7]  Wolf-Tilo Balke,et al.  Progressive distributed top-k retrieval in peer-to-peer networks , 2005, 21st International Conference on Data Engineering (ICDE'05).

[8]  Chao-Chun Chen,et al.  “Cache and Carry” for Location Management in Mobile Information Systems , 2004, Distributed and Parallel Databases.

[9]  Sandeep K. S. Gupta,et al.  An efficient cache maintenance scheme for mobile environment , 2000, Proceedings 20th IEEE International Conference on Distributed Computing Systems.

[10]  Ming-Syan Chen,et al.  Efficient Channel Allocation Tree Generation for Data Broadcasting in a Mobile Computing Environment , 2003, Wirel. Networks.

[11]  Edward Chan,et al.  Broadcast Strategies to Maintain Cached Data for Mobile Computing System , 1998, ER Workshops.

[12]  Ye-In Chang,et al.  A complementary approach to data broadcasting in mobile information systems , 2002, Data Knowl. Eng..

[13]  Jen-Jou Hung,et al.  Efficient index caching schemes for data broadcasting in mobile computing environments , 2003, 14th International Workshop on Database and Expert Systems Applications, 2003. Proceedings..

[14]  Chi-Yin Chow,et al.  Cache signatures for peer-to-peer cooperative caching in mobile environments , 2004, 18th International Conference on Advanced Information Networking and Applications, 2004. AINA 2004..

[15]  Vijay Kumar,et al.  Location dependent data and its management in mobile databases , 1998, Proceedings Ninth International Workshop on Database and Expert Systems Applications (Cat. No.98EX130).

[16]  David Taniar,et al.  Location Dependent Queries in Mobile Databases , 2004, IKE.

[17]  David Taniar,et al.  Parallel "GroupBy-Before-Join" Query Processing for High Performance Parallel/Distributed Database Systems , 2006, 20th International Conference on Advanced Information Networking and Applications - Volume 1 (AINA'06).

[18]  Guohong Cao,et al.  Proactive Power-Aware Cache Management for Mobile Computing Systems , 2002, IEEE Trans. Computers.

[19]  Hwan-Seung Yong,et al.  Personalized cache management for mobile computing environments , 2003, Inf. Process. Lett..

[20]  Ming-Syan Chen,et al.  Dependent data broadcasting for unordered queries in a multiple channel mobile environment , 2004, IEEE Transactions on Knowledge and Data Engineering.

[21]  David Taniar,et al.  Optimizing Query Access Time over Broadcast Channel in a Mobile Computing Environment , 2004, EUC.

[22]  JoAnne Holliday,et al.  Data Dissemination to a Large Mobile Network: Simulation of Broadcast Clouds , 2006, 7th International Conference on Mobile Data Management (MDM'06).

[23]  Dimitris Papadias,et al.  Top-k spatial joins , 2005, IEEE Transactions on Knowledge and Data Engineering.

[24]  Niki Pissinou,et al.  On the design of a location and query management strategy for mobile and wireless environments , 1999, Comput. Commun..

[25]  Clara Pizzuti,et al.  Top-k closest pairs join query: an approximate algorithm for large high dimensional data , 2004, Proceedings. International Database Engineering and Applications Symposium, 2004. IDEAS '04..

[26]  Akira Fukuda,et al.  Performance Modeling of Layered-Data Delivery for Mobile Users through Broadcast/On-Demand Hybrid Communication , 2001, Mobile Data Management.

[27]  David Taniar,et al.  Optimal Broadcast Channel for Data Dissemination in Mobile Database Environment , 2003, APPT.

[28]  Yehoshua Sagiv,et al.  Finding and approximating top-k answers in keyword proximity search , 2006, PODS '06.

[29]  Ming-Syan Chen,et al.  Using remote joins for the processing of distributed mobile queries , 2001, Proceedings Seventh International Conference on Database Systems for Advanced Applications. DASFAA 2001.

[30]  Dik Lun Lee,et al.  Cache algorithms based on adaptive invalidation reports for mobile environments , 1998, Cluster Computing.

[31]  Chi-Yin Chow,et al.  Group-based cooperative cache management for mobile clients in a mobile environment , 2004 .

[32]  Jie Liu,et al.  A pruning-based approach for supporting Top-K join queries , 2006, WWW '06.

[33]  Luis Gravano,et al.  Evaluating Top-k Selection Queries , 1999, VLDB.

[34]  Jun Yu,et al.  A Semantic-Driven Cache Management Approach for Mobile Applications , 2006, International Conference on Computational Science.

[35]  Sin Yeung Lee,et al.  Analysis of pre-computed partition top method for range top-k queries in OLAP data cubes , 2002, CIKM '02.

[36]  Kian-Lee Tan,et al.  Organization of Invalidation Reports for Energy-Efficient Cache Invalidation in Mobile Environments , 2001, Mob. Networks Appl..

[37]  Patrick Valduriez,et al.  Distributed and parallel database systems , 1996, CSUR.

[38]  Sharad Mehrotra,et al.  Evaluating refined queries in top-k retrieval systems , 2004, IEEE Transactions on Knowledge and Data Engineering.

[39]  Richard B. Bunt,et al.  Adaptive File Cache Management for Mobile Computing , 2003, Mobile Data Management.

[40]  Ming-Syan Chen,et al.  Query processing in a mobile computing environment: exploiting the features of asymmetry , 2005, IEEE Transactions on Knowledge and Data Engineering.

[41]  Guohong Cao.  A Scalable Low-Latency Cache Invalidation Strategy for Mobile , 2003, IEEE Trans. Knowl. Data Eng..

[42]  Ming-Syan Chen,et al.  Processing Distributed Mobile Queries with Interleaved Remote Mobile Joins , 2002, IEEE Trans. Computers.

[43]  Abdelkader Hameurlain,et al.  Mobile join operators for restricted sources , 2005, Mob. Inf. Syst..

[44]  Evaggelia Pitoura,et al.  Tutorial 2: Mobile and Wireless Database Access for Pervasive Computing , 2000, Proceedings of 16th International Conference on Data Engineering (Cat. No.00CB37073).

[45]  Quan Wang,et al.  Universal Quantification in Relational Databases: A Classification of Data and Algorithms , 2002, EDBT.

[46]  Jianzhong Li,et al.  Using PR-Tree and HPIR to Manage Coherence of Semantic Cache for Location Dependent Data in Mobile Database , 2002, WAIM.

[47]  Andreas Heuer,et al.  Database Access in Mobile Environments , 1996, DEXA.

[48]  Edward Chan,et al.  Cache invalidation scheme for mobile computing systems with real-time data , 2000, SGMD.

[49]  Rajeswari Malladi,et al.  Applying multiple query optimization in mobile databases , 2003, 36th Annual Hawaii International Conference on System Sciences, 2003. Proceedings of the.

[50]  Vijay Kumar,et al.  Broadcast protocols to support efficient retrieval from databases by mobile users , 1999, TODS.

[51]  Wolf-Tilo Balke,et al.  Top-k Query Evaluation for Schema-Based Peer-to-Peer Networks , 2004, SEMWEB.

[52]  Vijay Kumar,et al.  DAYS mobile: a location based data broadcast service for mobile users , 2007, SAC '07.

[53]  Chung-Min Chen,et al.  A Sampling-Based Estimator for Top-k Query. , 2002, ICDE 2002.

[54]  Yungho Leu,et al.  Efficient data broadcast schemes for mobile computing environments with data missing , 2005, Inf. Sci..

[55]  Xiaoyong Du,et al.  Efficient Top-k Query Processing in P2P Network , 2004, DEXA.

[56]  Clara Pizzuti,et al.  An approximate algorithm for top-k closest pairs join query in large high dimensional data , 2005, Data Knowl. Eng..

[57]  Guohong Cao.  On Improving the Performance of Cache Invalidation in Mobile Environments , 2002, Mob. Networks Appl..

[58]  Edward Chan,et al.  Concurrency Control for Mobile Systems with Data Broadcast , 2001, J. Interconnect. Networks.

[59]  Ming-Syan Chen,et al.  Dynamic Leveling: Adaptive Data Broadcasting in a Mobile Computing Environment , 2003, Mob. Networks Appl..

[60]  Giuseppe Pelagatti,et al.  Semantics and Probelms of Universal Quantification in SQL , 1989, Comput. J..

[61]  Sin Yeung Lee,et al.  Adaptive Method for Range Top- k Queries in OLAP Data Cubes , 2002, DEXA.

[62]  Hua-Gang Li,et al.  Efficient Processing of Distributed Top-k Queries , 2005, DEXA.

[63]  Ken C. K. Lee,et al.  Adaptive semantic data broadcast in a mobile environment , 2001, SAC.

[64]  Patrick Valduriez,et al.  Reducing network traffic in unstructured P2P systems using Top-k queries , 2006, Distributed and Parallel Databases.

[65]  Panos Kalnis,et al.  Optimization of Spatial Joins on Mobile Devices , 2003, SSTD.

[66]  David Taniar,et al.  Parallel processing of "GroupBy-Before-Join" queries in cluster architecture , 2001, Proceedings First IEEE/ACM International Symposium on Cluster Computing and the Grid.

[67]  Philip S. Yu,et al.  Optimizing Index Allocation for Sequential Data Broadcasting in Wireless Mobile Computing , 2003, IEEE Trans. Knowl. Data Eng..

[68]  Q. Zhang,et al.  TOP-k Query Calculation in Peer-to-Peer Networks , 2005, ASIAN.

[69]  Richard Vlach.  Efficient execution strategies for mobile procedures querying distributed databases , 2000, Proceedings DOA'00. International Symposium on Distributed Objects and Applications.

[70]  Quan Wang,et al.  Algorithms and applications for universal quantification in relational databases , 2003, Inf. Syst..

[71]  David Taniar,et al.  Performance Evaluation of Parallel GroupBy-Before-Join Query Processing in High Performance Database Systems , 2001, HPCN Europe.

[72]  Claudio Fratarcangeli.  Technique for universal quantification in SQL , 1991, SGMD.

[73]  Man Lung Yiu,et al.  Top-k Spatial Preference Queries , 2007, 2007 IEEE 23rd International Conference on Data Engineering.

[74]  Luis Gravano,et al.  Optimizing top-k selection queries over multimedia repositories , 2004, IEEE Transactions on Knowledge and Data Engineering.

[75]  Aoying Zhou,et al.  Approximate Top-k Structural Similarity Search over XML Documents , 2006, APWeb.

[76]  Jie Liu,et al.  Semantic link based top-K join queries in P2P networks , 2006, WWW '06.

[77]  Edward Omiecinski.  Parallel Relational Database Systems , 1995, Modern Database Systems.

[78]  Hong V. Lcorig.  Cache Management for Mobile Databases: Design and Evaluation* , 1998 .

[79]  Shan Wang,et al.  Location dependent query in a mobile environment , 2003, Inf. Sci..

[80]  Jen-Jou Hung,et al.  An energy efficient data reaccess scheme for data broadcast in mobile computing environments , 2003, 2003 International Conference on Parallel Processing Workshops, 2003. Proceedings..

[81]  Zoubir Mammeri,et al.  Query processing in mobile environments: a survey and open problems , 2005, First International Conference on Distributed Frameworks for Multimedia Applications.

[82]  David Taniar,et al.  On building a data broadcasting system for mobile databases , 2005, 19th International Conference on Advanced Information Networking and Applications (AINA'05) Volume 1 (AINA papers).

[83]  Divyakant Agrawal,et al.  Efficient Computation of Frequent and Top-k Elements in Data Streams , 2005, ICDT.

[84]  Seung-won Hwang,et al.  Optimizing access cost for top-k queries over Web sources: a unified cost-based approach , 2005, 21st International Conference on Data Engineering (ICDE'05).

[85]  David Taniar,et al.  Performance analysis of "Groupby-After-Join" query processing in parallel database systems , 2004, Inf. Sci..

[86]  Ming-Syan Chen,et al.  SOM: dynamic push-pull channel allocation framework for mobile data broadcasting , 2006, IEEE Transactions on Mobile Computing.

[87]  Jiawei Han,et al.  Answering top-k queries with multi-dimensional selections: the ranking cube approach , 2006, VLDB.

[88]  Hans-Erich Kottkamp,et al.  Location-aware query processing in mobile database systems , 1998, SAC '98.

[89]  Po-Jen Chuang,et al.  An efficient cache invalidation strategy in mobile environments , 2004, 18th International Conference on Advanced Information Networking and Applications, 2004. AINA 2004..

[90]  Gerhard Weikum,et al.  KLEE: A Framework for Distributed Top-k Query Algorithms , 2005, VLDB.

[91]  Mohan Kumar,et al.  Flexible Integrated Cache for Efficient Information Access in Mobile Computing Environments , 2001, Infrastructure for Mobile and Wireless Systems.

[92]  Won-Sik Yoon,et al.  An Energy Efficient Broadcasting for Mobile Devices Using a Cache Scheme , 2004, International Conference on Computational Science.

[93]  Darin Chan,et al.  Context-Sensitive Mobile Database Summarisation , 2003, ACSC.

[94]  Cheng-Jung Tsai,et al.  An efficient approach to extracting and ranking the top K interesting target ranks from Web search engines , 2001, Informatica.

[95]  C. J. Date.  An Introduction to Database Systems, 6th Edition , 1995 .

[96]  Krithi Ramamritham,et al.  Broadcast on demand: efficient and timely dissemination of data in mobile environments , 1997, Proceedings Third IEEE Real-Time Technology and Applications Symposium.

[97]  Young-Koo Lee,et al.  An Efficient Algorithm for Computing Range-Groupby Queries , 2006, DASFAA.

[98]  Sihem Amer-Yahia,et al.  Adaptive processing of top-k queries in XML , 2005, 21st International Conference on Data Engineering (ICDE'05).

[99]  Ahmad S. Al-Mogren,et al.  BUC, a simple yet efficient concurrency control technique for mobile data broadcast environment , 2001, 12th International Workshop on Database and Expert Systems Applications.

[100]  Ken C. K. Lee,et al.  Semantic Data Broadcast for a Mobile Environment Based on Dynamic and Adaptive Chunking , 2002, IEEE Trans. Computers.

[101]  Kevin Chen-Chuan Chang,et al.  RankSQL: query algebra and optimization for relational top-k queries , 2005, SIGMOD '05.

[102]  Jianliang Xu,et al.  Cache Invalidation and Replacement Strategies for Location-Dependent Data in Mobile Environments , 2002, IEEE Trans. Computers.

[103]  David Taniar,et al.  Parallel Aggregate-Join Query Processing , 2002, Informatica.

[104]  David Taniar,et al.  Data Dissemination in Mobile Databases , 2005, Encyclopedia of Information Science and Technology.

[105]  Dik Lun Lee,et al.  Adaptive cache invalidation methods in mobile environments , 1997, Proceedings. The Sixth IEEE International Symposium on High Performance Distributed Computing (Cat. No.97TB100183).

[106]  Bo Xu,et al.  Searching Local Information in Mobile Databases , 2006, 22nd International Conference on Data Engineering (ICDE'06).

[107]  Goetz Graefe,et al.  Fast algorithms for universal quantification in large databases , 1995, TODS.

[108]  Sin Yeung Lee,et al.  Range Top/Bottom k Queries in OLAP Sparse Data Cubes , 2001, DEXA.

[109]  Kamesh Munagala,et al.  A Sampling-Based Approach to Optimizing Top-k Queries in Sensor Networks , 2006, 22nd International Conference on Data Engineering (ICDE'06).

[110]  Ahmed K. Elmagarmid,et al.  Scalable Cache Invalidation Algorithms for Mobile Data Access , 2003, IEEE Trans. Knowl. Data Eng..

[111]  Zhe Wang,et al.  Efficient top-K query calculation in distributed networks , 2004, PODC '04.

[112]  Yi Zhu,et al.  Index and Data Allocation in Mobile Broadcast , 2001, DEXA.