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
5832
Venue
SIGMOD
Year
2019
Pagerank
8.1465406e-05
Overall Rank
2,769 | 81.01%
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 23 of 23 citing papers.
Rank
Citing Paper
Year
Venue
Pagerank
4,128
The Relational Data Borg is Learning 2020
VLDB
6.8850804e-05
4,571
GeCo: Quality Counterfactual Explanations in Real Time 2021
VLDB
6.625099e-05
5,414
Optimizing Tensor Programs on Flexible Storage 2023
SIGMOD
6.2258658e-05
5,508
LMFAO: An Engine for Batches of Group-By Aggregates 2020
VLDB
6.1922654e-05
6,105
Optimizing In-memory Database Engine for AI-powered On-line Decision Augmentation Using Persistent Memory 2021
VLDB
5.9743349e-05
6,194
Incorporating Super-Operators in Big-Data Query Optimizers 2020
VLDB
5.9470844e-05
6,585
JoinBoost: Grow Trees Over Normalized Data Using Only SQL 2023
VLDB
5.8350362e-05
6,929
Mining Approximate Acyclic Schemes from Relations 2020
SIGMOD
5.7369354e-05
7,721
Identifying Insufficient Data Coverage in Databases with Multiple Relations 2020
VLDB
5.5587371e-05
7,787
A Practical Approach to Groupjoin and Nested Aggregates 2021
VLDB
5.5449593e-05
7,914
Saibot: A Differentially Private Data Search Platform 2023
VLDB
5.5181056e-05
8,638
Towards A Polyglot Framework for Factorized ML 2021
VLDB
5.395289e-05
8,794
AWARE: Workload-aware, Redundancy-exploiting Linear Algebra 2023
SIGMOD
5.370464e-05
8,960
An Intermediate Representation for Hybrid Database and Machine Learning Workloads 2021
VLDB
5.3444589e-05
9,700
Quantifying the Loss of Acyclic Join Dependencies 2023
PODS
5.2351259e-05
9,720
Avoiding Materialisation for Guarded Aggregate Queries 2025
VLDB
5.2319816e-05
9,993
In-Database Data Imputation 2024
SIGMOD
5.1815618e-05
10,292
SPALM: A Sparsity-Pattern-Adaptive Library for Matrices 2026
SIGMOD
5.093636e-05
10,466
InferF: Declarative Factorization of AI/ML Inferences over Joins 2026
SIGMOD
5.093636e-05
10,692
GES: High-Performance Graph Processing Engine and Service in Huawei 2025
SIGMOD
5.093636e-05
11,421
Lightweight Materialization for Fast Dashboards Over Joins 2023
SIGMOD
5.093636e-05
11,481
Demonstration of OpenDBML, a Framework for Democratizing In-Database Machine Learning 2023
VLDB
5.093636e-05
11,561
Givens QR Decomposition over Relational Databases 2022
SIGMOD
5.093636e-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.00071822821
23
Efficiently Compiling Efficient Query Plans for Modern Hardware 2011
VLDB
0.00054886415
106
The MADlib Analytics Library or MAD Skills, the SQL 2012
VLDB
0.00033539462
206
Eager Aggregation and Lazy Aggregation 1995
VLDB
0.00025092273
211
EmptyHeaded: A Relational Engine for Graph Processing 2016
SIGMOD
0.00024797217
358
FAQ: Questions Asked Frequently 2016
PODS
0.00020243592
415
SystemML: Declarative Machine Learning on Spark 2016
VLDB
0.0001888524
476
The Making of TPC-DS 2006
VLDB
0.00017860667
518
Towards a Unified Architecture for in-RDBMS Analytics 2012
SIGMOD
0.00017167492
536
Learning Linear Regression Models over Factorized Joins 2016
SIGMOD
0.0001693369
649
Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask 2018
VLDB
0.00015320656
715
Learning Generalized Linear Models Over Normalized Data 2015
SIGMOD
0.00014655327
764
To Join or Not to Join? Thinking Twice about Joins before Feature Selection 2016
SIGMOD
0.00014226652
860
Aggregation and Ordering in Factorised Databases 2013
VLDB
0.00013560445
905
Maintenance of Data Cubes and Summary Tables in a Warehouse 1997
SIGMOD
0.0001331508
1,235
Towards Linear Algebra over Normalized Data 2017
VLDB
0.00011548457
1,469
Voodoo - A Vector Algebra for Portable Database Performance on Modern Hardware 2016
VLDB
0.00010678751
1,797
How to Architect a Query Compiler 2016
SIGMOD
9.7368925e-05
2,276
Shared Workload Optimization 2014
VLDB
8.8196376e-05
2,392
FDB: A Query Engine for Factorised Relational Databases 2012
VLDB
8.6404947e-05
2,488
How to Architect a Query Compiler, Revisited 2018
SIGMOD
8.5091578e-05
2,927
In-Database Learning with Sparse Tensors 2018
PODS
7.9531195e-05
3,284
SPOOF: Sum-Product Optimization and Operator Fusion for Large-Scale Machine Learning 2017
CIDR
7.5663058e-05
3,930
Data Canopy: Accelerating Exploratory Statistical Analysis 2017
SIGMOD
7.0102082e-05
6,030
The BUDS Language for Distributed Bayesian Machine Learning 2017
SIGMOD
6.0009079e-05
Semantically Similar Papers