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
h46cbbd2219cd8458
Venue
SIGMOD
Year
2019
Pagerank
8.1276375e-05
Overall Rank
2,673 | 82.09%
DOI
10.1145/3299869.3324961
Incoming Non-self Citations Over Time
BibTeX Citation
@inproceedings{schleich_sigmod19,
title = {{A Layered Aggregate Engine for Analytics Workloads}},
author = {Schleich, Maximilian and Olteanu, Dan and Khamis, Mahmoud Abo and Ngo, Hung Q. and Nguyen, XuanLong},
series = {{SIGMOD} '19},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3299869.3324961},
url = {https://dl.acm.org/doi/10.1145/3299869.3324961},
year = {2019}
}
Incoming Citations (Sorted by Pagerank)
Showing 25 of 25 citing papers.
Rank
Citing Paper
Year
Venue
Pagerank
4,174
The Relational Data Borg is Learning 2020
VLDB
6.750725e-05
4,686
GeCo: Quality Counterfactual Explanations in Real Time 2021
VLDB
6.4519834e-05
5,459
Optimizing Tensor Programs on Flexible Storage 2023
SIGMOD
6.1054526e-05
5,649
LMFAO: An Engine for Batches of Group-By Aggregates 2020
VLDB
6.0349644e-05
6,249
Optimizing In-memory Database Engine for AI-powered On-line Decision Augmentation Using Persistent Memory 2021
VLDB
5.8190376e-05
6,294
Incorporating Super-Operators in Big-Data Query Optimizers 2020
VLDB
5.8043081e-05
6,562
JoinBoost: Grow Trees Over Normalized Data Using Only SQL 2023
VLDB
5.7287508e-05
6,600
Mining Approximate Acyclic Schemes from Relations 2020
SIGMOD
5.721104e-05
7,902
Identifying Insufficient Data Coverage in Databases with Multiple Relations 2020
VLDB
5.4135994e-05
7,927
A Practical Approach to Groupjoin and Nested Aggregates 2021
VLDB
5.4082473e-05
7,936
Avoiding Materialisation for Guarded Aggregate Queries 2025
VLDB
5.4070923e-05
8,106
Saibot: A Differentially Private Data Search Platform 2023
VLDB
5.3739121e-05
8,407
AWARE: Workload-aware, Redundancy-exploiting Linear Algebra 2023
SIGMOD
5.3219903e-05
8,504
An Intermediate Representation for Hybrid Database and Machine Learning Workloads 2021
VLDB
5.3126407e-05
8,805
Towards A Polyglot Framework for Factorized ML 2021
VLDB
5.2581471e-05
9,586
GES: High-Performance Graph Processing Engine and Service in Huawei 2025
SIGMOD
5.1392367e-05
9,915
Quantifying the Loss of Acyclic Join Dependencies 2023
PODS
5.0983269e-05
10,218
In-Database Data Imputation 2024
SIGMOD
5.0461625e-05
10,581
SPALM: A Sparsity-Pattern-Adaptive Library for Matrices 2026
SIGMOD
4.9605343e-05
10,725
InferF: Declarative Factorization of AI/ML Inferences over Joins 2026
SIGMOD
4.9605343e-05
10,873
BaCon: Efficient Batch Processing of Counting Queries 2026
VLDB
4.9605343e-05
10,913
The Data World Is Not Flat: Efficient Factorized Execution for Relational Systems 2026
VLDB
4.9605343e-05
11,785
Lightweight Materialization for Fast Dashboards Over Joins 2023
SIGMOD
4.9605343e-05
11,841
Demonstration of OpenDBML, a Framework for Democratizing In-Database Machine Learning 2023
VLDB
4.9605343e-05
11,920
Givens QR Decomposition over Relational Databases 2022
SIGMOD
4.9605343e-05
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
11
Implementing Data Cubes Efficiently 1996
SIGMOD
0.00070860346
21
Efficiently Compiling Efficient Query Plans for Modern Hardware 2011
VLDB
0.00056737487
105
The MADlib Analytics Library or MAD Skills, the SQL 2012
VLDB
0.00033605348
208
EmptyHeaded: A Relational Engine for Graph Processing 2016
SIGMOD
0.00024929198
213
Eager Aggregation and Lazy Aggregation 1995
VLDB
0.00024695393
357
FAQ: Questions Asked Frequently 2016
PODS
0.00020048899
415
SystemML: Declarative Machine Learning on Spark 2016
VLDB
0.00018619173
473
The Making of TPC-DS 2006
VLDB
0.00017656775
506
Towards a Unified Architecture for in-RDBMS Analytics 2012
SIGMOD
0.00017158546
522
Learning Linear Regression Models over Factorized Joins 2016
SIGMOD
0.00016893112
606
Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask 2018
VLDB
0.00015609823
731
Learning Generalized Linear Models Over Normalized Data 2015
SIGMOD
0.00014363943
783
To Join or Not to Join? Thinking Twice about Joins before Feature Selection 2016
SIGMOD
0.00014015599
848
Aggregation and Ordering in Factorised Databases 2013
VLDB
0.00013463236
904
Maintenance of Data Cubes and Summary Tables in a Warehouse 1997
SIGMOD
0.00013138723
1,200
Towards Linear Algebra over Normalized Data 2017
VLDB
0.00011524945
1,475
Voodoo - A Vector Algebra for Portable Database Performance on Modern Hardware 2016
VLDB
0.00010525713
1,756
How to Architect a Query Compiler 2016
SIGMOD
9.7053947e-05
2,237
Shared Workload Optimization 2014
VLDB
8.7777395e-05
2,298
FDB: A Query Engine for Factorised Relational Databases 2012
VLDB
8.6645337e-05
2,433
How to Architect a Query Compiler, Revisited 2018
SIGMOD
8.4614165e-05
2,974
In-Database Learning with Sparse Tensors 2018
PODS
7.7812156e-05
3,331
SPOOF: Sum-Product Optimization and Operator Fusion for Large-Scale Machine Learning 2017
CIDR
7.4065701e-05
3,993
Data Canopy: Accelerating Exploratory Statistical Analysis 2017
SIGMOD
6.8565106e-05
6,159
The BUDS Language for Distributed Bayesian Machine Learning 2017
SIGMOD
5.851731e-05
Semantically Similar Papers