SNEE: a query processor for wireless sensor networks

A wireless sensor network (WSN) can be construed as an intelligent, large-scale device for observing and measuring properties of the physical world. In recent years, the database research community has championed the view that if we construe a WSN as a database (i.e., if a significant aspect of its intelligent behavior is that it can execute declaratively-expressed queries), then one can achieve a significant reduction in the cost of engineering the software that implements a data collection program for the WSN while still achieving, through query optimization, very favorable cost:benefit ratios. This paper describes a query processing framework for WSNs that meets many desiderata associated with the view of WSN as databases. The framework is presented in the form of compiler/optimizer, called SNEE, for a continuous declarative query language over sensed data streams, called SNEEql. SNEEql can be shown to meet the expressiveness requirements of a large class of applications. SNEE can be shown to generate effective and efficient query evaluation plans. More specifically, the paper describes the following contributions: (1) a user-level syntax and physical algebra for SNEEql, an expressive continuous query language over WSNs; (2) example concrete algorithms for physical algebraic operators defined in such a way that the task of deriving memory, time and energy analytical cost-estimation models (CEMs) for them becomes straightforward by reduction to a structural traversal of the pseudocode; (3) CEMs for the concrete algorithms alluded to; (4) an architecture for the optimization of SNEEql queries, called SNEE, building on well-established distributed query processing components where possible, but making enhancements or refinements where necessary to accommodate the WSN context; (5) algorithms that instantiate the components in the SNEE architecture, thereby supporting integrated query planning that includes routing, placement and timing; and (6) an empirical performance evaluation of the resulting framework.

[1]  Wolfgang J. Paul,et al.  Hardware design , 1995 .

[2]  Norman W. Paton,et al.  Adapting to Changing Resources in Grid Query Processing , 2005 .

[3]  Andreas Willig,et al.  Wireless sensor networks : first European Workshop, EWSN 2004, Berlin, Germany, January 19-21, 2004, proceedings , 2004 .

[4]  Goetz Graefe,et al.  Encapsulation of parallelism in the Volcano query processing system , 1990, SIGMOD '90.

[5]  Jennifer Widom,et al.  Towards a streaming SQL standard , 2008, Proc. VLDB Endow..

[6]  Norman W. Paton,et al.  A novel approach to resource scheduling for parallel query processing on computational grids , 2004, Fifth IEEE/ACM International Workshop on Grid Computing.

[7]  Gustavo Alonso,et al.  SwissQM: Next Generation Data Processing in Sensor Networks , 2007, CIDR.

[8]  Christian Y. A. Brenninkmeijer,et al.  QUERYING SENSOR NETWORKS: REQUIREMENTS, SEMANTICS, ALGORITHMS AND COST MODELS , 2010 .

[9]  David E. Culler,et al.  System architecture directions for networked sensors , 2000, SIGP.

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

[11]  Samuel Madden,et al.  PAQ: Time Series Forecasting for Approximate Query Answering in Sensor Networks , 2006, EWSN.

