# LMFAO: An Engine for Batches of Group-By Aggregates

arXiv: https://arxiv.org/abs/2008.08657 · HTML: https://mlsanity.com/paper/2008.08657/

## Key facts

- Cited by 2 papers in the map (data through 14 Oct 2026).
- First posted on arXiv 19 Aug 2020.

## Built on by (most cited first, 2 of 2)

- [In-Database Data Imputation](https://mlsanity.com/paper/2401.03359/) (2024)
- [Graphical Join: A New Physical Join Algorithm for RDBMSs](https://mlsanity.com/paper/2206.10435/) (2022)

## Abstract (arXiv)

LMFAO is an in-memory optimization and execution engine for large batches of group-by aggregates over joins. Such database workloads capture the data-intensive computation of a variety of data science applications. We demonstrate LMFAO for three popular models: ridge linear regression with batch gradient descent, decision trees with CART, and clustering with Rk-means.