## IIT Database Group

### Abstract

Provenance and intervention-based techniques have been used to explain surprisingly high or low outcomes of aggregation queries. However, such techniques may miss interesting explanations emerging from data that is not in the provenance. For instance, an unusually low number of publications of a prolific researcher in a certain venue and year can be explained by an increased number of publications in another venue in the same year. We present a novel approach for explaining outliers in aggregation queries through counterbalancing. That is, explanations are outliers in the opposite direction of the outlier of interest. Outliers are defined w.r.t. patterns that hold over the data in aggregate. We present efficient methods for mining such aggregate regression patterns (ARPs), discuss how to use ARPs to generate and rank explanations, and experimentally demonstrate the efficiency and effectiveness of our approach.

### bibtex

@inproceedings{MZ19,
author = {Miao, Zhengjie and Zeng, Qitian and Glavic, Boris and Roy, Sudeepa},
booktitle = {Proceedings of the 44th International Conference on Management of Data},
keywords = {Provenance; Explanations; Cape},
pages = {485--502},
pdfurl = {http://cs.iit.edu/%7edbgroup/assets/pdfpubls/MZ19.pdf},
reproducibility = {https://hub.docker.com/repository/docker/iitdbgroup/2019-sigmod-reproducibility-cape},
doi = {10.1145/3299869.3300066},
video = {https://av.tib.eu/media/42903},
projects = {Explanations beyond Provenance},
title = {Going Beyond Provenance: Explaining Query Answers with Pattern-based Counterbalances},
venueshort = {SIGMOD},
year = {2019}
}


### Reference

Going Beyond Provenance: Explaining Query Answers with Pattern-based Counterbalances Zhengjie Miao, Qitian Zeng, Boris Glavic and Sudeepa Roy Proceedings of the 44th International Conference on Management of Data (2019), pp. 485–502.