Skip to main content

Advertisement

SpringerLink
Log in

Adaptive processing of historical spatial range queries in peer-to-peer sensor networks

  • Published:
Distributed and Parallel Databases Aims and scope Submit manuscript

Abstract

We investigate the problem of processing historical queries on a sensor network. Since data is considered to have been already collected at the sensor nodes, the main issue is exploring the spatial component of the query in order to minimize its cost represented by the energy consumption. We assume queries can be issued at any network node, i.e., there is no central base station and all nodes have only local knowledge of the network. On the one hand, a globally optimum query processing plan is desirable but its construction is not possible due to the lack of global knowledge of the network. On the other hand, while a simple network flooding is feasible, it is not a practical choice from a cost perspective. To address this problem we propose a two-phase query processing strategy, where in the first phase a path from the query originator to the query region is found and in the second phase the query is processed within the query region itself. This strategy is supported by analytical models that are used to dynamically select the best processing strategy depending on the query specifics. Our extensive analytical and experimental results show that our analytical models are accurate and that the two-phase strategy is better suited for small to medium sized queries, being up to 10 times more cost effective than a typical network flooding. In addition, the dynamic selection of a query processing technique proved itself capable of always delivering at least as good performance as the most energy efficient strategy for all query sizes.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  1. Abadi, D., Madden, S., Lindner, W.: REED: robust, efficient filtering and event detection in sensor networks. In: Proceedings of the International Conference on Very Large Databases (VLDB), pp. 769–780 (2005)

  2. Coman, A., Nascimento, M.A.: A distributed algorithm for joins in sensor networks. In: Proceedings of the International Conference on Scientific and Statistical Database Management (SSDBM) (2007)

  3. Coman, A., Nascimento, M.A., Sander, J.: A framework for spatio-temporal query processing over wireless sensor networks. In: Proceedings of the International Workshop on Data Management for Sensor Networks (with VLDB), pp. 104–110 (2004)

  4. Coman, A., Nascimento, M.A., Sander, J.: On join location in sensor networks. In: Proceedings of International Conference on Mobile Data Management (MDM) (2007)

  5. Crossbow Technology Inc.: MICA sensor platform. www.xbow.com

  6. Dana, P.H.: Global positioning system overview. The Geographer’s Craft Project, University of Colorado at Boulder (1994–2000). Available at http://www.colorado.edu/geography/gcraft/notes/gps/gps.html

  7. Demers, A., Gehrke, J., Rajaraman, R., Trigoni, N., Yao, Y.: Energy-efficient data management for sensor networks. In: Proceedings of the Upstate New York Workshop on Sensor Networks (2003)

  8. Finn, G.G.: Routing and addressing problems in large metropolitan-scale internetworks. ISI Res. Rep. ISU/RR-87-180, University of Southern California (1987)

  9. He, G., Zheng, R., Gupta, I., Sha, L.: A framework for time indexing in sensor networks. ACM Trans. Sensor Netw. 1(1), 101–133 (2005)

    Article  Google Scholar 

  10. Heinzelman, W.: Application-specific protocol architectures for wireless networks. PhD thesis, MIT (2000). http://www-mtl.mit.edu/research/ic-systems/uamps/pubs/

  11. Intanagonwiwat, C., Govindan, R., Estrin, D., Heidemann, J., Silva, F.: Directed diffusion for wireless sensor networking. IEEE Trans. Netw. 11(1), 2–16 (2003)

    Article  Google Scholar 

  12. Karp, B., Kung, H.T.: Greedy perimeter stateless routing for wireless networks. In: Proceedings of the International Conference on Mobile Computing and Networking (MobiCom), pp. 243–254 (2000)

  13. Kranakis, E., Singh, H., Urrutia, J.: Compass routing on geometric networks. In: Proceedings of the 11th Canadian Conference on Computational Geometry, pp. 51–54 (1999)

  14. Madden, S., Franklin, M.J., Hellerstein, J.M.: TAG: a tiny aggregation service for ad-hoc sensor networks. In: Proceedings of the Symposium on Operating Systems Design and Implementation (OSDI), pp. 131–146 (2002)

  15. Madden, S., Franklin, M.J., Hellerstein, J.M., Hong, W.: The design of an acquisitional query processor for sensor networks. In: Proceedings of the SIGMOD Conference on Management of Data (SIGMOD), pp. 491–502 (2003)

  16. Maihofer, C.: A survey of geocast routing protocols. IEEE Commun. Surv. 6(2), 32–42 (2004)

    Article  Google Scholar 

  17. Ozsu, M.T., Valduriez, P.: Principles of Distributed Database Systems. Prentice-Hall, New York (1999)

    Google Scholar 

  18. Ramakrishnan, R., Gehrke, J.: Database Management Systems, 2nd edn. McGraw-Hill, New York (2000)

    Google Scholar 

  19. Rappaport, T.: Wireless Communications: Principles and Practice. Prentice-Hall, New York (1996)

    Google Scholar 

  20. Ratnasamy, S., Karp, B., Yin, L., Yu, F., Estrin, D., Govindan, R., Shenker, S.: GHT: A geographic hash table for data-centric storage. In: Proceedings of the International Workshop on Wireless Sensor Networks and Applications (WSNA) (2002)

  21. Ricadela, A.: Sensors everywhere. Information Week, 24 January 2005

  22. Sensoria Corp. WINS sensor platform. www.sensoria.com

  23. Sharaf, M.A., Beaver, J., Labrinidis, A., Chrysanthis, P.K.: Balancing energy efficiency and quality of aggregate data in sensor networks. Very Large Data Bases J. 13(4), 384–403 (2004)

    Article  Google Scholar 

  24. Silberstein, A., Braynard, R., Yang, J.: Constraint chaining: on energy-efficient continuous monitoring in sensor networks. In: Proceedings of the SIGMOD Conference on Management of Data, pp. 157–168 (2006)

  25. Stojmenovic, I.: Position based routing in ad hoc networks. IEEE Commun. Mag. 40(7), 128–134 (2002)

    Article  Google Scholar 

  26. Takagi, H., Kleinrock, L.: Optimal transmission ranges for randomly distributed packet radio terminals. IEEE Trans. Commun. 32(3), 247–256 (1984)

    Article  Google Scholar 

  27. Xu, Y., Lee, W.C., Xu, J., Mitchell, G.: Processing window queries in wireless sensor networks. In: Proceedings of the International Conference on Data Engineering (ICDE), p. 70 (2006)

  28. Yao, Y., Gehrke, J.: The Cougar approach to in-network query processing in sensor networks. SIGMOD Rec. 31(3), 9–18 (2002)

    Article  Google Scholar 

  29. Yao, Y., Gehrke, J.: Query processing in sensor networks. In: Proceedings of the Conference on Innovative Data Systems Research (CIDR) (2003)

  30. Yu, H., Lim, E.P., Zhang, J.: On in-network synopsis join processing for sensor networks. In: Proceedings of International Conference on Mobile Data Management (MDM), pp. 32–39 (2006)

  31. Zhang, D., Gunopulos, D., Tsotras, V.J., Seeger, B.: Temporal and spatio-temporal aggregations over data streams using multiple time granularities. Inf. Syst. 28, 61–84 (2003)

    Article  MATH  Google Scholar 

  32. Zhao, F., Guibas, L.: Wireless Sensor Networks: An Information Processing Approach. Kaufmann, Los Altos (2004)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Computing Science, University of Alberta, 2-21 Athabasca Hall, Edmonton, AB, T6G 2E8, Canada

    Alexandru Coman, Joerg Sander & Mario A. Nascimento

Authors
  1. Alexandru Coman
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Joerg Sander
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Mario A. Nascimento
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Alexandru Coman.

Additional information

Communicated by Sunil Prabhakar.

Research supported in part by NSERC Canada.

Rights and permissions

Reprints and permissions

About this article

Cite this article

Coman, A., Sander, J. & Nascimento, M.A. Adaptive processing of historical spatial range queries in peer-to-peer sensor networks. Distrib Parallel Databases 22, 133–163 (2007). https://doi.org/10.1007/s10619-007-7018-8

Download citation

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s10619-007-7018-8

Keywords

Search

Navigation