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: 6812
Venue: SIGMOD
Year: 2023
Pagerank: 5.093636e-05
Overall Rank: 11,421 | 21.65%
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.0024089429
17	Provenance Semirings	2007	PODS	0.00059843817
103	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00034161428
128	Efficient and Extensible Algorithms for Multi Query Optimization	2000	SIGMOD	0.0003072825
198	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.00025618616
211	EmptyHeaded: A Relational Engine for Graph Processing	2016	SIGMOD	0.00024797217
321	Worst-Case Optimal Join Algorithms: Techniques, Results, and Open Problems	2018	PODS	0.00021283186
358	FAQ: Questions Asked Frequently	2016	PODS	0.00020243592
423	Massively Parallel Sort-Merge Joins in Main Memory Multi-Core Database Systems	2012	VLDB	0.00018725853
536	Learning Linear Regression Models over Factorized Joins	2016	SIGMOD	0.0001693369
816	The Dynamic Yannakakis Algorithm: Compact and Efficient Query Processing Under Updates	2017	SIGMOD	0.00013827772
1,121	ARDA: Automatic Relational Data Augmentation for Machine Learning	2020	VLDB	0.00012093059
1,286	Adaptive Optimization of Very Large Join Queries	2018	SIGMOD	0.00011320736
1,549	AJAR: Aggregations and Joins over Annotated Relations	2016	PODS	0.00010390168
1,767	IDEBench: A Benchmark for Interactive Data Exploration	2020	SIGMOD	9.805856e-05
1,787	Adapting Materialized Views after Redefinitions	1995	SIGMOD	9.7681572e-05
2,025	Data Market Platforms: Trading Data Assets to Solve Data Problems	2020	VLDB	9.2903125e-05
2,149	Probabilistic Optimization of Top N Queries	1999	VLDB	9.0821709e-05
2,266	On Functional Aggregate Queries with Additive Inequalities	2019	PODS	8.8391372e-05
2,769	A Layered Aggregate Engine for Analytics Workloads	2019	SIGMOD	8.1465406e-05
3,206	Incremental View Maintenance with Triple Lock Factorization Benefits	2018	SIGMOD	7.6367549e-05
3,327	Automated Verification of Query Equivalence Using Satisfiability Modulo Theories	2019	VLDB	7.518491e-05
6,159	General and Fractional Hypertree Decompositions: Hard and Easy Cases	2018	PODS	5.9542729e-05
6,672	Computing Join Queries with Functional Dependencies	2016	PODS	5.8070233e-05
9,962	Structure-Aware Machine Learning over Multi-Relational Databases	2021	SIGMOD	5.1879626e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	3,622	Robust Join Processing with Diamond Hardened Joins	2024	VLDB
2	8,572	T3: Accurate and Fast Performance Prediction for Relational Database Systems With Compiled Decision Trees	2025	SIGMOD
3	9,840	Distributed Numerical and Machine Learning Computations via Two-Phase Execution of Aggregated Join Trees	2021	VLDB
4	7,921	Monte Carlo Tree Search for Generating Interactive Data Analysis Interfaces	2020	SIGMOD
5	4,535	Triton Join: Efficiently Scaling to a Large Join State on GPUs with Fast Interconnects	2022	SIGMOD
6	8,721	Accelerate Distributed Joins with Predicate Transfer	2025	SIGMOD
7	1,022	A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses	2009	VLDB
8	7,207	A Scalable and Generic Approach to Range Joins	2022	VLDB
9	4,902	Reducing Multidatabase Query Response Time By Tree Balancing	1995	SIGMOD
10	6,585	JoinBoost: Grow Trees Over Normalized Data Using Only SQL	2023	VLDB