Acknowledging the reality of streaming languages and platforms overlapping with SQL and database systems, in 2019 INCTIS Data Management established an Expert Group with the focused mission to initiate the process of standardizing streaming support in SQL. Over time, the roster included companies like Actian, Alibaba, Amazon Web Services, Confluent, dbt Labs, Google, Hazelcast, IBM, Materialize, Microsoft, Oracle, Snowflake, SQLstream and Timeplus. For the span of more than one year, representatives of each company have presented key features of their streaming product or, in some cases, multiple streaming products. These were live technical Q&A sessions accompanied by summary or position papers, which are unquestionably valuable. As expected, substantial time was spent in clarifying what common terms meant in each system and setting up a glossary. These sessions were followed by clarification notes and debates, and decisions that appeared mandatory to allow further progress. This first phase was followed by the next phase, which consisted of the group meetings, in which the expert group (EG) agreed on main exit criteria topics that a streaming solution in SQL must address, and position papers and follow-ups were written and discussed. This paper summarizes these group efforts, up to the summer of 2023.
翻译:鉴于流式语言和平台与SQL及数据库系统重叠的现状,INCTIS数据管理组织于2019年成立了专家组,其核心使命是启动SQL中流式支持的标准化进程。随着时间的推移,成员名单逐步纳入Actian、阿里巴巴、Amazon Web Services、Confluent、dbt Labs、谷歌、Hazelcast、IBM、Materialize、微软、Oracle、Snowflake、SQLstream和Timeplus等企业。在超过一年的时间里,各企业代表展示了其流式产品的核心特性,部分企业甚至展示了多个流式产品。这些会议采用实时技术问答形式,并辅以摘要或立场文件,其价值毋庸置疑。不出所料,大量时间被用于厘清每个系统中通用术语的涵义,并建立术语表。随后,这些会议引发了澄清性说明、辩论以及看似必须做出的决策,以推动后续进展。第一阶段结束后进入第二阶段,即专家组会议阶段。在此期间,专家组就流式SQL解决方案必须满足的主要退出标准议题达成共识,并撰写和讨论了相关立场文件及后续跟进工作。本文总结了截至2023年夏季这些集体工作的成果。