Lightweight Materialization for Fast Dashboards Over Joins

Summary: Treant accelerates dashboards over large joins with factorized execution and lightweight materialization. CJT makes work scale with query delta, enabling offline materialization and portable SQL rewrite; 100x dashboard speedups and 10x ML gains vs SOTA. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h01ee153f0202cf23
Venue: SIGMOD
Year: 2023
Pagerank: 4.9769913e-05
Overall Rank: 11,741 | 21.09%
DOI: 10.1145/3626735

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

1. Zezhou Huang (Columbia University)
2. Eugene Wu (Columbia University)

BibTeX Citation

@inproceedings{huang_sigmod23,
        title = {{Lightweight Materialization for Fast Dashboards Over Joins}},
        author = {Huang, Zezhou and Wu, Eugene},
        series = {{SIGMOD} '23},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3626735},
        url = {https://dl.acm.org/doi/10.1145/3626735},
        year = {2023}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 25 of 25 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
1	Access Path Selection in a Relational Database Management System	1979	SIGMOD	0.0023943337
17	Provenance Semirings	2007	PODS	0.00059813669
71	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00037724477
129	Efficient and Extensible Algorithms for Multi Query Optimization	2000	SIGMOD	0.00030395767
202	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.0002523837
208	EmptyHeaded: A Relational Engine for Graph Processing	2016	SIGMOD	0.00024899872
315	Worst-Case Optimal Join Algorithms: Techniques, Results, and Open Problems	2018	PODS	0.00021236408
357	FAQ: Questions Asked Frequently	2016	PODS	0.00020013731
425	Massively Parallel Sort-Merge Joins in Main Memory Multi-Core Database Systems	2012	VLDB	0.00018485358
521	Learning Linear Regression Models over Factorized Joins	2016	SIGMOD	0.00016923519
813	The Dynamic Yannakakis Algorithm: Compact and Efficient Query Processing Under Updates	2017	SIGMOD	0.00013722638
1,038	ARDA: Automatic Relational Data Augmentation for Machine Learning	2020	VLDB	0.000123653
1,185	Adaptive Optimization of Very Large Join Queries	2018	SIGMOD	0.00011607329
1,570	AJAR: Aggregations and Joins over Annotated Relations	2016	PODS	0.0001020376
1,797	IDEBench: A Benchmark for Interactive Data Exploration	2020	SIGMOD	9.6143465e-05
1,822	Adapting Materialized Views after Redefinitions	1995	SIGMOD	9.5620235e-05
1,847	Data Market Platforms: Trading Data Assets to Solve Data Problems	2020	VLDB	9.5091361e-05
2,183	Probabilistic Optimization of Top N Queries	1999	VLDB	8.9044171e-05
2,302	On Functional Aggregate Queries with Additive Inequalities	2019	PODS	8.6687541e-05
2,663	A Layered Aggregate Engine for Analytics Workloads	2019	SIGMOD	8.1542952e-05
3,114	Incremental View Maintenance with Triple Lock Factorization Benefits	2018	SIGMOD	7.6321464e-05
3,297	Automated Verification of Query Equivalence Using Satisfiability Modulo Theories	2019	VLDB	7.4421962e-05
6,268	General and Fractional Hypertree Decompositions: Hard and Easy Cases	2018	PODS	5.8281193e-05
6,745	Computing Join Queries with Functional Dependencies	2016	PODS	5.6890943e-05
10,158	Structure-Aware Machine Learning over Multi-Relational Databases	2021	SIGMOD	5.0691578e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	7,464	T3: Accurate and Fast Performance Prediction for Relational Database Systems With Compiled Decision Trees	2025	SIGMOD
2	10,026	Distributed Numerical and Machine Learning Computations via Two-Phase Execution of Aggregated Join Trees	2021	VLDB
3	8,096	Monte Carlo Tree Search for Generating Interactive Data Analysis Interfaces	2020	SIGMOD
4	3,628	Triton Join: Efficiently Scaling to a Large Join State on GPUs with Fast Interconnects	2022	SIGMOD
5	10,852	The Data World Is Not Flat: Efficient Factorized Execution for Relational Systems	2026	VLDB
6	8,275	Accelerate Distributed Joins with Predicate Transfer	2025	SIGMOD
7	1,034	A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses	2009	VLDB
8	7,351	A Scalable and Generic Approach to Range Joins	2022	VLDB
9	5,010	Reducing Multidatabase Query Response Time By Tree Balancing	1995	SIGMOD
10	6,552	JoinBoost: Grow Trees Over Normalized Data Using Only SQL	2023	VLDB