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.1542952e-05
Overall Rank
2,663 | 82.11%
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,161
The Relational Data Borg is Learning 2020
VLDB
6.7669004e-05
4,673
GeCo: Quality Counterfactual Explanations in Real Time 2021
VLDB
6.4733885e-05
5,444
Optimizing Tensor Programs on Flexible Storage 2023
SIGMOD
6.1250455e-05
5,636
LMFAO: An Engine for Batches of Group-By Aggregates 2020
VLDB
6.0549222e-05
6,239
Optimizing In-memory Database Engine for AI-powered On-line Decision Augmentation Using Persistent Memory 2021
VLDB
5.8381685e-05
6,293
Incorporating Super-Operators in Big-Data Query Optimizers 2020
VLDB
5.8195888e-05
6,552
JoinBoost: Grow Trees Over Normalized Data Using Only SQL 2023
VLDB
5.7475822e-05
6,591
Mining Approximate Acyclic Schemes from Relations 2020
SIGMOD
5.7400812e-05
7,885
Identifying Insufficient Data Coverage in Databases with Multiple Relations 2020
VLDB
5.4315576e-05
7,911
A Practical Approach to Groupjoin and Nested Aggregates 2021
VLDB
5.4261869e-05
7,922
Avoiding Materialisation for Guarded Aggregate Queries 2025
VLDB
5.4250308e-05
8,088
Saibot: A Differentially Private Data Search Platform 2023
VLDB
5.3917406e-05
8,389
AWARE: Workload-aware, Redundancy-exploiting Linear Algebra 2023
SIGMOD
5.3396465e-05
8,489
An Intermediate Representation for Hybrid Database and Machine Learning Workloads 2021
VLDB
5.3302659e-05
8,806
Towards A Polyglot Framework for Factorized ML 2021
VLDB
5.2721353e-05
9,560
GES: High-Performance Graph Processing Engine and Service in Huawei 2025
SIGMOD
5.1562866e-05
9,882
Quantifying the Loss of Acyclic Join Dependencies 2023
PODS
5.115241e-05
10,185
In-Database Data Imputation 2024
SIGMOD
5.0629036e-05
10,515
SPALM: A Sparsity-Pattern-Adaptive Library for Matrices 2026
SIGMOD
4.9769913e-05
10,664
InferF: Declarative Factorization of AI/ML Inferences over Joins 2026
SIGMOD
4.9769913e-05
10,812
BaCon: Efficient Batch Processing of Counting Queries 2026
VLDB
4.9769913e-05
10,852
The Data World Is Not Flat: Efficient Factorized Execution for Relational Systems 2026
VLDB
4.9769913e-05
11,741
Lightweight Materialization for Fast Dashboards Over Joins 2023
SIGMOD
4.9769913e-05
11,797
Demonstration of OpenDBML, a Framework for Democratizing In-Database Machine Learning 2023
VLDB
4.9769913e-05
11,876
Givens QR Decomposition over Relational Databases 2022
SIGMOD
4.9769913e-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.00071056708
21
Efficiently Compiling Efficient Query Plans for Modern Hardware 2011
VLDB
0.00056835296
105
The MADlib Analytics Library or MAD Skills, the SQL 2012
VLDB
0.00033633007
208
EmptyHeaded: A Relational Engine for Graph Processing 2016
SIGMOD
0.00024899872
213
Eager Aggregation and Lazy Aggregation 1995
VLDB
0.00024753576
357
FAQ: Questions Asked Frequently 2016
PODS
0.00020013731
416
SystemML: Declarative Machine Learning on Spark 2016
VLDB
0.00018650998
480
The Making of TPC-DS 2006
VLDB
0.00017615432
503
Towards a Unified Architecture for in-RDBMS Analytics 2012
SIGMOD
0.00017195428
521
Learning Linear Regression Models over Factorized Joins 2016
SIGMOD
0.00016923519
605
Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask 2018
VLDB
0.00015640305
731
Learning Generalized Linear Models Over Normalized Data 2015
SIGMOD
0.00014400356
779
To Join or Not to Join? Thinking Twice about Joins before Feature Selection 2016
SIGMOD
0.00014048128
849
Aggregation and Ordering in Factorised Databases 2013
VLDB
0.00013498306
901
Maintenance of Data Cubes and Summary Tables in a Warehouse 1997
SIGMOD
0.00013179526
1,257
Towards Linear Algebra over Normalized Data 2017
VLDB
0.0001130959
1,473
Voodoo - A Vector Algebra for Portable Database Performance on Modern Hardware 2016
VLDB
0.00010552993
1,744
How to Architect a Query Compiler 2016
SIGMOD
9.7332903e-05
2,225
Shared Workload Optimization 2014
VLDB
8.8062552e-05
2,293
FDB: A Query Engine for Factorised Relational Databases 2012
VLDB
8.685044e-05
2,420
How to Architect a Query Compiler, Revisited 2018
SIGMOD
8.4883426e-05
2,978
In-Database Learning with Sparse Tensors 2018
PODS
7.7872011e-05
3,331
SPOOF: Sum-Product Optimization and Operator Fusion for Large-Scale Machine Learning 2017
CIDR
7.4138851e-05
3,985
Data Canopy: Accelerating Exploratory Statistical Analysis 2017
SIGMOD
6.8708857e-05
6,144
The BUDS Language for Distributed Bayesian Machine Learning 2017
SIGMOD
5.8705515e-05
Semantically Similar Papers