Aggregate query processing in the presence of duplicates in wireless sensor networks

Abstract Wireless sensor networks (WSNs) have received increasing attention in the past decade. In existing studies for query processing of WSNs, each sensor node measures environmental parameters such as temperature, light and humidity around its location. Instead, in our work, we consider a different type of sensors that detect objects in their sensing regions which may overlap with each other. In WSNs with such sensors, an object may be detected by several sensor nodes and processing of aggregate queries (such as COUNT, SUM and AVERAGE) becomes problematic since an identical object can be considered redundantly. In this paper, we propose efficient algorithms for processing aggregate queries as well as sliding window aggregate queries in the presence of multiply detected events. To perform de-duplication, our proposed algorithms identify potential duplicates among detected events by communicating with other nodes and perform aggregations as early as possible. In addition, we extend our algorithms for aggregate queries to support time-based sliding windows. By extensive performance study with diverse environments, we show that the energy consumptions of our proposed algorithms are much smaller than those of baseline algorithms.

[1]  Gregory J. Pottie,et al.  Protocols for self-organization of a wireless sensor network , 2000, IEEE Wirel. Commun..

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

[3]  Andrei Broder,et al.  Network Applications of Bloom Filters: A Survey , 2004, Internet Math..

[4]  Yossi Matias,et al.  Spectral bloom filters , 2003, SIGMOD '03.

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

[6]  Burton H. Bloom,et al.  Space/time trade-offs in hash coding with allowable errors , 1970, CACM.

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

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

[9]  Dik Lun Lee,et al.  Semantic Caching in Location-Dependent Query Processing , 2001, SSTD.

[10]  Kamesh Munagala,et al.  Energy-efficient monitoring of extreme values in sensor networks , 2006, SIGMOD Conference.

[11]  Gregory J. Pottie,et al.  Collaborative networking requirements for unattended ground sensor systems , 2003, 2003 IEEE Aerospace Conference Proceedings (Cat. No.03TH8652).

[12]  Lei Chen,et al.  Max Regional Aggregate over Sensor Networks , 2009, 2009 IEEE 25th International Conference on Data Engineering.

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

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

[15]  Katja Hose,et al.  Stream engines meet wireless sensor networks: cost-based planning and processing of complex queries in AnduIN , 2011, Distributed and Parallel Databases.

[16]  Yong Wang,et al.  Energy-efficient computing for wildlife tracking: design tradeoffs and early experiences with ZebraNet , 2002, ASPLOS X.

[17]  David Maier,et al.  Semantics and evaluation techniques for window aggregates in data streams , 2005, SIGMOD '05.

[18]  Dong-Wan Choi,et al.  REQUEST: Region-Based Query Processing in Sensor Networks , 2011, DASFAA.

[19]  Ajay D. Kshemkalyani,et al.  Clock synchronization for wireless sensor networks: a survey , 2005, Ad Hoc Networks.

[20]  Richard T. Snodgrass,et al.  Spatiotemporal aggregate computation: a survey , 2005, IEEE Transactions on Knowledge and Data Engineering.

[21]  Sharad Mehrotra,et al.  Progressive approximate aggregate queries with a multi-resolution tree structure , 2001, SIGMOD '01.

[22]  Srinivasan Seshan,et al.  Synopsis diffusion for robust aggregation in sensor networks , 2004, SenSys '04.

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

[24]  Divyakant Agrawal,et al.  Medians and beyond: new aggregation techniques for sensor networks , 2004, SenSys '04.

[25]  Philippe Flajolet,et al.  Probabilistic Counting Algorithms for Data Base Applications , 1985, J. Comput. Syst. Sci..

[26]  Anantha P. Chandrakasan,et al.  An application-specific protocol architecture for wireless microsensor networks , 2002, IEEE Trans. Wirel. Commun..

[27]  Dimitrios Gunopulos,et al.  Spatial queries in sensor networks , 2005, GIS '05.

[28]  Dimitrios Gunopulos,et al.  Efficient computation of temporal aggregates with range predicates , 2001, PODS '01.

[29]  Rajmohan Rajaraman,et al.  The Cougar Project: a work-in-progress report , 2003, SGMD.

[30]  Donghui Zhang,et al.  Improving min/max aggregation over spatial objects , 2001, GIS '01.

[31]  Jeffrey Considine,et al.  Spatio-temporal aggregation using sketches , 2004, Proceedings. 20th International Conference on Data Engineering.

[32]  Christian Y. A. Brenninkmeijer,et al.  SNEE: a query processor for wireless sensor networks , 2011, Distributed and Parallel Databases.

[33]  Antonin Guttman,et al.  R-trees: a dynamic index structure for spatial searching , 1984, SIGMOD '84.

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