Leveraging discarded samples for tighter estimation of multiple-set aggregates

Edith Cohen*, Haim Kaplan

*Corresponding author for this work

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

Abstract

Many datasets, including market basket data, text or hypertext documents, and events recorded in different locations or time periods, can be modeled as a collection of sets over a ground set of keys. Common queries over such data, including similarity or association rules are represented as the weight or selectivity of keys that satisfy some selection predicate defined over keys' attributes and memberships in particular sets. On massive data sets, exact computation of such aggregates can be inefficient or infeasible, and therefore, approximate queries are processed over sketches of the sets. Sketches based on coordinated random samples are scalable and flexible and well suited for many applications. Queries are resolved by producing a sketch of the union of the sets used in the predicate, from the sketches of these sets, and then applying an estimator to this union-sketch. We derive novel tighter (unbiased) estimators that leverage sampled keys that are present in the union of applicable sketches but excluded from the union sketch. We establish analytically that our estimators dominate estimators applied to the union-sketch for all queries and data sets. Empirical evaluation on synthetic and real data reveals that on typical applications we can expect a 25%-75% reduction in estimation error.

Original languageEnglish
Title of host publicationSIGMETRICS/Performance'09 - Proceedings of the 11th International Joint Conference on Measurement and Modeling of Computer Systems
Pages251-262
Number of pages12
Edition1
DOIs
StatePublished - 2009
Event11th International Joint Conference on Measurement and Modeling of Computer Systems, SIGMETRICS/Performance'09 - Seattle, WA, United States
Duration: 15 Jun 200919 Jun 2009

Publication series

NameSIGMETRICS/Performance'09 - Proceedings of the 11th International Joint Conference on Measurement and Modeling of Computer Systems
Number1
Volume37

Conference

Conference11th International Joint Conference on Measurement and Modeling of Computer Systems, SIGMETRICS/Performance'09
Country/TerritoryUnited States
CitySeattle, WA
Period15/06/0919/06/09

Keywords

  • Algorithms
  • G.3: probabilistic algorithms
  • H.2 database management
  • Measurement
  • Performance

Fingerprint

Dive into the research topics of 'Leveraging discarded samples for tighter estimation of multiple-set aggregates'. Together they form a unique fingerprint.

Cite this