DBToaster: A SQL Compiler for High-Performance Delta Processing in Main-Memory Databases

Summary: DBToaster: a SQL compiler that emits high-performance compiled delta processors for in-memory, standing aggregates over streams. It recursively compiles deltas of maintenance queries into C++ code, removing scans/joins and VM overhead to deliver 1–3 order-of-magnitude speedups across DBMS. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 9832
Venue: VLDB
Year: 2009
Pagerank: 6.2033567e-05
Overall Rank: 4,407 | 69.38%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Yanif Ahmad
2. Christoph Koch

Incoming Citations (Sorted by Pagerank)

Showing 15 of 15 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
585	DBToaster: Higher-order Delta Processing for Dynamic, Frequently Fresh Views	2012	VLDB	0.00019682634
1,231	Incremental Query Evaluation in a Ring of Databases	2010	PODS	0.00013141213
1,865	Relaxed Operator Fusion for In-Memory Databases: Making Compilation, Vectorization, and Prefetching Work Together At Last	2018	VLDB	0.00010271333
1,884	Tuplex: Data Science in Python at Native Code Speed	2021	SIGMOD	0.00010206514
2,383	How to Architect a Query Compiler	2016	SIGMOD	8.9198524e-05
2,843	How to Architect a Query Compiler, Revisited	2018	SIGMOD	8.0334687e-05
4,930	User-Defined Operators: Efficiently Integrating Custom Algorithms into Modern Databases	2022	VLDB	5.8171482e-05
5,334	Fast In-Memory SQL Analytics on Typed Graphs	2017	VLDB	5.5625443e-05
5,947	DBSP: Automatic Incremental View Maintenance for Rich Query Languages	2023	VLDB	5.2577662e-05
6,649	Grizzly: Efficient Stream Processing Through Adaptive Query Compilation	2020	SIGMOD	4.9724735e-05
7,880	DBToaster: Agile Views in a Dynamic Data Management System	2011	CIDR	4.6250755e-05
9,337	PlinyCompute: A Platform for High-Performance, Distributed, Data-Intensive Tool Development	2018	SIGMOD	4.351469e-05
10,794	Streaming View: An Efficient Data Processing Engine for Modern Real-time Data Warehouse of Alibaba Cloud	2025	VLDB	4.1905499e-05
10,972	Query Compilation Without Regrets	2024	SIGMOD	4.1905499e-05
11,196	A Step Toward Deep Online Aggregation	2023	SIGMOD	4.1905499e-05

Outgoing Citations (Sorted by Pagerank)

Showing 2 of 2 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
194	Query Processing, Resource Management, and Approximation in a Data Stream Management System	2003	CIDR	0.00035402379
1,467	SPADE: The System S Declarative Stream Processing Engine	2008	SIGMOD	0.00011838188

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
59	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.0006445664
9,856	Towards Unifying Query Interpretation and Compilation	2023	CIDR	4.2652623e-05
4,373	Just-in-time compilation for SQL query processing	2013	VLDB	6.2365066e-05
8,623	Adaptive Code Generation for Data-Intensive Analytics	2021	VLDB	4.4786182e-05
2,843	How to Architect a Query Compiler, Revisited	2018	SIGMOD	8.0334687e-05
2,383	How to Architect a Query Compiler	2016	SIGMOD	8.9198524e-05
7,880	DBToaster: Agile Views in a Dynamic Data Management System	2011	CIDR	4.6250755e-05
9,420	TreeToaster: Towards an IVM-Optimized Compiler	2021	SIGMOD	4.3399748e-05
8,610	Efficient Incrementialization of Correlated Nested Aggregate Queries using Relative Partial Aggregate Indexes (RPAI)	2022	SIGMOD	4.480988e-05
585	DBToaster: Higher-order Delta Processing for Dynamic, Frequently Fresh Views	2012	VLDB	0.00019682634