Communication-Efficient Implementation of Range-Joins in Sensor Networks

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.

[1]  Gregory J. Pottie,et al.  Wireless integrated network sensors , 2000, Commun. ACM.

[2]  Walid G. Aref,et al.  A Stream Database Server for Sensor Applications , 2002 .

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

[4]  Deborah Estrin,et al.  GHT: a geographic hash table for data-centric storage , 2002, WSNA '02.

[5]  Michael Stonebraker,et al.  Aurora: a new model and architecture for data stream management , 2003, The VLDB Journal.

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

[7]  B. R. Badrinath,et al.  Routing on a curve , 2003, CCRV.

[8]  A. N. Wilschut,et al.  Dataflow query execution in a parallel main-memory environment , 1991, Distributed and Parallel Databases.

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

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

[11]  Satish Kumar,et al.  Next century challenges: scalable coordination in sensor networks , 1999, MobiCom.

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

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

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

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

[16]  Stefano Ceri,et al.  Distributed Databases: Principles and Systems , 1984 .

[17]  Jianping Pan,et al.  Topology control for wireless sensor networks , 2003, MobiCom '03.

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

[19]  Michael Stonebraker,et al.  Monitoring Streams - A New Class of Data Management Applications , 2002, VLDB.

[20]  Deborah Estrin,et al.  Embedding the Internet: introduction , 2000, Commun. ACM.

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

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

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

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

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

[26]  David E. Culler,et al.  Supporting aggregate queries over ad-hoc wireless sensor networks , 2002, Proceedings Fourth IEEE Workshop on Mobile Computing Systems and Applications.

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

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

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

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

[31]  Ram Ramanathan,et al.  Topology control of multihop wireless networks using transmit power adjustment , 2000, Proceedings IEEE INFOCOM 2000. Conference on Computer Communications. Nineteenth Annual Joint Conference of the IEEE Computer and Communications Societies (Cat. No.00CH37064).

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

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

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

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

[36]  Donald Kossmann,et al.  The state of the art in distributed query processing , 2000, CSUR.

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