中国科学院软件研究所机构知识库
Advanced  
ISCAS OpenIR  > 软件所图书馆  > 会议论文
Title:
Consistent query answering based on repairing inconsistent attributes with nulls
Author: Liu, Jie (1) ; Ye, Dan (1) ; Wei, Jun (1) ; Huang, Fei (1) ; Zhong, Hua (1)
Conference Name: 18th International Conference on Database Systems for Advanced Applications, DASFAA 2013
Conference Date: April 22, 2013 - April 25, 2013
Issued Date: 2013
Conference Place: Wuhan, China
Publish Place: Springer Verlag, Tiergartenstrasse 17, Heidelberg, D-69121, Germany
Indexed Type: EI
ISSN: 3029743
ISBN: 9783642374869
Department: (1) Institute of Software, Chinese Academy of Sciences, Beijing, 100190, China
Abstract: Although integrity constraints can successfully capture data semantics, the actual data in the database often violates such constraints. A Consistent Query Answer (CQA) in a possibly inconsistent database is an answer which is true in every minimal repair of the database. It has been proved that for most constraints and queries CQA is a NP problem based on repairing by tuple deletions or tuple insertions. Furthermore, repairing by deleting tuples will also cause information losing. In this paper we present a new repair semantics named repairing with nulls, which replaces the inconsistent attribute values with nulls. To capture all the inconsistent attribute values, we study the transitivity of nulls and provide an algorithm to extend the original constraints. Based on repairing with nulls, there will be only one repair and CQA can be computed in PTIME by SQL query rewriting. Finally, we study the performance of our new approach for CQA by detailed experiments. © Springer-Verlag 2013.
English Abstract: Although integrity constraints can successfully capture data semantics, the actual data in the database often violates such constraints. A Consistent Query Answer (CQA) in a possibly inconsistent database is an answer which is true in every minimal repair of the database. It has been proved that for most constraints and queries CQA is a NP problem based on repairing by tuple deletions or tuple insertions. Furthermore, repairing by deleting tuples will also cause information losing. In this paper we present a new repair semantics named repairing with nulls, which replaces the inconsistent attribute values with nulls. To capture all the inconsistent attribute values, we study the transitivity of nulls and provide an algorithm to extend the original constraints. Based on repairing with nulls, there will be only one repair and CQA can be computed in PTIME by SQL query rewriting. Finally, we study the performance of our new approach for CQA by detailed experiments. © Springer-Verlag 2013.
Language: 英语
Content Type: 会议论文
URI: http://ir.iscas.ac.cn/handle/311060/16669
Appears in Collections:软件所图书馆_会议论文

Files in This Item:

There are no files associated with this item.


Recommended Citation:
Liu, Jie ,Ye, Dan ,Wei, Jun ,et al. Consistent query answering based on repairing inconsistent attributes with nulls[C]. 见:18th International Conference on Database Systems for Advanced Applications, DASFAA 2013. Wuhan, China. April 22, 2013 - April 25, 2013.
Service
Recommend this item
Sava as my favorate item
Show this item's statistics
Export Endnote File
Google Scholar
Similar articles in Google Scholar
[Liu, Jie (1)]'s Articles
[Ye, Dan (1)]'s Articles
[Wei, Jun (1)]'s Articles
CSDL cross search
Similar articles in CSDL Cross Search
[Liu, Jie (1)]‘s Articles
[Ye, Dan (1)]‘s Articles
[Wei, Jun (1)]‘s Articles
Related Copyright Policies
Null
Social Bookmarking
Add to CiteULike Add to Connotea Add to Del.icio.us Add to Digg Add to Reddit
所有评论 (0)
暂无评论
 
评注功能仅针对注册用户开放,请您登录
您对该条目有什么异议,请填写以下表单,管理员会尽快联系您。
内 容:
Email:  *
单位:
验证码:   刷新
您在IR的使用过程中有什么好的想法或者建议可以反馈给我们。
标 题:
 *
内 容:
Email:  *
验证码:   刷新

Items in IR are protected by copyright, with all rights reserved, unless otherwise indicated.

 

 

Valid XHTML 1.0!
Copyright © 2007-2019  中国科学院软件研究所 - Feedback
Powered by CSpace