Tài liệu Mining Database Structure; Or, How to Build a Data Quality Browser docx

Mining Database Structure; Or, How to Build a Data Quality

Browser

Tamraparni Dasu, Theodore Johnson, S. Muthukrishnan, Vladislav Shkapenyuk

AT&T Labs–Research

￾


 

    !"#"$ &% '

% $(

ABSTRACT

)
*,+-+./*"#"#$ 0
1+.$#2-2314,"#5
 
5
 "76'
8
*9:"

;2-1<#"#6= ;>9:"#"(=+.6"#
+3?;"6 @/A'
 "("6 @$#2-""6 !;6BC

$("#"6D+-
EE$#"#+-"#
4FGH%JIK +.2-"L6
M,+-+-/L
2-

/"
231N"# ;$#"O
 "P9+.2-+3
1=F8
 "P;231Q
4
R>A"S6'
C

6T+-A"#U6+.$("(+-"## :,Q
@FV
 "W
+-,"7:"#
X+-H:"(FY,+-/>

;2-1+-8+.Z:"#
Z+-L6
0+.6"#
+-?$
+-& [/
 "\+./ [$(2."#+-/

;6]$#"#+-/U
 ">6
T%U^T+-,+.2.'2-1 _$\ "#>0>+-/0
2-

A"P9:"("#`6"#A"#2-:"6=
E "#2-D
>
"O
 "P
=F*+-/

2-"#/$(1aUFY"6"(
"6D6'
R$#"#UFGSM"(bc:" 79

,"4
 
,
 "HQ
$(
"HFW
 "H6
]$#"(d+-,b5"(2.2XC

6"(Q
T6%5eWb5"#"(@
 "Z6'
"(
@
,9:"fFY"6"(
"6H>#1d$#,"

Fgh6<#"#[F6
9;"(i$(
+-+-/W
 6[F
92-"#i;6

"(_F
 ;6&F?;"#2.6# b@+3
 *2-+3

2-"j"#2-+.92-"@6$#,"#

+-

9:
!+->1dA"(1k@FG"#+-/U"(1#%

I]"]'"L6"(A"#2-+./BMQ1Q
"#H 7lWm(nYno,pq Wb@ +-$\ a:"(FY,

6
7,+-+-/Z
 "Zrsutvw(suvTtm5F
 "!6'
9"%Vxy>
 +-j:"(

bz"P"#"#
d
"#$\ +.{"#>FYU{+-$T2-1E+.6"#
+3FG1+-/|b@ +-$\ K?;"(2g6

A">+.,+-2.*2-"## V+.6"#
+-Fg1+./

Q+.M
 # V"(Q
+.>'
+-/

Q+-

6+3"#$(
+-_6f+-<#"## 6f+g6"#
+3FG1+-/kQ
$\
"#&+.f
 "V6'
9;"%

} "*"#23
7Fi
 "*6
9;"Q
$(
"*,+-+./d2-2-'bh
 "C

231Q
X
,>"7"#"ZFV
 "*6
9;"Z$#
"#
% } +-!+.FY>C

+-U$H9:"7"64
"% /%. ;"#"Z6'
FYf6
,+-+-/ ?;6

FG"#+-/EA"\10

+-FG$\ "#>H>+-/ [+g6"#
+3FG1|Q
"(*


9:"!
A"#d
"(A"#
5
 "f6
9;"fFG~$(2-2.+-/,;6"(5
 "

bz"#+-/ 
!F[+3
@$#,2-"(+-
y1%

1. INTRODUCTION

€ "#"#,+-/*+-T'+.
5F_2./"fT6$(
+-06'
9"#k+-5
 ;'

 "(1,9:"#$(,"!6+-6"("6>"(z
+-,"% } "f6+.6"(k+-"#5FG

7+-"(
y1F&$"#5+-$#2-;6+-/7+.$#"($(
231>"#
"("6,6'
 T+-$(C

"($(
_"iFT
 "i6'
9;"!u:"\ ;‚6"_
@k2.$WF6$#,"(T
'C

+-:ƒ\ ;6Z"5F
 "56'
9"5
W,T6"#2
+-$#+-;'
"68"(A"#


;64"(T
+3
+-"#8u"% /%- :"(ba"(T+.$("#!W$(Q
,"\k
1:"#ƒ\% €6,+-C

+-Q
'
!;6d"(@F_
 "#"Z6
9;"(!'"76"(X6"#>6+-/

+-,"!"#"#X;6,FG"#{T"#
231d6
@ '"!
 "X
+-,"W
$'"(C

FG2-23142.& ,+3
 ;6d$#2-"H
 "#+3X6'
9;"%z„@"(,2-"

 ",2-"#ZFY$#",+-*,"+-T
"\"#Q
"6P+-|>T+./H42-">
 P+.

Permission to make digital or hard copies of all or part of this work for

personal or classroom use is granted without fee provided that copies are

not made or distributed for profit or commercial advantage and that copies

bear this notice and the full citation on the first page. To copy otherwise, to

republish, to post on servers or to redistribute to lists, requires prior specific

permission and/or a fee.

ACM SIGMOD ’2002 June 4-6, Madison, Wisconsin, USA

Copyright 2002 ACM 1-58113-497-5/02/06 ...…5.00.

$#"#$(
231H,T6"#2-+./>$#Q
,"(!6H"#
"(+-/,2.2‚+.FY>
+-

"#2.
"#6]
H
 ">2-" VHT+-+-+./O/L>#1P,
2-1

"#
"(,+-R
 "4"\+-$#"†$#+3$#+-
,
 "(1M'T+-+.B9
,+-/ T


6"(2."\
"f
 "#~W6+-2.+-/"#
2-1%

‡FY
;'
"#231 _
 "("46+.6"("#6R6
9;"( ;A"dU+-/+-FgC

+-$
>$#Q
%NˆV2g+./ @;2-1+-# X6B6
P,+-+./]'"HFGQC


"#6B91E+-$#"#$\
04,+-+-/|6
T%a‰W"(bŠ'

Q"($(
0b@ +.$

"{+3"W$#$#"(5
**23
+-2-"f6
9"#@'"f6+-‹$#23
"(:"#+-A"

60:"( X"(A"#4+-,:+.92-"f
+-,2-"#,"#
%

€ +-"(
y1F:
2-i ;A"59:"#"(,6"#"#2-:"6*FGz6'
9;"k$#2-"C

+-/dŒŽ'‚6>FG@$ "#>7>+-/dŒ‘'’ ;5b5"W6+-$#k+-d,"

6"\
+-2_9:"#2-b7%WxyUW"(:"(+-"#$#" : b5"#A"\ "Z+-!FY$#"#6Ub@+3


 "i6+-‹$#23
&92-"#NF6"(Q
;6+-/5
 "[$#T
"(T
&6fQ
$(C

"ZFi
 "6
9;"uƒ!
! ;;6H9:"(FG"8
 "(10$O9:"Z$#2-""6

5 ;A"@
 "#+3k$ "#>5>:"6%_‚'/"fT6$\
+.46
9;"(

Fg
"#O ;A"7 T6"65
,
 6@FV
92-"#!b@+3
 H
 ;6

P
"(,FW
 6,FW?;"#2.6#%=i"#B+-=S$#2-"B6'
9;"

6+-$#'A"\+./8
 "X6
9;"WQ
$\
"@+-k6+3‹,$#23
59:"#$"XF
 "

$2."ZF_
 "792-"#H%

ˆ[T6$\
+.86
9;"#‚FG
"#Z$#T
+-8>1f66+3
+-2A9C

2-"#,@b@ +-$\ U>A"f;6"\Q
;6+-/
 "(+-!Q
$\
"7$\ 0,"

6+3‹,$(23
%j•zQ
$(
+-/d"#
+3
1Uu"% /%. Z$#:
"f$#Q
,"(

dP6'
P"(T+-$#"H"(+-/ƒFG
"#R"{+3"#,>1H

+-b@+3


2-/d

+-M;
 # iFG
"(B$(,6
9;"(#% } "d$ "#>O6$\C

,"(T
'
+-]+-82-231|;'"d;6P
CFGCy6'
"%U„"#+-/MA"(1

6"(:"#;6"#$#+-"#f";2-231S
7>+-
+-"#6P;6O>1U6"#/6"

'A"(
+-,"%E•zTA"("#231 i
92-"#,>#1L$(
+-R;6$#,"(T
"#6

FY"#+-/EA"(1#% €
92-"4>#1|$(
+-R "(
"(/"#"#"#
+3
+-"##

+u% "%f"(
!Fib@f+-H
 "Z
92-"Z
 ;'
W '"6+-"\"#
j

+-O;
 #%

} "j$#TA"(T
+-fFY["($#6+./!+-FY>'
+-Z>#179:"z6+3"("#
_+-

6+3"("(T
z
92-"#7u"% /%j*$#Q
,"(k,"X,+-/ 
k9:"!"($#6"60+-

"W?;"(2g6>+-0"W
92-" 9
k+-0
yb58@,"X?;"#2.6k+.0
 "(\ƒ\%

€0a+g6=
MU6
L$#2-"+-/R"(
# !b5"S ;A"S6"#"#23C

:"#6NlWm(nYnopq 5|6'
|{;2-+3
1R9'b@"\%`j"#2-2.>='T+.6"#

 "k;2;{"(16$ "#>W+-/
+-
2.# ;62-*f$(23C

2-"#$(
+-OFi
2-764"(T+-$#"#!b@ +-$\ S"86"#+-/"#6U
, "#2-H
 "

"\6+.$("(*
 ">Q
$(
"d+-|
 "06
9;"%Sz"#2-2->L"(

™pspšpr#mf›;tQœQjnžYqŸ>Œ3 #[
>$#2-2-"#$(
f,>+-"#@Fj
 "*6
9;"

92-"#;$#"## @
92."(# W;6E?"#2.6#% } "("S,>+-"#>'"P6+-QC

2.#1"64
,
 "8"(f+-OS+-
"($(
+-A"*>"(X7'"*"6HFY

,"U$(,2-"(B{"(+-"##%¡j"#2-2.>K$#2-2-"#$(
d
 "U$#TA"#
+-;2

?;2-"#8u"% /%- ;T9:"(kF[b@!+-U
92-" ;T9:"(kFV6+-Q
+-$\

2-"#k+-08?"#2.6 "(
$% ƒ\ 5bz"#2-2‚k,"W +.Q
+-$'
"60?2."(

Yb@ +-$ H+-@"7F_
 "W9T

Q"#$(
XF‚
 +-@;:"\\ƒ\%

xS6"(7
4;6"(Q
6O
 "Q
$\
"Fk46
9;" _+3
Z+-

"($#"#1R
];6"(Q
6R 'b~?"#2.6"#2.'
"H
]"U
 "(%

z"#2-2->7$(2-2-"#$(
_$#$#+-"i,>'+."(&F
 "V2-"#FT
 "[?"#2.6#%

} "(",>'+."(f2-2-b¡z"#2-2->O
46"(
"(,+-"Zb@ "\
 "(f
yb5