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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
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)
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)
Badrinath, B., Srivastava, M., Mills, K., Scholtz, J., Sollins, K. (eds.): Special Issue on Smart Spaces and Environments, IEEE Personal Communications (2000)
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)
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)
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)
Ceri, S., Pelagatti, G.: Distributed Database Design: Principles and Systems. MacGraw-Hill, New York (1984)
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)
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)
Chowdhary, V., Gupta, H.: Communication-efficient implementation of join in sensor networks. Technical report, SUNY, Stony Brook, Computer Science Department (2004)
Das, A., Gehrke, J., Riedewald, M.: Approximate join processing over data streams. In: Proceedings of the ACM SIGMOD Conference on Management of Data (2003)
Ding, L., Mehta, N., Rundensteiner, E., Heineman, G.: Joining punctuated streams. In: Proceedings of the International Conference on Extending Database Technology (2004)
Estrin, D., Govindan, R., Heidemann, J. (eds.): Special Issue on Embedding the Internet. Communications of the ACM 43 (2000)
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)
Gelfand, I., Fomin, S.: Calculus of Variations. Dover Publications (2000)
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)
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)
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)
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)
Kossmann, D.: The state of the art in distributed query processing. ACM Computing Surveys 32(4) (2000)
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)
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 (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 (2003)
Madden, S.R., Hellerstein, J.M., Hong, W.: TinyDB: In-network query processing in tinyos (September 2003), http://telegraph.cs.berkeley.edu/tinydb
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)
Nath, B., Niculescu, D.: Routing on a curve. In: Proceedings of the Workshop on Hot Topics in Networks (2002)
Ozsu, M.T., Valduriez, P.: Principles of Distributed Database Systems. Prentice-Hall, Englewood Cliffs (1999)
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)
Pottie, G., Kaiser, W.: Wireless integrated sensor networks. Communications of the ACM 43 (2000)
Ramanathan, R., Rosales-Hain, R.: Topology control in multihop wireless networks using transmit power adjustment. In: Proceedings of the IEEE INFOCOM (2000)
Yao, Y., Gehrke, J.: The cougar approach to in-network query processing in sensor networks. 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
© 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)