Join of Multiple Data Streams in Sensor Networks

Sensor networks are multihop wireless networks of resource-constrained sensor nodes used to realize high-level collaborative sensing tasks. To query or access data generated by the sensor nodes, the sensor network can be viewed as a distributed database. In this paper, we develop algorithms for communication-efficient implementation of join of multiple (two or more) data streams in a sensor network. The distributed implementation of join in sensor networks is particularly challenging due to unique characteristics of the sensor networks such as limited memory and battery energy on individual nodes, arbitrary and dynamic network topology, multihop communication, and unreliable infrastructure. One of our proposed approaches, viz., the perpendicular approach (PA), is load balanced, and in fact, incurs near-optimal communication cost for the special case of binary joins in grid networks under the assumption of uniform generation of tuples across the network. We compare the performance of our designed approaches through extensive simulations on the ns2 simulator, and show that PA results in substantially prolonging the network lifetime compared to other approaches, especially for joins involving spatial constraints.

[1]  Nicole Immorlica,et al.  Locality-sensitive hashing scheme based on p-stable distributions , 2004, SCG '04.

[2]  Xiang Xu,et al.  Deductive Framework for Programming Sensor Networks , 2009, 2009 IEEE 25th International Conference on Data Engineering.

[3]  Ion Stoica,et al.  Declarative routing: extensible routing with declarative queries , 2005, SIGCOMM '05.

[4]  David Chu,et al.  Entirely declarative sensor network systems , 2006, VLDB.

[5]  Hongjun Lu,et al.  Processing multi-join query in parallel systems , 1992, SAC '92.

[6]  Samir Ranjan Das,et al.  Serial data fusion using space-filling curves in wireless sensor networks , 2004, 2004 First Annual IEEE Communications Society Conference on Sensor and Ad Hoc Communications and Networks, 2004. IEEE SECON 2004..

[7]  Jie Gao,et al.  Double Rulings for Information Brokerage in Sensor Networks , 2006, IEEE/ACM Transactions on Networking.

[8]  Walid G. Aref,et al.  Stream window join: tracking moving objects in sensor-network databases , 2003, 15th International Conference on Scientific and Statistical Database Management, 2003..

[9]  Frederick Reiss,et al.  TelegraphCQ: continuous dataflow processing , 2003, SIGMOD '03.

[10]  Elke A. Rundensteiner,et al.  Joining Punctuated Streams , 2004, EDBT.

[11]  Qiang Chen,et al.  Aurora : a new model and architecture for data stream management ) , 2006 .

[12]  Ying Zhang,et al.  Combs, needles, haystacks: balancing push and pull for discovery in large-scale sensor networks , 2004, SenSys '04.

[13]  Philip Levis,et al.  The design and implementation of a declarative sensor network system , 2007, SenSys '07.

[14]  H. Gupta,et al.  Deductive Approach for Programming Sensor Networks , 2008 .

[15]  Ramesh Govindan,et al.  The Sensor Network as a Database , 2002 .

[16]  Jennifer Widom,et al.  Models and issues in data stream systems , 2002, PODS.

[17]  Abhinandan Das,et al.  Approximate join processing over data streams , 2003, SIGMOD '03.

[18]  Ying Xing,et al.  Providing resiliency to load variations in distributed stream processing , 2006, VLDB.

[19]  Jennifer Widom,et al.  Operator placement for in-network stream query processing , 2005, PODS.

[20]  Samir R. Das,et al.  Efficient gathering of correlated data in sensor networks , 2005, MobiHoc '05.

[21]  David J. DeWitt,et al.  A performance evaluation of four parallel join algorithms in a shared-nothing multiprocessor environment , 1989, SIGMOD '89.

[22]  Jeffrey F. Naughton,et al.  Evaluating window joins over unbounded streams , 2003, Proceedings 19th International Conference on Data Engineering (Cat. No.03CH37405).

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

[24]  Jie Wu,et al.  Connected k-hop clustering in ad hoc networks , 2005, 2005 International Conference on Parallel Processing (ICPP'05).

[25]  Lukasz Golab,et al.  Processing Sliding Window Multi-Joins in Continuous Queries over Data Streams , 2003, VLDB.

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

[27]  Mostafa H. Ammar,et al.  The Grid Protocol: A High Performance Scheme for Maintaining Replicated Data , 1992, IEEE Trans. Knowl. Data Eng..

[28]  Samuel Madden,et al.  Distributing queries over low-power wireless sensor networks , 2002, SIGMOD '02.

[29]  David J. DeWitt,et al.  NiagaraCQ: a scalable continuous query system for Internet databases , 2000, SIGMOD '00.

[30]  Jennifer Widom,et al.  Memory-Limited Execution of Windowed Stream Joins , 2004, VLDB.

[31]  Wei Hong,et al.  Model-based approximate querying in sensor networks , 2005, The VLDB Journal.

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

[33]  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 .

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

[35]  Brad Karp,et al.  Greedy Perimeter Stateless Routing for Wireless Networks , 2000 .

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

[37]  GuptaHimanshu,et al.  Efficient gathering of correlated data in sensor networks , 2008 .

[38]  Hector Garcia-Molina,et al.  The SIFT information dissemination system , 1999, TODS.

[39]  Ion Stoica,et al.  Declarative networking: language, execution and optimization , 2006, SIGMOD Conference.

[40]  Hongjun Lu,et al.  Optimization of Multi-Way Join Queries for Parallel Execution , 1991, VLDB.

[41]  Leonidas J. Guibas,et al.  Sensing, tracking and reasoning with relations , 2002, IEEE Signal Process. Mag..

[42]  Jennifer Widom,et al.  The CQL continuous query language: semantic foundations and query execution , 2006, The VLDB Journal.

[43]  Deborah Estrin,et al.  Localization in sensor networks , 2004 .

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

[45]  Hongjun Lu,et al.  Design and evaluation of parallel pipelined join algorithms , 1987, SIGMOD '87.

[46]  Deborah Estrin,et al.  Data-Centric Storage in Sensornets with GHT, a Geographic Hash Table , 2003, Mob. Networks Appl..

[47]  Samuel Madden,et al.  TinyDB: In-Network Query Processing in TinyOS , 2002 .

[48]  Deborah Estrin,et al.  Building efficient wireless sensor networks with low-level naming , 2001, SOSP.

[49]  Toshihide Ibaraki,et al.  On the optimal nesting order for computing N-relational joins , 1984, TODS.

[50]  Sang Hyuk Son,et al.  Event Detection Services Using Data Service Middleware in Distributed Sensor Networks , 2003, Telecommun. Syst..

[51]  Ying Xing,et al.  The Design of the Borealis Stream Processing Engine , 2005, CIDR.

[52]  Samuel Madden,et al.  Fjording the stream: an architecture for queries over streaming sensor data , 2002, Proceedings 18th International Conference on Data Engineering.

[53]  Brad Karp,et al.  GPSR: greedy perimeter stateless routing for wireless networks , 2000, MobiCom '00.

[54]  Philippe Bonnet,et al.  Towards Sensor Database Systems , 2001, Mobile Data Management.