[12]  Wei Hong,et al.  Approximate Data Collection in Sensor Networks using Probabilistic Models , 2006, 22nd International Conference on Data Engineering (ICDE'06).

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

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

[15]  Jeffrey F. Naughton,et al.  Rate-based query optimization for streaming information sources , 2002, SIGMOD '02.

[16]  Jim Smith,et al.  Distributed Query Processing on the Grid , 2003, Int. J. High Perform. Comput. Appl..

[17]  Margaret Martonosi,et al.  Hardware design experiences in ZebraNet , 2004, SenSys '04.

[18]  John Anderson,et al.  An analysis of a large scale habitat monitoring application , 2004, SenSys '04.

[19]  Jim Smith,et al.  Distributed Query Processing on the Grid , 2002, GRID.

[20]  Rajmohan Rajaraman,et al.  Multi-query Optimization for Sensor Networks , 2005, DCOSS.

[21]  Frederick Reiss,et al.  TelegraphCQ: Continuous Dataflow Processing for an Uncertain World , 2003, CIDR.

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

[23]  Eduardo Mena,et al.  Using cooperative mobile agents to monitor distributed and dynamic environments , 2008, Inf. Sci..

[24]  Christian Y. A. Brenninkmeijer,et al.  Comprehensive Optimization of Declarative Sensor Network Queries , 2009, SSDBM.

[25]  Prashant J. Shenoy,et al.  Rethinking Data Management for Storage-centric Sensor Networks , 2007, CIDR.

[26]  Laura M. Haas,et al.  Cost Models DO Matter: Providing Cost Information for Diverse Data Sources in a Federated System , 1999, VLDB.

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

[28]  Luping Ding,et al.  CAPE: Continuous Query Engine with Heterogeneous-Grained Adaptivity , 2004, VLDB.

[29]  Suman Nath,et al.  Tributaries and deltas: efficient and robust aggregation in sensor network streams , 2005, SIGMOD '05.

[30]  David J. DeWitt,et al.  Design and evaluation of alternative selection placement strategies in optimizing continuous queries , 2002, Proceedings 18th International Conference on Data Engineering.

[31]  Christian Y. A. Brenninkmeijer,et al.  An Architecture for Query Optimization in Sensor Networks , 2008, 2008 IEEE 24th International Conference on Data Engineering.

[32]  Walid G. Aref,et al.  Nile: a query processing engine for data streams , 2004, Proceedings. 20th International Conference on Data Engineering.

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

[34]  Saurabh Ganeriwal,et al.  Timing-sync protocol for sensor networks , 2003, SenSys '03.

[35]  Christian Y. A. Brenninkmeijer,et al.  Validated cost models for sensor network queries , 2009, DMSN '09.

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

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

[38]  Michael Stonebraker,et al.  Mariposa: a wide-area distributed database system , 1996, The VLDB Journal.

[39]  Jens Palsberg,et al.  Avrora: scalable sensor network simulation with precise timing , 2005, IPSN 2005. Fourth International Symposium on Information Processing in Sensor Networks, 2005..

[40]  Jennifer Widom,et al.  STREAM: the stanford stream data manager (demonstration description) , 2003, SIGMOD '03.

[41]  Andreas Willig,et al.  Wireless Sensor Networks: First European Workshop, Ewsn 2004, Berlin, Germany, January 2004, Proceedings (LECTURE NOTES IN COMPUTER SCIENCE) , 2004 .

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

[43]  Jennifer Widom,et al.  STREAM: The Stanford Stream Data Manager , 2003, IEEE Data Eng. Bull..

[44]  John Anderson,et al.  Wireless sensor networks for habitat monitoring , 2002, WSNA '02.

[45]  Kirk Martinez,et al.  Environmental Sensor Networks: A revolution in the earth system science? , 2006 .

[46]  Jenna Burrell,et al.  Vineyard computing: sensor networks in agricultural production , 2004, IEEE Pervasive Computing.

[47]  Andreas Willig,et al.  Protocols and Architectures for Wireless Sensor Networks , 2005 .

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

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

[50]  Richard Beckwith,et al.  Report from the field: results from an agricultural wireless sensor network , 2004, 29th Annual IEEE International Conference on Local Computer Networks.

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

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

[53]  Ian W. Marshall,et al.  Multi-sensor Cross Correlation for Alarm Generation in a Deployed Sensor Network , 2007, EuroSSC.

[54]  Mohamed A. Sharaf,et al.  TiNA: a scheme for temporal coherency-aware in-network aggregation , 2003, MobiDe '03.

[55]  David E. Culler,et al.  The nesC language: A holistic approach to networked embedded systems , 2003, PLDI.

[56]  David E. Culler,et al.  TinyOS: An Operating System for Sensor Networks , 2005, Ambient Intelligence.

[57]  Angelo Brayner,et al.  An adaptive in-network aggregation operator for query processing in wireless sensor networks , 2008, J. Syst. Softw..

[58]  Jennifer Widom,et al.  Database System Implementation , 2000 .

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

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

[61]  Rajmohan Rajaraman,et al.  Wave scheduling and routing in sensor networks , 2007, TOSN.

[62]  Christian Y. A. Brenninkmeijer,et al.  A Semantics for a Query Language over Sensors, Streams and Relations , 2008, BNCOD.

[63]  Kay Römer,et al.  Wireless Sensor Networks, Third European Workshop, EWSN 2006, Zurich, Switzerland, February 13-15, 2006, Proceedings , 2006, EWSN.

[64]  Vladimir Zadorozhny,et al.  A framework for extending the synergy between MAC layer and query optimization in sensor networks , 2004, DMSN '04.

[65]  Minos N. Garofalakis,et al.  Parallel Query Scheduling and Optimization with Time- and Space-Shared Resources , 1997, VLDB.

[66]  Deborah Estrin,et al.  Habitat monitoring with sensor networks , 2004, CACM.

[67]  Surajit Chaudhuri,et al.  An overview of query optimization in relational systems , 1998, PODS.

[68]  Lukasz Golab,et al.  Issues in data stream management , 2003, SGMD.