Communication-Efficient Implementation of Range-Joins in Sensor Networks

  • Aditi Pandit
  • Himanshu Gupta
Part of the Lecture Notes in Computer Science book series (LNCS, volume 3882)


In this article, we consider energy-efficient implementation of the SQL join operation in sensor databases, when the join selection condition is a range predicate. Apart from two simple approaches, we propose distributed hash-join and index-join algorithms for implementation of range-join operations in sensor networks. Through extensive simulations, we show that hash-join as well as index-join approaches significantly outperform the simple approaches, even for moderately sized networks. Our experiments also reveal that although both approach scale well, the index-join algorithm performs better than the hash-join algorithm especially in large sensor networks.


Sensor Network Sensor Node Wireless Sensor Network Data Stream Hash Function 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    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, Springer, Heidelberg (2003)CrossRefGoogle Scholar
  2. 2.
    Bonnet, P., Gehrke, J., Seshadri, P.: Towards sensor database systems. In: Proceeding of the International Conference on Mobile Data Management (2001)Google Scholar
  3. 3.
    Chowdhary, V., Gupta, H.: Communication-efficient implementation of join in sensor networks. In: Zhou, L.-z., Ooi, B.-C., Meng, X. (eds.) DASFAA 2005. LNCS, vol. 3453, Springer, Heidelberg (2005)CrossRefGoogle Scholar
  4. 4.
    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
  5. 5.
    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
  6. 6.
    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
  7. 7.
    Madden, S., Hellerstein, J.M.: Distributing queries over low-power wireless sensor networks. In: Proceedings of the ACM SIGMOD Conference on Management of Data, pp. 622–622 (2002)Google Scholar
  8. 8.
    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
  9. 9.
    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, pp. 491–502 (2003)Google Scholar
  10. 10.
    Madden, S.R., Hellerstein, J.M., Hong, W.: TinyDB: In-network query processing in tinyos (September 2003),
  11. 11.
    Ratnasamy, S., Karp, B., Shenker, S., Estrin, D., Govindan, R., Yin, L., Yu, F.: Data-centric storage in sensornets with GHT, a geographic hash table. Mobile Networks and Applications 8(4), 427–442 (2003)CrossRefGoogle Scholar
  12. 12.
    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 ACM Intl. Workshop on Wireless Sensor Networks and Applications (WSNA) (2002)Google Scholar
  13. 13.
    Wilschut, A.N., Apers, P.M.G.: Dataflow query execution in a parallel main memory environment. Distributed and Parallel Databases 1(1), 103–128 (1993)CrossRefGoogle Scholar
  14. 14.
    Yao, Y., Gehrke, J.: The cougar approach to in-network query processing in sensor networks. In: SIGMOD Record (2002)Google Scholar
  15. 15.
    Yao, Y., Gehrke, J.: Query processing for sensor networks. In: Proceedings of the International Conference on Innovative Data Systems Research (CIDR) (2003)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Aditi Pandit
    • 1
  • Himanshu Gupta
    • 1
  1. 1.SUNYStony BrookUSA

Personalised recommendations