TY - GEN
T1 - Leveraging discarded samples for tighter estimation of multiple-set aggregates
AU - Cohen, Edith
AU - Kaplan, Haim
PY - 2009
Y1 - 2009
N2 - 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.
AB - 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.
KW - Algorithms
KW - G.3: probabilistic algorithms
KW - H.2 database management
KW - Measurement
KW - Performance
UR - http://www.scopus.com/inward/record.url?scp=70449636034&partnerID=8YFLogxK
U2 - 10.1145/1555349.1555379
DO - 10.1145/1555349.1555379
M3 - ???researchoutput.researchoutputtypes.contributiontobookanthology.conference???
AN - SCOPUS:70449636034
SN - 9781605585116
T3 - SIGMETRICS/Performance'09 - Proceedings of the 11th International Joint Conference on Measurement and Modeling of Computer Systems
SP - 251
EP - 262
BT - SIGMETRICS/Performance'09 - Proceedings of the 11th International Joint Conference on Measurement and Modeling of Computer Systems
T2 - 11th International Joint Conference on Measurement and Modeling of Computer Systems, SIGMETRICS/Performance'09
Y2 - 15 June 2009 through 19 June 2009
ER -