arrow
返回

Discovering Conditional Functional Dependencies

delete2011-05-01
delete141
delete
OA
AI
W
Wenfei Fan *
F
Floris Geerts
J
Jianzhong Li
M
Ming Xiong
DOI:10.1109/TKDE.2010.154delete
delete原文链接
delete分享
delete收藏
查看原文
摘要

摘要

En 中文
This paper investigates the discovery of conditional functional dependencies (CFDs). CFDs are a recent extension of functional dependencies (FDs) by supporting patterns of semantically related constants, and can be used as rules for cleaning relational data. However, finding quality CFDs is an expensive process that involves intensive manual effort. To effectively identify data cleaning rules, we develop techniques for discovering CFDs from relations. Already hard for traditional FDs, the discovery problem is more difficult for CFDs. Indeed, mining patterns in CFDs introduces new challenges. We provide three methods for CFD discovery. The first, referred to as CFDMiner, is based on techniques for mining closed item sets, and is used to discover constant CFDs, namely, CFDs with constant patterns only. Constant CFDs are particularly important for object identification, which is essential to data cleaning and data integration. The other two algorithms are developed for discovering general CFDs. One algorithm, referred to as CTANE, is a levelwise algorithm that extends TANE, a well-known algorithm for mining FDs. The other, referred to as FastCFD, is based on the depth-first approach used in FastFD, a method for discovering FDs. It leverages closed-item-set mining to reduce the search space. As verified by our experimental study, CFDMiner can be multiple orders of magnitude faster than CTANE and FastCFD for constant CFD discovery. CTANE works well when a given relation is large, but it does not scale well with the arity of the relation. FastCFD is far more efficient than CTANE when the arity of the relation is large; better still, leveraging optimization based on closed-item-set mining, FastCFD also scales well with the size of the relation. These algorithms provide a set of cleaning-rule discovery tools for users to choose for different applications.
Keyword:
Integrity
conditional functional dependency
functional dependency
free item set
closed item set
AI总结

AI总结

对已上传原文的论文进行重点信息的提取,主要内容包括:简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。

期刊

IEEE Transactions on Knowledge and Data Engineering 封面图
IEEE Transactions on Knowledge and Data Engineering
IF:
10.4
论文数:
6.8K
被引数:
3.2W

机构

H
harbin institute of technology
学者数:
8.0W
论文数: 6.6W
被引数: 66
A
AT&T
学者数:
811
论文数: 717
被引数: 460
U
University of Edinburgh
学者数:
5.2W
论文数: 4.6W
被引数: 71
学者 查看更多机构
引用论文

引用论文

Chance Fracture After Pedicle Screw Fixation
err1998-02-01
err0
PREAI
errDavid S. Levine; Jeffrey R. Dugas; Scott J. Tarantino; Oheneba Boachie-Adjei
err分享
err收藏
Integrated microRNA and mRNA Transcriptome Sequencing Reveals the Potential Roles of miRNAs in Stage I Endometrioid Endometrial Carcinoma
err2014-10-17
err0
errOAAI
errHanzhen Xiong; Qiulian Li; Shaoyan Liu; Fang Wang; Zhongtang Xiong; Juan Chen; Hui Chen; Yuexin Yang; Xuexian Tan; Qiuping Luo; Juan Peng; Guohong Xiao; Qingping Jiang
err分享
err收藏
The effects of a catastrophic forest fire on the biomass of submerged stream macrophytes
err2019-01-01
err0
PREAI
errVirginia F. Thompson; Diane L. Marshall; Justin K. Reale; Clifford N. Dahm
err分享
err收藏
Disruption of DNA repair processes by carcinogenic metal compounds
err1998-06-26
err0
PREAI
errAndrea Hartwig; Leon Mullenders; Monika Asmuß; Heike Dally; M. Hartmann
err分享
err收藏
Gasless laparoscopy in abdominal surgery
err1995-05-01
err0
PREAI
errV. Paolucci; C. N. Gutt; B. Schaeff; A. Encke
err分享
err收藏
Experimental investigation of pressure fluctuation on the bed of compound flip buckets
err2017-06-30
err0
PREAI
errO. Aminoroayaie Yamini; M. R. Kavianpour; S. Hooman Mousavi; Azin Movahedi; Majid Bavandpour
err分享
err收藏
Students’ acceptance of E-books: An application of UTAUT
err2018-04-19
err0
PREAI
errAssion Lawson-Body; Lori Willoughby; Laurence Lawson-Body; Eric Matofam Tamandja
err分享
err收藏
学者 查看更多内容