### Abstract

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(n^{2}), where n is the number of filters. Our algorithm for (1) improves on an earlier O(n^{3} log n) algorithm of Kodialam.

Original language | English (US) |
---|---|

Title of host publication | Proceedings of the Twenty-Fifth ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, PODS 2006 |

Pages | 193-202 |

Number of pages | 10 |

DOIs | |

State | Published - 2006 |

Event | 25th ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, PODS 2006 - Chicago, IL, United States Duration: Jun 26 2006 → Jun 28 2006 |

### Publication series

Name | Proceedings of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems |
---|

### Other

Other | 25th ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, PODS 2006 |
---|---|

Country | United States |

City | Chicago, IL |

Period | 6/26/06 → 6/28/06 |

### Keywords

- Flow algorithms
- Pipelined filter ordering
- Query optimization
- Selection ordering

### ASJC Scopus subject areas

- Software
- Information Systems
- Hardware and Architecture

## Fingerprint Dive into the research topics of 'Flow algorithms for two pipelined filter ordering problems'. Together they form a unique fingerprint.

## Cite this

*Proceedings of the Twenty-Fifth ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, PODS 2006*(pp. 193-202). (Proceedings of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems). https://doi.org/10.1145/1142351.1142379