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
- 6750
- Venue
- SIGMOD
- Year
- 2023
- Pagerank
- 4.1945683e-05
- Overall Rank
- 11,220 | 21.95%
- 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.0040449103 |
| 31 |
Provenance Semirings |
2007 |
PODS |
0.0007857786 |
| 179 |
Efficient and Extensible Algorithms for Multi Query Optimization |
2000 |
SIGMOD |
0.00037672155 |
| 185 |
DuckDB: an Embeddable Analytical Database |
2019 |
SIGMOD |
0.00036538405 |
| 218 |
Aggregate-Query Processing in Data Warehousing Environments |
1995 |
VLDB |
0.00033503922 |
| 342 |
EmptyHeaded: A Relational Engine for Graph Processing |
2016 |
SIGMOD |
0.00026795977 |
| 583 |
FAQ: Questions Asked Frequently |
2016 |
PODS |
0.00019717214 |
| 585 |
Massively Parallel Sort-Merge Joins in Main Memory Multi-Core Database Systems |
2012 |
VLDB |
0.00019706145 |
| 834 |
Learning Linear Regression Models over Factorized Joins |
2016 |
SIGMOD |
0.00016135159 |
| 1,056 |
The Dynamic Yannakakis Algorithm: Compact and Efficient Query Processing Under Updates |
2017 |
SIGMOD |
0.0001441128 |
| 1,463 |
ARDA: Automatic Relational Data Augmentation for Machine Learning |
2020 |
VLDB |
0.00011869295 |
| 1,617 |
Adapting Materialized Views after Redefinitions |
1995 |
SIGMOD |
0.00011119837 |
| 1,619 |
Adaptive Optimization of Very Large Join Queries |
2018 |
SIGMOD |
0.00011111678 |
| 2,129 |
IDEBench: A Benchmark for Interactive Data Exploration |
2020 |
SIGMOD |
9.480002e-05 |
| 2,169 |
AJAR: Aggregations and Joins over Annotated Relations |
2016 |
PODS |
9.3845975e-05 |
| 2,359 |
Data Market Platforms: Trading Data Assets to Solve Data Problems |
2020 |
VLDB |
8.9607667e-05 |
| 2,556 |
Probabilistic Optimization of Top N Queries |
1999 |
VLDB |
8.5465733e-05 |
| 3,006 |
On Functional Aggregate Queries with Additive Inequalities |
2019 |
PODS |
7.7299363e-05 |
| 3,277 |
A Layered Aggregate Engine for Analytics Workloads |
2019 |
SIGMOD |
7.2871625e-05 |
| 3,901 |
Automated Verification of Query Equivalence Using Satisfiability Modulo Theories |
2019 |
VLDB |
6.6499845e-05 |
| 4,197 |
Incremental View Maintenance with Triple Lock Factorization Benefits |
2018 |
SIGMOD |
6.367895e-05 |
| 6,824 |
Computing Join Queries with Functional Dependencies |
2016 |
PODS |
4.9144789e-05 |
| 9,776 |
Structure-Aware Machine Learning over Multi-Relational Databases |
2021 |
SIGMOD |
4.2856106e-05 |
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 4,465 |
Robust Join Processing with Diamond Hardened Joins |
2024 |
VLDB |
6.1604282e-05 |
| 8,956 |
T3: Accurate and Fast Performance Prediction for Relational Database Systems With Compiled Decision Trees |
2025 |
SIGMOD |
4.4214154e-05 |
| 9,706 |
Distributed Numerical and Machine Learning Computations via Two-Phase Execution of Aggregated Join Trees |
2021 |
VLDB |
4.2992942e-05 |
| 7,499 |
Monte Carlo Tree Search for Generating Interactive Data Analysis Interfaces |
2020 |
SIGMOD |
4.7180617e-05 |
| 5,247 |
Triton Join: Efficiently Scaling to a Large Join State on GPUs with Fast Interconnects |
2022 |
SIGMOD |
5.6057839e-05 |
| 8,781 |
Accelerate Distributed Joins with Predicate Transfer |
2025 |
SIGMOD |
4.4534753e-05 |
| 1,429 |
A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses |
2009 |
VLDB |
0.00012033518 |
| 7,250 |
A Scalable and Generic Approach to Range Joins |
2022 |
VLDB |
4.78908e-05 |
| 4,722 |
Reducing Multidatabase Query Response Time By Tree Balancing |
1995 |
SIGMOD |
5.9717332e-05 |
| 7,920 |
JoinBoost: Grow Trees Over Normalized Data Using Only SQL |
2023 |
VLDB |
4.6163888e-05 |