Skip to main content
SpringerLink
Log in
Book cover
  • Book
  • © 2011

Repairing and Querying Databases under Aggregate Constraints

Authors:

  1. Sergio Flesca

    1. , Dipartimento di Elettronica, Università della Calabria, Rende, Italy

    View author publications

    You can also search for this author in PubMed   Google Scholar

  2. Filippo Furfaro

    1. , Dipartimento di Elettronica, Università della Calabria, Rende, Italy

    View author publications

    You can also search for this author in PubMed   Google Scholar

  3. Francesco Parisi

    1. , Dipartimento di Elettronica, Università della Calabria, Rende, Italy

    View author publications

    You can also search for this author in PubMed   Google Scholar

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

Sections

Buy it now

eBook USD 29.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 39.95
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (6 chapters)

  1. Front Matter

    Pages i-viii
    PDF

  2. Introduction

    • Sergio Flesca, Filippo Furfaro, Francesco Parisi
    Pages 1-11

  3. Preliminaries

    • Sergio Flesca, Filippo Furfaro, Francesco Parisi
    Pages 13-23

  4. Repairing and Querying: the Fundamental Decision Problems

    • Sergio Flesca, Filippo Furfaro, Francesco Parisi
    Pages 25-31

  5. Computing Card-minimal Repairs

    • Sergio Flesca, Filippo Furfaro, Francesco Parisi
    Pages 33-45

  6. Consistent Answers to Aggregate Queries

    • Sergio Flesca, Filippo Furfaro, Francesco Parisi
    Pages 47-54

  7. Possible Extensions and Open Problems

    • Sergio Flesca, Filippo Furfaro, Francesco Parisi
    Pages 55-58

  8. Back Matter

    Pages 59-61
    PDF
Back to top

About this book

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.
Back to top

Keywords

Back to top

Authors and Affiliations

  • , Dipartimento di Elettronica, Università della Calabria, Rende, Italy

    Sergio Flesca, Filippo Furfaro, Francesco Parisi

Back to top

Bibliographic Information

  • Book Title: Repairing and Querying Databases under Aggregate Constraints

  • Authors: Sergio Flesca, Filippo Furfaro, Francesco Parisi

  • Series Title: SpringerBriefs in Computer Science

  • DOI: https://doi.org/10.1007/978-1-4614-1641-8

  • Publisher: Springer New York, NY

  • eBook Packages: Computer Science, Computer Science (R0)

  • Copyright Information: The Author(s) 2011

  • Softcover ISBN: 978-1-4614-1640-1Published: 19 October 2011

  • eBook ISBN: 978-1-4614-1641-8Published: 20 October 2011

  • Series ISSN: 2191-5768

  • Series E-ISSN: 2191-5776

  • Edition Number: 1

  • Number of Pages: VIII, 61

  • Topics: Database Management

Back to top

Publish with us

Policies and ethics

Back to top
Access via your institution

Buy it now

eBook USD 29.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 39.95
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Search

Navigation