{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,21]],"date-time":"2026-05-21T02:53:35Z","timestamp":1779332015791,"version":"3.51.4"},"reference-count":24,"publisher":"Association for Computing Machinery (ACM)","issue":"2","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2008,8]]},"abstract":"<jats:p>This paper describes a unification of two different SQL extensions for streams and its associated semantics. We use the data models from Oracle and StreamBase as our examples. Oracle uses a time-based execution model while StreamBase uses a tuple-based execution model. Time-based execution provides a way to model simultaneity while tuple-based execution provides a way to react to primitive events as soon as they are seen by the system.<\/jats:p>\n          <jats:p>The result is a new model that gives the user control over the granularity at which one can express simultaneity. Of course, it is possible to ignore simultaneity altogether. The proposed model captures ordering and simultaneity through partial orders on batches of tuples. The batching and the ordering are encapsulated in and can be modified by means of a powerful new operator that we call SPREAD. This paper describes the semantics of SPREAD and gives several examples of its use.<\/jats:p>","DOI":"10.14778\/1454159.1454179","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1379-1390","source":"Crossref","is-referenced-by-count":95,"title":["Towards a streaming SQL standard"],"prefix":"10.14778","volume":"1","author":[{"given":"Namit","family":"Jain","sequence":"first","affiliation":[{"name":"Oracle Corp., Redwood Shores, CA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Shailendra","family":"Mishra","sequence":"additional","affiliation":[{"name":"Oracle Corp., Redwood Shores, CA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Anand","family":"Srinivasan","sequence":"additional","affiliation":[{"name":"Oracle Corp., Redwood Shores, CA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Johannes","family":"Gehrke","sequence":"additional","affiliation":[{"name":"Cornell University"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jennifer","family":"Widom","sequence":"additional","affiliation":[{"name":"Stanford University"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Hari","family":"Balakrishnan","sequence":"additional","affiliation":[{"name":"StreamBase, Inc. Lexington, MA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"U\u01e7ur","family":"\u00c7etintemel","sequence":"additional","affiliation":[{"name":"StreamBase, Inc. Lexington, MA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Mitch","family":"Cherniack","sequence":"additional","affiliation":[{"name":"StreamBase, Inc. Lexington, MA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Richard","family":"Tibbetts","sequence":"additional","affiliation":[{"name":"StreamBase, Inc. Lexington, MA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Stan","family":"Zdonik","sequence":"additional","affiliation":[{"name":"StreamBase, Inc. Lexington, MA"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2008,8]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-004-0147-z"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-003-0095-z"},{"key":"e_1_2_1_3_1","first-page":"480","volume":"2004","author":"Arasu A.","unstructured":"A. Arasu , M. Cherniack , E. F. Galvez , D. Maier , A. Maskey , E. Ryvkina , M. Stonebraker , and R. Tibbetts: Linear Road: A Stream Data Management Benchmark. VLDB 2004 : 480 -- 491 A. Arasu, M. Cherniack, E. F. Galvez, D. Maier, A. Maskey, E. Ryvkina, M. Stonebraker, and R. Tibbetts: Linear Road: A Stream Data Management Benchmark. VLDB 2004: 480--491","journal-title":"Tibbetts: Linear Road: A Stream Data Management Benchmark. VLDB"},{"key":"e_1_2_1_4_1","volume-title":"March, 2007.","author":"Anonymous","unstructured":"Anonymous : Pattern Matching in Sequences of Rows, SQL standard proposal, http:\/\/asktom.oracle.com\/tkyte\/row-pattern-recogniton-11-public.pdf , March, 2007. Anonymous: Pattern Matching in Sequences of Rows, SQL standard proposal, http:\/\/asktom.oracle.com\/tkyte\/row-pattern-recogniton-11-public.pdf, March, 2007."},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/872757.872789"},{"key":"e_1_2_1_6_1","volume-title":"M. Hong: Consistent Streaming Through Time: A Vision for Event Stream Processing. CIDR 2007:  363--374","author":"Barga R. S.","unstructured":"R. S. Barga , J. Goldstein , M. H. Ali , M. Hong: Consistent Streaming Through Time: A Vision for Event Stream Processing. CIDR 2007: 363--374 R. S. Barga, J. Goldstein, M. H. Ali, M. Hong: Consistent Streaming Through Time: A Vision for Event Stream Processing. CIDR 2007: 363--374"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/1183614.1183664"},{"key":"e_1_2_1_8_1","unstructured":"Coral8 Inc. Coral8 CCL Reference available at http:\/\/www.coral8.com\/system\/files\/assets\/pdf\/5.2.0\/Coral8CclReference.pdf  Coral8 Inc. Coral8 CCL Reference available at http:\/\/www.coral8.com\/system\/files\/assets\/pdf\/5.2.0\/Coral8CclReference.pdf"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.5555\/1315451.1315523"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.5555\/1287369.1287388"},{"key":"e_1_2_1_12_1","unstructured":"Codehaus.org Esper online documentation set http:\/\/esper.codehaus.org\/tutorials\/tutorials.html 2007.  Codehaus.org Esper online documentation set http:\/\/esper.codehaus.org\/tutorials\/tutorials.html 2007."},{"key":"e_1_2_1_13_1","volume-title":"Slides from a talk given on","author":"N.","year":"2007","unstructured":"Conway, N. , An Introduction to Data Stream Query Processing , Slides from a talk given on May 24, 2007 , http:\/\/www.pgcon.org\/2007\/schedule\/attachments\/17-stream intro.pdf., 2007. Conway, N., An Introduction to Data Stream Query Processing, Slides from a talk given on May 24, 2007, http:\/\/www.pgcon.org\/2007\/schedule\/attachments\/17-stream intro.pdf., 2007."},{"key":"e_1_2_1_14_1","unstructured":"Coral8 Systems Coral8 CCL Reference Version 5.1 http:\/\/www.coral8.com\/system\/files\/assets\/pdf\/current\/Coral8CclReference.pdf 2007.  Coral8 Systems Coral8 CCL Reference Version 5.1 http:\/\/www.coral8.com\/system\/files\/assets\/pdf\/current\/Coral8CclReference.pdf 2007."},{"key":"e_1_2_1_15_1","unstructured":"Coral8 Inc. http:\/\/www.coral8.com  Coral8 Inc. http:\/\/www.coral8.com"},{"key":"e_1_2_1_16_1","volume-title":"Walker M. White: Cayuga: A General Purpose Event Monitoring System. CIDR 2007:  412--422","author":"Demers Alan J.","unstructured":"Alan J. Demers , Johannes Gehrke , Biswanath Panda , Mirek Riedewald , Varun Sharma , Walker M. White: Cayuga: A General Purpose Event Monitoring System. CIDR 2007: 412--422 Alan J. Demers, Johannes Gehrke, Biswanath Panda, Mirek Riedewald, Varun Sharma, Walker M. White: Cayuga: A General Purpose Event Monitoring System. CIDR 2007: 412--422"},{"key":"e_1_2_1_17_1","volume-title":"CIDR","author":"Gyllstrom D.","year":"2007","unstructured":"D. Gyllstrom , E. Wu , H. Chae , Y. Diao , P. Stahlberg , G. Anderson : SASE: Complex Event Processing over Streams . CIDR 2007 . D. Gyllstrom, E. Wu, H. Chae, Y. Diao, P. Stahlberg, G. Anderson: SASE: Complex Event Processing over Streams. CIDR 2007."},{"key":"e_1_2_1_18_1","volume-title":"M. Jarke: Incremental Maintenance of Externally Materialized Views. VLDB","author":"Staudt M.","year":"1996","unstructured":"M. Staudt , M. Jarke: Incremental Maintenance of Externally Materialized Views. VLDB 1996 . M. Staudt, M. Jarke: Incremental Maintenance of Externally Materialized Views. VLDB 1996."},{"key":"e_1_2_1_19_1","unstructured":"StreamBase Systems StreamSQL online documentation http:\/\/streambase.com\/developers\/docs\/latest\/streamsql\/index.html 2007.  StreamBase Systems StreamSQL online documentation http:\/\/streambase.com\/developers\/docs\/latest\/streamsql\/index.html 2007."},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1145\/1005566.1005568"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/141484.130333"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142520"},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2007.1052"},{"key":"e_1_2_1_24_1","unstructured":"Widom Jennifer: CQL: A Language for Continuous Queries over Streams and Relations Slides from a talk given at the Database Programming Language (DBPL) Workshop http:\/\/www-db.stanford.edu\/~widom\/cql-talk.pdf 2003.  Widom Jennifer: CQL: A Language for Continuous Queries over Streams and Relations Slides from a talk given at the Database Programming Language (DBPL) Workshop http:\/\/www-db.stanford.edu\/~widom\/cql-talk.pdf 2003."},{"key":"e_1_2_1_25_1","volume-title":"UCLA","author":"H.","year":"2006","unstructured":"Zaniolo, C., Luo, C., Wang, H., Bai, Y., Thakkar, H. : An Introduction to the Expressive Stream Language (ESL), Technical Report , UCLA , 2006 . Zaniolo, C., Luo, C., Wang, H., Bai, Y., Thakkar, H.: An Introduction to the Expressive Stream Language (ESL), Technical Report, UCLA, 2006."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/1454159.1454179","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T09:56:32Z","timestamp":1672221392000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/1454159.1454179"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2008,8]]},"references-count":24,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2008,8]]}},"alternative-id":["10.14778\/1454159.1454179"],"URL":"https:\/\/doi.org\/10.14778\/1454159.1454179","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2008,8]]}}}