Skip to main content

Directions in Multi-Query Optimization for Sensor Networks

  • Chapter
Advances in Pervasive Computing and Networking

Abstract

The widespread dissemination of small-scale sensor nodes has sparked interest in a powerful new database abstraction for sensor networks: Clients “program” the sensors through queries in a high-level declarative language (such as a variant of SQL), and catalog management and query processing techniques abstract the user from the physical details of tasking the sensors. We call the resulting system a sensor data management system (SDMS). Sensor networks have important constraints on communication, computation and power consumption. Energy is the most valuable resource for unattended battery-powered nodes. Since radio communication consumes most of the available node power, our goal is to identify strategies that reduce network traffic. We give an overview of three distinct approaches to reducing the cost of processing aggregate queries in sensor networks: i) selection of suitable routes for collecting results of multiple queries, ii) data reduction techniques that exploit query commonalities and iii) a hybrid pull-push communication paradigm for query and result propagation. We pay particular attention to the third approach and present in detail an algorithm for finding a pull-push configuration that minimizes on expectation the network traffic. Experimental analysis shows that our algorithm offers significant energy savings.

The authors wish to thank Douglas Holzhauer and Zen Pryke from the Air Force Rome Labs for helpful discussions. This work is supported by NSF Grants CCR-0205452, IIS-0133481, and IIS-0330201, by the Cornell Information Assurance Institute, and by Lockheed Martin.

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

Access this chapter

