Back to papers
A Layered Aggregate Engine for Analytics Workloads
Summary: LMFAO is an in-memory, layered engine for batches of group-by aggregates over joins in analytics. It uses layered optimizations, sharing, and code specialization to accelerate ridge regression, trees, Chow-Liu networks, and data cubes, outperforming DBMSs and ML frameworks on these tasks.
(summarized by gpt-5-nano on Feb 09 2026)
- Paper ID
- 5771
- Venue
- SIGMOD
- Year
- 2019
- Pagerank
- 7.2813732e-05
- Overall Rank
- 3,280 | 77.21%
- DOI
-
10.1145/3299869.3324961
Incoming Non-self Citations Over Time
Incoming Citations (Sorted by Pagerank)
Showing 22 of 22 citing papers.
| Rank |
Citing Paper |
Year |
Venue |
Pagerank |
| 4,724 |
GeCo: Quality Counterfactual Explanations in Real Time |
2021 |
VLDB |
5.9640238e-05 |
| 4,787 |
The Relational Data Borg is Learning |
2020 |
VLDB |
5.9168117e-05 |
| 5,957 |
LMFAO: An Engine for Batches of Group-By Aggregates |
2020 |
VLDB |
5.2523266e-05 |
| 6,157 |
Optimizing Tensor Programs on Flexible Storage |
2023 |
SIGMOD |
5.1755682e-05 |
| 6,242 |
Optimizing In-memory Database Engine for AI-powered On-line Decision Augmentation Using Persistent Memory |
2021 |
VLDB |
5.1351431e-05 |
| 6,671 |
Incorporating Super-Operators in Big-Data Query Optimizers |
2020 |
VLDB |
4.9625353e-05 |
| 7,073 |
Mining Approximate Acyclic Schemes from Relations |
2020 |
SIGMOD |
4.8378353e-05 |
| 7,490 |
Saibot: A Differentially Private Data Search Platform |
2023 |
VLDB |
4.7135369e-05 |
| 7,571 |
Identifying Insufficient Data Coverage in Databases with Multiple Relations |
2020 |
VLDB |
4.7037322e-05 |
| 7,920 |
JoinBoost: Grow Trees Over Normalized Data Using Only SQL |
2023 |
VLDB |
4.6120304e-05 |
| 8,593 |
Towards A Polyglot Framework for Factorized ML |
2021 |
VLDB |
4.4846362e-05 |
| 8,676 |
A Practical Approach to Groupjoin and Nested Aggregates |
2021 |
VLDB |
4.4652082e-05 |
| 8,753 |
An Intermediate Representation for Hybrid Database and Machine Learning Workloads |
2021 |
VLDB |
4.4520434e-05 |
| 8,782 |
AWARE: Workload-aware, Redundancy-exploiting Linear Algebra |
2023 |
SIGMOD |
4.4478585e-05 |
| 9,488 |
Quantifying the Loss of Acyclic Join Dependencies |
2023 |
PODS |
4.3300131e-05 |
| 9,855 |
In-Database Data Imputation |
2024 |
SIGMOD |
4.2652623e-05 |
| 10,177 |
InferF: Declarative Factorization of AI/ML Inferences over Joins |
2026 |
SIGMOD |
4.1905499e-05 |
| 10,417 |
GES: High-Performance Graph Processing Engine and Service in Huawei |
2025 |
SIGMOD |
4.1905499e-05 |
| 10,560 |
Avoiding Materialisation for Guarded Aggregate Queries |
2025 |
VLDB |
4.1905499e-05 |
| 11,222 |
Lightweight Materialization for Fast Dashboards Over Joins |
2023 |
SIGMOD |
4.1905499e-05 |
| 11,284 |
Demonstration of OpenDBML, a Framework for Democratizing In-Database Machine Learning |
2023 |
VLDB |
4.1905499e-05 |
| 11,365 |
Givens QR Decomposition over Relational Databases |
2022 |
SIGMOD |
4.1905499e-05 |
Outgoing Citations (Sorted by Pagerank)
Showing 24 of 24 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank |
Cited Paper |
Year |
Venue |
Pagerank |
| 11 |
Implementing Data Cubes Efficiently |
1996 |
SIGMOD |
0.0011695087 |
| 59 |
Efficiently Compiling Efficient Query Plans for Modern Hardware |
2011 |
VLDB |
0.0006445664 |
| 139 |
The MADlib Analytics Library or MAD Skills, the SQL |
2012 |
VLDB |
0.00042320525 |
| 249 |
Eager Aggregation and Lazy Aggregation |
1995 |
VLDB |
0.00030773137 |
| 341 |
EmptyHeaded: A Relational Engine for Graph Processing |
2016 |
SIGMOD |
0.00026850764 |
| 557 |
SystemML: Declarative Machine Learning on Spark |
2016 |
VLDB |
0.00020186115 |
| 564 |
FAQ: Questions Asked Frequently |
2016 |
PODS |
0.00020002796 |
| 638 |
Towards a Unified Architecture for in-RDBMS Analytics |
2012 |
SIGMOD |
0.00018810785 |
| 659 |
The Making of TPC-DS |
2006 |
VLDB |
0.00018514913 |
| 832 |
Learning Linear Regression Models over Factorized Joins |
2016 |
SIGMOD |
0.00016089705 |
| 848 |
Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask |
2018 |
VLDB |
0.00015933538 |
| 901 |
To Join or Not to Join? Thinking Twice about Joins before Feature Selection |
2016 |
SIGMOD |
0.00015462938 |
| 963 |
Maintenance of Data Cubes and Summary Tables in a Warehouse |
1997 |
SIGMOD |
0.00014975448 |
| 1,172 |
Learning Generalized Linear Models Over Normalized Data |
2015 |
SIGMOD |
0.00013504249 |
| 1,255 |
Aggregation and Ordering in Factorised Databases |
2013 |
VLDB |
0.00013011216 |
| 1,283 |
Towards Linear Algebra over Normalized Data |
2017 |
VLDB |
0.00012826013 |
| 2,019 |
Voodoo - A Vector Algebra for Portable Database Performance on Modern Hardware |
2016 |
VLDB |
9.7814175e-05 |
| 2,383 |
How to Architect a Query Compiler |
2016 |
SIGMOD |
8.9198524e-05 |
| 2,843 |
How to Architect a Query Compiler, Revisited |
2018 |
SIGMOD |
8.0334687e-05 |
| 2,928 |
Shared Workload Optimization |
2014 |
VLDB |
7.881485e-05 |
| 3,088 |
FDB: A Query Engine for Factorised Relational Databases |
2012 |
VLDB |
7.5940302e-05 |
| 3,878 |
Data Canopy: Accelerating Exploratory Statistical Analysis |
2017 |
SIGMOD |
6.6669911e-05 |
| 4,508 |
SPOOF: Sum-Product Optimization and Operator Fusion for Large-Scale Machine Learning |
2017 |
CIDR |
6.1261819e-05 |
| 6,321 |
The BUDS Language for Distributed Bayesian Machine Learning |
2017 |
SIGMOD |
5.1075833e-05 |
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 8,663 |
Advancing Fact Attribution for Query Answering: Aggregate Queries and Novel Algorithms |
2025 |
VLDB |
4.4676883e-05 |
| 9,705 |
Distributed Numerical and Machine Learning Computations via Two-Phase Execution of Aggregated Join Trees |
2021 |
VLDB |
4.2951758e-05 |
| 9,581 |
Low Rank Learning for Offline Query Optimization |
2025 |
SIGMOD |
4.3186744e-05 |
| 9,225 |
Towards an Optimized GROUP BY Abstraction for Large-Scale Machine Learning |
2021 |
VLDB |
4.3656789e-05 |
| 1,172 |
Learning Generalized Linear Models Over Normalized Data |
2015 |
SIGMOD |
0.00013504249 |
| 4,547 |
Database-Agnostic Workload Management |
2019 |
CIDR |
6.0904384e-05 |
| 6,329 |
Efficient Construction of Approximate Ad-Hoc ML models Through Materialization and Reuse |
2018 |
VLDB |
5.1030159e-05 |
| 9,350 |
LIMAO: A Framework for Lifelong Modular Learned Query Optimization |
2025 |
VLDB |
4.3494621e-05 |
| 9,775 |
Structure-Aware Machine Learning over Multi-Relational Databases |
2021 |
SIGMOD |
4.2815042e-05 |
| 5,957 |
LMFAO: An Engine for Batches of Group-By Aggregates |
2020 |
VLDB |
5.2523266e-05 |