4XHU\ /DQJXDJHV IRU 6HPLVWUXFWXUHG 'DWD
0LFKDLO 3HWURSRXORV
&6( '(3$570(17
2XWOLQH
8Q4/
± 4XHU\ ODQJXDJH IRU XQVWUXFWXUHG GDWD ± 83HQQ $&0 6,*02'
/RUHO
± 4XHU\ ODQJXDJH IRU VHPLVWUXFWXUHG GDWD ± 6WDQIRUG -2'/
06/
± 0HGLDWRU VSHFLILFDWLRQ ODQJXDJH ± 6WDQIRUG 9/'%
:HE24/
± 4XHU\ ODQJXDJH IRU GRFXPHQWV GDWDEDVHV DQG ZHEV UHVWUXFWXULQJ ± 87RURQWR ,&'(
6WUX4/
± /DQJXDJH IRU TXHU\LQJ DQG UHVWUXFWXULQJ VHPLVWUXFWXUHG GDWD ± $7 7 /DEV $&0 6,*02'
8Q4/
'DWD 0RGHO
5RRWHG HGJHODEHOHG GLUHFWHG JUDSK ODEHOHG WUHH
± )L[HGGHSWK DUELWUDU\GHSWK F\FOLF VWUXFWXUHV
,QIRUPDWLRQ UHVLGHV RQO\ DW ODEHOV /DEHO W\SHV LQWHJHUV VWULQJV V\PEROV ([DPSOH WUHHV
{ { {},C {}},D {}}
([DPSOH F\FOLF VWUXFWXUHV WUHH PDUNHUV
X 1 where X 1 = {A X 2,C {D,E X 1}}, X 2 = {B X 2}
8Q4/
&KDUDFWHULVWLFV DQG ([SUHVVLYHQHVV
7UHHWUDYHUVLQJ SDWWHUQPDWFKLQJEDVHG ODQJXDJH 7ZR W\SHV /DEHOV DQG 7UHHV $ WUHH LV D VHW RI SDLUV RI ODEHOV DQG WUHHV 4XHULHV GHILQHG HYHQ RQ F\FOLF VWUXFWXUHV ([SUHVVLYH SRZHU RI UHODWLRQDO DOJHEUD RQ IL[HGGHSWK VWUXFWXUHV 7UDYHUVDOV RI DUELWUDU\GHSWK WUHHV FRQWUROOHG E\ UHJXODU H[SUHVVLRQV RQ SDWKV 5HVWUXFWXULQJ DELOLW\ DW DUELWUDU\ GHSWKV $OO TXHULHV FRPSXWDEOH LQ SRO\QRPLDO WLPH
8Q4/
6HOHFWLRQ 4XHULHV
([DPSOH *URXS E\ & FROXPQ RQ 5
select {x (select y where R2 Tup {C x,D \y} ← DB)} where R2 Tup C \x {}} ← DB
{3 {" c"},5 {" d"," e"}}
8Q4/
'HHS 4XHULHV
([DPSOH )LQG DOO PRYLHV LQYROYLQJ %RJDUW DQG %DFDOO
select {Movie x} where Movie \x ←← DB [^ Movie] " Bogart" _ ← x, [^ Movie] " Bacall" _ ← x
Movie \x ←← DB denotes _ Movie \x ← DB
8Q4/
5HVWUXFWXULQJ 4XHULHV
([DPSOH 5HSODFH HYHU\ 6SHFLDO*XHVW HGJH ZLWK D )HDWXULQJ HGJH EXW RQO\ LQ 796KRZV
traverse DB giving X 1, X 2 case TVShow _ case SpecialGuest _ case \ l _ then X 1 := {TVShow X 2} then X 2 := {Featuring X 2} then X 1 := {l X 1}, X 2 := {l X 2}

下一页