An asymmetric cost model for query processing in mobile computing environments

We address the issue of query processing for information services in mobile environments, using a mobile sales and inventory application example. Efficient query processing depends upon choosing one of several candidate query plans based upon a cost model which accurately reflects computation and communication costs. Unlike traditional distributed database environments, mobile environments necessitate new cost models which are asymmetric in the sense that the resources available at mobile sites are less than those at fixed sites, and communication costs vary with the direction of data transfer. In addition, communication costs may vary as the mobile moves. We design a cost model which incorporates these criteria and illustrate it via examples. As costs change dynamically, it is desirable that the query execution plan be modified dynamically to optimize the cost. Existing distributed query processing algorithms can be modified to suit the mobile environment and this paper discusses our ongoing work to do so.

[1]  S. B. Yao,et al.  Optimization Algorithms for Distributed Queries , 1986, IEEE Transactions on Software Engineering.

[2]  Rafael Alonso,et al.  Query optimization in mobile environments , 1993 .

[3]  Tomasz Imielinski,et al.  Mobile wireless computing: challenges in data management , 1994, CACM.

[4]  Guy M. Lohman,et al.  Optimizer Validation and Performance Evaluation for Distributed Queries , 1998 .

[5]  Alan R. Hevner,et al.  Query Processing in Distributed Database System , 1979, IEEE Transactions on Software Engineering.

[6]  Clement T. Yu,et al.  Query Processing in a Fragmented Relational Distributed System: Mermaid , 1985, IEEE Transactions on Software Engineering.

[7]  Andreas Reuter,et al.  Transaction Processing: Concepts and Techniques , 1992 .

[8]  Patrick Valduriez,et al.  Principles of Distributed Database Systems , 1990 .

[9]  Narayanan Krishnakumar,et al.  Network support for personal information services to PCS users , 1994, Proceedings of Networks for Personal Communications - NPC'94.

[10]  Tomasz Imielinski,et al.  Energy efficient indexing on air , 1994, SIGMOD '94.

[11]  Michael Stonebraker,et al.  Distributed query processing in a relational data base system , 1978, SIGMOD Conference.

[12]  Clement T. Yu,et al.  Performance Issues in Distributed Query Processing , 1993, IEEE Trans. Parallel Distributed Syst..

[13]  Tomasz Imielinski,et al.  Data management issues in mobile computing , 1994 .

[14]  Eugene Wong,et al.  Query processing in a system for distributed databases (SDD-1) , 1981, TODS.

[15]  Ravi Jain,et al.  Airdisks and AirRAID: Modeling and scheduling periodic wireless data broadcast (Extended , 1995 .

[16]  Clement T. Yu,et al.  Distributed query processing , 1984, CSUR.

[17]  Don Batory,et al.  Query Processing in Database Systems , 2011, Topics in Information Systems.