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: 5653
Venue: SIGMOD
Year: 2019
Pagerank: 5.6704313e-05
Overall Rank: 5,131 | 64.35%
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,011	SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL	2024	VLDB	5.7544221e-05
6,726	Beyond Analytics: The Evolution of Stream Processing Systems	2020	SIGMOD	4.9444528e-05
6,986	CrocodileDB: Efficient Database Execution through Intelligent Deferment	2020	CIDR	4.8672517e-05
8,911	What's the Difference? Incremental Processing with Change Queries in Snowflake	2023	SIGMOD	4.4229886e-05
9,027	CrocodileDB in Action: Resource-Efficient Query Execution by Exploiting Time Slackness	2020	VLDB	4.4011428e-05
10,624	Unraveling the Impact of Window Semantics: Optimizing Join Order for Efficient Stream Processing	2025	VLDB	4.1905499e-05
11,438	Synchronization Schemas	2021	PODS	4.1905499e-05

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.00073944756
99	XMark: A Benchmark for XML Data Management	2002	VLDB	0.00050043993
191	The Design of the Borealis Stream Processing Engine	2005	CIDR	0.00035714897
201	LINQ: Reconciling Objects, Relations and XML in the .NET Framework	2006	SIGMOD	0.00034903121
314	MillWheel: Fault-Tolerant Stream Processing at Internet Scale	2013	VLDB	0.00028059664
374	Continuous Queries over Append-Only Databases	1992	SIGMOD	0.00025325855
536	The Dataflow Model: A Practical Approach to Balancing Correctness, Latency, and Cost in Massive-Scale, Unbounded, Out-of-Order Data Processing	2015	VLDB	0.00020651621
542	Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources	2018	SIGMOD	0.00020522627
1,467	SPADE: The System S Declarative Stream Processing Engine	2008	SIGMOD	0.00011838188
1,546	Structured Streaming: A Declarative API for Real-Time Applications in Apache Spark	2018	SIGMOD	0.00011418993

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
7,941	Correctness in Stream Processing: Challenges and Opportunities	2022	CIDR	4.6089395e-05
4,925	Shared Arrangements: practical inter-query sharing for streaming dataflows	2020	VLDB	5.818597e-05
11,734	Challenges and Experiences in Building an Efficient Apache Beam Runner For IBM Streams	2018	VLDB	4.1905499e-05
194	Query Processing, Resource Management, and Approximation in a Data Stream Management System	2003	CIDR	0.00035402379
6,769	Watermarks in Stream Processing Systems: Semantics and Comparative Analysis of Apache Flink and Google Cloud Dataflow	2021	VLDB	4.9274854e-05
6,726	Beyond Analytics: The Evolution of Stream Processing Systems	2020	SIGMOD	4.9444528e-05
5,284	Query Languages and Data Models for Database Sequences and Data Streams	2004	VLDB	5.5834113e-05
1,799	Towards a Streaming SQL Standard	2008	VLDB	0.0001049736
10,427	Streaming Democratized: Ease Across the Latency Spectrum with Delayed View Semantics and Snowflake Dynamic Tables	2025	SIGMOD	4.1905499e-05
1,546	Structured Streaming: A Declarative API for Real-Time Applications in Apache Spark	2018	SIGMOD	0.00011418993