eBook
USD 16.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 109.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Bonnet, P., Gehrke, J., and Seshadri, P. Querying the physical world. IEEE Personal Communications, 7(5):10–15, 2000.

    Article  Google Scholar 

  2. Ceri, S. and Pelagatti, G. Distributed Database Design: Principles and Systems. MacGraw-Hill (New York NY), 1984.

    Google Scholar 

  3. Chang, J. and Tassiulas, L. Energy conserving routing in wireless ad-hoc networks. In Proceedings of the 2000 IEEE Computer and Communications Societies Conference on Computer Communications (INFOCOM-00), pages 22–31, Los Alamitos. IEEE, 2000.

    Google Scholar 

  4. Elson, J., Girod, L., and Estrin, D. Fine-grained network time synchronization using reference broadcasts. In Proceedings of the 5th Symposium on Operating Systems Design and Implementation, pages 147–163, 2000.

    Google Scholar 

  5. Garey, M. and Johnson, D. The rectilinear Steiner tree problem is NP-complete. SIAM Journal on Applied Mathematics, 32:826–834, 1977.

    Article  MathSciNet  Google Scholar 

  6. Goel, A. and Estrin, D. Simultaneous optimization for concave costs: Single sink aggregation or single source buy-at-bulk. In Proceedings of the 14th Annual ACM-SIAM Symposium on Discrete Algorithms, 2003.

    Google Scholar 

  7. Heidemann, J., Silva, F., Yu, Y., Estrin, D., and Haldar, P. Diffusion filters as a flexible architecture for event notification in wireless sensor networks. Technical Report ISI-TR-556, USC/Information Sciences Institute, 2002.

    Google Scholar 

  8. Heidemann, J.S., Silva, F., Intanagonwiwat, C., Govindan, R., Estrin, D., and Ganesan, D. Building efficient wireless sensor networks with low-level naming. In Symposium on Operating Systems Principles, pages 146–159, 2001.

    Google Scholar 

  9. Heinzelman, W.R., Kulik, J., and Balakrishnan, H. Adaptive protocols for information dissemination in wireless sensor networks. pages 174–185. ACM SIGMOBILE, ACM Press, 1999.

    Google Scholar 

  10. Intanagonwiwat, C., Govindan, R., and Estrin, D. Directed diffusion: A scalable and robust communication paradigm for sensor networks. pages 56–67. ACM SIGMOBILE, ACM Press, 2000.

    Google Scholar 

  11. Kossmann, D. The state of the art in distributed query processing. Computing Surveys, 32, 2000.

    Google Scholar 

  12. Liao, C., Martonosi, M., and Clark, D. Experience with an adaptive globally-synchronizing clock algorithm. In Proceedings of the 11th Annual ACM Symposium on Parallel Algorithms and Architectures, pages 106–114, 1999.

    Google Scholar 

  13. Madden, S., Franklin, M.J., Hellerstein, J., and Hong, W. The design of an acquisitional query processor for sensor networks. In Proceedings of the ACM SIGMOD International Conference on Management of Data, 2003.

    Google Scholar 

  14. Madden, S.R., Franklin, M.J., Hellerstein, J.M., and Hong, W. Tag: A tiny aggregation service for ad-hoc sensor networks. In OSDI, 2002.

    Google Scholar 

  15. Özsu, M.T. and Valduriez, P. Principles of Distributed Database Systems. Prentice Hall, Englewood Cliffs, 1991.

    Google Scholar 

  16. Pottie, G.J. and Kaiser, W.J. Embedding the Internet: wireless integrated network sensors. Communications of the ACM, 43(5):51–51, 2000.

    Article  Google Scholar 

  17. Shatdal, A. and Naughton, J. Adaptive parallel aggregation algorithms. In Carey, Michael J. and Schneider, Donovan A., editors, Proceedings of the 1995 ACM SIGMOD International Conference on Management of Data, pages 104–114, San Jose, California, 1995.

    Google Scholar 

  18. Xu, Y., Bien, S., Mori, Y., Heidemann, J., and Estrin, D. Topology control protocols to conserve energy inwireless ad hoc networks. Technical Report 6, University of California, Los Angeles, Center for Embedded Networked Computing. submitted for publication, 2003.

    Google Scholar 

  19. Xu, Y., Heidemann, J., and Estrin, D. Geography-informed energy conservation for ad hoc routing. In Proceedings of the ACM/IEEE International Conference on Mobile Computing and Networking, pages 70–84, 2001.

    Google Scholar 

  20. Yan, W.P. and Larson, P. Eager aggregation and lazy aggregation. In Dayal, Umeshwar, Gray, Peter M. D., and Nishio, Shojiro, editors, VLDB’95, Proceedings of 21th International Conference on Very Large Data Bases, pages 345–357, Zurich, Switzerland. Morgan Kaufmann, 1995.

    Google Scholar 

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

    Google Scholar 

  22. Ye, F.L., Haiyun, C., Jerry, L.S., and Zhang, L. A two-tier data dissemination model for large-scale wireless sensor networks. In Proceedings of the Eighth Annual International Conference on Mobile Computing and Networking (MobiCom), 2002.

    Google Scholar 

  23. Yu, C. and Meng, W. Principles of Database Query Processing for Advanced Applications. Morgan Kaufmann, San Francisco, 1998.

    Google Scholar 

  24. Yu, C. T. and Chang, C. C. Distributed query processing. ACM Computing Surveys, 16(4):399–433, 1984.

    Article  Google Scholar 

  25. Yu, Y., Govindan, R., and Estrin, D. Geographical and energy aware routing: A recursive data dissemination protocol for wireless sensor networks. Technical Report UCLA/CSD-TR-01-0023, University of Southern California, 2001.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2005 Springer Science+Business Media, Inc.

About this chapter

Cite this chapter

Demers, A., Gehrke, J., Rajaraman, R., Trigoni, N., Yao, Y. (2005). Directions in Multi-Query Optimization for Sensor Networks. In: Szymanski, B.K., Yener, B. (eds) Advances in Pervasive Computing and Networking. Springer, Boston, MA. https://doi.org/10.1007/0-387-23466-7_9

Download citation

  • DOI: https://doi.org/10.1007/0-387-23466-7_9

  • Publisher Name: Springer, Boston, MA

  • Print ISBN: 978-0-387-23042-9

  • Online ISBN: 978-0-387-23466-3

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics