Advertisement

Repairing and Querying Databases under Aggregate Constraints

  • Sergio Flesca
  • Filippo Furfaro
  • Francesco Parisi

Part of the SpringerBriefs in Computer Science book series (BRIEFSCOMPUTER)

Table of contents

  1. Front Matter
    Pages i-viii
  2. Sergio Flesca, Filippo Furfaro, Francesco Parisi
    Pages 1-11
  3. Sergio Flesca, Filippo Furfaro, Francesco Parisi
    Pages 13-23
  4. Sergio Flesca, Filippo Furfaro, Francesco Parisi
    Pages 25-31
  5. Sergio Flesca, Filippo Furfaro, Francesco Parisi
    Pages 33-45
  6. Sergio Flesca, Filippo Furfaro, Francesco Parisi
    Pages 47-54
  7. Sergio Flesca, Filippo Furfaro, Francesco Parisi
    Pages 55-58
  8. Back Matter
    Pages 59-61

About this book

Introduction

Research has deeply investigated several issues related to the use of integrity constraints on relational databases. In particular, a great deal of attention has been devoted to the problem of extracting "reliable" information from databases containing pieces of information inconsistent with regard to some integrity constraints. In this manuscript, the problem of extracting consistent information from relational databases violating integrity constraints on numerical data is addressed. Aggregate constraints defined as linear inequalities on aggregate-sum queries on input data are considered. The notion of repair as consistent set of updates at attribute-value level is exploited, and the characterization of several data-complexity issues related to repairing data and computing consistent query answers is provided. Moreover, a method for computing “reasonable” repairs of inconsistent numerical databases is introduced, for a restricted but expressive class of aggregate constraints. An extension of this method for dealing with the data repairing problem in the presence of weak aggregate constraints which are expected to be satisfied, but not required to, is presented. Furthermore, a technique for computing consistent answers of aggregate queries in the presence of a wide form of aggregate constraints is provided. Finally, extensions of the framework as well as several open problems are discussed.

Keywords

Inconsistent databases aggregate constraints consistent query answer numerical data integrity repairs

Authors and affiliations

  • Sergio Flesca
    • 1
  • Filippo Furfaro
    • 2
  • Francesco Parisi
    • 3
  1. 1., Dipartimento di ElettronicaUniversità della CalabriaRendeItaly
  2. 2., Dipartimento di ElettronicaUniversità della CalabriaRendeItaly
  3. 3., Dipartimento di ElettronicaUniversità della CalabriaRendeItaly

Bibliographic information

  • DOI https://doi.org/10.1007/978-1-4614-1641-8
  • Copyright Information The Author(s) 2011
  • Publisher Name Springer, New York, NY
  • eBook Packages Computer Science
  • Print ISBN 978-1-4614-1640-1
  • Online ISBN 978-1-4614-1641-8
  • Series Print ISSN 2191-5768
  • Series Online ISSN 2191-5776
  • Buy this book on publisher's site