{"id":"https://openalex.org/W2157022252","doi":"https://doi.org/10.14778/1454159.1454179","title":"Towards a streaming SQL standard","display_name":"Towards a streaming SQL standard","publication_year":2008,"publication_date":"2008-08-01","ids":{"openalex":"https://openalex.org/W2157022252","doi":"https://doi.org/10.14778/1454159.1454179","mag":"2157022252"},"language":"en","primary_location":{"id":"doi:10.14778/1454159.1454179","is_oa":false,"landing_page_url":"https://doi.org/10.14778/1454159.1454179","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5059659735","display_name":"Namit Jain","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Namit Jain","raw_affiliation_strings":["Oracle Corp., Redwood Shores, CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corp., Redwood Shores, CA","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5028523826","display_name":"Shailendra Mishra","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Shailendra Mishra","raw_affiliation_strings":["Oracle Corp., Redwood Shores, CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corp., Redwood Shores, CA","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101769231","display_name":"Anand Srinivasan","orcid":"https://orcid.org/0000-0002-0533-2413"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Anand Srinivasan","raw_affiliation_strings":["Oracle Corp., Redwood Shores, CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corp., Redwood Shores, CA","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023537206","display_name":"Johannes Gehrke","orcid":"https://orcid.org/0009-0006-6293-5209"},"institutions":[{"id":"https://openalex.org/I205783295","display_name":"Cornell University","ror":"https://ror.org/05bnh6r87","country_code":"US","type":"education","lineage":["https://openalex.org/I205783295"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Johannes Gehrke","raw_affiliation_strings":["Cornell University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Cornell University","institution_ids":["https://openalex.org/I205783295"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010857944","display_name":"Jennifer Widom","orcid":null},"institutions":[{"id":"https://openalex.org/I97018004","display_name":"Stanford University","ror":"https://ror.org/00f54p054","country_code":"US","type":"education","lineage":["https://openalex.org/I97018004"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jennifer Widom","raw_affiliation_strings":["Stanford University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Stanford University","institution_ids":["https://openalex.org/I97018004"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103959495","display_name":"Hari Balakrishnan","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Hari Balakrishnan","raw_affiliation_strings":["StreamBase, Inc. Lexington, MA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"StreamBase, Inc. Lexington, MA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109862110","display_name":"U\u011fur \u00c7etintemel","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"U\u01e7ur \u00c7etintemel","raw_affiliation_strings":["StreamBase, Inc. Lexington, MA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"StreamBase, Inc. Lexington, MA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027464544","display_name":"Mitch Cherniack","orcid":"https://orcid.org/0000-0001-7461-891X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mitch Cherniack","raw_affiliation_strings":["StreamBase, Inc. Lexington, MA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"StreamBase, Inc. Lexington, MA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027702894","display_name":"Richard Tibbetts","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Richard Tibbetts","raw_affiliation_strings":["StreamBase, Inc. Lexington, MA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"StreamBase, Inc. Lexington, MA","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5111367666","display_name":"Stan Zdonik","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Stan Zdonik","raw_affiliation_strings":["StreamBase, Inc. Lexington, MA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"StreamBase, Inc. Lexington, MA","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":10,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":21.7384,"has_fulltext":false,"cited_by_count":157,"citation_normalized_percentile":{"value":0.99519315,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":100},"biblio":{"volume":"1","issue":"2","first_page":"1379","last_page":"1390"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.996399998664856,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.989300012588501,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8242173790931702},{"id":"https://openalex.org/keywords/simultaneity","display_name":"Simultaneity","score":0.8055710792541504},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.7809264659881592},{"id":"https://openalex.org/keywords/oracle","display_name":"Oracle","score":0.6531001329421997},{"id":"https://openalex.org/keywords/granularity","display_name":"Granularity","score":0.590142011642456},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.58506178855896},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.5446781516075134},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5155479907989502},{"id":"https://openalex.org/keywords/unification","display_name":"Unification","score":0.45142853260040283},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4158446788787842},{"id":"https://openalex.org/keywords/operator","display_name":"Operator (biology)","score":0.4114537835121155},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.1010657548904419}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8242173790931702},{"id":"https://openalex.org/C91317487","wikidata":"https://www.wikidata.org/wiki/Q1530412","display_name":"Simultaneity","level":2,"score":0.8055710792541504},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.7809264659881592},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.6531001329421997},{"id":"https://openalex.org/C177774035","wikidata":"https://www.wikidata.org/wiki/Q1246948","display_name":"Granularity","level":2,"score":0.590142011642456},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.58506178855896},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.5446781516075134},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5155479907989502},{"id":"https://openalex.org/C96146094","wikidata":"https://www.wikidata.org/wiki/Q609057","display_name":"Unification","level":2,"score":0.45142853260040283},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4158446788787842},{"id":"https://openalex.org/C17020691","wikidata":"https://www.wikidata.org/wiki/Q139677","display_name":"Operator (biology)","level":5,"score":0.4114537835121155},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.1010657548904419},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C86339819","wikidata":"https://www.wikidata.org/wiki/Q407384","display_name":"Transcription factor","level":3,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C74650414","wikidata":"https://www.wikidata.org/wiki/Q11397","display_name":"Classical mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C158448853","wikidata":"https://www.wikidata.org/wiki/Q425218","display_name":"Repressor","level":4,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/1454159.1454179","is_oa":false,"landing_page_url":"https://doi.org/10.14778/1454159.1454179","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W79504326","https://openalex.org/W1497285001","https://openalex.org/W1582747324","https://openalex.org/W2002110561","https://openalex.org/W2025190917","https://openalex.org/W2099395665","https://openalex.org/W2112215401","https://openalex.org/W2124298185","https://openalex.org/W2142580323","https://openalex.org/W2144771673","https://openalex.org/W2149233085","https://openalex.org/W2149576945","https://openalex.org/W2153753043","https://openalex.org/W2162553498","https://openalex.org/W2166604013","https://openalex.org/W2167274498","https://openalex.org/W2999505802"],"related_works":["https://openalex.org/W2931688134","https://openalex.org/W2377919138","https://openalex.org/W2378857091","https://openalex.org/W4256502920","https://openalex.org/W103652678","https://openalex.org/W1981956918","https://openalex.org/W2050463416","https://openalex.org/W23253958","https://openalex.org/W3030674916","https://openalex.org/W2327539013"],"abstract_inverted_index":{"This":[0,135],"paper":[1,136],"describes":[2,137],"a":[3,30,37,44,53,72,127],"unification":[4],"of":[5,110,126,140,146],"two":[6],"different":[7],"SQL":[8],"extensions":[9],"for":[10],"streams":[11],"and":[12,23,103,114,120,142],"its":[13,147],"associated":[14],"semantics.":[15],"We":[16],"use":[17],"the":[18,67,77,81,115,138],"data":[19],"models":[20],"from":[21],"Oracle":[22,28],"StreamBase":[24,35],"as":[25,60,62],"our":[26],"examples.":[27],"uses":[29,36],"time-based":[31],"execution":[32,39,42,51],"model":[33,47,74,100],"while":[34,49],"tuple-based":[38,50],"model.":[40],"Time-based":[41],"provides":[43,52],"way":[45,54],"to":[46,55,57,94],"simultaneity":[48,96,104],"react":[56],"primitive":[58],"events":[59],"soon":[61],"they":[63],"are":[64,117],"seen":[65],"by":[66,124],"system.":[68],"The":[69,98,112],"result":[70],"is":[71,92],"new":[73,129],"that":[75,131],"gives":[76,143],"user":[78],"control":[79],"over":[80],"granularity":[82],"at":[83],"which":[84],"one":[85],"can":[86,121],"express":[87],"simultaneity.":[88],"Of":[89],"course,":[90],"it":[91],"possible":[93],"ignore":[95],"altogether.":[97],"proposed":[99],"captures":[101],"ordering":[102,116],"through":[105],"partial":[106],"orders":[107],"on":[108],"batches":[109],"tuples.":[111],"batching":[113],"encapsulated":[118],"in":[119],"be":[122],"modified":[123],"means":[125],"powerful":[128],"operator":[130],"we":[132],"call":[133],"SPREAD.":[134],"semantics":[139],"SPREAD":[141],"several":[144],"examples":[145],"use.":[148]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":2},{"year":2020,"cited_by_count":5},{"year":2019,"cited_by_count":7},{"year":2018,"cited_by_count":7},{"year":2017,"cited_by_count":6},{"year":2016,"cited_by_count":14},{"year":2015,"cited_by_count":13},{"year":2014,"cited_by_count":12},{"year":2013,"cited_by_count":11},{"year":2012,"cited_by_count":14}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}