Mining Database Structure; Or, How to Build a ... - Semantic Scholar

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
"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"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
C—FGCy6'
"%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(nYn opq 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;"%S˜z"#2-2->L"( ™ ps—pš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

?"#2.6!$U9:"k Q+-"6 6H+-Fi,
 "Z6+3"#$(
+-OFV
 "@ +-Mu"% /% "
d>1 :>1H
0>1 "(
$% ƒ|6U
 "+-2-+-A"#231
49:"$#
+."6P+-L
 "(% } "#">{"#Q
+-Z$P9:",:"6 Z{"(+-"#fS
 "*,>+-'+."(# ;˜z"(2.2->U$H:" 6
,+-+./{"\+."(X$\ 4# „_+-;6H2-2&F[
 "z +-8u+->1dA"\1 FY"(+./UA"(1 X
 C "(b@+-"'ƒW9:"(
yb5"#"(O
 +-!
92-"6O1H
 "(!
92-"*+.U
 " 6'
9"% ¢

¢M£ +-A"#4?"#2.6H¤ ?;;602-2‚"\
!F_?;"#2.6f#¥>$\ d
 ;
@
 " $#T
"(T
XFj¤h"82-+-A"#2314
,9:"8$#,:+3
"*F[
 "Z$#C
"#
kF[¥d% ¢M£ +-A"#KS
92-"H¦Z X6"(d+3
d ;A"H
yb5=u2.'/"#231ƒd6+-Y Q+-
9"(
@b@ +-$\ * Q+-U

92-"#X¦Z Z;60¦WŽ4u+u% "%5+-X¦` "(
C "(/"#"#Ĥ } "#"Z6'
,+-+-/{"(+-"## 64>1>
 "(# $U2-,9:"  Qbz"("6EFg¨
 "H,>'+."(# 5;6R
 "("(FG"H"#2-
"6R+.  "($#6#% } +-f+-
"($(
+-A"6
9"*Q
$(
"*,+-+-/02-2.b@
 "7"(X
,6+.$("(!
 "7Q
$(
"7F[
 "Z6
9;" ;"#92.+-/
 ",2-+-$
+-|F@6
4$(2."#+-/ [6
4,+-+./ ‚6S$ "#> >+./*
2.#%

1.1 Related Work

} "86
9;"8"#"#$ S$(,+3
1> !"(2-"6H,"8QC :"($(
_F
 "i92-"#`F;6
@$#2-"+-/Œ AŽ'’%j©W"j:"#$\
[F
 +- "("$ ,66"#"(V
 "592-"#ªF;?;6+-/!62-+-$
"k2-"([+. f
92-"Œ ŽŽ AŽ «T ¬’%z­4"X/"#"(2-231 "X$,:"(FY®p\›:¯ ›tœ°žYopsym8ops—w±TžYqŸ ;+-0b@ +.$ * +-X"#6+-$
"(X$#49:"79"6 BQ
+-/|6+-Q
$#"|Œ A« @²T !Ž³’%a©W,+-
"("#Q
>+->+.M?;6+-/ "(2g'
"6P?"#2.6Z,/42-2i?"#2.67+-P
 ",6'
9" &
 "\7
 ; :"\FY,+-/,10;
+-$#2.i Q+-%zxy]Œ ¬’ 
 "Z
 @$#,;'"
yb5S,"(
 T68FG*?;;6+-/U"#2.
"6|?"#2.6#%PeWb5"#"(
 "#"4'" $\;6"4,"(
 T6b@ +-$ = "T+-231B6"#:"#6RB$ "#>S+.FY>C
+-&% €!´A€!µ Œ- (;6 €X¶!· } ©7^0Œ ¸'"!{"(1Q1Q
"#,j6"(+./"6
7"\"#j;6*
+-,+-
"ƒ+-7
C 92-"#@Œ Ž  A A‘T A³’%[IK +-2."j
 +-[+-FY>
+-+.V2-;92-"zFG ,+-+./6
9;"WQ
$(
"’6d+->Fu$\
kb5"f"702-/+3
  9"6UO
 "Z"8"("#
"6H+-LŒ ŽGƒ\ &66+3
+-;2_+-FG>
+- 9:
!$("#$(
+-@9:"(
bz"#"#4?"#2.6@+-X"#"6"6% ) 
5,>'+-"#&F'+.FY,& '"i9:"("#7"6f+-Z6
9"# >+-231ZFYj"#2-"#$(
+-T+3
1*"#Q
+->
+-ºA
 "("5
1+-$2.231*+-$#2-;6"k +-QC
/,# ,2."(iVbkA"#2-"(
j$#"(‹,$(+."(T
XŒ3 ¸'—%[I]"k"k"#"(2 +-"(
+-"#*FX,+-C— ; ]+-/
"#;6|A"(
$ "(8+-L8b5:% ­4+-Cy,2-"#i ;A"@9:"#"#"6+-,"#Q
+->
+-/f
+3
+-A"@$#2-" +-'
+.KŒ «'’%U^TA"(
$ "#7 A"9:"#"# "6B+-K2-+-$'
+.0$ K,?;6+-/P"#"#"(T
'
+-A"H
"#;6 Œ Ž'z;6UQ
",+-/>bkA"#2-"(
Œ3 #²’% } "#+37"8FY86
>$#2-"C +-/+-!"#2u%

x d
 +-@;:"( bz"7>A"X
 "WFG2-2-b@+./0$(
+-9
+-#» ¢

I|"i6"#"#2-f"#"(2A,"\
 T6FY‚?;6+-/z"#2.
"6Z6
9" ?;"#2.6@+./>2-2,>'+."(#% ¢

I|"S"#2-;
"O
 "S+-+-"#d"{+3"6=FY $#$#$(1% ¢

I|"@"#"(T
i"(b=2-/+3
 ,jFY5,+-+-/W
 "@Q
$\
"@F 6'
9;"%

2. SUMMARIZING VALUES OF A FIELD

©W5A$\ ,
*6'
9;"WQ
$(
"X,+-+-/Z+-z
Z?Q
5$(23C 2-"#$(
0rvTo*o,ptž—m\r7F!
 "06
9;"% } "#"0,>+-"#8$M9:" $#,
"#6{+-$\T231 ;6"("#"#
i
 "k"#2-"#
iFY"'
"#jF
 " 6'
9"X+.>f>2-2;,
VF$#"%j©Wj6
f,+-+./Z2-/C +3
 ,i:"('
"!Fgh
 "#"X,>'+."(# T6,k7$#"{"($#" "fFYQ
!9:"#$"f
 "W,>+-"#@'"7>2-2u% ­H1dF[
 "#"f,>+-"#@"Z{+-
"7+-,2." "% /%j
 "fTC 9:"(7Fj
2-"#f+-S"$ O
92-" 
 "*T*9:"(!Fk6+-Q
+.$(
Z;6H
 " T*9:"(fFkT2-2V2."#7F5"$ P?"#2.6%,"(
$%d©!
 "(f,>+-"# "U,"4 +-Q
+-$'
"6K6R '"H+-/+3?$
231R,"H:b5"\
>"#A"2_
 "8Q
$(
"*Fj
 "6
9"%ZxyH
 +-f"#$\
+.& b5" "("#

 "("d,"0 +.Q
+-$'
"6M,>+-"#*6]
 "02-/C +3
 ,5b@ +.$ H"W
 "#J@+.
%

2.1 Set Resemblance

} "@tm\r(m\oš#n-pq:wm&F
yb5@"(
‚¼L;67½=+-¾*¿hÀ ¼7ÁV½dÀ ÂÀ ¼7Ãi½dÀ %

"j"#"#92.$("5F
b5!"(
V+-V!,""zF: bM+-,+-2.[
 "\1 }  "% } "#"H"(
>'"H$#,
"6|Fg¨?"#2.6FZO
92-"H91M {"(14$ S7¼ª¿fÄÅÆ Å#ÇÈZÉ5Ê Ë ÈÊ-ÌÇÈ7Í[Î Ï@%„7f:"#Wb5" "Z,"8+-
"("#Q
"#6H+.4$#,
+-/+-FGÐ
 "W"#"(92.$#"791 ¾ À ¼À(ÑaÀ ½dÀ ƒ ¾fÑ= 

À ¼MÁ4½dÀ¿

Q 'ƒ

©WQ1Q
"#¨?;2-"#
 "0T9:"(*Ff6+-Q
+-$(
,2-"#F!"$\ ?;"(2g6 HÀ ¼*À;6PÀ ½dÀT+.!23b51X+-2g92-"% } "7"2_+-/+-?$$#"FV
 "f"#"#*92.$#"Z+-!
 ;'
W+3
!$O9:" "+.231"#Q
+->
"6%[“&"\
_Ò=9:"5
 "5+."("kF:2-"#[FGªb@ +.$ "#2-"#,"#
kF_
 "f"\
!'"Z6#b@& 602-"(
!Ó4»'ÒaÔÖÕ×>d"#2-"(C ,"#
kF&ÒØ+3FY,2-10;6Bٗ;6,231Ú

 "f"(
!F[
2 T*9:"([ÕD%i“"(
Wہ’¼WƒV¿K,+-ÜÝÞz’Ó‚u߃ƒ\% } "# ˆV'Œ ÛA’¼fƒV¿NÛA’½ƒy;¿B¾ } ;'
‚+-# '
 "V+-;6+-$
_+.92."Và:Œ ÛA’¼fƒ[¿aÛA’½ƒy+-_k˜z"(2.2-+ 6ª'+g92-"kb@+3
 ;',"(
"(V¾:%V„jWFF:
 +.VQ
'
"(C ,"#
 '"#"XŒ ¸’ 9
&b5"i/+-A"5@{+-$f+-
+3
+-A"V"(2.
+-%i•zC +.6"(!
 "Z+-TA"("Z>+-/,Óá‚âf»ÕãÔäÒ*% } "ZFG$(
+-SÓ&á‚â 6"\?;"(z7,2-+./7Q

"#/1FYk+-$T+./Z,"#2-"#,"(T
jF
 "X"\
¼8 ;,"#231Z"#2-"#$(
jÓ&á&⁒³Aƒ‚+3F:+3
V+-[+-¼8 "#2-"kÓ&á&â'Q 'ƒ\ "#2-"kÓ&á‚â'—Žƒ\ 6f&% } "k$#"#i+-V+.,+-2.i
W
 'b@+-/76'
j'
j76
9:A'6 [Q
+./4b@ "(L|"(2."(,"#
*F5
 ","\
*+-8 +3
%4“&"(
8 $#+.6"(8Ó á‚⠁’åƒ\ 
 "8?Q
7"#2-"#,"#
W+.O
 "*"{"#$#"*b@ +-$\ S+- +-B¼aÃ]½,% } "4$ ;$#"0
 ;
,Ó&á‚â'’åƒ4æؼNÁ]½ç+-¾: k;6M+- +-;6+.$#
"64914ÛA’¼fƒ[¿NÛA’½ƒ\% € ˜z"(2-2-+&;6Ð+.92."W ;X82g'/"Z+.$#"W"#2.
+-A"
7+3
z,"&% } f
+./ 
"#
 "@$#?:6"#$("X9:6# bz"!$(2-2-"#$(
kè ,2-"##% } "@rž.Ÿq;psuvTtm&F"(
_¼|+-_ék’¼WƒV¿ª—Û ’¼Wƒ\ê(ë#ëë(êÛ'ìZ’¼Wƒƒ\ â b@ "\"7"$ OÛ큒¼fƒV¿=,+. ÜÝÞ ’Ó;íu߃ƒ\%_I|"7"#Q
+->'
"W¾>91  î¾ ¿

íGð

ï âñ ò ò ò ñ

ì

à:Œ ÛíQ’¼Wƒi¿NÛíuóƒyGÂ(è

b@ "("Zè ¾d î ;X½8ô’õö÷4ô’ßø Y¾:êèUƒ56+.Q
+-9
+-%z„X$(
+-$2 :"## z"#$ RF!
 "0  LFY$(
+-,Ó í $(2.6L9:"d;+3b@+-" +-6"#:"#6"#
% xy|">FX+-/;'
"## Vbz"d>A"
bzU,T6+3?;$#
+-8FG +-,2."X;6*FYQ
5+-,2."(,"#

+-%[„_+3Q
 b5"@>*
 "k"(
jF&2-2 ?+3
"ZQ
+-/@

 "7/">Œ ³ê\Žù(âzúE (‚FGW$#TA"#+-"#
@+.
"#/"( >+-2.
+-%|IK +-2-">
 "("0+.8
 "d:+-9+-2-+3
1RFWO$#2-2-+-+. 9:"\
b5"("#= ; "6R"#2-"#,"#
# 5
 "H9;9+-2.+3
y1EF8]$#2.2-+-+-K+- >2-2!+3Ff
 "H"(
>+-
+-O
 ;P"\
f"(C "(92.$#" +3
X2-$#d"#Q
+->
"W¾ Þüý ¿ªÀ ¼|þj½dÀ ÂÀ ¼|Ã,½dÀT;6 ¾ Þüý ¿ªÀ ½Kþk¼À ÂÀ ¼MÃ0½dÀT9T1 ¾ ÿ Þüý ¾ ÿ ý&üÞ

¿

ï

¿

ígð ígð

ï

âñ ò ò ò ñ

ì

à:Œ Û'íQ’¼Wƒ
=Û큒½*ƒyYÂ\è à:Œ Û'íQ’¼Wƒ
=Û큒½*ƒyYÂ\è

ì â ñ ò ò ò ñ € 23
 / ]
 +-8+-84+-,2-",9"(
+-]/+-A"#]
 ",$#
"(T
ZF
 "W,+-, ; "## Tbz"f"!
@#bk"WF‚1,"(+-zbz
 ;'
>6"f"7F_
 +-X9"(
+-&% x—F ¾7 î 6¾ ÿ ý‚üÞ "j2./" 9
V¾ ÿ Þ&üý +-‚>2-2u b5"i$8$#$#2-;6"
 
W¼Ø+-!2./"#231U$#T
+-"6H+-O½, :9
W½¡+-W
W$(
+-"#6H+. ¼Z%i„_+-;2-231 b5"!
"X
 
5"\
5+-/
"(@"X,>92-"% } 
+- é5’¼MÃd½ƒV¿Øu,+-&—Û

’¼Wƒ\êÛ ’½ƒƒ\ê(ë#ë#ë#ê,+-—Û ì ’¼fƒ\êÛ ì ’½*ƒƒƒ â â I]"U"O"(
d+-/
"(0
|?;6E"($(
4>'
$\ S Q+.4+-B
 " 6
9;"% ) +./H?;2-+-/ VH"(
8+-/;'
">+-*$(2-2-"#$(
"6]FG "(A"(1?"#2.6b@+3
 >
52-"Q
@Ž³86+-Q
+.$(
j2."#X’Z"(z6 Q
92-" ,"(
"(\ƒ\%,‰!C—Q
+-/d?;"#2.6Z"$#TA"(
"6O
0
 "(+-ZQ
+-/ "("#"#
'
+.#% } "#"Z'"7Q
"60+.d
 "76
9;"7+-/
 " $ "(>» Ä 
_Ï zÍ  Æ Å(ËÇ#ÅÆ ÅÊ ÅÆ  'Ë
! 'Ë#"$Æ %

Ž³³A§De!bh2g'/"bz2.6O
 "! +-|9:"'§Kx f
 "("06"#:"(;6"($#" 9:"(
yb5"#"#4"(2.+-/?;"(2g602."#!;602."fFG"{"#$(1§OˆV"\C T+-i Q+.O+-
+-O,"(
 T6@"#2-+-"6UU,2-+./,FG "#2.
+-kFY@"$ * +-|Œ3 '‘ :Ž—%z©W5,"(
 T6d/+."#@2-
"\;
" $ ]b@ +-$ |+-*2-,Q
OÙyFg"#"#Ú V/+-A"#]
 
7bz",$#2-2-"#$(
8
 " "(
X+-/
"(#% € 6
9"k?;2-"k
1+.$#2-231$#
+-V
 "5T9:"(VF:
2-"# +-d7
92-" ;6FYk"$ ,?;"#2.6
 "!T*9:"(iF&6+-Q
+-$\
k6,2-2 2-"##% } "#"7T*9:"(z$49:"f"6d
*$#,
"@
 "7A"\/" 23
+.2-+.$(+-
y1BFZ
 "U?;"#2.6=2-"(#% e!b5"#A"\ X
 +-4+-4L$(6" "#Q
+->
"%V„V"\,2-" >1f?"#2.6[ '"5"5V,"56"\Fu23
2-"#Zu
 "(X
 ;H‰ ‡ “‚“_ƒjb@ +-$\ H$($#!A"(1>FG"#{T"#
231H;6 9+.@
 "ZA"(/"72-"WFg"{"#$(1% “&"\@
Kä9:">423
+."\
 [6]2-"(
*¼ 9:"
 ""(
>ßL»‚ßLC æ KHA% “&"\
f÷]uß:Lê K4ƒ@9:"8
 "8T9:"(XFi
+-,"#@
 ;
W"#2-"#,"#
!ßH$#$# +-I  KO%OI|"06"\?;",
 "Oo*žYqL±prQ±EwœvTqs7Œ ³k
O9:6 " M í N K0ƒ¿ ÷]’Ó í á‚⠁’¼Wƒ\Oê K4ƒ\ A+’% "%- 
 "XT9:"(iF
+-,"#V
 ;'
5Ó í á&⠁’¼fƒ[$#$# +-M23
+-"(@
KO%P˜z"($"HÓ í á&⠁’¼fƒ7+-"#2-"#$(
"6L+3FY,2-1PC 6,231|,/0
 ","(
*F!6+-Q
+-$\
2-"(8+-M¼Z [÷HíN K0ƒ7+- T9+g"6"#Q
+->
5F&
 : " PtRm Q(vm\q:w S ™ žYrsut\ž’š(vTsuž’œq*¥0N K4ƒ[T F KU% } ;'
X+.

¥ [ NK4ƒV¿]\_^ 0

ì ígð â

à:Œ M è

í NK4ƒV¿KåT

»AåXWa `

x P$#TA"(T
+-;2V,2-+-/ ‚+3
"#,8",+3FY,231O6,2-1  "#2-"#$(
"#6>FgaKU%V˜j1$#
Q
 T,+-,  >,2.+-/8+3FY,231 6,2-1B"#2-"#$(
U+3
"#,dFGã¼8 W6K
 "P,+-N ; N$#T
$#2.2-"#$\

 "#+3*2-
+-2.+-$#+3
+-"##% } ">$#9+-
+-LF!,+-L  ,2-+./H;6P,+-P ; P$#
7$("
">Sovn sužYr(m\s!rž.Ÿq;psuvTtm\% x UŒ3 «'’ T
 "X
 j"("#
5f +-Q
+-$
"#6d,"(
 T6*FY5C 2-+-/d6+.Q
+-$(
W2-"#W;6H"64+3
WFGf"(Q
+.>'
+-/
 "ZT*9:"( Fz+g{"*2-"(f+-],?;"#2.6 &9
!
 "#+37$ "#,"*6"(f
7 ;A"
 "W"#Q
+->
+-H:"(
+-"#!9:'A"WF[
 "W23
+-"(
@+-/
"##% “&+-A"k"\
z+-/
"## T2-
+-"(
i+-/
"#5'"X,>92." QC +-/ Û í NKªÃXbƒV¿

÷HíNKªÃXbƒV¿ ¿ ¿

,+-&—Û í NK4ƒ\êÛ í Nbƒƒ ÷4íNK4ƒ

ÛíNK0ƒ
BÛ'íNbƒ

÷4íNK4ƒÑL÷HíNbƒ

ÛíNK0ƒV¿NÛ'íNbƒ

÷ í Nbƒ

Û í NK0ƒ
BÛ í Nbƒ

I|"W$H"f
 "f,+-d ; H$#
@+.H'+-"(
1dF‚bk#1#% ¢

} "8,+.4 ; O$#
!'T+g6"#fS$#$#
"8"#Q
+->
"8F 
"H
+-2fFZ
 "O6+-Q
+-9
+-KFZ2-"#0+-cKU%ªx B$#C

Q$(
+-fb@+3
 7
"#$ +.{"(b@ +.$ Z$($#'
"#2317"#Q
+->
"V
 "

"6fFT
 "i6+-Q
+-9
+-,u"% /%- "#6W9+."#6Z +-Q
/,Œ Ž‘'Gƒ\ b5">$L$ ;'$(
"\+.'
"#k
 "fFG"#{T"#$\1 }  6+-Q
+-9
+-& T9
56"#5Z+->$# Q$(
+->b@+3
 0Z"(
z+./C ;
"%WI]"*$#U
 "("\FY"*$#,
"8,'+-"(
1UFz"(FY2 +.FY>
+-U9:
X
 "f;'
"fFi! Q+-&%

£ +-A"(U*"#"#*92.$#"79:"(
yb5"#"#0
b5*?;"#2.6# b5"Z$H$#,
"
 "+-2-2+-T
"\"#$(
+-H+-1>
+.,"(#%jIK +-2."7"\
!"#"(92.$#"7$H'T+.6"7+-FGC >'
+-L9:
7b@ "(
 "\8
yb5H*23
+-"(
7 ;A""(2.+-/H23C "## i+3
6"#
'+.6"01|+-FG>
+-E9:
*
 "d*23
+3C 2-+.$(+-
y1|Fk
 ","#2-"#,"#
7+-]
 ",23
+-"(
%0x |>1O$"## [bz" bz2g6O2-+-A"8
d ;A"Z
 "823
+.2-+.$(+-
y1H+-FG>'
+.&%Z„f"\C 2-" bz2.64
 "5 Q+-O9:"7"(C’
C—" ;"(C’
Cy>1 W>1d
 >1;§dxyF[+3
@+-@"% /%i"f
>1 T+-@+3
7 f
,Ž ‚ W
,Ž³ Z f


»÷PußêRK4ƒV¿Kå&À »åXWa Y À ¼*À

^+-$#"O"$ N,2-Z " M]íNK0ƒ>+-HL˜j"(2-2-+f;6 +.92." b@+3
 O;,"(
"(fˆVŒ ÷ í ’¼fƒk¿Øå_FG7"$\ På: :b5"8$S"#Q
+->
" ÿ N K0ƒ\ b@ "("
 "!¥4N K0ƒzb@+-
 ¥4

I]"U$E?;;6E2-2!?"#2.6>b@ +-$ B"#"#*92-"O];'
+-$#2.d?;"(2g6 µ % &% 'S+./
 "f{T"(1» ÄÅÆ Å#ÇÈ(*)Î Æ Å\ËÇ(Å*)Î Æ Å+*)Î,Ê ÅÆ Ç-.ÌÈ/ 102% 34-.`Ä5 
_Ï  z Í 6(785Ä  
_Ï  z Í 9:) Å  7Î Æ Å(/Ë Ç#>Å =@? AB?B Ï zC É (7AÎ Æ #Å =@? DB?

Ï 5É ; 2Å 3g< (7A,Î Ê ÅÆ =@? E$?T

Ï 5C É  7,Î  /Ë 
F=G:)4Î HË : Ï 5I

É (7A,Î  'Ë #"$+ Æ =J:)4Î HË #" TÆ

À ß0æ9K

¥0NK4ƒV¿VUjˆ['Œ ÷HíNK4ƒ[¿K叿

d

I|"*$O$#,
"Z
 " ™ žYtmw(suž’œqHFj
 "X +-& &+u% "%Z+- +3
H"(C’
C—" f"(C’
Cy>1 @>1TC—
C—>1 k;6

b~>1;§c^T:"0bz"O"H/+."#R
 "4*23
+-"(
+-/
"(B F K¨;e 6 b>% } "(& [FG"#{T"#$\1L6+-Q
+3C 9
+-MF!
 "4"(2."(,"#
G F K b@ +-$\ O Q+-Eb@+3
f

b Y"#:"#$\
+."#231+ b¡b@+-
9

K4ƒ5+-@/+-A"#091 ÿ NKSÀ bƒV¿ ¥H

à:Œ M

U ^

í NK0ƒi¿Kå.gjà:Œ é í N K0ƒV¿aé í Nbƒy »AåhWN  í à:Œ é í N K0ƒV¿aé í Nbƒy

^

Y

I|"*$P$#,
" ™ žYrsutž’š(vTsuž’œq ™ my›m\q ™ m\q:wm7F K ÿ NK4ƒ8;6 I  b ’6MT+-$#"0A"(AƒZ91L$#,+-/ ¥0 ÿ¥0N KPÀ bƒ\ z"% /%K91M$#,;'+./P
 "#+3>,"R2-"## +-/@  iHjf
"(Q
 "(
$%

d

I|"0$R"#Q
+->
"0
 "@k#œžYqBrž4l'mF$#,
+-/7
 "W"(
k+-/;
"WF‚
 "!{AC—/ "(
% } " {AC—/Ð"("#92g$#"WF[
bz"(
X¼`;60½ +-#»

Y

60+-X"#Q
+->
"6d9T1 à:Œ ÛíQN Š!‹GŒfF ¼ Mh’¼Wƒƒ[¿aÛíN Š!‹GŒfG ¼ Mª’½*ƒƒyYÂ\è ì â ñ ò ò ò ñ ^+-$#"8bz"$#,
"yŠ!‹GŒf¼FMh’¼Wƒ@9:"\FY"*$#,
+-/>+3
W"\
+-/
" bz"!$#>Q
"À Š!‹GŒfF ¼ Mh’¼Wƒ#Àzb5"#2-2z
 "!{ACy/ +-/
"% } "("(FY"b5"$#S"#Q
+->
"
 "+-
 "W"#Q
+->'
"6dFg"{"#$(1d6+-QC
+-9
+-HF_?;"(2g6 µ % &% 'U+-/

v Ê-ÌV{ ÌÈzÇ-. ÌÈ/ 102% 34-. v :wxB Ä5iÄ5  ;  Å23gÅd"#2.
"6]91S 4 >2-2:
QFY>
+-%je!b5"#A"\ +3
@+-kFg
"#0
 "W$"f
 ;'
5
 " "(
7F5{AC—/,!Fz"8?;"#2.6O½~"du2./"(2-1ƒ!$(
+-"#6S+-U
 " "(
7Fk{AC—/,WF5
 "\f?;"#2.6O½çYFYZ"(,2-" +3Fz2."#f+- ?;"(2g6P½~$#
+-]0FY"(b¡"(T
>$\ $(
"(# [8"$#,:"6SF 2-"#jFG¡?;"#2.6>¼K$
"(;
"#6>b@+3
 >2-"#zFg¡?;"#2.X 6 Ž7ƒ\%[I|" "#$2-2zFG ^T"#$(
+-MŽ%- 4H$(2-"dF@"(FG25:"(
+-"#8F@"\
+-/
"(#% I|">$M6"(
"(,+-">{AC—/c"(
$(
+-,"(T
8+./H
 " {C—/~;2-/WF_¾ Þü\ý 6d¾ ý‚üÞ ¢

2.3 Substring Resemblance

) 
9"#&>+-
+-"#6f9T1W6+3–"("(T
/A+-'
# _9
f+-DÙy
"(T
;2-2-1O+-,+3C 2.'Ú>b5#1#%5„X"(,2-" 6
9;@ "  ,+-/ T
@Q
"Z$#Q
,"( â ,"#k+-4*?;"#2.q 6 ‚[vr„s ƒ7po>m5+-4
 "WFY>F
… “‚Q
‰f," ;„_+3Q
C ‰W, " †- _b@ +-2."06'
9X "  ,+-/ 
ZQ
"d$#Q
,"(8;,"#Z+. j
yb5?"#2.6# ‡‚pr„s ƒ7po>m@6 6 ˆjžYtr„s ƒZpo,m\% € 
 "(@$#,,d$(C $("#$#"j+-FY_kA"(1X
X A"V"(T
z
"(T
_:"#6"6 '"#:"#6"6 +-"\
"6|+-T
H
 ">,+g662-"%O„*"(,2-"  ,+./ 
*Q
" â ^T$#+.2‚^"#$(+3
1,T9:"(i+-d
 "XFG>B
…3666TC 66Cy666 6 †. b@ +-2-"  j "#Z
 "FY>~
…3^^666TC 66Cy666 6 †[uFg
"#|
 ">66+3
+-2
"\
@ @$#T
"\
C—:"#$(+-?$f,"+-/Aƒ\% „_+-6+-/7 Q+-P
 !+-Ob@ +-$\ U
 "ZA"\1!Q
!9:"8$'
"#;'
"6
QFG,"6 @d9:
 E+.>A"\1B6+3‹,$#23
 k9:"($"O
>
"6

+-4
"#Q
+-/,6"#@
@+-$#:'
"Z
QFG,#%ixy
k+-@Fg
"#4
 " $#"5
 ;'
[ T>$*+g6"#
+3FG1Z$#,,Z;'

"(_+-Z
bz!?;"(2g6 ;67>T2-23176"\
"(,+-"[
 "V
QFYH% } +-‚$#"#_+-_2.9: +-
"#+." kLO?;23
"(+-/|,"($\ +- +->"("6"6L
|"#2-+-,+-;'
" ?"#2.6kb@ +-$ U"79T+-2314:X>
$ "##%

ï

¾ÿ   zÑE¾ ÿ

} "!*23
+-"(
j+./;'
"#5$#>9:"@Q
"6,+-d86
9;"X+-/ *$\ "#>*+-,+-2.X

 ;'
@"6>FYX
 "W"(
X+./;'
"## "% /%-

v
wx  Ä5jÄ 
Æ Å(ËÇ#Å.Æ ÅÊ ÅÆ HË:y 'Ë#"$Æz v Ê-ÌV{ ÌÈR%

À Š!‹GŒf¼FMh’¼WƒÁhŠ!‹GŒf¼GMª’½*ƒ#À À Š!‹GŒfF ¼ Mh’¼Wƒh à Š!‹GŒfG ¼ Mª’½*ƒ#À

¾X¿

¾ÿ

I|"z$"(Q
+.>'
"5
 "5Fg"{"#$(1*6+-Q
+-9
+-F:
 "

Q+-4"#23
X+-/ à:Œ M]íNK4ƒRM]íNbƒi¿Kågzà:Œ éíNK0ƒV¿aéíNbƒy »å_Wa  à:Œ é í N K0ƒV¿aé í N bƒy

„_+-;6+./09Q
+-/>+-,+-2.+3
1O9:"(
yb5"#"(S
yb5>?;"#2.6W+.f06+-‹C #$ 2-
_92-"#D9:"($"5F
 "i T/"iT*9:"(‚F9Q
+-/[F
 "
bz?;"(2g6kb@ +-$\ 0Q
k9:"7$#,"6% €
y1+-$2$ 4FY "6$#+-/7
 "!$#,2-"(+3
1F
 "X92-"# +-z
Z,>+-2-"#!Y
1+-$2.231 T• å –—’ƒ\% } "8Lr Am\s—w±8H F  é[å 8ƒ\ +-

3±- ¬ Ä5­:©{*I(78 ¬ Ä­

{*I:) ;  Å3GÅ=@? DB?ÏBzÉ (A7 Î, Ê ÅÆ =@? E$? Ï 5  Éf(A7 ÎiÄ®8
²=J*) Î Ä®
 2.5 Finding Keys

x 86"(V
f6"(
"(,+-"z
 "zQ
$(
"5Ff6
9" b5"k"#"6
,6"(
"(,+-"X
 "f,+-+->2:A"(15FY!"#$ 0
92-" "% /%j
6"(
"\C ,+-">+->'1|A"(1TC—+->'1P"(1|+->'1|A"(1TC’FY"#+-/MA"(1

Q+-E
 #%]I|"d+.,2-"#,"#
"6|O2-"#A"#23b@+-"HA"(1]?;;6+-/S2-/C +3
 h+-,+-2g'z
‘  ³:pq:m@Œ Ž’%z^+-$#"@k2-/+3
  +-z9,"6 91 } " b5"5
"j2317
 "z+-/+-?$
i6+-–"\"#$#"(_9:"(
bz"#"#* +-,2-"#,"#
'
+.#» I|"'",+-T
"\"#Q
"6O231S+-]A"\1# 
82-2VFY$(
+-2i6"\C :"#;6"#$#+-"##% } "("(FY"Ub5"U"#6B|$\ M+-,2-"(0;6 ,"7//"(+."*+-/$#;6+3
+-% ¢

} "f"#@8:"#$#+.2?;2-"fQ
$(
"!
$($#"#2-"(
"f
 "fA"(1 ?;;6+-/Z$#"(#%5©W5FG
b5" ˜z"#2-2-> +.k+-
"#6"6
 9:"4E"+-2-1R:
92-"0/ä"#+.6+-/SM
 "d$#2-+-"#
>$ +-"%j•j"#
+-/>1>2g'/"7?;2-"74
 "f$(2.+-"#
X"#"#, +.6+-92-" @+.Q
"6Wbz"j9,+3T
{-ÌÈVÉ5Ê Ë ÈÊ-ÌÇÈ:{"(+-"#

 "76
9;"%

êë#ë#ë#Oê }˜>“•”Aƒ â } 
0+-# W|"(
$\ BF8|A"#$\
d+-4|$#2-2."($(
+-NFZ6  "#$(
+-#% } "š™ 6+-Q
$#"49:"(
yb5"#"(EA"($(
X   ;C 6  j ⠙ j  â ê/ j ƒz+-!j+.>'
"6>9T1>
 "WFY$(
+- ¢

é[偐*ƒV¿Ø}˜>“

™› j  â êO j

ƒi¿

”

ž œ ï íGð

—é[偐 â

ƒ(Œ ôu;ú|é[偐

j

ƒ(Œ ôuGƒ j Âå

â yx 4X2-+-$
+-& bz"7"7+-
"("#Q
"#60+-4
 "@Q#¯YŸtQpo Ÿmw(s—œt ™ žYrs—pq:wm\% } "!{C—/ "#$(
zF_7?"#2.6d+-kZ>2-+-’¼ ƒ\Oê Š!’¼ ƒƒ_+-j+-,N «#Oê «ƒ_$#?:6"#$(" j j â +-
"(2&;h 6 ™ N Š!’¼ ƒ\Oê Š!>’¼ ƒƒ\% j j ⠓+-A"X
 "W{AC—/ +-/;
" T
 "X{AC—/¡A"(
$ >$>9:"X"6
8?;6>+3kF&?;"#2.65b@ +-$\ 0"!
"(T
;2-231>+-,+-2g'%[IK +-2-"W
 " {AC—/ +-/
"U"#"#"#

 "4"(
>FZ{AC—/,,+-=P?"#2.6
 "4{AC—/ "(
$\ |"("#"#
8
 "d23
+-"(
*F!{AC—/,*+-M ?"#2.6 } "z{C—/`"(
$\ Z+-_
 "\"(FY"z
 "j,"j6+-$(+-,+-;
+-/ ,>1Z9:"#$#"k+3
V,""k+-V9;"#6
 "k6+-Q
+-9
+-F ?"#2.6H2-"##% } +.!$U9:"8,:+3
+-A"Zf"#/
+-A"*

+-9
" 6"#:"#6+-/*4
 "W
1:"fFV"$ H9:"#+-/6"% ‡ 2-+-A">{AC—/ç+-/;
"## V+3
+-86+3‹,$(23
*
H6"(
"(,+-","(
$(
+-,"(T
f+-/0{ACy/®"(
$\ "##%8eWb5"(A"( &A"(
$ "#7'" ,>92." 9:"(+./2-+-"'!$(9+-;
+-#% } "8{C—/~A"(
$ "(X$#H9:"ZQ
"#64+-4
 "Z6
9"Z+-/
 "7$\ "#>»

¬ 5Ä ­:.
{*
Æ Å(ËÇ#Å.Æ ÅÊ ÅÆ TÄ®8
!Ä®/"$TÆ % I]"W$0?;6,
 "7{AC—/ A"#$\
X6+-Q
$#"WFgJ8;
+-$#2. ?"#2.6 µ % &*% '
W2-2
 "\_?;"#2.6[+.8
 "z6
9;"5+-/X
 "i"#23
F5
 "*FY2-2-b@+-/S{"(1L’;6P6+-T+g6+-/491Så: ‚
 "#S
T+./0
 " {"f
\ƒ\» ÄÅÆ Å#ÇÈ(*)Î Æ Å\ËÇ(Å*)Î Æ Å+*)Î,Ê ÅÆ  Ä t ©  7Î Ä ®" TÆ ¯°*)Î Ä ®/"$Æ %O0 (7AÎ Ä ®/"$Æ ¯°:)Î Ä®"$Æ %R%

3. MINING DATABASE STRUCTURES

} "U
2.4"#"#
"6E+.=
 "O"#$#"#6+-/M"#$(
+-D2-2.b "
*{T+-$\T231>6"\
"(,+-"X$#,:"#
zF&
 "f6
9"fQ
$(
"% ©W$("*,,>1dFV
 "86
9"8 ;W9:"#"#U$(,
"6 
 "\1 2-2-bØ
 "Z"(!
>9,+3
X9b@+-/d{"(+-"## :$\ Oµ  ´,±pskžGr sG±mWr(m\sjLœ P(A/m SH r P(œt!sG±žYr@s—pAš#n.m\ F  ¶_±psiœsG±m\tVzm(n ™ r5±2 p ŸF m Ÿpn vm\r sG±pskptm7ržGožun-ptWs—œ>sG±TžGrV5m(n ™ § ©W"i$*2-W"i
 "#"V
2-_
!fFG
 "\[{"#Q
+-[9:
Q
$\
">Fk
 "06
9;"%S„*"(,2.· " ´,±ps7œsG±m\t>s—pAš#n.m\r kœžGqds—œZsG±TžYrks—pAš#n.m ¸ ©  ¹rksG±TžYrzm(n ™ p8wœoW›œržGsymfLœ P@ps ¶jœ*œt@o,œtm 5m(n ™ r*žYq]pq;œsG±m\ts—pAš#n. m ¸Ux U
 +-!"#$(
+- bz"
2-+-" bØ
 " FY2-2.b@+-/P
 "#"4{T"(+-"#$E9:"0{+-$231MQbz"("6M+-/O
 " +-/
"(W;60"(
$\ "##» ¢

„_+.6+-/! Q+-H
 #% ¢

„_+.6+-/$#,:+-
"f?"#2.6#% ¢

„_+.6+-/ "(
"(/"#"#k
92-"##%

3.1 Finding Join Paths

£ +-A"#Z>
92-"¦Z b5"*b52.6P2-+-A"*
d?;;6S2-2[bk#17+-Pb@ +.$  
 "(
92-"d¦Bº5$#U Q+.Lb@+3
 L¦Z%]„
 "\ _b5">b52.6L2.+-A" 
"#Q
+-$(
!f'

"#
+.4
f Q+-X+.TA2-+-/,A"(1@F[¦Z ¦ º ; 9:
 %[xy
z+-5$#2-"z
 ;
jb5"!$dQb5"(z
 +-5{"\1+-/8
 "X"\
+-/
"(!uj*23
+-"(
i+-/;'
"#ƒV68
 "k2.+-Q
jFA"\1[F:
 "
92-"##%  %k„_+.6L2-2k;+3F@?"#2.6_»N¿®¼½iêx¼+½ º ƒH$\ |
 
8
 " ;+3k kZ +-/ d"#"(92.$#"+ ¼¾½S+-@7?;"#2.6,+-d¦Z ;6h¼ ½ º ¿ ¦Z% +.X*?"#2.64+-0¦ º:¿B ŽT%kˆ[
+3
+-c»N+.
|»½2Àê#ë#ëëx»½¾Á8 jb@ "("4"$ »½¾Ã,$#C
+-z2-26>231
 "X;+3zb@+3
 ,?;"(2g6jFg
92-"#i¦ ;6>¦íQ%

½¾Ã ’Aƒ>„@"#$ 0A"\1X¨ ½ F_
92."X¦N$ d
 
@2-2?"#2.6k+- ¨~½O"X+.9»½¾Ã ;6$#>9:"@>
$ "6*b@+3
 d6+3–"("(T


%k„X"$\ 0;
+3
+-Z»

?;"#2.6XF_¦ í %

+u%X©W

U2-2:+.92-"E>'
$\ +./UFX¨~½ b@+-
 ?"#2.6>F7¦ í 6#b@BFGÄ  » ½ Ã0$\ E
 ;
d"$\ ?"#2.6PB F ¨~½E+.Z>'
$\ "6Ob@+3
 L46+3–"("#
7?;"(2g6 F_¦ í %

u9:ƒ>„_+-;6O2-2VA"(1F¨ ½à Fz
92-"*¦ í $\ U
 ;'
Z2-2[?;"(2g6 +-6  ¨~½¾Ã@"Z+-‘  »½j ;60"7>'
$\ "6>b@+3
 U6+3–"("#
?;"(2g6kF[¦Z% ˜i1+-/8*23
+-"(
i+-/;'
"## +3
j+.j:+-92-"@
Z"#2-;
"k
 " Q
"(/
 8F
 " Q+-&%[x—
‚
 "jA"(1G¨ +-_*X+-/2-"j?"#2.6 '
 "#7
 "

+-d+."#Q
+->
+->,"(
 T6i6"#$\+.9:"#6>+-d^T"#$(C
+-]Ž% Žd'"2-+-$92-"%fx—FiA"(9 1 ¨ ;W*23
+-2-"Z$#,:"#
# bz"f$
@"X
 "j +-H+-Û ÅxÆ#Y¦@ë ¼8êQ¦ º ë ¼fƒ89:">
 "d+-Å/Æ(Y¦Xë ¼ZêQ¦

º ë ¼Wƒ ^ ì ^ ígð

ŽFÇȁY¦ º ë ¼8ê ¦Xë ¼Wƒi¿ ì Gí ð M í Y¦ º ë ¼fƒ à:Œ Û í Y ¦Xë ¼Wƒi¿NÛ í Y¦ º ë ¼fƒy â à:Œ Û í Y¦@ë ¼fƒV¿NÛ í Y¦ º ë ¼fƒy

â ^ +-,+.2.'2-1 76"(?"P
 "|+-
"("#$(
+-`6D$#'A"(/"|F¦ º ë ½ T b@+3
 =¦@ë ½>% } "(Bb5"U$="#Q
+->
"OK:"(9:;6MB
 " T9:"(kF_
2-"#@F_¦a
 ;'
kb@+.2-2&9:"5 Q+-"60b@+3
 4¦ º 91

º ë ¼fƒ àÛ>Åx#Æ Y¦@ë ½>êy¦ º ë ½ƒ\ê º ë ¼8ê ¦Xë ¼Wƒ\êxŽFÇȁY¦ º ë ½>ê¦@ë ½*ƒ

,+-uàÛ>Å/Æ#Y¦@ë ¼8êy¦

ŽFÇȁY¦

3.2 Finding Composite Fields

€ #$ ,,,92-"#¡+-d?;6+./k Q+-59:"(
bz"#"#,
92-"#5+-46+3FGC FG"("#
>6
9"#4’;6LFG
"# jb@+3
 +-M
 "d,"06'
9;"'ƒ*+-
 
f
yb5>?;"#2.6W,+-/ 
f$(
+-O
 "8,"8+.FY>
+- &9
W+. *2.+-/ T
23106+3–"("(T
kb5#1Pu+u% "%- "!?;"#2.60+-XdsutQpq±r P#œt\opsuž’œq>F 
 "(\ƒ\%]©!FG
"(& [
 ",
QFY>
+-MFG ",?;"(2g6|
OC 
 "(X+-TA2-A"(@:"(;6+-/X"#:"#;6+-/* 
k
"\
Zu"% /%j $(Q
,"\!+.6"#
+-?"(G  …g ³²«  †9:"#$#,"(G  …3•! #³²A«'.  † ƒ\% } "8{AC—/ +-/;
"8;60{ACy/~A"\
$\ 0,>+-"#@'"7"(FG2FYX+.6"(C
+3Fg1+-/
 "f+-,+-2.+3
10F_
 "#"7;+3#% ©!
 "(k?;"(2g6d
QFG>'
+.X"Z,"f$#,2-"(%j©W"f$#C ,$#,2-"(Z
QFY>'
+-,+-ib@ "#,!?"#2.6+-,"5
92-"@+-i $(,:+3
"!F‚
yb58k,"!?"#2.6z+-0
 "\5
92."%i„k"\C 2-"*$(Q
,"\#  † X;,"7,+-/ 
X9:"8Q
"6U<  … ef,+.6 € >6p+ † +-,
 G " ƒ7po>m[?;"#2.6F
92-"X¦Z  ;6,B  … ef,+. 6 †h 6 … € >6p+ † +-
 F " ˆjžGt\r„s ƒ7po>mi;_ 6 ‡&pr„s ƒZpo,mV?"#2.6# "#:"#$\
+."#231 F:
92-" ¦WŽ% ^T9Q
+./k"$ 86Z+-6"(+-/k+-_@6+-‹$#23
_92."(a+-Z/"(C "\2u%_IK +.2-"Vb5"V$
_+.6"(T
+3Fg1f"($#+-"#231fb@ +-$ f?;"#2.6&$#*9+-"
U>A",
 "( _bz"d$#|">
 ",:"(
+-"#*Fk
 ">{AC—/ +-/;
"4
ST6$#"HO>2-2@T*9:"(8Ff$#;6+.6
"(b@ +-$\ ,+-/ T
@$(9+-"W
FGÐ
 "f$#,:+3
"f?;"#2.6%  % £ +-A"#4?"#2.66¼& Ž%@„_+-;6f
 "i"(
‚F?;"#2.6_¤Rb@+3
 8X +./ 8{C—/N"#"#92.$("
9  ¼]6Ob@ ",{AC—/,f"*2./"(2-1P>9"(
7Fi
 " +-4?;"(2g60¤% T%@ˆ[
+3
+-]¤ +-
4¤ ½2À ê(ë#ë#ë#ê¤ ½Á b@ "\""$\ P¤ ½ ÃW$#C
+-Z2-2z;6O2-1O
 "?"#2.6f+-|¤ 6#b@PFg
  92-" ¦ í % %@„!"#$ H;'
+-
+-U¤

½¾Ã

’Aƒ € 662-2:$#9+-
+-jF_Žf5,"k?"#2.6iF&¤H½¾Ãi

 "7$;6+g6
"f2-+-Q
GŽ*%

‘T% ¶ ,
 "f"(T
+-"#@+-šŽª;64
!91,T+-/%

¶ "#$2-2Fg ^"($(
+-0ŽT%- @
 ;'
ibz"!$#>6"\
"(,+-"5b@ "\
 "(©¼ â +-W2./"#231O,9"(
WF
¼ 914+./4¾. ÿ É À ü ÉLÊA% ) "#:"#6+-/,H
 " j ,+-+-K2-"#A"#2AF;{AC—/a"("#92g$#"V"{+3"6WFGV6,+-+-
!  ¼& 
 "kT9:"(VF&"(T
+-"#i+-X  ŽN,+-/ T
i9:"@A"(1*2./"%Vx 
 +- $" &
 "*T+-/dQ
"#P+-7$(+3
+-$2VFGZ"#"#
+-/00"\FY2["\
FV"#23
!
,
 "Z"\%X„
;
"(2-1 
 "("8"8"#A"\2_+-,2-" 9
f"(FY2_T+-/d "(+-Q
+-$#Z+.2.92-"%8„_+3Q
 _>>2-2-"(7"\
Fk?"#2.68+-8,",2-+."#231]
H9:",+-
"("#Q
+-/H
 L02g'/"("% ^"($#6 ‚
 "$#,:+3
","(
8Fk?"#2.6Z$P9:"A"6P91O
 "(+- {AC—/Ð"("#92g$#"WX
 "#+3X{AC—/~"(
$\ 46+-Q
$#"7FG ¼  ¶ "#$2-2z
 
8
 ">+-/
"d*A"(
$ LF@
 "0{AC—/,ZF@
 " +-4F‚
yb5*?"#2.6k+-@"+-231d$#,
"6,FG
 "W+./;'
"f A"(
$ ]F5
 "{C—/,fFk
 "
yb54+-6+-T+g6;2i?"#2.6ƒ\% } +-6 $#9+-
+-zF?;"(2g6jb@ +.$ >+-$(""!
 "#+3j"#"(92.$#"@
y¼ u6"($("",
 "#+3{AC—/çA"(
$ |6+.Q
$#"ƒ8*$#,;'"6S

 "W+.6+-T+.6;2?"#2.6@,+-/ 
k/+-U+-0T+./% ¤ ½¾Ã'À Ë. } "i2./+3
 DQ
"#7Aƒ:"#{T+3"#&
+-,"[:
+-2A
ZÀ H 23
 / *+-Z$(
+-$#"j
 "j

b52.689:"i2-+.,+3
"6f
@"(
‚b@+3
 
*,Q
Z"% /%H
 "("?;"#2.6#% } U;6"\Q
;6Ob@ ;'
*
 ",

+-9+-2.2-+-/*Q1Q
"#,j
89:"(

"(z:
z
 "!>2.2:9+-"( >"(
% } "("Z"#{T+3"*66+-
+-;2&
92-"#Xb@ +-$ O6"#$(+-9:"Z
 " 9+-"#_$(Q
,"\#%V^ 
231W
 "("'FG
"( 
 "i$#,176"#$#+.6"(
Z–"(z 231'
"!2gz5d23
"(;'
+-A"X
7
 "@?"6+-$#" 2.&% € "\bª
92-"+-866"6U
0
 "6
9"b@ +.$ P"($#6 ,T6"(Ð/"7FYX
 "f 231d
"7$#Q
,"(#% IK +.2-"81d+-/2."*6' QQ
,"#
k

 "Z6'
9"ZQ
$(
"7+- +-,2-"!
*6"(Q
;6 'FG
"(X82-/*"{"#$#"WF‚
 "#"76' QQ
C ,"#
,
 "O6
9"SQ
$(
"O$K9:"#$(,"S{+3
"U$#,2-"(% ©!FG
"(& _
 "#">Q
$(
"#'">
6$(,"#
"6 [6P
 ">6
 231Q
WW$ "(>>:"(XQ
X6+-$#'A"(X
 "#~91>
+.2[;6 "(% eWbz"#A"( :+3
W+.!:+-92-"8
d"7
 "Z:"(
+-"#fFi"(
W+-/;'C
"@
*6+-$#'A"(5
92-"#zb@ +-$\ 0"!2.+-A"(2-1
*9:"X "(
"\/"("## 642.
 "j +-XF_
 "f "\
"(/"#"#@;'
+3
+.@F‚
 "W
'C 92-"%  % £ +."#0
92-"f¦Z

ŽT%k„X"#A"\1d?"#2.66¼HF‚
92-"f¦

’ƒ0„_+-;6h»V T
 "X"(
kF‚?"#2.6jb@+3
 d +-/ >"#"#*92.$#"!
 ¼&%

u9:ƒ>ˆ[
+3
+-¤»]+-
H2»½2Àê#ëë#ë#êx»½ Á  b@ "("Z
 "7?;"(2g6 +-4"$\‘

»½¾ÃX"Z2-2‚;6d2-1>
 "7+-4
92-"f¦í%

½ Ã#

u$ƒ0„@"$ µ»

+u%X©W

z2-2:>'+->29"(
X¼ ê#ë(ëëx¼Î7f$\ â
 
WÀ ¼X! Á ¼ í y Á ¼ ª À+-5>2-2’ <   ÏEô*¤Ð~ÏR÷P%[;6 "$\š

¼íV+-!6T#b@4FGJ6+3–"("#G
»½2Ñ%

Á ¼'íX Á ¼xªÀ$09:"f6"W+./8+.,2-" ) "(
"(,+-+-/Z
 ;'
ZÀ ¼ZX "\
"(+-SFz"(
7+-/
"(Y"#$2.2j^T"#$(
+-]ŽT%- 'ƒWF ¼& T¼ í ;6 ¼xªT +u% "%i9T1d$#,
+./

” 4.

ð

ï âñ ò ò ò ñ

ì

à:Œ Û

”  ¼:ƒi¿aÛ ”  ¼

BELLMAN

í ƒV¿DÛ

”  ¼ ª

ƒyGÂ(è

I "Z"86"(A"#2-+./dlWm(nYn opq ,6'
9"Z9b@"(XFYW$#C ] 2-"(76
9"##%[˜z"#2-2->7'T+.6"#
 "V;26'
9;"j9b@"( FG$(
+-X$ UW,{"\1d
2[6H$ "#>89b@"(%@˜z"(2.23C >]2-4$#2.2-"#$\
8?2."(7Fz
 "6
9;" [6SQ
"#f
 "(" ?2."(+-L
 "d6'
9;"0+3
"#23Fy%L­HT1]FX
 ">?;2-"#8b@ +-$\ ˜j"#2-2.>O$#2-2-"#$(
Z'"*+-,2-" :FG7"\,2-"7
 "ZT*9:"(XFi
C 92-"#V+.!
92."(;$(" A
 "kT9:"(‚F:b@j+-!
92." A
 "5TC 9:"\VF6+.Q
+-$(
i68T2-2T2-"#[F;"$\ 8?;"#2.6%V˜j1Z$$\ +./W
 "(" ?2."(X+-d
 "76
9" 
 "\10$#49:"W+.
"($(
+-A"#23106+-2.#1"6
,
 "7"(%kI]"8 A"7FY;64
 
!"#A"#4
 +-!+-,2-"7FY$(
+-C 2-+-
y14/"
2314+.,2-+-?"#5
 "Z6
9;"7"\2-
+-H$#"(#% ˜j"#2-2.>H2.$#2-2-"#$(
k
 "W,"W$(,2-"(>?2."(@6+-$#"#6 +-R
 "H"#T+.,"#$\
+.`uA"\1# z2-
+-"(
+./;'
"## X{AC—/ +-/;
"## [;6S{ACy/ÖA"(
$ "#ƒ\% € 2-2_?;"(2g6,u"% /%- _T,"(+-$ 6
" ;6!?"#6C—2-"#/
 fQ
+-/ƒ"V$#"(
"6W
k+.92."\Cy2-"#/
 Q
+-/0?;"(2g6f9:"(FG"?;2-+-/%*I]"* A"+-,2-"#,"(T
"#6Ud+3C "\
1dF_
2-*’+-2.92-"Z £ ‡ xjb@+-;6b@X$#2-2.92-"Z91d9

 $(2.+-$ƒ[b@ +.$ ,2.2-b=
 "k"(V
Z{"(1Z
 "k+.FY>
+-,+-
 "(" ?2."(W+-OU+-
"($\
+."Zb5#1%@„!"(,2-" ;"7
2[2-2.b@
 ""(W
d"#2-"#$(
8,?;"#2.6UFz,
92-" &;6U
 "#U?;6U2-2V
 "( ?"#2.6&+.f
 "i6
9;"i
 
& ;A"Vk +-/ f"("#92g$#"% } "V
C 
X+-W2-A6"6H+-O
92-"8b@ +-$\ U+-;6+-$
"#@
 "7?"#2.64;," 
 " "(Q
+.>'
"64"#"#*92.$#" ;;6d
 "7"#Q
+->
"#64+-T
"\"#$(
+-O+-'
+-& +-$#2-;6+-/W
 "5FG"{"($(1*6+-Q
+-9
+-,F
 "5?;"(2g6 
 " "(Q
+.>'
"6* +-U+-;
+-$#+-
"X+.,
 "V +-& ;6
 "XFg"{"#$(1 6+-Q
+.9
+-BF7
 "* Q+-="#23
% } "U"(d$K2-L9,+3
$#"6R{T"(+-"#*
O
 "PuC—?;2-"'ƒZ6
9;"4
]6"(
"(,+-"
 "W$(
;2;+-
"("#$(
+-06f Q+->+-]+- ´ '0+-/ ´ ) ˜k•D
H$#$#"# P©!$#2-"6
9;"%Z˜z"#$"˜z"#2-2->O+-f+-T
"(;6"#64
d9:"* "#+-231+-Q
2.2-"6$(2.+-"#
 b5"k>6"z
 "56"#$#+-+-
W:"(FYh2-2F
 "5;231+-# A+-$(2.6+-/X
 "j?2-"z$#,
'
+-& 
‚
 "z$(2.+-"#
% I]"7FY;64
 
´ >6 ´ ) ˜k•a"ZFu'W
d2.bØ;6H9//1 FGW$(
2&" b5"fbk
"7
 "Z;231+-!$#T6"7+-O•kÑ7ÑØ+-/
 "f© } “|Œ T (2-+-91
*$#$#"#j
 "X6'
9;"%j© } “U+-58•kÑ7Ñ bk:"(>b@ +.$ B +.6"#
 "U6"(
+-2.>FZ6'
9;"O$#$("#"#0;6 b@ +-$\ 0$0"W"(A"(2$#"#$(
+-0,"(
 T65+-$#2-;6+-/,© ) ˜k• ;6S©7•zx\%I|"Z9
+-"6U/T6S:"(FG>$#"Z+-/d˜z"#2-2-> |0«³³U­4 
+-/H
 ",+.2.2&u+u% "%. Ž ‘ ÌØj2-"#ƒ\%i”[$("#
iFY
 "("6
>:+-
# :
 "‘³C—,2-"*"(Q
+.>'
"*+-792-"*
d6+.Q
+-C /+- d9:"\
b5"("#>>2-2u ,"#6+-¡62./"W+.
"("($(
+-# Tb@ +.$ +-k/T6d"#/ ,FGk
 "!:"WF&?;6+./8?"#2.6zb@+3
 d+-,+.2.' 2-"##% } "U ³³C—,2-"d"(Q
+.>'
">+.*92-">
O6+-Q
+./+. L+-C
"("#$\
+.0+-9:
k²³*"($#6k+-/Ž‘³C—,2-"f+-/
"( Ø  ³A«¬R?;2-"6B?;"(2g6#%hI|"U"#:"'
"6B
 "U
+-,+-/|
"#Q
4 M˜z"#2-2->N+-Q
2.2.'
+.D+-Kb@ +-$ N2-2fFY0
92-"#$#"(4b5"(" ?;2-"6 _;6SFG;6U
 ;
7
 ","{"(1U"{+-"(Z9:
8³ "#$#;6X+-/>‘³C—,2."7+-/;
"#X4 ŽA²,?;2-"6>?;"#2.6#%

5.2 Estimating Join Sizes

x Z["(T
["(:"(+-,"#
 b5"j"#2-;
"j
 "j9+-2-+3
18F
 "j2-C
+-"(
@+-/
"f
*"#Q
+->
"W
 "!Fg"{"#$(1d6+-Q
+-9
+.4F_
 " 2-"#+-8z?;"#2.6% € 
 "#"["#23
&b52.679:"i6+3‹,$#2-

@"#"(T
T+-;2-231 Abz"X+-Q
"6"!,+-T
"\"#Q
+-/7T1»_"#Q
+->'
+./f
 " +-'
"5
 "zFg"{"#$(1*6+-Q
+-9
+.$#$#'
"#231% â } "W6
fb5"!"6+->z"\:"\+.,"(T
i+-z"#+3
+."!$#:'
" 6'
*b@ +-$ H$
@9:"f"#2-""#64

 "f92.+-$%

Error in intersection size estimation, 50 samples 0.8

Error in estimation

0.7 0.6 0.5 Error in Join Size Estimation, 100 samples

0.4 0.3

1.4

0.2

1.2

0.1 0

0.2

0.4

0.6

0.8

1

Resemblance

ÓBÔ±ÕÖT×¾ØeÙÚtÛÜÝ>Ø×Þ>ØßÝ#ԄàÜÂÞ#Ô±á8ؑØ.Þ>Ý>ÔpâZã+Ý>ԄàÜ:ä:å+æ¤Þ>ãâZç è±Ø.Þé

Estimation error

1

0

0.8 0.6 0.4 0.2 0

Error in intersection size estimation, 100 samples

0

0.8

0.4

0.6

0.8

1

Resemblance

0.7

Ó Ô„ÕÖ5×ØZìÚÝ#Ôpâµã+Ý#ԄàÜ:ä ÙææëÞ>ãâZç è„ØÞé

0.6 Erro in estimation

0.2

0.5 0.4 0.3 0.2 0.1 0 0

0.2

0.4

0.6

0.8

1

Resemblance

Ó Ô„ÕÖT×¾ØëêÚ!Û/ÜÝØ×Þ>ØßÝ#Ô±àÜÂÞ#Ԅá8ؑØÞ>Ý#ÔpâZã.Ý#ԄàÜ*äBÙææeÞ>ãâZçHè„ØÞé Error in join size estimation, 250 samples 1.6 1.4 1.2 Error in estimation

I]""#"6S
 ",",¸¬06ç;+3ZFz?;"#2.6f
 
7bz"("  "6L+-|
 "d+.
"("($(
+-M+-'
"6P
 "(+-X Q+-R+-'
"0F
 "k Q+-U+-
 "6
 :+-T
i+-
 "7 ³³C—,2-"# +->+-'
"%[xy?;/"#z‘T Abz" 2-
‚
 "V;6 Q
"6 #³³C—,2-" +-Z+-'
"i/A+-Q
_
 " $(
;2; Q+.P+-'
"# '",
 ">6'
H:+-
Z+./+3?;$#
231|9:"#2-b
 "
"#;6P2.+-"%4I]" 2-

 "46 QQ
"6L"#Q
+->
"#*+-B¸T% € 23
 / L
 "("0"0Q
+.2-2 "(A"(2X +-/ C—"(>"(Q
+.>'
"#>"#A"#EFg
"(>
 "46 Q
,"#
 z+. "(A"(1E$"Ob5"S"S92-"U
|$#"($(
231="#Q
+->
"U
 "U6"\4F >/+-
6"fF[
 "z +-H+-2.2&;$#"Z+-/
 "7,"(
 T6 6"#$(+-9:"64+-PŒ- #¬’%z„
 "(," bz"Z6*
X"#"6d
*Q
"f
 " $(
;2@2."#,F!
 "0,Q
Fg"{"#
,2-"(# 5+-Q
"6Rbz"H$ Q
"k
 "#+3j ; 2."##%V˜5"6,V"#2-
# 
 "_ Q+.,+- '‘2Ìd%,I|"*"#Q
+->
"6
 "U{AC—/ "("#92g$#"4+-/]{C—/ +-/
"(>b@+3
 N‘³  #³³T  '‘³ Ž³³T ;6*Ž‘³!,2-"## 6*2-W$#,
"#67
 "z"($(
"("#92g$#"79:"\
b5"("#0
 "7;+3@F‚?;"#2.6#% I= "#]?;6+./H+-,+-2g'?"#2.68+-/O{AC—/,# _b5"d">+-
"(C "(Q
"6L+.MU+-,+-2.+3
1L,"#",'
 "(*
 ;MUT,"\+.$,2-" $\ >j
 "k+.
"("($(
+->+-'
+.O"(u$#,"6H
,
 "8$\
;2_"("#C 92.$("'ƒ>+-d2 « Ì +-B
 "S‘³'Cy,2-"O"(:"(+-,"#
 @6KŽT#  Ì +.
 "4 '‘³C—,2-","(:"(+-,"#
% € $($#'
"#231P"(Q
+.>'
+-/U{AC—/ "("#92g$#"*+-7"+-"(7
 S"#Q
+->
+-/d+-T
"\"#$(
+-P+.ÖHÞ>Ý>ØðZñàÔòÜcÞ#Ԅá8ØZØ.Þ>Ý>ÔpâZã+ÝØä Ùæ+æeÞ>ãâZç è±Ø.Þé

Estimated vs. Actual Q-gram Resemblance, 50 samples 1

Estimated resemblance

1

0.8 0.6 0.4 0.2 0 0

0.2

0.4

0.6

0.8

1

Actual resemblance

Ó Ô„ÕÖT×¾ØCõÚ6öyóRÕ×¾ãâ÷×¾Ø.Þ>Ø.âšø è„ã+ÜHßؤØÞ>Ý#ÔòâZã+Ý#Ô±àÜ:ä|å+æCÞ>ãâµó ç è„ØÞé $",
 ">+-A"(",FX:+.92-"02-"(8+-*$ ]>2-2."\%HI|" $N$#$#
"#231E
"#2-2!
 "O6+3–"("#$("U9:"(
bz"#"#K2./" X,"6+-H 60>2.2"#"#*92.$#"f+./,‘³C—,2-"7{ACy/Ð+-/;
"%

5.4 Q-gram Sketches

„_+-;2.231 Tb5"!"#2-;'
"!
 "W$#$($\1>F[{AC—/ A"\
$\ "##%V„
 +-["(:"(+-,"#
 bz"k"j
 "z,"5"(
VF;¸A«@;+3VF?;"#2.6_
 ;
b5""6S+.S
 ",{AC—/ +-/
","(:"(+-,"#
%*I]""#Q
+->
"
 ! " ™ j 6+-Q
$#"Z9:"(
bz"#"#H
 "7>2.+-'
"6]{AC—/çA"#$(
*6+-Q
$#",+-*2.

"6]/A+.Q

 "W$(
2&{ACy/ A"#$(
X6+-Q
$#"f+-H„_+-/"7²8FG!‘³C—,2." "#Q
+->
"(# i;6P+.M„_+-/"O ³4FY4 ‘³C—,2-">"#Q
+->
"##% € 23C
 / |
 "O '‘³'C—,2-"d"#Q
+->
"#* ;A"dU$\ P2.bz"(,"(
 ;U
 "‘³C—,2-"*"(Q
+.>'
"## 
 "*‘³'C—,2-"*"#Q
+->
"#!$ "6+-231R6+-Q
+-/+- E9:"(
yb5"#"(R>2-2’ j,"6+.H V6L2g'/"U6+-QC
$#"##%7I]"$#$#2-;6"*
 
f231P‘³>,2-"#7"8"{+3"6UFY {AC—/~A"#$(
@A"(
$ &% I|"8
"*
 
Z{AC—/ A"#$\
Z6+.Q
$#"6P{AC—/Š"#"(C 92.$#"X"k'
 "(z6+3–"("#
j6$#,2-"#,"#
18,""##%_x  „_+-/"Z   Abz"@2-
V
 "@$(
;2;{AC—/ªA"#$(
56+.Q
$#"@/A+.Q


Q-gram vector distance vs. g-gram resemblance Estimated vs. Actual Q-gram Resemblance, 150 Samples 1.4

1 1.2 Q-gram vector distance

Estimated resemblance

0.8

0.6

0.4

1 0.8 0.6 0.4 0.2

0.2

0 0

0 0

0.2

0.4

0.6

0.8

1

Actual resemblance

Ó Ô„ÕÖT׾ؚùÚØ.âšø è„ã+ÜHßØ_ØÞ>Ý#ÔpâZã.Ý#ԄàÜ:ä:Ùå+æ‘Þ>ãâ‘ó

çHè„ØÞé

0.2

0.4

0.6

0.8

1

Q-gram resemblance

Ó Ô„ÕÖT×¾Ø}ÙÙÚIöyóRÕ+×ãâÿýØßÝà×ëðHԄÞ>Ý>ãÜHß2Øfý5Þé
óLÕ×¾ãâ Þ>Ø.â‘øHè„ãÜHß2Øé

×¾Øó


 "X$(
;2;{AC—/ª"#"(92.$#"kFYz
 "!¸«W;+-jF?;"(2g6j"6 +-f
 "V"(+-"(:"(+-,"#
% € 23
 / 7 +./ C’"#"#*92.$#"[;+3 "7
@ +./ Cy6+-Q
$#"f+3# ;
 "(b@+-"f
 "("7+-k2.+3

2-"Z$#"(2g'C
+-H9:"\
b5"("#4"#"#*92.$#"7;646+-Q
$("%

Estimated vs. actual q-gram vector distance, 50 sketch samples 1.2

5.5 Qualitative Experiments

Estimated q-gram distance

1 0.8 0.6 0.4 0.2 0 0

0.2

0.4

0.6

0.8

1

1.2

1.4

Actual q-gram vector distance

Ó Ô„ÕÖT×¾ØuûÚüö@óLÕ×¾ãâþýØ.ß2Ý>à×JðTÔòÞ>Ý>ãÜTßØsØÞ>Ý#Ôpâµã+Ý#ԄàÜ:ä¤å+æ Þ>ãâZç è„ØÞé

Estimated vs. actual q-gram vector distance, 150 sketch samples 1.2

Estimated q-gram distance

1 0.8 0.6 0.4 0.2 0 0

0.2

0.4

0.6

0.8

1

1.2

1.4

Actual q-gram vector distance

Ó Ô„ÕÖT×¾ØeÙæ5Ú!ö@óLÕ×¾ãâÄýØßÝ>à×XðHԄÞ>Ý>ãÜHß2Øä(Ùå+æëÞ>ãâµç è„ØÞé

x a
 "|"#T+-O"(:"(+-,"#
# fbz"L ;A"|"(Q
92-+- "#6`
 ;
 >2-2[,>+-"#f'"‹,$#+-"#
fFYf
 "*:"Fz"\2-+-/
 "0Q
$(
"4F7O2g'/"O;6M$#,2."\M6'
9;"%EeWb5"#"(
 "Z{"#Q
+-HF[b@ "(
 "(@
 "7,>'+-"#@$(
2-231H "#2-H+-4
 " "(2-
+-H$#"#XQ
+-2.2&"#"#65
9:"ZQb5"\"6% } "!6'
f"(
zbz"!"XFGz"(:"(+-,"#
j+-z$(?;6"#
+.2$#:C 
"!6'
 7bz"X$#
56+-$#j1;
+-$#2.k{"(1*"(23
#% eWbz"#A"( Xb5"S$a6+.$(H+-K/"("(2f
 "S"(FG2-"#0F8
 "
2-#%

5.5.1 Using Multiset Resemblance

€ A"(+-PFk˜j"#2-2.>Pb@ +.$ S ;79:"("#S"(2."#"6P
0"#A"(2 "\j$#2-2."($(
5;6Q
"#j*23
+-"(
i+-/;'
"#iF2-2?;"#2.6Vb@+3
 
H2."#Q
PŽ³R6+-Q
+-$\
U2-"#|’L"(Cy6 Q
92-"|;',"(
"\\ƒ\% ˜z"#2-2->,$(
+-jf
2FY5{"(1+-/W
 "k2-
+-"(
j+-/
"(
H?;6]2.2i?;"#2.68b@+3
 LH,+-+-*¨u"(Q
+.>'
"6;ƒW"#"(92.$#"
>/+-A"(H?;"#2.6% } "7"#23
!+-W6+.2.1A"64

 "7"(W+-O
'C 92-"Wb@ +-$\ 0+.$#2-;6"#@$#2-,5+-;6+.$#
+-/
 "f"#Q
+->
"#6>"#"(C 92.$#" A"#Q
+->
"6+-
"("#$(
+-,+.
"6W +-FG"#{T"#$\1 6"(:"#;6"#$#+-"## 60"#Q
+->'
"6* Q+-H+-;ƒ\%V˜z"#2-2->  † V9+-2-+3
18
f{+-$T2-17;68+-T
"\$(
+-A"#231Z?;6

+-/ C’"#"#*92.$#"k?;"#2.6j ;59:"#"#>Z6+-Q
+-$\
52-;92-"!FG"
" 60 @2-"60
"#"(2"(:"#$(
"606+-$#'A"(+-"##% } "\"'"+-"(
y1HFi
 "(W,"(
 T6@FG!?;;6+-/f Q+-;92-" ?;"(2g6#% ©W"U,"(
 T6B+-0
L:"(FG
 " +-& !9
H6+-/L +-7$#$#"(
9231O2.b7% € 
 "(7,"\
 T6U+-f
42-UFYZ?;"#2.6 b@+3
 R
 "0,"4,"%LxyM"(2-'
+-# zb5"4 A"dFG;6
 ;'
& +-;92-"@?;"#2.6['"#231 ;A"k
 "k,"k;,"7’6Fg
"#d6 
X"#A"#0 ;A"f+-,+-2.X;,"#ƒ\% € ,"X +.Q
+-$'
"6,,"(
 T6*+.i
7$#2-2-"#$(
57'+."\
1*FFY"'C
"(dF7
 "H?"#2.6 @$ =d
 "O6'
P
1:"HF7
 "H?;"(2g6 k
 " 2-"#/
 OFi
 "Z?;"#2.6 
 "8;
"*Fj
 "Z$\ $\
"(f+-U
 "Z?;"#2.6

u2-"(

"\# @9:"(# z$(

+-;ƒ\% } +-0,"\
 T6M+.>"6B91 Q 1Q
"#,0b@ +-$\ a?;2-"|6
9;"(# 7
1+-$2.231aU"#
+- FG,+./
+-/HH2."(/A$\1L6'
9"SŒ- ŽT i jŽ¬'’%U„_+-"#2.68b@ +-$\

A"U+-,+.2.'4FY"#
"(H", ;6/"6B
L9:"U+-,+-2g'%heWb5"(A"(
 +-0
1:"OF8?;2-+-/M+-H$#"#
+-92."O
|Fu2-"|:+3
+-A"#4;6 FY2-"]"#/A'
+-A"##% } "O"#KFG4
 "HFu2."S:+3
+-A"#0+-0"#T+3C 6"#
>u"% /%,
yb50?"#2.6Z,+-/ 
7$#
+-||C—'A"(2.+-/0"(
F[
"#2-"# "8T9:"(ƒ\%[IK "#0
 "Z6'
9;"Z$#
+-X?FG
"#"#
 ;6=?"#2.6# f"(2.+-,+-;'
+-/RH>1BFu2-"]:+3
+-A"#HH+- :+-92-"f+-k$(+3
+-$2u%j„;2-"f"#/A'
+-A"#5$0$($#kb@ "#d8?;"(2g6,+- :2-2.
"6Sb@+3
 P"\:"($(
"6U2-"## &"% /%d?;"(2g6Ub@ +-$ ]+-7C :"64
,$#T
+-O4 ³,6+-/+-
!A"(1d,+-/ 
X$#T
+-U"#
+."(x j7$\ *Ùy"#Ú _Ù 7A"(1Ú &Ù eW,+.6 € >6+-Ú "(
$% } "5?;"#2.6"("#,
!$#
+.2- T,"\+.$j6'
 A;67
 "\"(FY"5+-[
_"#"#
"6 W*>
$ d
,8?;"#2.6db@+3
 ] #³,6+-/+3
X"#
+-"##% ^T,",Q1Q
"#,Zb@+-2.2@'

"#,
Z
U$#2.+-Fg1L
 ">;'
">F@
 " 6
T z"% /%L;," i66"## i
"#2-"# "0T*9:"( ["(
$%=Œ AT @‘'’% } +-d
y1:"UF7,"U"(2."($(
+-A"UFY"'
"O$B "#2-B
L"#2-+-,+-;'
" FY2-">:+3
+-A"## &9
7+3
ZQ
+.2-2i–"(fFg
 "92-"#,fFz
 " FG"
"A"($(
fA$\ %7x O66+3
+- 
 "8,"(
 T6H+-WFg/+-2-" ÍPb5"423bk#1,"#"#ä
P"($#
"(>O"(bÐ6'
OFG>
+.R "\2-
+-#%JeWbz"#A"(0b5"]
"O
 ;'
H9:
 NF*
 "#"S
y1:"# Ff?;2-+-/P"0"(FG2@6 Q$(
*
S
 "0?;2-+-/S
"#$ +.{"( 6+-$#"60+.0
 +-@;:"\%

5.5.2 Using Q-gram Similarity

,>+-"#Lu9:
 D+-/;'
"#P6DA"\
$\ "#ƒ } "M{ACy/ ?;6O?;"#2.67b@ +.$ L'"LÙy
"(T
;2-2-1P+-,+-2g'ÚH
U0
'/"(
8?;"#2.6šÍ
 
j+-# 
1+-$2?;"(2g6*2."#i2.+-,+-2g'j
7
 "k >*"(1"% € {AC—/ç+-,+.2.'+-
y1P{T"(1OFg
"#]"(
Z42-/H2-+-Q
8Fk+-,+-2. ?"#2.6k’[+.[2-+-A"#2317
! ;:"#Zb@ "#>  ³³³AÑB?;"(2g6V"5?2."#6;ƒ\ 9
5A"#6091>+-,+.2.'+-
y1% } "W?"#2.6k+-0
 "W"#2-
@2-+-Q
!"fFGC
"(E"#>
+.$#2-231L"#2.
"6L
S
 "d
'/"(
,?"#2.6%M„,"(,2-" 0{"(1U
d?;;6U?;"(2g6f+-,+-2g'Z
Hš  {‚Ê NÈ €?;"#2.6U"(
"6O>1 
 "(j?;"#2.6z$#T
+-+-/Z$#+3
1;,"## T9
z2-8?"#2.6z$(
+-+-/ 66T"#"#,;6]?Q
6|2.Q
,"#8FX:"#2-"% € {"(1P P?"#2.6P$#T
+-+-/Hx ˆD66T"#"#7"(
"6O
 "\ZxQˆa66T"# ?"#2.6# [9
*2-O,"?"#2.6Z$#T
+-+-/H?"#6P:+-
*9:"( b@+3
 4
 "#"Z6+-/+-
@FV"#$#+-+-HFG
"\!
 "76"#$(+.>2u% ˜i1U+-/, +./ U2-"(C’"#"#*92.$#"7?;"#2.6!FGŠ
 "7"#23
F8|{AC—/ +-,+-2.+3
1B{"(1R;6B'+.6+./||6
]"\2-C '
+- £ ‡ x\ b5"8$O2-231U>"8"\"#;6+.+3
W6+-$#'A"(+-"##% „Z"(,2-" ‚,"Fz
 "*?"#2.6fFG6S
09:"
"(T
;2.231S+-C +-2.
O
 9 " {_Ê NÈ €0bz"("42.9:"#2-"C 6 {-.Ì/È 34€%|©WL$#2-"\,"(,+-;'C
+-& '
 "#"V?;"(2g6_$(
;2.2317$(
+-"#6dwœvTqps Sz,"#i’6f>1 $(
y1S;6O$#+3
1O,"#f"+.6"(T
+-$2gƒ\% } "{C—/®+-,+-2.C +3
y1U{"(10OUxQˆ=66T"#!?"#2.64"(
"6H?;"(2g6H$(
+-+-/ $(2gQC •B"(?"(jF&
 "!x ˆL66T"#"#fu+u% "%- 
 "@?Q
57$(
"(
5F
 "7C—$(
"(
Xx ˆE66"("#ƒ\% I]"X
+-"6
 "#"f{AC—/ +-,+-2.+3
1d{"\+."(# ;6,"#"(2:
 C "\# +-/,9:
 O{C—/J+-/;'
"#W6U{C—/JA"(
$ "##% €  $#|9:""\:"($(
"6 &b5"FG6S
 ""#23
ZFz
 ",{"\1PP
 " {AC—/çA"(
$ "#7
H9:", +-/ 231S
/"(
"6 ‚b@ +-2-">
 ">{"(1S
 "7{AC—/~+-/;
"#k
9:"f*$ d2-"#X% € 2.,Q
X2-2F_
 "

+-/ 231OA"6H"#2-
f"\
"#6S91H
 "{AC—/ÖA"(
$ ]{"(1 bz"("8 +-/ 2-1d"#2-"#
 ;9
@
 "Z{"(1d,+."#6H"#A"(2‚+-
"("#Q
C +-/O?"#2.68"(
"6|91P
 "0{AC—/ +-/;
"%SI|">$#$#2-;6"
 
!
 "#"Z
2-7'"*$#,2-"#,"#
'1 ;;6U9:
 O'""\FY2‚+. *9b@"(%

6.

j

CONCLUSIONS

I|"f '"f"#$(
"("#60>1>$\ 0"(,2-"##%

x U
 +.W;:"\ bz" '""(2-"6H
 ""F!o*žYqS±pr±>+./C ;'
"#z6UrLAm\s—w±m\rV
Z,>'+-A"
 "(Ð4+.
"f9+-2.6+-/*92-$\,FGX6'
*,+-+-/{"\+."( f
 "VQ
$(
"iF@2.'/"j;6f$(,2-"(W6'
9"%i­H1f$ {"(+-"#8'",:+-92-" _bz",:"
 "(",6P/+-A">2-/+3
 , FYW"(2.
+-/*
 "#H% } ">?;2-"#8b5">$#2.2-"#$\
,Fk
 "06
9;"d 2.6|9:">>2-2u FYW"\‹,$#+-"#
WQ
/"*;60FYQ
f{T"(1>"#:"7
+.," 9
@2./" "#/ P
H/+-A",$($#'
">Qbz"(#%,I|""#2-;
"#6S
 "*
6"\C –R9:"(
yb5"#"(|,>'1O+.N?;2-"#0
 "S6
9;" f$$\ "#0
 "S"\C 23
# ;6H'T+.6"#X+-
"($(
+-A"Z"#:"#X
>
 "Z"(% ‡ "\ F;˜z"#2-2->* ;A"VFY;67
 "z9+-2-+3
1Z
!6+-$#'A"([?"#2.6‚b@+3
  +-/ "#"#*92.$#"7
>9:"*"(T
"#,"(2-10"\FY2‚+.U
 "*6
,"(2-
+- $("##%

7. REFERENCES

Œ3 \ ) % € $\ 2-+.
#% ) '
9"(C’FG+-"#6231d;6~ "#$(
+-#% x   ;Ž³³T % Œ ŽZ‰*% € 2- ;ˆ_% £ +-99:# ;;6U­P%;^%&%­H'
+gW;6% } $T+./W Q+-U64"#23FGC- Q+-U+. :;6H^:% } /"\&% € FG"+-9+-2-+3
1 Q
;61d;64:"\FY>$#"WQ
;61dFV6"#:"(;6"($(1d+-FG"("#$("% x  5tœw 5¹qs’n
‚iœ>q P 8ps—p 5qTŸžYq:mm\tžYqŸ ;;/"#X¸A# ‘ ͸   ²¬²% Œ ‘ *%˜z · % ) "# *T & T;64^%;^#b5/+u% € 
>
+-$2.231d"(T
$\
+./Q
$\
"fFGÐFG"#"7
"(T
66T"#"##% 8ps—p kqŸžYqmm\tžYqTŸl@vnYn.m\sužYq Žuƒ\» Ž# « ÍTŽT Ž³³³% Œ ¸' € %˜jT6"\%©W0
 "W"#"#*92.$#"Z60$#
+-,"#
@F 6$#,"#
#%xy‘  ¹ V‚iœoW›;tm\rržuœq|pq ™ ‚iœoW›;n.m°žYps S0Lœ P Rm Q(vm\q:wm\r ' ;/"#!ŽTx  ÍŽ² _ #²²A«% Œ «y  '[%;•z "# ;„z% ·  ‰*% · ;6# 6H^%;­4
 TT+- ;% ^"#2-"#$(
+-T+3
1d"#Q
+->
+-4FYW9:2."#O{"(+-"##%x   ;/"#!ŽT #¾ ¸ ÍŽŽ‘ &Ž³³³% Œ ¬'*•!%;•z2-+3FG
& ;”@%eW>& 6 € % ¶ "#
 ;2’%”[:"(+-"#$#" b@+-
 H$#*9+-"#60$ 4
,'

+.9
"(C—>'
$\ +./ $(! "(
"(/"#"(!6'
9"##%x ‘  ¹  ´HœOt rQ±œ\› œq 8ps—p m\opqsuž’w(r & ²²«T% Œ ²'8”@%;•z "#&%;^+-'
+.4FG,"(b5db@+3
 2-+.$#
+-X

+3
+-A"7$#2-"Z60"$ ;9+-2-+3
1% ‚  ;‘‘T’Aƒ\» /  ÍA‘T V ²²«T% Œ3 ³' € % ) A& ˆ_% ) ,+-/# ;;6 € %ef2-"#1% ¶ "#$#$#+-2-+./ $\ "#>5FV6+-
"f6
8$#"##» € >$\ +-"(C—2-"+-/ A$\ %xy 5tœw ¹  ‚iœ#q P - /"#f‘³#² Í‘Ž³ Ž³³T %



 





  

 

 



 



  



 

  

 ! #"$%



Œ3  ( € % ) & ˆ_% ) ,+-/# ;;6 € %“&"(T1%“"+./$#" 6"($(+-
+-4FGW6'
+-T
"(/
+-&%;xy 5tœw 5¹qs’n ´4œOt rQ±œ›LœI q ³&±š m ´Um#š8pq ™ 8ps—pAšpr(m\r &Ž³³³% Œ3 Ž'8”VAA"7^Fg
b5"% T

» ††'bkbkb7% "#A"#FG
ybk"% $(d†T% Œ3 #8”VAA"7^Fg
b5"% ) 
?2.+-/,64>+-/ 
 " "#"#
+.2?Q
XQ
"#0+.H6
*,+./
+-H;6d+-T
"(/
+- ' Q"($(
#%



&» ††bkbkb7% "#A"#Fg
bk'"% $#d†'6Fu†'bk
 ) ˆj­P% 6TF Ž³³³T% Œ3 (Ze*% £ 2- 6# ) %„_2-"#$(& ) %;^T ; ; 6H”k%:^T+.,&% €W´€!µ » € 4"(T
"#+.92-"Z6
*$#2-"+./
2u%:xy 5tœw ¹  ‚iœ>q P . ;/"*‘²³ Ž³³³% Œ3 ‘'*^% £ /2-1 ˆ_% £ +.99:#+ &%­H'
+g# 6 € %;^+-2-9:"($ ;'
pq ™ q;2 œ ¶@n.m ™ Ÿm fžYr\w2 œ Ÿm\/t S ŽTQ 'ƒ\» ¾ ² ͐A«T ‚ ²²¬% Œ Ž<  &%eW 
2. ´ % · T+-"# ˆ_%ˆ_T 6 e*% } +."(&%”V‹,$(+."(T
!6+.$("(1dF_FG$\
+.;2 6"(:"#;6"#$#+-"#X;64'+->
"f6"#:"#6"#$#+-"#k+-/ ;'
+3
+.#%x  5tœw 5¹ ¹qs’n
‚iœ#q P _œq Zps—p 5qTŸžYq:mm\tžYqŸ ;;/"#!²#Ž ÍAA³  _ ²²¬T% Œ Ž'8ˆ_%xy;6T1: T‰8% · ;6# :;64^%­4
 T+- % } "#;6 +-H>+-A"!
+.,"W"(+-"#W6
"\
X+-/A"\
$\ "##%xy ‡ Wlk /"(W¸¾ ͐A«ŽT Ž³³³T% Œ Ž‘'<  &%x +.6+-X6 *%ˆ_2.%:e!+.Q
/Cy9"6 2-
+.@
,6+-A"\"76'
9;"Z"#Q
+->
+-H92."(,#% 8ps—p 5qTŸžYq:mm\t\žYqŸ,l@vnYn.m\sužYq  ¬’ƒ\»- ¾ ³ Í ¬T i #²²‘T% Œ Ž¸7IØ% ´  U6 ´ %;“&+-;6"#Q
#%”VT
"#+.@F 2-+-$ +3
+-/k+.
,* +-2-9:"(
X;$("%xyC  ‚iœ>q Pm\tm\q;wm žYq Pœ ™ m\t\q q:pn SržYrZpq ™ 5tœšpš(žun žYps S /"(8 #¬¾ ² ÍTŽ³¸  ²¬% Œ Ž«' *% ·  1TH;6 € %^"(
 %:^T"#>
+-$f;64$ "#>'
+-$ +-,+-2g'+3
+."(X9:"\
b5"("#46
9;"!9T Q"#$\
#» € $#T
"\
C—9"6 $ &% ‡ Wl œvTt\q;pn ‘Tuƒ\» Ž«¾ ¸ ÍT³ [ ²²¸% Œ Ž¬ · b@2-"6/" ) +-A"\%T T

» ††'bkbkb7% Tb@2-"6/"6T+."(% $#d†% Œ Ž² ) % · T
 &$ % ³&±m tskLœ P•‚iœo!›;vTsym\t 5tœŸtQpoo*žYqTŸ œn :œt\sužYqŸ4pq ™ :mptw±TžYqŸ% € 66+-0I|"(2."\1 & #²A«T% Œ ³*^% · ,"(X64˜!%ˆVFY +./"(%;”V‹$#+-"#
!"#$ HF[Q
+-/ ;'+3
2_6"(
"(,+-;'
+-#%x  5tœw 5¹qs’n
‚iœ#q P Vœq

  



 #"$%

 



 #"$%

(' )

&

* + 

,

' !



$

 

-' )

 ! #"$%

.



/

  



' !







 

0

 1 2$



,

3' )  , 





2  

%' 465

7

-

/

 $

q:2 œ ¶@n.m ™ Ÿm 7žYr\w2 œ Ÿm\t*pq ™ Zps—p UžYqžYqŸ /"#XA«Tx  ÍT«¬   ²²¸% Œ  \*^% · $ +-&%©!$#2-" ;T69:$Z;6069;Ž'C—$#2-+
"(,2.
"f2-+-9'1 /,,"(# † k/+.6"%

T

» ††'bkbkb7% /"#$#+3
+-"##% $#d†'$\ +-:†
2g† ,"% 
H% Œ AŽ*­P%;“"#" e*%“& } %“&+-/ ;;_ 6 &% · %;•z2-"+./>6'
*FY ,+.+-/;6>bk"( +-/%x  ktQœw 'sG±  ²²²% Œ '7IØ%;“+‚;64^%;•z2.+3Fg
&%:^”j­4x ‰ } » €
2&FGX+.6"#
+3FG1+-/ 

+-9
"f$#"(:;6$#"#X+.4 "(
"(/"#X6'
9;"# +-/"#2&"(
bzT#% 8ps—pdpq ™ q;2 œ ¶@n.m ™ Ÿm kqŸžYqmm\tžYqTŸ ;Q ƒ\» A¾ ² ͬ &Ž³³³% Œ *­4"(
/"#+30x $% 

&» ††'bkbkb7% ,"(
/"#+3% $#d†' ,"% &% Œ A‘ ¶ %­4+-2-2."\ “i%ef# ;6H­P%e!"(;;6"( >+-/X{T"(1d6+-$#'A"\1%xy 5tœw 5¹qs’n :‚iœ>q P ‡ Wl@ ;/"#!«>« ÍT¬¬ Ž³³³T% Œ A« € %­4/"% } "f?;"(2g60>
$ +-/*92-"#H» € 2-/+3
 , ;602-+-$
+-#5 % ¹ Zps—p kqŸžYqmm\tžYqTŸl@vnYn.m\sužYq ŽuAƒ\»- #  ÍTŽ³T &Ž³³³% Œ ¬' € %­4/"864ˆ_%;”V2-&% } "f?"#2.60>
$ +-/92-"#H» q P € 2-/+-
 ,@6H2-+-$
+-#%;xy 5tœw 5¹qs’n
‚iœ# q:2 œ ¶@n.m ™ Ÿm 7žYr\w2 œ Ÿm\xt S0pq ™ 8ps—p OžYqžYqTŸ  ²²¸T% Œ ²' € %­4/"864ˆ_%;”V2-&% € 0"(‹,$#+-"#
6>+-C—+-;6"(:"#;6"#
k2-/+3
 ~FYf6"(
"#$(
+-/ +->'
"#231462.+-$'
"76'
9"7"#$#6#%;xy 5tœw ¹ —´HœRt rQ±œ\›|œq Xm\r(mptwh ± ¹rrvm\r7žYq Zps—p OžYqžGqTŸ>pq ™ q: œ ¶@n.m ™ Ÿm 7žGr(w2 œ Ÿm\xt S _ ²²A«T% Œ A³'*^%;­4
 T+- &%”VQ
+->
+-/9:"(5F_'"72."# U6
*Q
"#,# ;Ž³³T %^T9,+-

"#6,FG!92-+-$
+-% Œ  \*•!%;ˆ['"#
W;64^%;^;$#$#"#+-"(
%x "#X;64A$\ "# FV6
9"Z+-
"#/'
+.&: % ‚iœoo _Lœ PfsG±m ‚ O  A—‘ƒ\»- ¸#¸ Í; «¬ V #²²¬T% Œ Ž8”@% ¶  ~;64e8% ) % ) 
*$#2-"+./»zˆV92-"#,@;6 $#"#
X$ "## % ¹ Zps—p 5qTŸžGqmm\t\žGqTŸlkvnGn.m\sužYq ŽuAƒ\»-/  Í;   &Ž³³³T% Œ A' *% ¶ >4;6 ´ %;e!"#2-2-"(Q
"#+-&%;ˆ_

"(kb@ "("#2u» €  +.
"($(
+-A"Z6'
$#2-"+-/Q1Q
"#H%xy 5tœw ‡ Wl@ Ž³³T % Œ Zx\%;^T+->64ˆ_%;„_2.$\ %:˜z

C—d+-;6$(
+-0F FY$(
+-2&6"#:"#6"#$#+-"#5FG~"#2.
+-#%;x  5tœw ¹ q:2 œ ¶@n.m ™ Ÿm 7žYr\w2 œ Ÿm\xt S>žYq 8ps—pšpr#m\r /"(Z «¾  Í; ¬‘T  ²²% Œ ‘ ´ %:^T$\ 2-+.,,"\%”V‹,$(+."(T
2310+-;6$#+-/,6"(
"(,+-;'
+-#» € $#,2."\
"764Q1Q
"#>
+-$f"'$\ H2-/+-
 ~
 ;
X"# +-/%xy 5tœw ¹ q;2œ ¶@n.m ™ Ÿm 7žGr(w2œ Ÿm\xt S>žYq 8ps—pAšpr(m\r :/"(fŽ¬  ÍTŽ²³ _ #²²T% Œ A¸'8ˆ[% j+-2-+g6+.# '[% z/"# ;^%^T+.6:2-# ‰*% · #1T+.6+.# ;6 } %;^"#2-2-+-#% €!¶X· } ©7^» €
2&FG 6
*$#2-"+./>6d
QFY>
+-H+-U6
*b5"# " "#T+3,"#
#% 8ps—p 5qTŸžYq:mm\tžYqŸl@vnYn.m\sužYq :ŽuAƒ\» ¾  ÍAA¬ Ž³³³%

 8:9 2;< ,

.



 !=?> @' )



  

' )

$

 #"$%



A 

    1$

-

/

1/

B 

1/

2



7

 

, )$

A 1



 ' )

/

-



  ,;,3, / &

&

2  ;, ,3,

2