English

Hierarchical Summarization of Metric Changes

Databases 2017-03-24 v1

Abstract

We study changes in metrics that are defined on a cartesian product of trees. Such metrics occur naturally in many practical applications, where a global metric (such as revenue) can be broken down along several hierarchical dimensions (such as location, gender, etc). Given a change in such a metric, our goal is to identify a small set of non-overlapping data segments that account for the change. An organization interested in improving the metric can then focus their attention on these data segments. Our key contribution is an algorithm that mimics the operation of a hierarchical organization of analysts. The algorithm has been successfully applied, for example within Google Adwords to help advertisers triage the performance of their advertising campaigns. We show that the algorithm is optimal for two dimensions, and has an approximation ratio logd2(n+1)\log^{d-2}(n+1) for d3d \geq 3 dimensions, where nn is the number of input data segments. For the Adwords application, we can show that our algorithm is in fact a 22-approximation. Mathematically, we identify a certain data pattern called a \emph{conflict} that both guides the design of the algorithm, and plays a central role in the hardness results. We use these conflicts to both derive a lower bound of 1.144d21.144^{d-2} (again d3d\geq3) for our algorithm, and to show that the problem is NP-hard, justifying the focus on approximation.

Keywords

Cite

@article{arxiv.1703.07795,
  title  = {Hierarchical Summarization of Metric Changes},
  author = {Matthias Ruhl and Mukund Sundararajan and Qiqi Yan},
  journal= {arXiv preprint arXiv:1703.07795},
  year   = {2017}
}

Comments

Under submission

R2 v1 2026-06-22T18:54:06.645Z