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
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;
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
DOI :
10.1109/CISE.2010.5677027