Towards Efficient Processing of General-Purpose Joins in Sensor Networks

Join processing in wireless sensor networks is difficult: As the tuples can be arbitrarily distributed within the network, matching pairs of tuples is communication intensive and costly in terms of energy. Current solutions only work well with specific placements of the nodes and/or make restrictive assumptions. In this paper, we present SENS-Join, an efficient general-purpose join method for sensor networks. To obtain efficiency, SENS-Join does not ship tuples that do not join, based on a filtering step. Our main contribution is the design of this filtering step which is highly efficient in order not to exhaust the potential savings. We demonstrate the performance of SENS-Join experimentally: The overall energy consumption can be reduced by more than 80%, as compared to the state-of-the-art approach. The per node energy consumption of the most loaded nodes can be reduced by more than an order of magnitude.

[1]  Philippe Bonnet,et al.  Adaptive and Decentralized Operator Placement for In-Network Query Processing , 2003, Telecommun. Syst..

[2]  Jörg Sander,et al.  On Join Location in Sensor Networks , 2007, 2007 International Conference on Mobile Data Management.

[3]  Klemens Böhm,et al.  Where in the Sensor Network Should the Join Be Computed, After All? , 2008 .

[4]  Himanshu Gupta,et al.  Communication-Efficient Implementation of Range-Joins in Sensor Networks , 2006, DASFAA.

[5]  Khalid Sayood,et al.  Introduction to data compression (2nd ed.) , 2000 .

[6]  Nick Roussopoulos,et al.  A Pipeline N-way Join Algorithm Based on the 2-way Semijoin Program , 1991, IEEE Trans. Knowl. Data Eng..

[7]  Oliver Günther,et al.  Multidimensional access methods , 1998, CSUR.

[8]  Hanan Samet,et al.  The Quadtree and Related Hierarchical Data Structures , 1984, CSUR.

[9]  Johannes Gehrke,et al.  Query Processing in Sensor Networks , 2003, CIDR.

[10]  Wei Hong,et al.  TinyDB: an acquisitional query processing system for sensor networks , 2005, TODS.

[11]  Wei Hong,et al.  The design of an acquisitional query processor for sensor networks , 2003, SIGMOD '03.

[12]  Mario A. Nascimento,et al.  A Distributed Algorithm for Joins in Sensor Networks , 2007, 19th International Conference on Scientific and Statistical Database Management (SSDBM 2007).

[13]  Man Lung Yiu,et al.  Evaluation of Spatial Pattern Queries in Sensor Networks , 2007 .

[14]  Patrick Valduriez,et al.  Principles of distributed database systems (2nd ed.) , 1999 .

[15]  Kian-Lee Tan,et al.  In-network execution of monitoring queries in sensor networks , 2007, SIGMOD '07.

[16]  Khalid Sayood,et al.  Introduction to Data Compression , 1996 .

[17]  Jeffrey Considine,et al.  Approximate aggregation techniques for sensor databases , 2004, Proceedings. 20th International Conference on Data Engineering.

[18]  Deborah Estrin,et al.  Advances in network simulation , 2000, Computer.

[19]  Himanshu Gupta,et al.  Communication-Efficient Implementation of Join in Sensor Networks , 2005, DASFAA.

[20]  Yong Yao,et al.  The cougar approach to in-network query processing in sensor networks , 2002, SGMD.

[21]  Himanshu Gupta,et al.  Communication-efficient implementation of join in sensor networks , 2007, Ad Hoc Networks.

[22]  Margaret Martonosi,et al.  Data compression algorithms for energy-constrained devices in delay tolerant networks , 2006, SenSys '06.

[23]  Wei Hong,et al.  Model-Driven Data Acquisition in Sensor Networks , 2004, VLDB.

[24]  Ee-Peng Lim,et al.  On In-network Synopsis Join Processing for Sensor Networks , 2006, 7th International Conference on Mobile Data Management (MDM'06).

[25]  Daniel J. Abadi,et al.  REED: Robust, Efficient Filtering and Event Detection in Sensor Networks , 2005, VLDB.

[26]  Wei Hong,et al.  Proceedings of the 5th Symposium on Operating Systems Design and Implementation Tag: a Tiny Aggregation Service for Ad-hoc Sensor Networks , 2022 .

[27]  Patrick Valduriez,et al.  Principles of Distributed Database Systems , 1990 .