TY - JOUR
T1 - Distributed top-k aggregation queries at large
AU - Neumann, Thomas
AU - Bender, Matthias
AU - Michel, Sebastian
AU - Schenkel, Ralf
AU - Triantafillou, Peter
AU - Weikum, Gerhard
PY - 2009/8
Y1 - 2009/8
N2 - Top-k query processing is a fundamental building block for efficient ranking in a large number of applications. Efficiency is a central issue, especially for distributed settings, when the data is spread across different nodes in a network. This paper introduces novel optimization methods for top-k aggregation queries in such distributed environments. The optimizations can be applied to all algorithms that fall into the frameworks of the prior TPUT and KLEE methods. The optimizations address three degrees of freedom: 1) hierarchically grouping input lists into top-k operator trees and optimizing the tree structure, 2) computing data-adaptive scan depths for different input sources, and 3) data-adaptive sampling of a small subset of input sources in scenarios with hundreds or thousands of query-relevant network nodes. All optimizations are based on a statistical cost model that utilizes local synopses, e.g., in the form of histograms, efficiently computed convolutions, and estimators based on order statistics. The paper presents comprehensive experiments, with three different real-life datasets and using the ns-2 network simulator for a packet-level simulation of a large Internet-style network.
AB - Top-k query processing is a fundamental building block for efficient ranking in a large number of applications. Efficiency is a central issue, especially for distributed settings, when the data is spread across different nodes in a network. This paper introduces novel optimization methods for top-k aggregation queries in such distributed environments. The optimizations can be applied to all algorithms that fall into the frameworks of the prior TPUT and KLEE methods. The optimizations address three degrees of freedom: 1) hierarchically grouping input lists into top-k operator trees and optimizing the tree structure, 2) computing data-adaptive scan depths for different input sources, and 3) data-adaptive sampling of a small subset of input sources in scenarios with hundreds or thousands of query-relevant network nodes. All optimizations are based on a statistical cost model that utilizes local synopses, e.g., in the form of histograms, efficiently computed convolutions, and estimators based on order statistics. The paper presents comprehensive experiments, with three different real-life datasets and using the ns-2 network simulator for a packet-level simulation of a large Internet-style network.
KW - Cost models
KW - Distributed queries
KW - Query optimization
KW - Top-k
UR - http://www.scopus.com/inward/record.url?scp=67651211686&partnerID=8YFLogxK
U2 - 10.1007/s10619-009-7041-z
DO - 10.1007/s10619-009-7041-z
M3 - Article
AN - SCOPUS:67651211686
SN - 0926-8782
VL - 26
SP - 3
EP - 27
JO - Distributed and Parallel Databases
JF - Distributed and Parallel Databases
IS - 1
ER -