Skip to main content
SpringerLink
Log in

Communication-Efficient Implementation of Join in Sensor Networks

  • Conference paper
Database Systems for Advanced Applications (DASFAA 2005)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 3453))

Included in the following conference series:

Abstract

A sensor network is a wireless ad hoc network of resource-constrained sensor nodes. In this article, we address the problem of communication-efficient implementation of the SQL “join” operator in sensor networks. We design an optimal join-implementation algorithm that provably incurs minimum communication cost under certain reasonable assumptions. In addition, we design a much faster suboptimal heuristic that empirically delivers a near-optimal solution. We evaluate the performance of our designed algorithms through extensive simulations.

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.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

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. Abadi, D.J., Carney, D., Cetintemel, U., Cherniack, M., Convey, C., Lee, S., Stonebraker, M., Tatbul, N., Zdonik, S.: Aurora: a new model and architecture for data stream management. The VLDB Journal 12(2), 120–139 (2003)

    Article  Google Scholar 

  2. Babcock, B., Babu, S., Datar, M., Motwani, R., Widom, J.: Models and issues in data stream systems. In: Proceedings of the ACM Symposium on Principles of Database Systems (PODS) (2002)

    Google Scholar 

  3. Badrinath, B., Srivastava, M., Mills, K., Scholtz, J., Sollins, K. (eds.): Special Issue on Smart Spaces and Environments, IEEE Personal Communications (2000)

    Google Scholar 

  4. Bonfils, B., Bonnet, P.: Adaptive and decentralized operator placement for in-network query processing. In: Zhao, F., Guibas, L.J. (eds.) IPSN 2003. LNCS, vol. 2634, pp. 47–62. Springer, Heidelberg (2003)

    Chapter  Google Scholar 

  5. Bonnet, P., Gehrke, J., Seshadri, P.: Towards sensor database systems. In: Tan, K.-L., Franklin, M.J., Lui, J.C.-S. (eds.) MDM 2001. LNCS, vol. 1987, pp. 3–14. Springer, Heidelberg (2000)

    Chapter  Google Scholar 

  6. Carney, D., Cetintemel, U., Cherniack, M., Convey, C., Lee, S., Seidman, G., Stonebraker, M., Tatbul, N., Zdonik, S.: Monitoring streams - A new class of data management applications. In: Proceedings of the International Conference on Very Large Data Bases, VLDB (2002)

    Google Scholar 

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

    Google Scholar 

  8. Chandrasekaran, S., Cooper, O., Deshpande, A., Franklin, M.J., Hellerstein, J.M., Hong, W., Krishnamurthy, S., Madden, S.R., Reiss, F., Shah, M.A.: TelegraphCQ: Continuous dataflow processing. In: Proceedings of the ACM SIGMOD Conference on Management of Data (2003)

    Google Scholar 

  9. Chen, J., DeWitt, D.J., Tian, F., Wang, Y.: NiagaraCQ: a scalable continuous query system for internet databases. In: Proceedings of the ACM SIGMOD Conference on Management of Data (2000)

    Google Scholar 

  10. Chowdhary, V., Gupta, H.: Communication-efficient implementation of join in sensor networks. Technical report, SUNY, Stony Brook, Computer Science Department (2004)

    Google Scholar 

  11. Das, A., Gehrke, J., Riedewald, M.: Approximate join processing over data streams. In: Proceedings of the ACM SIGMOD Conference on Management of Data (2003)

    Google Scholar 

  12. Ding, L., Mehta, N., Rundensteiner, E., Heineman, G.: Joining punctuated streams. In: Proceedings of the International Conference on Extending Database Technology (2004)

    Google Scholar 

  13. Estrin, D., Govindan, R., Heidemann, J. (eds.): Special Issue on Embedding the Internet. Communications of the ACM 43 (2000)

    Google Scholar 

  14. Estrin, D., Govindan, R., Heidemann, J.S., Kumar, S.: Next century challenges: Scalable coordination in sensor networks. In: Proceedings of the International Conference on Mobile Computing and Networking, MobiCom (1999)

    Google Scholar 

  15. Gelfand, I., Fomin, S.: Calculus of Variations. Dover Publications (2000)

    Google Scholar 

  16. Govindan, R., Hellerstein, J., Hong, W., Madden, S., Franklin, M., Shenker, S.: The sensor network as a database. Technical report, University of Southern California, Computer Science Department (2002)

    Google Scholar 

  17. Hammad, M., Aref, W., Catlin, A., Elfeky, M., Elmagarmid, A.: A stream database server for sensor applications. Technical report, Purdue University, Department of Computer Science (2002)

    Google Scholar 

  18. Heidemann, J.S., Silva, F., Intanagonwiwat, C., Govindan, R., Estrin, D., Ganesan, D.: Building efficient wireless sensor networks with low-level naming. In: Symposium on Operating Systems Principles (2001)

    Google Scholar 

  19. Karp, B., Kung, H.: Gpsr: greedy perimeter stateless routing for wireless networks. In: Proceedings of the International Conference on Mobile Computing and Networking (MobiCom) (2000)

    Google Scholar 

  20. Kossmann, D.: The state of the art in distributed query processing. ACM Computing Surveys 32(4) (2000)

    Google Scholar 

  21. Madden, S., Franklin, M.: Fjording the stream: An architecture for queries over streaming sensor data. In: Proceedings of the International Conference on Database Engineering (ICDE) (2002)

    Google Scholar 

  22. Madden, S., Franklin, M., Hellerstein, J., Hong, W.: TAG: A tiny aggregation service for ad-hoc sensor networks. In: Proceedings of the Symposium on Operating Systems Design and Implementation (OSDI) (2002)

    Google Scholar 

  23. Madden, S., Hellerstein, J.M.: Distributing queries over low-power wireless sensor networks. In: Proceedings of the ACM SIGMOD Conference on Management of Data (2002)

    Google Scholar 

  24. Madden, S., Szewczyk, R., Franklin, M., Culler, D.: Supporting aggregate queries over ad-hoc wireless sensor networks. In: Workshop on Mobile Computing and Systems Applications (2002)

    Google Scholar 

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

    Google Scholar 

  26. Madden, S.R., Hellerstein, J.M., Hong, W.: TinyDB: In-network query processing in tinyos (September 2003), http://telegraph.cs.berkeley.edu/tinydb

  27. Motwani, R., Widom, J., Arasu, A., Babcock, B., Babu, S., Datar, M., Manku, G., Olston, C., Rosenstein, J., Varma, R.: Query processing, approximation, and resource management in a data stream management system. In: Proceedings of the International Conference on Innovative Data Systems Research (CIDR) (2003)

    Google Scholar 

  28. Nath, B., Niculescu, D.: Routing on a curve. In: Proceedings of the Workshop on Hot Topics in Networks (2002)

    Google Scholar 

  29. Ozsu, M.T., Valduriez, P.: Principles of Distributed Database Systems. Prentice-Hall, Englewood Cliffs (1999)

    Google Scholar 

  30. Pan, J., Hou, Y.T., Cai, L., Shi, Y., Shen, S.X.: Topology control for wireless sensor networks. In: Proceedings of the International Conference on Mobile Computing and Networking (MobiCom) (2003)

    Google Scholar 

  31. Pottie, G., Kaiser, W.: Wireless integrated sensor networks. Communications of the ACM 43 (2000)

    Google Scholar 

  32. Ramanathan, R., Rosales-Hain, R.: Topology control in multihop wireless networks using transmit power adjustment. In: Proceedings of the IEEE INFOCOM (2000)

    Google Scholar 

  33. Yao, Y., Gehrke, J.: The cougar approach to in-network query processing in sensor networks. SIGMOD Record (2002)

    Google Scholar 

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

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. SUNY, Stony Brook, NY, 11754

    Vishal Chowdhary & Himanshu Gupta

Authors
  1. Vishal Chowdhary
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Himanshu Gupta
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Research Institute of Information Technology, Tsinghua National Laboratory for Information Science and Technology, Department of Computer Science and Technology, Tsinghua University, 100084, Beijing, China

    Lizhu Zhou

  2. National University of Singapore, Singapore

    Beng Chin Ooi

  3. School of Information, Renmin University of China,  

    Xiaofeng Meng

Rights and permissions

Reprints and permissions

Copyright information

© 2005 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Chowdhary, V., Gupta, H. (2005). Communication-Efficient Implementation of Join in Sensor Networks. In: Zhou, L., Ooi, B.C., Meng, X. (eds) Database Systems for Advanced Applications. DASFAA 2005. Lecture Notes in Computer Science, vol 3453. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11408079_40

Download citation

  • DOI: https://doi.org/10.1007/11408079_40

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-25334-1

  • Online ISBN: 978-3-540-32005-0

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation