Query processing in sensor networks
2010, Distributed and Parallel Databases
https://doi.org/10.1007/S10619-010-7076-1Abstract
Hardware for sensor nodes that combine physical sensors, actuators, embedded processors, and communication components has advanced significantly over the last decade, and made the large-scale deployment of such sensors a reality. Applications range from monitoring applications such as inventory maintenance over health care to military applications. In this paper, we evaluate the design of a query layer for sensor networks. The query layer accepts queries in a declarative language that are then optimized to generate efficient query execution plans with in-network processing which can significantly reduce resource requirements. We examine the main architectural components of such a query layer, concentrating on in-network aggregation, interaction of in-network aggregation with the wireless routing protocol, and distributed query processing. Initial simulation experiments with the ns-2 network simulator show the tradeoffs of our system.
References (40)
- ACM SIGMOBILE. Proceedings of MOBICOM 1998. ACM Press.
- L. Breslau, D. Estrin, K. Fall, S. Floyd, J. Heide- mann, A. Helmy, P. Huang, S. McCanne, K. Varad- han, Y. Xu, and H. Yu. Advances in network simula- tion. IEEE Computer, 33(5):59-67, May 2000.
- J. Broch, D. A. Maltz, D. B. Johnson, Y.-C. Hu, and J. Jetcheva. A performance comparison of multi-hop wireless ad hoc network routing protocols. [3], pages 85-97.
- M. Calimlim, W. F. Fung, J. Gehrke, D. Sun, and Y. Yao. Cougar Project web page. www.cs.cornell.edu/database/cougar.
- S. Ceri and G. Pelagatti. Distributed Database De- sign: Principles and Systems. MacGraw-Hill (New York NY), 1984.
- S. Das, C. Perkins, and E. Royer. Performance com- parison of two on-demand routing protocols for ad hoc networks. In INFOCOM 2000, pages 3-12. IEEE.
- D. Estrin, R. Govindan, J. Heidemann, and S. Ku- mar. Next century challenges: Scalable coordination in sensor networks. In MOBICOM 1999, pages 263- 270. ACM Press.
- J. Gray, S. Chaudhuri, A. Bosworth, A. Layman, D. Reichart, M. Venkatrao, F. Pellow, and H. Pira- hesh. Data cube: A relational aggregation operator generalizing group-by, cross-tab, and sub-totals. Data Mining and Knowledge Discovery, 1(1):29-53, 1997.
- Z. Haas. The zone routing protocol (ZRP) for wireless networks. IETF MANET, Internet Draft, 1997.
- D. L. Hall and J. Llinas, editors. Handbook of Multi- sensor Data Fusion. CRC Press, 2001.
- J. Hill and D. Culler. A wireless embedded sensor architecture for system-level optimization. Submitted for publication, 2002.
- C. Intanagonwiwat, R. Govindan, and D. Estrin. Di- rected diffusion: A scalable and robust communica- tion paradigm for sensor networks. In MOBICOM 2000, pages 56-67. ACM Press.
- P. Johansson, T. Larsson, N. Hedman, B. Mielczarek, and M. Degermark. Scenario-based performance anal- ysis of routing protocols for mobile ad-hoc networks. In MOBICOM 1999, pages 195-206. ACM Press.
- D. B. Johnson and D. A. Maltz. Dynamic source rout- ing in ad hoc wireless networks. In Mobile Computing. Kluwer Academic Publishers, 1996.
- J. Jubin and J. D. Tornow. The DARPA packet radio network protocol. Proceedings of the IEEE, 75(1):21- 32, Jan. 1987.
- D. Kossmann. The state of the art in distributed query processing. Computing Surveys, 32, 2000.
- S. Madden and M. J. Franklin. Fjording the stream: An architecture for queries over streaming sensor data. In ICDE 2002.
- S. Madden and J. M. Hellerstein. Distributing queries over low-power wireless sensor networks. In SIGMOD 2002.
- S. R. Madden, M. J. Franklin, J. M. Hellerstein, and W. Hong. Tag: A tiny aggregation service for ad-hoc sensor networks. In OSDI 2002.
- S. R. Madden, R. Szewczyk, M. J. Franklin, and D. Culler. Supporting aggregate queries over ad-hoc sensor networks. In Workshop on Mobile Computing and Systems Applications (WMCSA), 2002.
- M. T. Özsy and P. Valduriez. Principles of Distributed Database Systems. Prentice Hall, Englewood Cliffs, 1991.
- V. D. Park and M. S. Corson. A highly adaptive distributed routing algorithm for mobile wireless net- works. In INFOCOM 1997. IEEE.
- C. Perkins and P. Bhagwat. Highly dynamic destination-sequenced distance-vector routing (DSDV) for mobile computers. In SIGCOMM 1994 , pages 234-244. ACM Press.
- C. E. Perkins. Ad hoc on demand dis- tance vector (aodv) routing. Internet Draft, http://www.ietf.org/internet-drafts/draft-ietf-manet- aodv-04.txt, October 1999.
- G. J. Pottie and W. J. Kaiser. Embedding the Inter- net: wireless integrated network sensors. Communi- cations of the ACM, 43(5):51-51, May 2000.
- G. J. Pottie and W. J. Kaiser. Wireless integrated net- work sensors. Communications of the ACM, 43(5):51- 58, 2000.
- V. Raghunathan, C. Schurgers, S. Park, and M. B. Sri- vastava. Energy-aware wireless microsensor networks. IEEE Signal Processing Magazine, 19(2):40-50, 2002.
- N. Schacham and J. Westcott. Future directions in packet radio architectures and protocols. Proceedings of the IEEE, 75(1):83-99, January 1987.
- P. Seshadri, M. Livny, and R. Ramakrishnan. Seq: A model for sequence databases. In ICDE 1995. IEEE Computer Society.
- P. Seshadri, M. Livny, and R. Ramakrishnan. The de- sign and implementation of a sequence database sys- tem.
- In VLDB 1996, pages 99-110. Morgan Kauf- mann.
- A. Shatdal and J. F. Naughton. Adaptive parallel aggregation algorithms. In SIGMOD 1995, pages 104- 114.
- T. Simunic, H. Vikalo, P. Glynn, and G. D. Micheli. Energy efficient design of portable wireless systems. In ISLPED 2000, pages 49-54. ACM Press.
- S. Singh, M. Woo, and C. S. Raghavendra. Power- aware routing in mobile ad hoc networks. [3], pages 181-190.
- I. C. Society. Wireless LAN medium access control (mac) and physical layer specification. IEEE Std 802.11, 1999.
- M. Stonebraker. Operating system support for database management. CACM, 24(7):412-418, 1981.
- W. P. Yan and P.-Å. Larson. Eager aggregation and lazy aggregation. In VLDB 1995. Morgan Kaufmann.
- C. Yu and W. Meng. Principles of Database Query Processing for Advanced Applications. Morgan Kauf- mann, San Francisco, 1998.
- C. T. Yu and C. C. Chang. Distributed query process- ing. ACM Computing Surveys, 16(4):399-433, Dec. 1984.
- C. Zaniolo, C. S., C. Faloutsos, R. Snodgrass, V. S. Subrahmanian, and R. Zicari, editors. Advanced Database Systems. Morgan Kaufmann, San Francisco, 1997.