Back to papers
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
- 6751
- Venue
- SIGMOD
- Year
- 2023
- Pagerank
- 4.1905499e-05
- Overall Rank
- 11,222 | 22.01%
- DOI
-
10.1145/3626735
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Incoming Citations (Sorted by Pagerank)
Showing 0 of 0 citing papers.
| Rank |
Citing Paper |
Year |
Venue |
Pagerank |
Outgoing Citations (Sorted by Pagerank)
Showing 23 of 23 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.0040465394 |
| 31 |
Provenance Semirings |
2007 |
PODS |
0.00078516827 |
| 179 |
Efficient and Extensible Algorithms for Multi Query Optimization |
2000 |
SIGMOD |
0.00037637319 |
| 185 |
DuckDB: an Embeddable Analytical Database |
2019 |
SIGMOD |
0.00036529607 |
| 218 |
Aggregate-Query Processing in Data Warehousing Environments |
1995 |
VLDB |
0.00033489004 |
| 341 |
EmptyHeaded: A Relational Engine for Graph Processing |
2016 |
SIGMOD |
0.00026850764 |
| 564 |
FAQ: Questions Asked Frequently |
2016 |
PODS |
0.00020002796 |
| 584 |
Massively Parallel Sort-Merge Joins in Main Memory Multi-Core Database Systems |
2012 |
VLDB |
0.00019700451 |
| 832 |
Learning Linear Regression Models over Factorized Joins |
2016 |
SIGMOD |
0.00016089705 |
| 1,054 |
The Dynamic Yannakakis Algorithm: Compact and Efficient Query Processing Under Updates |
2017 |
SIGMOD |
0.00014397587 |
| 1,462 |
ARDA: Automatic Relational Data Augmentation for Machine Learning |
2020 |
VLDB |
0.00011866333 |
| 1,620 |
Adapting Materialized Views after Redefinitions |
1995 |
SIGMOD |
0.00011112989 |
| 1,621 |
Adaptive Optimization of Very Large Join Queries |
2018 |
SIGMOD |
0.00011105663 |
| 2,126 |
IDEBench: A Benchmark for Interactive Data Exploration |
2020 |
SIGMOD |
9.4814404e-05 |
| 2,173 |
AJAR: Aggregations and Joins over Annotated Relations |
2016 |
PODS |
9.3767985e-05 |
| 2,366 |
Data Market Platforms: Trading Data Assets to Solve Data Problems |
2020 |
VLDB |
8.9521259e-05 |
| 2,552 |
Probabilistic Optimization of Top N Queries |
1999 |
VLDB |
8.5540341e-05 |
| 3,009 |
On Functional Aggregate Queries with Additive Inequalities |
2019 |
PODS |
7.7230513e-05 |
| 3,280 |
A Layered Aggregate Engine for Analytics Workloads |
2019 |
SIGMOD |
7.2813732e-05 |
| 3,903 |
Automated Verification of Query Equivalence Using Satisfiability Modulo Theories |
2019 |
VLDB |
6.6439695e-05 |
| 4,200 |
Incremental View Maintenance with Triple Lock Factorization Benefits |
2018 |
SIGMOD |
6.3618329e-05 |
| 6,822 |
Computing Join Queries with Functional Dependencies |
2016 |
PODS |
4.9101655e-05 |
| 9,775 |
Structure-Aware Machine Learning over Multi-Relational Databases |
2021 |
SIGMOD |
4.2815042e-05 |
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 4,466 |
Robust Join Processing with Diamond Hardened Joins |
2024 |
VLDB |
6.1545841e-05 |
| 8,961 |
T3: Accurate and Fast Performance Prediction for Relational Database Systems With Compiled Decision Trees |
2025 |
SIGMOD |
4.4171776e-05 |
| 9,705 |
Distributed Numerical and Machine Learning Computations via Two-Phase Execution of Aggregated Join Trees |
2021 |
VLDB |
4.2951758e-05 |
| 7,498 |
Monte Carlo Tree Search for Generating Interactive Data Analysis Interfaces |
2020 |
SIGMOD |
4.7135369e-05 |
| 5,251 |
Triton Join: Efficiently Scaling to a Large Join State on GPUs with Fast Interconnects |
2022 |
SIGMOD |
5.6003972e-05 |
| 8,777 |
Accelerate Distributed Joins with Predicate Transfer |
2025 |
SIGMOD |
4.4492064e-05 |
| 1,430 |
A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses |
2009 |
VLDB |
0.0001202506 |
| 7,247 |
A Scalable and Generic Approach to Range Joins |
2022 |
VLDB |
4.7846107e-05 |
| 4,717 |
Reducing Multidatabase Query Response Time By Tree Balancing |
1995 |
SIGMOD |
5.966866e-05 |
| 7,920 |
JoinBoost: Grow Trees Over Normalized Data Using Only SQL |
2023 |
VLDB |
4.6120304e-05 |