TY - GEN
T1 - Flow algorithms for two pipelined filter ordering problems
AU - Condon, Anne
AU - Deshpande, Amol
AU - Hellerstein, Lisa
AU - Wu, Ning
PY - 2006
Y1 - 2006
N2 - Pipelined filter ordering is a central problem in database query optimization, and has received renewed attention recently in the context of environments such as the web, continuous high-speed data streams and sensor networks. We present algorithms for two natural extensions of the classical pipelined filter ordering problem: (1) a distributional type problem where the filters run in parallel and the goal is to maximize throughput, and (2) an adversarial type problem where the goal is to minimize the expected value of multiplicative regret. We show that both problems can be solved using similar flow algorithms, which find an optimal ordering scheme in time O(n2), where n is the number of filters. Our algorithm for (1) improves on an earlier O(n3 log n) algorithm of Kodialam.
AB - Pipelined filter ordering is a central problem in database query optimization, and has received renewed attention recently in the context of environments such as the web, continuous high-speed data streams and sensor networks. We present algorithms for two natural extensions of the classical pipelined filter ordering problem: (1) a distributional type problem where the filters run in parallel and the goal is to maximize throughput, and (2) an adversarial type problem where the goal is to minimize the expected value of multiplicative regret. We show that both problems can be solved using similar flow algorithms, which find an optimal ordering scheme in time O(n2), where n is the number of filters. Our algorithm for (1) improves on an earlier O(n3 log n) algorithm of Kodialam.
KW - Flow algorithms
KW - Pipelined filter ordering
KW - Query optimization
KW - Selection ordering
UR - http://www.scopus.com/inward/record.url?scp=34250677320&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=34250677320&partnerID=8YFLogxK
U2 - 10.1145/1142351.1142379
DO - 10.1145/1142351.1142379
M3 - Conference contribution
AN - SCOPUS:34250677320
SN - 1595933182
SN - 9781595933188
T3 - Proceedings of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems
SP - 193
EP - 202
BT - Proceedings of the Twenty-Fifth ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, PODS 2006
T2 - 25th ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, PODS 2006
Y2 - 26 June 2006 through 28 June 2006
ER -