Encyclopedia of Database Systems

Living Edition
| Editors: Ling Liu, M. Tamer Özsu

Window-Based Query Processing

  • Walid G. Aref
Living reference work entry
DOI: https://doi.org/10.1007/978-1-4899-7993-3_468-2

Synonyms

Definition

Data streams are infinite in nature. As a result, a query that executes over data streams specifies a “window” of focus or the part of the data stream that is of interest to the query. When new data items arrive into the data stream, the window may either expand or slide to allow the query to process these new data items. Hence, queries over data streams are continuous in nature, i.e., the query is continuously reevaluated each time the query window slides. Window-based query processing on data streams refers to the various ways and techniques for processing and evaluating continuous queries over windows of data stream items.

Historical Background

Windows over relational tables have already been introduced into standard SQL (SQL:1999) in order to support data analysis, decision support, and, more generally, OLAP-type operations.

However, the motivation for having windows in data stream management systems is quite different. Since data streams...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Srivastava U, Widom J. Flexible time management in data stream systems. In: Proceedings of 23rd ACM SIGACT-SIGMOD-SIGART symposium on principles of database systems. 2004. p. 263–74.Google Scholar
  2. 2.
    Abadi D, Ahmad Y, Balazinska M, Cetintemel U, Cherniack M, Hwang J-H, Lindner W, Maskey AS, Rasin A, Ryvkina E, Tatbul N, Xing Y, Zdonik S. The design of the Borealis stream processing engine. In: Proceedings of 2nd biennial conference on innovative data systems research. 2005. p. 277–89.Google Scholar
  3. 3.
    Ryvkina E, Maskey AS, Cherniack M, Zdonik S. Revision processing in a stream processing engine: a high-level design. In: Proceedings of 22nd international conference on data engineering. 2006.Google Scholar
  4. 4.
    Ghanem TM, Hammad MA, Mokbel MF, Aref WG, Elmagarmid AK. Incremental evaluation of sliding-window queries over data streams. IEEE Trans Knowl Data Eng. 2007;19(1):57–72.CrossRefGoogle Scholar
  5. 5.
    Tucker PA, Maier D, Sheard T, Fegaras L. Exploiting punctuation semantics in continuous data streams. IEEE Trans Knowl Data Eng. 2003;15(3):555–68.CrossRefGoogle Scholar
  6. 6.
    Chandrasekaran S, Franklin MJ. Streaming queries over streaming data. In: Proceedings of 28th international conference on very large data bases. 2002. p. 203–14.Google Scholar
  7. 7.
    Hammad MA, Franklin MJ, Aref WG, Elmagarmid AK Scheduling for shared window joins over data streams. In: Proceedings of 29th international conference on very large data bases. 2003. p. 297–308.Google Scholar
  8. 8.
    Jianjun C, DeWitt DJ, Feng T, Yuan W. NiagaraCQ: a scalable continuous query system for internet databases. In: Proceedings of ACM SIGMOD international conference on management of data. 2000. p. 379–90.Google Scholar
  9. 9.
    Jianjun C, DeWitt DJ, Naughton JF. Design and evaluation of alternative selection placement strategies in optimizing continuous queries. In: Proceedings of 18th international conference on data engineering. 2002. p. 345–56.Google Scholar
  10. 10.
    Madden S, Shah MA, Hellerstein JM, Raman V. Continuously adaptive continuous queries over streams. In: Proceedings of ACM SIGMOD international conference on management of data. 2002. p. 49–60.Google Scholar
  11. 11.
    The STREAM Group. STREAM: the stanford stream data manager. IEEE Data Eng Bull. 2003;26(1):19–26.Google Scholar
  12. 12.
    Hammad MA, Mokbel MF, Ali MH, Aref WG, Catlin AC, Elmagarmid AK, Eltabakh M, Elfeky MG, Ghanem T, Gwadera R, Ilyas IF, Marzouk M, Xiong X. Nile: a query processing engine for data streams. In: Proceedings of 20th international conference on data engineering. 2004. p. 851.Google Scholar
  13. 13.
    Ghanem TM, Elmagarmid AK, Larson PA, Aref WG. Supporting views in data stream management systems. ACM Transactions on Database Systems 35(1), 1:1–1:47 2010.Google Scholar
  14. 14.
    Abadi D, Carney D, Cetintemel U, Cherniack M, Convey C, Lee S, Stonebraker M, Tatbul N, Zdonik S. Aurora: a new model and architecture for data stream management. VLDB J. 2003;12(2):120–39.CrossRefGoogle Scholar
  15. 15.
    Bai Y, Thakkar H, Luo C, Wang H, Zaniolo C. A data stream language and system designed for power and extensibility. In: Proceedings of International Conference on information and knowledge management. 2006. p. 337–46.Google Scholar
  16. 16.
    Johnson T, Muthukrishnan S, Shkapenyuk V, Spatscheck O A heartbeat mechanism and its application in gigascope. In: Proceedings of 31st international conference on very large data bases. 2005. p. 1079–88.Google Scholar
  17. 17.
    Stonebraker M, Cetintemel U, Zdonik S. The 8 requirements of real-time stream processing. ACM SIGMOD Rec. 2005;34(4):42–7.CrossRefGoogle Scholar

Copyright information

© Springer Science+Business Media LLC 2017

Authors and Affiliations

  1. 1.Purdue UniversityWest LafayetteUSA

Section editors and affiliations

  • Ugur Cetintemel
    • 1
  1. 1.Department of Computer ScienceBrown UniversityProvidenceUSA