Data-Semantics-Aware Recommendation of Diverse Pivot Tables
Proceedings of the ACM on Management of Data · 02.04.2026 · 4 (1) · 1-28
DOI: 10.1145/3786637 ↗Kurz gefasst
Fachartikel in der Zeitschrift Proceedings of the ACM on Management of Data, online erschienen am 07.04.2026. Verfasst von Whanhee Cho und 1 weiteren Autor:innen. Die Arbeit wurde bisher 1-mal zitiert (Crossref) und nennt 84 Literaturangaben. Gefördert von: NSF (National Science Foundation), Stena Center for Financial Technology, One Utah Data Science Hub.
Abstract (Originalsprache)
Data summarization is essential to discover insights from large datasets. In spreadsheets, pivot tables offer a convenient way to summarize tabular data by computing aggregates over some attributes, grouped by others. However, identifying attribute combinations that will result in useful pivot tables remains a challenge, especially for high-dimensional datasets. We formalize the problem of automatically recommending insightful and interpretable pivot tables, eliminating the tedious manual process. A crucial aspect of recommending a set of pivot tables is to diversify them. Traditional work inadequately address the table-diversification problem, which leads us to the problem of pivot table diversification . We present SAGE, a data- s emantics- a ware system for recommendin g k-budgeted diverse pivot tables, overcoming the shortcomings of prior work for top-k recommendations that cause redundancy. SAGE ensures that each pivot table is insightful , interpretable , and adaptive to the user's actions and preferences, while also guaranteeing that the set of pivot tables are different from each other, offering a diverse recommendation. We make two key technical contributions: (1) a data-semantics-aware model to measure the utility of a single pivot table and the diversity of a set of pivot tables, and (2) a scalable greedy algorithm that can efficiently select a set of diverse pivot tables of high utility, by leveraging data semantics to significantly reduce the combinatorial search space. Our extensive experiments on four real-world datasets show that SAGE outperforms alternative approaches, and efficiently scales to accommodate high-dimensional datasets. Additionally, through multiple case studies, we demonstrate SAGE's qualitative superiority over existing tools, and through a user study, we validate its practical usefulness and alignment with user preferences.
Förderung
- NSF (National Science Foundation)
- Stena Center for Financial Technology
- One Utah Data Science Hub
Zitieren
APA
Cho, W., & Fariha, A. (2026). Data-Semantics-Aware Recommendation of Diverse Pivot Tables. Proceedings of the ACM on Management of Data, 4(1), 1-28. https://doi.org/10.1145/3786637
Vancouver
Cho W, Fariha A. Data-Semantics-Aware Recommendation of Diverse Pivot Tables. Proceedings of the ACM on Management of Data. 2026;4(1):1-28. doi:10.1145/3786637
BibTeX
@article{Cho2026,
author = {Cho, Whanhee and Fariha, Anna},
title = {Data-Semantics-Aware Recommendation of Diverse Pivot Tables},
journal = {Proceedings of the ACM on Management of Data},
year = {2026},
volume = {4},
number = {1},
pages = {1--28},
doi = {10.1145/3786637}
}
EUVIMED