• DocumentCode
    1876823
  • Title

    Decomposition-Based Consistent Query Answering in Databases with Universal Constraints under Cardinality-Based Semantics

  • Author

    Du, Jianfeng ; Shen, Yi-Dong ; Qi, Guilin

  • Author_Institution
    Guangdong Univ. of Foreign Studies, Guangzhou, China
  • fYear
    2010
  • fDate
    10-12 Dec. 2010
  • Firstpage
    1
  • Lastpage
    5
  • Abstract
    Consistent query answering (CQA) in relational databases under cardinality-based semantics is a well-known approach to dealing with inconsistency between databases and certain integrity constraints (ICs). It computes from a given database all consistent answers to a query that are satisfied by all the C-repairs, where a C-repair is a database that satisfies all the given ICs and minimizes the cardinality of the set of tuples in the symmetric difference with the given database. In this paper we address the problem of CQA in databases with universal constraints under cardinality-based semantics. This problem has no worst-case optimal solutions by now. We present a novel method for such problem which is worst-case optimal in terms of time data complexity and is further optimized by a decomposition-based framework. Experimental results on synthetic databases demonstrate the advantages of the proposed method.
  • Keywords
    computational complexity; constraint handling; optimisation; query processing; relational databases; C-repairs; consistent query answering; decomposition based framework; integrity constraint; relational database; time data complexity; tuples; Complexity theory; Computational modeling; Databases; Integrated circuit modeling; Maintenance engineering; Semantics;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Computational Intelligence and Software Engineering (CiSE), 2010 International Conference on
  • Conference_Location
    Wuhan
  • Print_ISBN
    978-1-4244-5391-7
  • Electronic_ISBN
    978-1-4244-5392-4
  • Type

    conf

  • DOI
    10.1109/CISE.2010.5677027
  • Filename
    5677027