{"id":"https://openalex.org/W3100469037","doi":"https://doi.org/10.1145/3299869.3314040","title":"One SQL to Rule Them All - an Efficient and Syntactically Idiomatic Approach to Management of Streams and Tables","display_name":"One SQL to Rule Them All - an Efficient and Syntactically Idiomatic Approach to Management of Streams and Tables","publication_year":2019,"publication_date":"2019-06-18","ids":{"openalex":"https://openalex.org/W3100469037","doi":"https://doi.org/10.1145/3299869.3314040","mag":"3100469037"},"language":"en","primary_location":{"id":"doi:10.1145/3299869.3314040","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3299869.3314040","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3299869.3314040","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2019 International Conference on Management of Data","raw_type":"proceedings-article"},"type":"preprint","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3299869.3314040","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5014317244","display_name":"Edmon Begoli","orcid":"https://orcid.org/0000-0002-2173-3663"},"institutions":[{"id":"https://openalex.org/I1289243028","display_name":"Oak Ridge National Laboratory","ror":"https://ror.org/01qz5mb56","country_code":"US","type":"facility","lineage":["https://openalex.org/I1289243028","https://openalex.org/I1330989302","https://openalex.org/I39565521","https://openalex.org/I4210159294"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Edmon Begoli","raw_affiliation_strings":["Oak Ridge National Laboratory, Oak Ridge, TN, USA"],"affiliations":[{"raw_affiliation_string":"Oak Ridge National Laboratory, Oak Ridge, TN, USA","institution_ids":["https://openalex.org/I1289243028"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063837636","display_name":"Tyler Akidau","orcid":"https://orcid.org/0009-0003-2446-300X"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Tyler Akidau","raw_affiliation_strings":["Google Inc., Seattle, WA, USA"],"affiliations":[{"raw_affiliation_string":"Google Inc., Seattle, WA, USA","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5066448126","display_name":"Fabian Hueske","orcid":"https://orcid.org/0009-0003-7764-9174"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Fabian Hueske","raw_affiliation_strings":["Ververica, Berlin, Germany"],"affiliations":[{"raw_affiliation_string":"Ververica, Berlin, Germany","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037196502","display_name":"Julian Hyde","orcid":"https://orcid.org/0009-0003-7857-7467"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Julian Hyde","raw_affiliation_strings":["Looker Inc., San Francisco, CA, USA"],"affiliations":[{"raw_affiliation_string":"Looker Inc., San Francisco, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5019939326","display_name":"Kathryn Knight","orcid":"https://orcid.org/0000-0003-2976-0049"},"institutions":[{"id":"https://openalex.org/I1289243028","display_name":"Oak Ridge National Laboratory","ror":"https://ror.org/01qz5mb56","country_code":"US","type":"facility","lineage":["https://openalex.org/I1289243028","https://openalex.org/I1330989302","https://openalex.org/I39565521","https://openalex.org/I4210159294"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kathryn Knight","raw_affiliation_strings":["Oak Ridge National Laboratory, Oak Ridge, TN, USA"],"affiliations":[{"raw_affiliation_string":"Oak Ridge National Laboratory, Oak Ridge, TN, USA","institution_ids":["https://openalex.org/I1289243028"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5086650392","display_name":"Kenneth Knowles","orcid":null},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kenneth Knowles","raw_affiliation_strings":["Google Inc., Seattle, WA, USA"],"affiliations":[{"raw_affiliation_string":"Google Inc., Seattle, WA, USA","institution_ids":["https://openalex.org/I1291425158"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5014317244"],"corresponding_institution_ids":["https://openalex.org/I1289243028"],"apc_list":null,"apc_paid":null,"fwci":3.343,"has_fulltext":true,"cited_by_count":34,"citation_normalized_percentile":{"value":0.93198762,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"1757","last_page":"1772"},"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.9997000098228455,"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.9997000098228455,"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.9951000213623047,"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.9807000160217285,"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.8108360767364502},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.631823718547821},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.594702959060669},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.35500258207321167}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8108360767364502},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.631823718547821},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.594702959060669},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.35500258207321167}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3299869.3314040","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3299869.3314040","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3299869.3314040","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2019 International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:oai:osti.gov:1559678","is_oa":true,"landing_page_url":"https://www.osti.gov/biblio/1559678","pdf_url":"https://www.osti.gov/servlets/purl/1559678","source":{"id":"https://openalex.org/S4306402487","display_name":"OSTI OAI (U.S. Department of Energy Office of Scientific and Technical Information)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I139351228","host_organization_name":"Office of Scientific and Technical Information","host_organization_lineage":["https://openalex.org/I139351228"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":{"id":"doi:10.1145/3299869.3314040","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3299869.3314040","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3299869.3314040","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2019 International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[{"display_name":"Quality Education","score":0.4099999964237213,"id":"https://metadata.un.org/sdg/4"}],"awards":[{"id":"https://openalex.org/G1645119126","display_name":null,"funder_award_id":"AC05-00OR22725","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G1719536385","display_name":null,"funder_award_id":"DE-AC05-00OR22725","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G2042897603","display_name":null,"funder_award_id":"DE-AC05-00OR2272","funder_id":"https://openalex.org/F4320316892","funder_display_name":"UT-Battelle"},{"id":"https://openalex.org/G2296932962","display_name":null,"funder_award_id":"DE-AC05-00OR227","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G3049477530","display_name":null,"funder_award_id":"Contract No. DE-AC05-00OR22725","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G3299391273","display_name":null,"funder_award_id":"E-AC05-00OR22725","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G4617282320","display_name":null,"funder_award_id":"No. DE-AC05-00OR227","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G4957472368","display_name":null,"funder_award_id":". DE-AC05-00OR22725","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G5726405315","display_name":null,"funder_award_id":"DE-AC05","funder_id":"https://openalex.org/F4320306250","funder_display_name":"Battelle"},{"id":"https://openalex.org/G6129992089","display_name":null,"funder_award_id":"DE-AC05-","funder_id":"https://openalex.org/F4320316892","funder_display_name":"UT-Battelle"},{"id":"https://openalex.org/G6864165199","display_name":null,"funder_award_id":"DE-AC05-00OR22725","funder_id":"https://openalex.org/F4320306250","funder_display_name":"Battelle"},{"id":"https://openalex.org/G6911681599","display_name":null,"funder_award_id":"No. DE-AC05-00OR22725","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G691578896","display_name":null,"funder_award_id":"DE-AC05-00OR2272","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G7769062580","display_name":null,"funder_award_id":"No. DE-AC05-00OR22725","funder_id":"https://openalex.org/F4320316892","funder_display_name":"UT-Battelle"},{"id":"https://openalex.org/G7995982022","display_name":null,"funder_award_id":"DE-AC05","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G8414908677","display_name":null,"funder_award_id":"DE-AC0","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G8799952057","display_name":null,"funder_award_id":"DE-AC05-00OR22","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G8813984943","display_name":null,"funder_award_id":"DE-AC05-00OR22725","funder_id":"https://openalex.org/F4320316892","funder_display_name":"UT-Battelle"},{"id":"https://openalex.org/G8906985441","display_name":null,"funder_award_id":"00OR22725","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G8943143067","display_name":null,"funder_award_id":"AC05-00OR22725","funder_id":"https://openalex.org/F4320316892","funder_display_name":"UT-Battelle"}],"funders":[{"id":"https://openalex.org/F4320306084","display_name":"U.S. Department of Energy","ror":"https://ror.org/01bj3aw27"},{"id":"https://openalex.org/F4320306250","display_name":"Battelle","ror":"https://ror.org/01h5tnr73"},{"id":"https://openalex.org/F4320316892","display_name":"UT-Battelle","ror":"https://ror.org/04nza6677"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3100469037.pdf","grobid_xml":"https://content.openalex.org/works/W3100469037.grobid-xml"},"referenced_works_count":30,"referenced_works":["https://openalex.org/W22359494","https://openalex.org/W87905120","https://openalex.org/W1582747324","https://openalex.org/W1831560769","https://openalex.org/W1941983649","https://openalex.org/W1966553486","https://openalex.org/W1978924650","https://openalex.org/W1986795233","https://openalex.org/W1997332627","https://openalex.org/W2002110561","https://openalex.org/W2088675571","https://openalex.org/W2097432384","https://openalex.org/W2099395665","https://openalex.org/W2099665113","https://openalex.org/W2115503987","https://openalex.org/W2132461362","https://openalex.org/W2132520482","https://openalex.org/W2149576945","https://openalex.org/W2153972927","https://openalex.org/W2159844592","https://openalex.org/W2230830246","https://openalex.org/W2247317079","https://openalex.org/W2566979091","https://openalex.org/W2788561287","https://openalex.org/W2798434712","https://openalex.org/W2892199102","https://openalex.org/W2950202855","https://openalex.org/W2999505802","https://openalex.org/W4253289225","https://openalex.org/W4291713239"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W4391913857","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4320802139"],"abstract_inverted_index":{"Real-time":[0],"data":[1],"analysis":[2,26],"and":[3,27,71,149,155,166,173,185],"management":[4,28],"are":[5],"increasingly":[6],"critical":[7],"for":[8,18,23,59,82,95,179],"today's":[9],"businesses.":[10],"SQL":[11,30,140,183],"is":[12,68,131],"the":[13,117,135,182],"de":[14],"facto":[15],"lingua":[16],"franca":[17],"these":[19,127,151],"endeavors,":[20],"yet":[21],"support":[22,58],"robust":[24,84,144],"streaming":[25,85,101],"with":[29,74,126,171],"remains":[31],"limited.":[32],"Many":[33],"approaches":[34],"restrict":[35],"semantics":[36,141,174],"to":[37,55,63,115,133,142],"a":[38,45,79,93,108,176],"reduced":[39],"subset":[40],"of":[41,47,52,111,119,138,175,181,189],"features":[42],"and/or":[43],"require":[44],"suite":[46,137],"non-standard":[48],"constructs.":[49],"Additionally,":[50],"use":[51],"event":[53,104],"timestamps":[54],"provide":[56],"native":[57],"analyzing":[60],"events":[61],"according":[62],"when":[64],"they":[65],"actually":[66],"occurred":[67],"not":[69],"pervasive,":[70],"often":[72],"comes":[73],"important":[75],"limitations.":[76],"We":[77,123,147,169],"present":[78],"three-part":[80],"proposal":[81,178],"integrating":[83],"into":[86],"SQL,":[87],"namely:":[88],"(1)":[89],"time-varying":[90,120],"relations":[91],"as":[92,98,100],"foundation":[94],"classical":[96],"tables":[97],"well":[99],"data,":[102],"(2)":[103],"time":[105],"semantics,":[106],"(3)":[107],"limited":[109],"set":[110],"optional":[112],"keyword":[113],"extensions":[114,180],"control":[116],"materialization":[118],"query":[121],"results.":[122],"show":[124],"how":[125],"minimal":[128],"additions":[129],"it":[130],"possible":[132],"utilize":[134],"complete":[136],"standard":[139,184],"perform":[143],"stream":[145],"processing.":[146],"motivate":[148],"illustrate":[150],"concepts":[152],"using":[153],"examples":[154],"describe":[156],"lessons":[157],"learned":[158],"from":[159],"implementations":[160],"in":[161],"Apache":[162,164,167],"Calcite,":[163],"Flink,":[165],"Beam.":[168],"conclude":[170],"syntax":[172],"concrete":[177],"note":[186],"further":[187],"areas":[188],"exploration.":[190]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":10},{"year":2022,"cited_by_count":6},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":7},{"year":2019,"cited_by_count":1}],"updated_date":"2026-04-15T08:11:43.952461","created_date":"2020-11-23T00:00:00"}