Range-consistent answers of aggregate queries under aggregate constraints

  • Authors:
  • Sergio Flesca;Filippo Furfaro;Francesco Parisi

  • Affiliations:
  • DEIS, Università della Calabria, Rende, CS, Italy;DEIS, Università della Calabria, Rende, CS, Italy;DEIS, Università della Calabria, Rende, CS, Italy

  • Venue:
  • SUM'10 Proceedings of the 4th international conference on Scalable uncertainty management
  • Year:
  • 2010

Quantified Score

Hi-index 0.00

Visualization

Abstract

A framework for computing range-consistent answers of aggregate queries in the presence of aggregate constraints is introduced. The rangeconsistent answer of an aggregate query is the narrowest interval containing all the answers of the query evaluated on every possible repaired database. A wide form of aggregate constraints is considered, consisting of linear inequalities on aggregate-sum functions. In this setting, three types of aggregate queries are investigated, namely SUM, MIN, MAX queries. Our approach computes consistent answers by solving Integer Linear Programming (ILP) problem instances, thus enabling well-established techniques for ILP resolution to be exploited.