%0 Journal Article
%T Consistent query answering based on virtual repairs with nulls<br>基于空值修复的数据库一致性查询方法*
%A HUANG Fei
%A LIU Jie
%A YE Dan
%A <br>黄飞
%A 刘杰
%A 叶丹
%J 计算机应用研究
%D 2009
%I 
%X ntegrity constraints are used to define the data semantics in databases. The database instanced and the tuples violating the constraints were inconsistent. Consistent query answering was one technique to obtain consistent answer from inconsistent database. The applicable areas of current techniques were limited because they supported little types of constraints or their high computation complexity. This paper presented a new approach based on null repair. Transformed the constraints first to unified format to locate inconsistency, and then rewritten the original SQL queries to query consistent answers by treating inconsistent attributes as nulls. The implementation of the system and the experiment results show that this approach can achieve stable performance under multiple combinations of constraints and SQL queries.
%K consistent query answering
%K integrity constraints
%K SQL query rewriting
%K repair
%K database<br>一致性查询
%K 完整性约束
%K 结构查询语言查询重写
%K 修复
%K 数据库
%U http://www.alljournals.cn/get_abstract_url.aspx?pcid=5B3AB970F71A803DEACDC0559115BFCF0A068CD97DD29835&cid=8240383F08CE46C8B05036380D75B607&jid=A9D9BE08CDC44144BE8B5685705D3AED&aid=D717E833B0D38FBE6A3A7815EA7881AA&yid=DE12191FBD62783C&vid=96C778EE049EE47D&iid=708DD6B15D2464E8&sid=93DB3797027BE80E&eid=408622421E43C317&journal_id=1001-3695&journal_name=计算机应用研究&referenced_num=0&reference_num=14