Database Paper Browser

Back to papers

One SQL to Rule Them All – an Efficient and Syntactically Idiomatic Approach to Management of Streams and Tables

Summary: Three-part proposal: time-varying relations underpin tables and streams, event-time semantics, and compact SQL extensions to control materialization. Shows standard SQL suffices for robust streaming with these additions, illustrated in Calcite, Flink, and Beam. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
5652
Venue
SIGMOD
Year
2019
Pagerank
5.6755067e-05
Overall Rank
5,130 | 64.32%
DOI
10.1145/3299869.3314040

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 7 of 7 citing papers.

Rank Citing Paper Year Venue Pagerank
5,012 SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL 2024 VLDB 5.7599595e-05
6,721 Beyond Analytics: The Evolution of Stream Processing Systems 2020 SIGMOD 4.9492015e-05
6,988 CrocodileDB: Efficient Database Execution through Intelligent Deferment 2020 CIDR 4.8718019e-05
8,909 What's the Difference? Incremental Processing with Change Queries in Snowflake 2023 SIGMOD 4.427232e-05
9,073 CrocodileDB in Action: Resource-Efficient Query Execution by Exploiting Time Slackness 2020 VLDB 4.4023079e-05
10,616 Unraveling the Impact of Window Semantics: Optimizing Join Order for Efficient Stream Processing 2025 VLDB 4.1945683e-05
11,435 Synchronization Schemas 2021 PODS 4.1945683e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 10 of 10 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
41 NiagaraCQ: A Scalable Continuous Query System for Internet Databases 2000 SIGMOD 0.00073964959
98 XMark: A Benchmark for XML Data Management 2002 VLDB 0.00050023808
191 The Design of the Borealis Stream Processing Engine 2005 CIDR 0.00035738595
202 LINQ: Reconciling Objects, Relations and XML in the .NET Framework 2006 SIGMOD 0.00034920912
314 MillWheel: Fault-Tolerant Stream Processing at Internet Scale 2013 VLDB 0.00028084774
373 Continuous Queries over Append-Only Databases 1992 SIGMOD 0.00025341527
538 The Dataflow Model: A Practical Approach to Balancing Correctness, Latency, and Cost in Massive-Scale, Unbounded, Out-of-Order Data Processing 2015 VLDB 0.00020678804
544 Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources 2018 SIGMOD 0.00020521965
1,467 SPADE: The System S Declarative Stream Processing Engine 2008 SIGMOD 0.00011849864
1,548 Structured Streaming: A Declarative API for Real-Time Applications in Apache Spark 2018 SIGMOD 0.00011431383
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
7,938 Correctness in Stream Processing: Challenges and Opportunities 2022 CIDR 4.613363e-05
11,728 Challenges and Experiences in Building an Efficient Apache Beam Runner For IBM Streams 2018 VLDB 4.1945683e-05
4,920 Shared Arrangements: practical inter-query sharing for streaming dataflows 2020 VLDB 5.8241888e-05
194 Query Processing, Resource Management, and Approximation in a Data Stream Management System 2003 CIDR 0.00035426067
6,767 Watermarks in Stream Processing Systems: Semantics and Comparative Analysis of Apache Flink and Google Cloud Dataflow 2021 VLDB 4.9322174e-05
6,721 Beyond Analytics: The Evolution of Stream Processing Systems 2020 SIGMOD 4.9492015e-05
5,284 Query Languages and Data Models for Database Sequences and Data Streams 2004 VLDB 5.584855e-05
1,802 Towards a Streaming SQL Standard 2008 VLDB 0.00010509786
10,417 Streaming Democratized: Ease Across the Latency Spectrum with Delayed View Semantics and Snowflake Dynamic Tables 2025 SIGMOD 4.1945683e-05
1,548 Structured Streaming: A Declarative API for Real-Time Applications in Apache Spark 2018 SIGMOD 0.00011431383