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.9793485e-05
Overall Rank: 11,735 | 21.11%
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.0023947656
17	Provenance Semirings	2007	PODS	0.00059752575
71	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00037720227
129	Efficient and Extensible Algorithms for Multi Query Optimization	2000	SIGMOD	0.0003040756
202	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.00025244649
208	EmptyHeaded: A Relational Engine for Graph Processing	2016	SIGMOD	0.00024884544
315	Worst-Case Optimal Join Algorithms: Techniques, Results, and Open Problems	2018	PODS	0.00021246
357	FAQ: Questions Asked Frequently	2016	PODS	0.00020020639
423	Massively Parallel Sort-Merge Joins in Main Memory Multi-Core Database Systems	2012	VLDB	0.00018491327
521	Learning Linear Regression Models over Factorized Joins	2016	SIGMOD	0.00016929744
812	The Dynamic Yannakakis Algorithm: Compact and Efficient Query Processing Under Updates	2017	SIGMOD	0.00013729015
1,038	ARDA: Automatic Relational Data Augmentation for Machine Learning	2020	VLDB	0.00012370691
1,186	Adaptive Optimization of Very Large Join Queries	2018	SIGMOD	0.0001160797
1,570	AJAR: Aggregations and Joins over Annotated Relations	2016	PODS	0.0001020855
1,797	IDEBench: A Benchmark for Interactive Data Exploration	2020	SIGMOD	9.6187325e-05
1,822	Adapting Materialized Views after Redefinitions	1995	SIGMOD	9.5664616e-05
1,845	Data Market Platforms: Trading Data Assets to Solve Data Problems	2020	VLDB	9.5136397e-05
2,181	Probabilistic Optimization of Top N Queries	1999	VLDB	8.9082736e-05
2,299	On Functional Aggregate Queries with Additive Inequalities	2019	PODS	8.6727773e-05
2,663	A Layered Aggregate Engine for Analytics Workloads	2019	SIGMOD	8.1581558e-05
3,112	Incremental View Maintenance with Triple Lock Factorization Benefits	2018	SIGMOD	7.6357579e-05
3,297	Automated Verification of Query Equivalence Using Satisfiability Modulo Theories	2019	VLDB	7.4452842e-05
6,264	General and Fractional Hypertree Decompositions: Hard and Easy Cases	2018	PODS	5.8308708e-05
6,739	Computing Join Queries with Functional Dependencies	2016	PODS	5.6917027e-05
10,154	Structure-Aware Machine Learning over Multi-Relational Databases	2021	SIGMOD	5.0715586e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	7,460	T3: Accurate and Fast Performance Prediction for Relational Database Systems With Compiled Decision Trees	2025	SIGMOD
2	10,021	Distributed Numerical and Machine Learning Computations via Two-Phase Execution of Aggregated Join Trees	2021	VLDB
3	8,089	Monte Carlo Tree Search for Generating Interactive Data Analysis Interfaces	2020	SIGMOD
4	3,626	Triton Join: Efficiently Scaling to a Large Join State on GPUs with Fast Interconnects	2022	SIGMOD
5	10,842	The Data World Is Not Flat: Efficient Factorized Execution for Relational Systems	2026	VLDB
6	8,269	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,348	A Scalable and Generic Approach to Range Joins	2022	VLDB
9	5,008	Reducing Multidatabase Query Response Time By Tree Balancing	1995	SIGMOD
10	6,550	JoinBoost: Grow Trees Over Normalized Data Using Only SQL	2023	VLDB