Abstract
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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
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)
Bonnet, P., Gehrke, J., Seshadri, P.: Towards sensor database systems. In: Proceeding of the International Conference on Mobile Data Management (2001)
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)
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)
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)
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)
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)
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)
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)
Madden, S.R., Hellerstein, J.M., Hong, W.: TinyDB: In-network query processing in tinyos (September 2003), http://telegraph.cs.berkeley.edu/tinydb
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)
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)
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)
Yao, Y., Gehrke, J.: The cougar approach to in-network query processing in sensor networks. In: SIGMOD Record (2002)
Yao, Y., Gehrke, J.: Query processing for sensor networks. In: Proceedings of the International Conference on Innovative Data Systems Research (CIDR) (2003)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Pandit, A., Gupta, H. (2006). Communication-Efficient Implementation of Range-Joins in Sensor Networks. In: Li Lee, M., Tan, KL., Wuwongse, V. (eds) Database Systems for Advanced Applications. DASFAA 2006. Lecture Notes in Computer Science, vol 3882. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11733836_63
Download citation
DOI: https://doi.org/10.1007/11733836_63
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-33337-1
Online ISBN: 978-3-540-33338-8
eBook Packages: Computer ScienceComputer Science (R0)