Efficient Query Repair for Aggregate Constraints

vldb26-897 · Regular Research · Shatha Algarni, Boris Glavic, Seokki Lee, Adriane Chapman
Abstract

In many real-world scenarios, query results must satisfy domain-specific constraints, e.g., a minimum percentage of interview candidates selected based on their qualifications should be female. These requirements can be expressed as constraints over an arithmetic combination of aggregates evaluated on the result of the query. In this work, we study how to repair a query to fulfill such constraints by modifying its filter predicates. We introduce a novel query repair technique that leverages bounds on sets of candidate solutions and interval arithmetic to efficiently prune the search space. We demonstrate experimentally, that our technique significantly outperforms baselines that consider a single candidate at a time.

Assigned reviewers

No reviewers assigned yet.

Candidates from the panel ranked by taxonomy affinity

#ReviewerMatchLoadWhy