• DocumentCode
    827114
  • Title

    A logical framework for querying and repairing inconsistent databases

  • Author

    Greco, Gianluigi ; Greco, Sergio ; Zumpano, Ester

  • Author_Institution
    DEIS Dept., Univ. della Calabria, Rende, Italy
  • Volume
    15
  • Issue
    6
  • fYear
    2003
  • Firstpage
    1389
  • Lastpage
    1408
  • Abstract
    In this paper, we address the problem of managing inconsistent databases, i.e., databases violating integrity constraints. We propose a general logic framework for computing repairs and consistent answers over inconsistent databases. A repair for a possibly inconsistent database is a minimal set of insert and delete operations which makes the database consistent, whereas a consistent answer is a set of tuples derived from the database, satisfying all integrity constraints. In our framework, different types of rules defining general integrity constraints, repair constraints (i.e., rules defining conditions on the insertion or deletion of atoms), and prioritized constraints (i.e., rules defining priorities among updates and repairs) are considered. We propose a technique based on the rewriting of constraints into (prioritized) extended disjunctive rules with two different forms of negation (negation as failure and classical negation). The disjunctive program can be used for two different purposes: to compute "repairs" for the database and produce consistent answers, i.e., a maximal set of atoms which do not violate the constraints. We show that our technique is sound, complete (each preferred stable model defines a repair and each repair is derived from a preferred stable model), and more general than techniques previously proposed.
  • Keywords
    data integrity; database management systems; database theory; query processing; classical negation; consistent answers; delete operations; disjunctive program; extended disjunctive rules; inconsistent database repair; inconsistent databases queries; insert operations; integrity constraint violation; negation as failure; prioritized constraints; repair constraints; tuples; Logic; Query processing; Transaction databases; Warehousing;
  • fLanguage
    English
  • Journal_Title
    Knowledge and Data Engineering, IEEE Transactions on
  • Publisher
    ieee
  • ISSN
    1041-4347
  • Type

    jour

  • DOI
    10.1109/TKDE.2003.1245280
  • Filename
    1245280