DWE中文教程

leolian

贡献于2011-01-25

字数:78135 关键词: 数据挖掘 C# CSS F# HTML

DB2 ® DWE LL DB2 }]Vbff> 9.1.1 LL f> 9.1.1 S151-0413-01  DB2 ® DWE LL DB2 }]Vbff> 9.1.1 LL f> 9.1.1 S151-0413-01  "b "b:Z9C>JO0d'VDz7.0,kDAZ 73 3D:yw;PDE"# Z}f,2006 j 12 B >f>JCZ DB2 }]Vbfz7Df> 9.1.1 0yPsx"PfM^)f,1=ZBf>PmPyw*9# © Copyright International Business Machines Corporation 2006. All rights reserved. ?< DB2 }]Vbff> 9.1.1 LL .....1 DB2 }]VbfLLri ..........1 I!:Design Studio ri ..........6 Z 1 N:Design Studio D8S<"S<"`-wM n? ................6 Z 2 N:(F Design Studio ........9 #i 1:hF}]VbDom}]#M ......9 Z 1 N:Z Design Studio P4(}]hFn? 10 Z 2 N:4(yZ DWESAMP }]bDom}] #M ................11 Z 3 N:T MARTS #=PDmmSb|}]b ..............48 Z 5 N:9CE/KJLrr<44( MQT ( i ................48 Z 6 N:?p(iD MQT........49 #i 5:9(yZ OLAP "=eD DB2 Alphablox (f .................51 Z 1 N:4( DB2 Alphablox "=e ....52 Z 2 N:Z WebSphere ~qwO?p DB2 Alphablox &CLr ...........55 Z 3 N:(e DB2 Alphablox FastForward (f 57 #i 6:4(Zr#M ...........59 I!:x}>#i ...........60 Z 1 N:Z Design Studio P4(CZxP}]Z rDL5G\n? ...........61 Z 2 N:Z Design Studio P4(Zrw ...61 Z 3 N:(eZrwDZr=h ......62 Z 4 N:KPMi4Zr#M .......68 #i 7:9(wC}]Zr#MD DB2 Alphablox ( f .................69 Z 1 N:?p“DWE LL”&CLrTck DB2 Alphablox dO9C ...........70 Z 2 N:(e9C“DB2 Alphablox X5(f”i~ D DB2 Alphablox FastForward (f .....70 \a .................72 yw ................73 Lj .................74 k IBM *5 ............77 z7E" ...............77 ICJDD5 ..............77 TD5Db{ ..............77 © Copyright IBM Corp. 2006 iii iv IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL DB2 }]Vbff> 9.1.1 LL KbgN9C DB2® }]Vbs5f(DWE)f> 9.1.1 49(M?pK=KL5G \bv=8#>LLi\ DWE DX*&\,T9z\;lY=cX*<9CKz7# Z>LLP,z+*i9Dc[+> JK Superstore *""?pM\myZVvDV" bv=8# >LL5wgN4("bTM?pBPZ]: v om}]#M v yZ SQL D}]wMXFw,TZmMVva9Pnd}] v CZxP*zVv&m(OLAP)D`,*}]M_e/i/m(MQT) v 9C Alphablox i/ OLAP "=eDyZ Web DVv v Zr#M v 9C Alphablox +Zra{IS/DyZ Web DVv jI%v#iLLP,z+*{* JK Superstore Di9+>hF"?p)9 DB2 }]Vb& \DL5G\bv=8# s5=8 JK Superstore G;d5P,xYuLjDc[s5#z7_|(~0","/17"R _MgwH#JK Superstore D5(Z}%8jZ!CKH(v$,VZ,K+>F.Z BDP!)95q"#{Z*XBP!D,1#V{s,=v$# JK Superstore D}]V"!i:p++>}]O"= DB2 }]bP,BDVb*Vv M(f&\a)K;BD}]4#KK DWH #=D om}]#M# © Copyright IBM Corp. 2006 1 BmhvKom#MPD 9 vm: m 1. MARTS #=Dom}]#MPTmDhv omm{ )9m{hv ITM_TXN L7;W “L7;W”m|,wN;W, b);WGZUx((h;NuN k,2ITm>z7KuK n# MKT_BSKT_TXN :o:;W :o:;WmTw*%;B~ ;p"zDwN;WxPV i#}g,;N:o:;WI Tm>;;M',1:rDL 7D/O# OU i/%* “i/%*”m|, JK Superstore c[4PDwdLj# PD z7 “z7”mj6 JK Superstore I Ta)rv[DuoM~q# PD_X_GRP 4iEPDz7 “4iEPDz7”m(ez7 kz7Vi.dDX5#g{ z7tZ`vz7i,r_| GP>ZT;,$Dz7z7 ViP,rI\a`NP>C z7# < 1. DWH #=Dom}]#M 2 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL m 1. MARTS #=Dom}]#MPTmDhv (x) omm{ )9m{hv GRP i “i”mj6 JK Superstore PK $DX(z7Vi#;viI TId{i9I#IT*Kx P*z"\m"XFr(fx 4(i# IP f0= “f0=”m|,k JK Superstore D5qn/`XDK1,}g Lj-mMz[*5K# MSR_PRD H?1dN “H?1dN”mGLL,b)j6G xPZryXhD# MARTS #=|, JK Superstore c[4D[/}],K}]GxPz[k([Vvy XhD#< 2 T>K MARTS #=Dom}]#M# BmhvK MARTS #=Dom#MPD 4 vm: m 2. MARTS #=Dom}]#MPTmDhv omm{ )9m{hv PRCHS_PRFL_ANLYSIS I:E*E"Vv “I:E*E"Vv”mG;v B5m#||,M'yI:D z7Mz[:Dz[H?5# STORE Lj “Lj”mG;v,m#|k} ]VbPDi/%*m`T &# TIME 1d “1d”mG;v,m#|k} ]VbPDH?1dNm`T &# < 2. MARTS #=Dom}]#M DB2 }]Vbff> 9.1.1 LL 3 m 2. MARTS #=Dom}]#MPTmDhv (x) omm{ )9m{hv PRODUCT z7 “z7”mG;v,m#|k} ]VbPDz7m`T&# >LL{vKgN9C DWE Dw*&\4* JK Superstore 5VK=KDL5G\b v=8# '0?j >LLD'0?jgBy>: v 9C Design Studio 4hFMbTbv=8 v 9C\mXF(4?pM\mbv=8 v |Bom#=hF v 9CyZ SQL D}]wMXFw4ndB}]/PDB5m v hFj{D"=e#M"?p\;a_T\D_e/i/m(MQT) v hFZr#M"TdxP@@ v 9(yZ OLAP *}]MZr#MD Alphablox (f yhD1d jI{vLL# m 3. jI?v#iyhD1d #i yhD1d I!:Design Studio ri 20 VS #i 1:hF}]VbDom}]#M 60 VS #i 2:hFVb9(&CLr 120 VS #i 3:?pMKPVb9(&CLr 60 VS #i 4:hF OLAP *}] 100 VS #i 5:9(yZ OLAP "=eD DB2 Alphablox (f 60 VS #i 6:4(Zr#M 75 VS #i 7:9(yZZr#MD DB2 Alphablox ( f 45 VS ITSI!Dri#i"#i 1"#i 2 r#i 4 *<9C>LL#*S#i 2 r #i 4 *<,kjIG)#i*7DSbo*<9CLLI!NL#2IT(}jI# i 6 *7Dl]NL4x}#i 6 PDyPNL# 4 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL g{*i4s?VLLNLDa{,ITZ Design Studio Pr*QjIDy>n?# SD~K%P,!qB( → >}... → }]V">}"jIr<#2IT1SS Design Studio D“6-”3fCJKr<# <\.=:PH >LLY(A_Kb}]V"ML5G\=fD;)En,+4Y(A_KbG)E nDNNX(Z DWE D5V# A_ >LLhvKgNjIkom}]b#="SQL V"w"OLAP *}]0\am"Zr #MM Alphablox (fDhF"?pM,$`XDNq#m`s58(I;,DK1j IhFM\mNqT0:p;,Dlr(SQL V""OLAP"ZrM(f)#rK,"G >LLPDyPNLLL,XkZ;vr`v53O20 DB2 }]Vbs5fDBPi ~#g{20DG DB2 }]Vby>f,x;Gs5f,r;\jI>LLDBP# i: v Z 9 3D:#i 1:hF}]VbDom}]#M; v Z 39 3D:#i 4:hF OLAP *}];,;|(NL 6 LLhCE>;\Z Windows® FczOKP#9C>LL1,k7#9C Windows ~qw,49zrcCbTMzz539C UNIX® r Linux® =(`gK# ~qwi~ v DB2 UDB s5~qwff> 9.1 rf> 8.2 v DWE Intelligent Miner™ v WebSphere® Application Server v DB2 Cube Views™ v DB2 Alphablox v DWE \mXF( M'zi~ v DB2 \mM'z v DWE Design Studio – Intelligent Miner e~ – SQL V"$_e~ – Cube Views e~ v DWE Intelligent Miner Visualization D5 v DWE y>MLL DB2 }]Vbff> 9.1.1 LL 5 Hvu~ Z*<9C>LL0,kjIBP=h: v 7#zZCZ>LLD DB2 }]b~qwO5P SYSADM (^#zh*K(^E \4(M^Dy*9CDy>}]b#Z>LLP,Y( db2admin C'j65P SYSADM (^# v g{9C6LM'zOD}]b~qw,r9C DB2 dCzVM catalogdb |n4 8>M'z,S=6L~qwD==# v (}@Nr* DB2 |n0Z"*=E>D~D20?<"dk setupdwesamp.bat, 4( DWESAMP }]bDu#bGE>D~D76,+ZzD53O,y] D~20;CD;,,K76I\Py;,# C:\program files\IBM\DWE\samples\data\setupdwesamp.bat *KbPXE>&\Dj8 E",kNDTvD~#bGTvD~D76,+ZzD53OK76I\Py; ,: C:\program files\IBM\DWE\samples\data\Readme.txt $Za{ g{jI{vLL,z+C=;vj{DP' DB2 }]Vb,C}]VbQkTVv YwxPKE/#z9+C==vyZ Web D(f# ?v#iLLDm`NLPLLPDNq# Z>#iP,z+jIBPNL: v Design Studio 8S<"S<"`-wMn? v (F Design Studio '0?j jI>#iPDNLs,z+: v seOl$8S<"S<"`-wMn? v l$ BI 8S<,|(}]n?J4\mw"}]bJ4\mwMtTS< v KbgN(F Design Studio S< yhD1d jI>#iZ]# 6 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL r* Design Studio 1,|aa>z8($wUd#$wUdGLL$wDf"?<# VZ,k!q1!;C#Ts,ITy]h*|D$wUdD;C# 8($wUds,Design Studio +T>“6-”S<,KS<|,8r DB2 DWE D5" LLMy>D~D4S#ZNNd{1r,*r*“6-”S<,k%woz → 6-# 8S< 1!ivB,XU“6-”SKwVICZ9 (E"VbDJ4,"tCKyZVbDVv&\,}g OLAP M}]Zr#Z Design Studio P,ITy]y4PDNqP;8S<#+G,Z>LLP,w*9C BI 8S <# S< Sn/`-w DtT#IT9C BI 8S<4/@}]n?J4\mwM}]bJ4\mwDE"w" r*`XD`-wr_T>"i4tT#ZSS<,;s!qCS<# “<=w”M“sY”S<;JCZ>LLPD$w#z+Z BI 8SZ Design Studio DsOG#KS< T>K}]hF"}]VbT0zZ>LLP9CDVvn?DVcw#|9 z\;/@y4(D`Xn?MTs#(#,z(}KS<4^Db)Ts, SxT#MMn?xP|D# }]bJ4\mw 1!ivB,}]bJ4\mwSZ Design Studio DsBG#KS}]bDVcw,zITTb)}]bxP=i",S=b)}]b"Zd P4(#M,ns9ITT|GxP^D#*jINN+T}]bxP5J^ DDLLNq,Xk9C_PJ1(^MX(D DB2 C'J'# tT 1!ivB,KSZ Design Studio DRBG#b)S<Z0f#IT9CtTS<4(eM^Dm`Q 4(DTs#*r*QXUDr~XDtTS<,k%w0Z → T>S< → t T# a>:g{R;=y*9CD!nrX~,k7#r*K}7DS<#k"b,}] n?J4\mwD!nMX~k}]bJ4\mwPD!nMX~;,# `-w `-wG Design Studio DISi~,(#CZ/@r^DJ4(}gn?PDTs)# 9C`-w^DTs1,IZ Design Studio ;aT/#f|D,yTzXkT=X# f|D# DB2 }]Vbff> 9.1.1 LL 7 Design Studio aT>y&mDTs`MD`&`-w#`-w(#_P`X*D(F! Ce#1!ivB,Design Studio Z-#Z}]n?J 4\mwP,IT9*n?"=idZ]T0CJ\;TdxP&mD`-w#y] y9(Dn?`MD;,,IT4(;,`MDTs#<8C?pn?"0l}]b 1,k9C Design Studio zIy]n?PDTs/|B}]bD SQL# n?D~#fZD~53D$wUd?XF53(CVS,bG ;V*E=4zkf>XFM-w$_)/I,rK\;Z`%-wD*"!i73 P2m Design Studio n?T0TdxP&m# Z>LLP,w*9CBfb=`n?: }]hFn?(OLAP) 9C}]hFn?4xP}]bhFME"/I#}]hFn?IT|,om M_-}]#M"r#M"Jcm#M"XSD #="OLAP TsT0E># }]Vbn? 9C}]Vbn?4hFM9(Vb#K`n?IT|, SQL V"Ts,}g om}]#M"OLAP Ts"}]w"XFwMZrw# “B(n?”0ZD}]V"D~P,1|,b=`n?# a>:Z>LLPD`v;C,a*sz9C|,`,}Vj6Dibm{#zI\ a"b=,y4=Dibm{9CKm;}Vj6#bViv\dM,r*y ] Design Studio Kc{Z- L L } C i b m DATA_016.MKT_BSK_TXN_ID M LOOKUP_016.MKT_BSK_TXN_ID 1 , z 4 =Di b m { I \ G DATA_094.MKT_BSK_TXN_ID M LOOKUP_094.MKT_BSK_TXN_ID# NL*c Z Design Studio P,zw*9C BI 8S<,K8SLLP9CDSLLP+4(Dn?,}g}]hFn?M}]Vbn? 8 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL Z 2 N:(F Design Studio Z>NP,+(F Design Studio 0ZDNP,uo0ZHITG`-w 2ITGS<# 9CBP=(4(F Design Studio LLPD3)Nq,zn;`;h*9C;v0ZrS<#zI\h *CC0Z<] Design Studio D+?Ud# v *9;v0Zns/,k+wC0Z%?|,0Z{D!n(,}gtT# *9C0ZV4*ns/0Ds!,kYN+wC!n(# v *93)0Zn!/,k%wC0ZROGDn!/; vXNr,Cr8>KC0ZD#?;C#+0ZE=OJD;Cs,E*s j4|# *+8S~XDS<,k%w0Z → T>S<,;s!qCS<# NL*c *K|P'JX9C Design Studio,ITTy9CDS#iP,z9C Design Studio 4*BD JK Superstore }]VbM}]/PLLP9CD Design Studio GUI M<=&\#Z>#i P,z+'0gN9C Design Studio 4jIBPNL: v 4(}]hFn? DB2 }]Vbff> 9.1.1 LL 9 v 4(yZ DWESAMP }]bDom}]#M v T MARTS #=PDmmSb|#iPDNLs,z+\;: v Z Design Studio P4(}]hFn? v TyZ}]bDom}]#MxP4rhF v 9C`-w,(}mS#iNP,z+Z Design Studio P4(;vn?,TcITSEhFom}]#M# K`#M|,k DB2 ?z!q1!$wUd,k4PCYw# 2. Z Design Studio P,%wD~ → B( → n?# 3. Z“B(n?”r Tutorial - Data Model n? 9.1.1 LL Z 2 N:4(yZ DWESAMP }]bDom}]#M Z>NP,z+4(om}]#M,TcITTdxP=iT0|D|D#=#(} TVPD DWESAMP }]b#MxP4rhF(4F)44(om}]#M# *4(yZ DWESAMP }]bDom}]#M: 1. ,S= DWESAMP }]b# a. Z}]bJ4\mwP,9*“,S”D~PTi4VPD}]b# b. R|%w DWESAMP }]b,;s%wXB,S# c. a>zdk DB2 C'{M\k1,k4PCYw,;s%w7(# 2. 9C“B(om}]#M”r<44(om}]#M#Z}]n?J4\mwPR| %w}]#MD~P,;s%wB( → om}]#M# 3. Z“#MD~”3P,8(BP!n: a. +D~{VN|D* DWESampleTutorial# b. lif>VNGqQhC* V9.1# c. !q(}4rhF4(,;s%wB;=# 4. Z“4”3P,liGq!qK}]b!n,;s%wB;=# 5. Z“!q,S”3P,!q9CVPD,S,;sSVPD,SPmP!q DWESAMP#%wB;=# 6. Z“#=”3P,!P DWH M MARTS #=D4!r#%wB;=# 7. Z“}]b*X”3P,7#!PKBPwn,;s%wB;=#1!ivB,4! P}L!n,rKh*!PC!n# v m v w} v %"w v }L v rP v mUd 8. Z“!n”3P,!PzI< - E@4!rT4(#=<,"!{!PFO~=X5 4!r#%wjI# DWH M MARTS #=VQ|,Z}]hFn?Dom}]#MP#zITT#=xP =i"i4|G#ZB8ZNP,z+^D#=# NL*c zZ}]hFn?P4(Kom}]#M#K#MyZVPD}]b# z'0KgN(}TVP}]bD}]#MxP4rhF44(BDom}]#M# Z 3 N:T MARTS #=PDmmSb|NP,(}ZB5mk MARTS #=PD?v,m.dmS 9.1.1 LL 11 Z Design Studio P,IT9C<`-w4mS!nPmP,!PT>|MT>G|4!r# a>:*K|=cX&mC<,k+wC<%?D MARTS !n(T+d)9= +As!#R|%wC<,;s%w+?EPTXBq=/CtTS<#Z“P”3P,!q PD_ID PDw|4!r# b. T,;==T`BDm8(BPw|# v !q STR_IP_ID w* STORE ,mDw|# v !q TIME_ID w* TIME ,mDw|# 3. i4m.dD~=X5: a. Z<`-wP,R|%w-~=X5# KB5mPDb|k,mPD`&w|.dDX5# 4. (}%wD~ → +?#f,#fom}]#M# NL*c zZB5mk?v,m.dmSKXhDb|NP,z+Tom}]#MxPi$,T7#4}pNNJb#Tom}]#M xP|Ds,"RZ+G)|D?p=?j}]b.0,&CTCom}]#MxP i$# *i$om}]#M: 1. Z}]n?J4\mwP,R|%w MARTS #= 9.1.1 LL v PRCHS_PRFL_ANLYSIS_STORE_FK D{F$H,vj6$H^F(4 18 vV {) v PRCHS_PRFL_ANLYSIS_TIME_FK D{F$H,vj6$H^F(4 18 vV {) b)msGIZy4(Db|K}vtTN P,(}Tn?M}]bxPHO",=,+zZn?PywD|D+%= DWESAMP }]b,;szI"KP Delta DDL E>#Delta DDL E>9CzZO;NPT}] #MywD|D4|B DWESAMP }]b# IT9CHO&\4HO}]b#Mk4}]b,"!q*Z DDL E>PzID|D# *y]om}]#MD|D4|B DWESAMP }]b: 1. Z}]n?J4\mwPR|%w MARTS #=,;s%wxPHO → -<4# 2. Z“HOa9”0ZP,i4T MARTS #=ywD|D**,"9G)|Dk?j }]b,=# a. 9*nPmPD?vm,Ti4zTom}]#MmSDw|Mb|# 0ZT> b)|Z DWESAMP:DWESAMP.MARTS -<4mP;fZ#kNDZ 14 3D < 3# DB2 }]Vbff> 9.1.1 LL 13 b. 7#Z“HOa9”0ZP!qK#=,;s%w“HOtT”$_8PDSs_4 F = R _ < j ( )# C 0 Z + T > y P |DV Z < Q f Z Z DWESAMP:DWESAMP.MARTS -<4PmP#kNDZ 15 3D< 4# < 3. xP,=0D“HOa9”0Z 14 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL 3. zI"KP Delta DDL E># a. %w“HOtT”$_8PDzIJ1D Delta DDL zdk C'{M\k,rh*T DWESAMP r*B,S#%wB;=# d. Z“\a”3P,%wjI# VZ,Q9CTom}]#MywD|D|BK DWESAMP }]b# NL*c zzI"KPK DDL E>,CE>y]O;NPT}]b#MywD|D4|B DWESAMP }]b# z'0K4PBPYwD=(: v +}]b#Mk4}]bwHO v zI Delta DDL E>,(}KPKE>,+hFn?PD|D+%=}]b #i 2:hF&CLrT9(}]Vb Z>#iP,z+9C Design Studio 4hFMKPyZ SQL D}]w,b)}]w ITozz9CPbeD JK Superstore VvyXhD}]4ndM,$}]Vbm# < 4. xP,=sD“HOa9”0Z DB2 }]Vbff> 9.1.1 LL 15 ZO;v#iP,z4(K|,om}]#MD}]hFn?#Z>#iP,z+9 CK}]hFn?: v hCVb9(73 v hFCZ0kVbB5mD}]w v ^DCZ0k}]/P,mD}]w v ^DCZ0k}]/PB5mD}]w '0?j jI>#iPDNLs,z+\;: v 4(}CKVP}]hFn?D}]Vbn? v S Design Studio P,S= DB2 }]b,;slimDZ] v hF9CwV SQL V"Kc{D}]w: – D~Kc{,f"}]wDPda{ v *Kc{tT(ed?,}gD~{Mm{ v 9C SQL u~9(wMmo=9(w$_4a_}]whFYH v i$}]w"zI|GD SQL zk v 1SS Design Studio PKP}]w,"a)d?DKP15 yhD1d jI>#iLLD C:\Program Files\IBM\dwe\samples ?<# I!:Sbo*<9CLL (}jI8vrLD=h,zITx}0fD#i"Sbo*<9C>LL#g{Q -jIKH0#i,;*4Pb)=h,k*=Z 1 N# g{4jIH0#i,"RkSbo*<,rh*4PBP=h# *Sbo*<9CLL: 1. (}r* DB2 |n0Z"KP C:\Program Files\IBM\dwe\samples\data\setupsqw.bat E>,4( DWESAMP }]bDJ1f>#PXE>&\Dj8E",kND C:\Program Files\IBM\dwe\samples\data\Readme.txt D~# 2. 4({* Tutorial - Data Model D}]hFn?# a. (}%w*< → yPLr → IBM DB2 }]Vbf → Design Studio,r* Design Studio# 16 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL b. Z Design Studio P,%wD~ → B( → n?# c. Z“B(n?”r Tutorial - Data Model n?VNGqQhC* V9.1# 3) !q(}4rhF4(,;s%wB;=# c. Z“4”3P,liGq!qK}]b!n,;s%wB;=# d. Z“!q,S”3P,!q9CVPD,S,;sSVPD,SPmP!q DWESAMP#%wB;=# e. Z“#=”3P,!P DWH M MARTS #=D4!r#%wB;=# f. Z“}]b*X”3P,%wB;=# g. Z“!n”3P,%wjI# DWH M MARTS #=VQ|,Z}]hFn?Dom}]#MP# NL*c zQjIKSbo*<9CLLyXk4PD=h#VZIT*=Z 1 N# Z 1 N:hCVb9(73 Z>NP,z(}4(}]Vbn?"CJ4mM?jmD4}]T0,S=n/D DB2 }]b4hCVb9(73# Design Studio a)KinD BI &CLrhFMbT73# *hCVb9(73: 1. 4(BD}]Vbn?,"CCn?}CzH04(D}]hFn?# a. !qD~ → B( → }]Vbn?# b. Zn?{VNPdk dwhproj,;s%wB;=# c. !qzZO;v#iP4(D}]hFn?,;s%wjI# Bn?+T>Z}]n?J4\mwP#Cn?|,;iQ|{DD~P# 2. (}jIBP=h,i4n?D4M?j*}]: a. r*Bn?PD}]bD~P,i$ DWESampleTutorial.dbm D~GqIS# I ZBn?}CK}]hFn?,yT|4S=Kom}]#M#Kom#M| ,z4(}]w19CD4mM?jmD*}]# b. r*#MD~,/@ DWH M MARTS #=PDm# DB2 }]Vbff> 9.1.1 LL 17 3. i$GqQ,S= DWESAMP }]b# K,SJmzkn/}]bxP;%"i 4mPD}]y>#g{QjIO;#i,rK,SQfZ#g{;fZ,S,r 4PBP=h: a. Z}]bJ4\mwP,R|%w,SD~P,;s!qB(,S# +r*“B (,S”r<# b. !q DB2 UDB V9.1 w*}]b\mw# c. Z}]bVNPdk DWESAMP# d. dk DB2 C'j6M\k# e. %wbT,S# f. g{,SI&,r%wB;=# g{bT'\,ri$}]bD,S8Z,|( JDBC }/Lr"C'j6M\kHE"# g. Z}Kw3P,!{!P{C}Kw4!r,!!!q!n,;s!qPmP D DWH M MARTS #=# h. %wjI# B,S+T>Z}]bJ4\mwP# 4. Z}]bJ4\mwP,/@= DWESAMP }]bw,Ti$}]bmGqIS# *=#= → DWH → m,R|%w PD m,;s!q}] → y>Z]#Z“}]d v”SCmPD;!?VP# NL*c z'0K4PBPYwD=(: v 4(}CK}]hFn?D}]Vbn? v i4n?D4M?j*}] v ,S= DB2 }]b"i4|DZ]y> Z 2 N:hF}]wT0kVbm Z>NP,z+4(;vBD}]w,T(eZ}]VbP0k ITM_TXN B5mD} L#}]wG NP,(}Z Design Studio PhFMKP}]w40k ITM_TXN B5m#Z>#i P,*KZ!1d,z+9CE>49(}]VbPd{Dm;Zzz73P,z9 +9C}]w49(b)m# z+*hFD}]wDC>G0k=v`FDdkD~,b=vdkD~|,;,1 dNDB5}]#+lib=vD~Gq|,X4DB5}],;s9C SQL UNION mo=O"}]"+}]f"Z;vG(mP#SE,+G(mPD}]4!A|i /YwP,CYwZ0kB5m.0+B5GN]> KK=KDVb9(=8,K=8v9C DB2 }]Vbf>mD&\#>NL5wK gN9C SQL V"$_4y]b?D~4TmxPnd#(#,SQL V"$_CZ} ]bPDw,TndVva9(}g[/M}]Zrm)# 18 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL TB8>E"Y(zGZ;NZ Design Studio PhF4SD}]w#+G,b)8> E"4TG#y>DNq(}g+Kc{EC=-Nq,kZ'0>NL0%EPX4(}]wD Show Me viewlet#(}!qoz → 6- → Ev → Design Studio <@ → SQL V"6} → hFCZ0kVbmD}]w,ITS Design Studio Pt/K viewlet# z+9(V*=?VD}]w#Z;?VT}]>Kc{a2,CKc{m>}]w PDG(c,ZC;C,+"/Kc{Da{f"= DWESAMP }]bDVCmP# bvG(mzm}]wPDI?V4c#BK}]wDZ;?V# Z~?V(}m;5PDd;4S}]>F/}],"nU0k ITM_TXN m#BK}]wDZ~?V# Z>LLP,b=?VZ]9I;v}]w,+Z5yP,zIT!q4(=v}] w#}]>Kc{m>;vVC?jm,K?jmITjGZ;v}]wDa2,z IT=cX+dCwZ~v}]wD4m#(g{9(=v}]w,rI9CXFw4 43rKP|G#) *hFCZ0k ITM_TXN mD}]w"TdxPbT: < 5. zZ>NLP+*9(D}]wDZ;?V < 6. zZ>NLP+*9(D}]wDZ~?V DB2 }]Vbff> 9.1.1 LL 19 1. R|%w}]Vbn?PD}]wD~P,;s!qB( > }]w# 2. +}]w|{* dwh-fact,;s%wjI# +r*}]w`-w# 3. ZU-LLPSB4D=v}L49(}]wDZ;?VMZ~?V# S7= 29(K}]wAYh*;v!1# v :hF ITM_TXN }]w(Z;?V); v Z 23 3D:hF ITM_TXN }]w(Z~?V); NL*c >NL{vK4S}]wDK=KhF}L,C}]w+0kVbB5m# z'0K4PBPYwD=(: v 4(BD}]w v (ewV SQL V"Kc{DtT: – D~Kc{4(e}]wPDG(c v 4(BmTw*}]wDiI?V,+dmS=om#MP,;sKP|D DDL E > v (eZKP1ITf;*5J5DKc{d? v 9C SQL u~9(w4Slu~Mmo=D(e}L v 1SS Design Studio Pi$MKP}]w hF ITM_TXN }]w(Z;?V) ITM_TXN }]wDhFV*=?V,4_-?VMI\m?V#ZZ;?VP,(} +"/Ywa{nd=G(mPNLDZ~?V5wZ0k ITM_TXN m.0gNTG(mPD}]4 P;)Yw# BK}]wDZ;?VZjIsDb[: 20 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL ":b)NLPD8>E"Y(z+9CtTS<4(e?vKc{D_e8Z,x ;G9C+X(Kc{O=-<1r*Dr<3#Z4(eNNtTDivB, IT(}%wjI4XUr<3#(}9C-?V# *9( ITM_TXN }]wDZ;?V: 1. T`,D==(e=v DWH_ITM_TXN_1.txt D ~ D 7 6 : C:\Program Files\IBM\dwe\samples\data\sqw\DWH_ITM_TXN_1.txt# TZZ~v fileformat D~ C:\Program Files\IBM\dwe\samples\data\sqw\dwh_itm_txn.fileformat#TZ ~v:Z9(K}]w1,k9CyPKc{D1!{F#;h*9C“#f”3 PDj)VN4X|{Kc{#Z3)ivB,g{+Kc{X|{,Z }]wP+]ibmP1MaQTj6|GD44# 2. T`,D==(e=v`lKc{: a. +=v`lKc{O=- 9.1.1 LL 21 a. +=v:N P,z+*=v# 5) Z“d?E"”0ZP%w7(,;sZ“!qd?”0ZP%wf;# 6) TZ~v 9.1.1 LL b. ZC"/Kc{D/Oj8E"3P,!q UNION(;*!q UNION_ALL)# 5. +;v}]>Kc{O=-Kc{D input KZ# 7. Z*=B;=h.0,k#fywD$w# 8. 4( ITM_TXN mD1>T+dCw}]>Kc{DG(m# a. Z}]n?J4\mwP,r*}]hFn?PDom}]#M# b. R|%w ITM_TXN m,;s!q4F# c. R|%w DWH #=,;s!q3y# bM+ ITM_TXN mD1>mS=Ko m}]#MP# d. ZtTSX|{* ITM_TXN_STAGE#qXdks 4Dm{# 9. zI"KPBG(mD DDL# a. R|%w ITM_TXN_STAGE m,;s!qzI DDL# +r*“zI DDL”r<# b. !qj<{FM CREATE od,;s%wB;=# c. e}}mTbDyP!(Ts,;s%wB;=# KPzIDE>1,+;4 (m(;a4(}]>;h*Ddk}]bC'j 6M\k,;sZ“\a”3P%wjI# g. (}Z}]bJ4\mwP"Bk DWESAMP }]bD,S"li DWH #= PDm,liGqQI&X4(KBm# 10. 7##f|BsDom}]#M#ZD~K%P,%w+?#f# 11. ZtTSKc{: a. +>`MhC* PERSISTENT_TABLE# b. dkm{ ITM_TXN_STAGE M#={ DWH#(}9C 4%,;h4P ;v=hMIThCb)tT# c. k;*!q+]!n# g{zrc`NKPC}]w"R*Z?NKPjIs e}G(mDZ],(iz!P>}yPP...4!r#KP}]w1,g{G (m;GUD,rT\+TxB5#!qK!nD;v1cG,^(Z?NK PjIsliG(mDZ]# 12. #f$w# (}jI>NLDZ~?V,jIC}]w# hF ITM_TXN }]w(Z~?V) ITM_TXN }]wV*=?V,4_-?VMI\m?V#Z~?V5wgNy]}] >G(m9(w1=nUTIz==+}]0k?jm# K?VD}]wi\KVb9(YwPD8V#ChF 9.1.1 LL 23 Studio a)K=`i/Kc{:“|i/”M“B5|f;”#b)Kc{k,S` F,|GDtTI;)u~iI,G)u~(edk}]k;vr`vi/m .dD%du~# SQL u~9(wrmo=9(w *KcZyw,Su~"i/u~Md{mo=,m`Kc{|,8r SQL u ~9(wrmo=9(wD4S#b)gfa)KOBD`XDdkPDP m,ITozz_'x<7Xn4Kc{tT#9(w0Z9|,ITZNN P'mo=ru~P9CD\'V/}M SQL =J# Iz0k K}]wax1,+TIz==+}]0k=?jmP#DB2 Iz0k5CL rCZT}]bm4Ps?Df;rek==0kYw#}]w!Ce9|, ;vy>?jmKc{,CKc{zI SQL INSERT"UPDATE M DELETE od# BK}]wDZ~?VZjIsDb[: *jI ITM_TXN }]w: 1. +;v|i/Kc{O=-Kc{D result KZ,S=|i/Kc{D data KZ# 3. (}%wVPi/KZB=DNLP+*9(D}]wDZ~?V 24 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL a. Z“u~Pm”3P,(eZ;vi/KZDi/u~:DATA_016.PD_ID = LOOKUP_016.PD_ID# (}4PTBYw,9C SQL u~9(w4(eKu~: Z5VNP%w,;s%w 4%#ZzD}]wP,ibm{ (DATA_016 M LOOKUP_016)I\aPy;,;|G!vZzZ-}yPDP,;s9CR=r4%4 +yP DATA PFX=CPmP#k;*+NN LOOKUP PF=!qPm P# d. k;*Z“G(mhC”3P(eNNtT# BKZ+ DATA PmSX=“a{P”PmsCPmDb[: 7. (e 9.1.1 LL 25 c. 9*|i/Kc{MIz0k?jKc{PD%dMdkPDPm#i$ match KZPyPDPK4{F,SD P# 10. #fQjIDw"TdxPi$# a. (}%w}]w`-wPDNNUW;C4!q}]w,;s!q}]w → i $# b. I!:(}%w}]w → zIzk,zI}]wDzk"TdxPli# 11. KPC}]w# a. Z}]bJ4\mwP,g{P4,S= DWESAMP }]b,rXB,S=C }]b# b. Z-NKP,IT9C 1!D~{#2IT#t“oO”M“J4”3PDtT;d# e. %w4P,;s%wZs(KP# ZKPw1,IT(}i4-2?”S< PT>`XU>D~D)2Z]# 4PjIs,+T>“4Pa{”0Z,C0 Z2|,U>E"# f. (}4PTBYw4liGqQ0kCm:Z}]bJ4\mwP"B DWESAMP }]b,R|%w DWH.ITM_TXN m,;s!q}] > y>Z ]# 5X=Z 2 NDEv?VTlixH,;s*=Z 3 N# < 11. 4{F,SPDIz0k?jKc{ 26 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL Z 3 N:^DCZ0k}]/P,mD}]w Z>NP,z+^D"jICZ0k}]/PP STORE ,mD4S}]w#}]/P D STORE ,yZVbPQ9(DmD}]# CZZ MARTS #=P9( STORE M PRODUCT ,D}]wGG#`FD#b)m PD}]4TZ;,DcrcNa9=fzmLjMz7E"DVb}]#*K9( f&CLrMVv&CLrdCrwxP'J,Z+K}]0k MARTS m.0QTd xPKrP/rGf6/&m# *KT}]xPd;,C}]wS=vVbmP!qP"T]i==+|G,S=; p#?vB,SNL45 wgNS7=29(K}]w#xG,>NL5wKgNjILLn?Pa)D?V jID}]w#K}]wI;5Pf0 OU M IP mD,SiI;4}]2GS CL M MKT_BSKT_TXN mP!qD#zDNqG|Bns;v,SKc{"mS=vBKc {w*}]wDa2#a{+C=;v}#$wDj{}]w,C}]w+Pek= STORE mP# BK}]wjIsns}vKc{Db[# *jIK}]w: 1. hC?VjIDy>}]Vbn?(||, MARTS #=D}]w)# a. SD~K%P,!qB( > >}... > }]V">} > SQL V"y> - ?V# b. S\1!n?{(sqlwSamplepartial),;s%wjI# +y>n?LLP&mD Tutorial - Data Model }]hFn?,;s% w7(# y>}]Vbn?+4S=C}]hFn?# 2. *=}]wD~P,;sr* marts-store }]w# < 12. }Z9(D}]wPDns}vKc{ DB2 }]Vbff> 9.1.1 LL 27 3. ZC}]wDtTS:TZ,SKc{45,z!qDCZ,S=B;vKc{DKZ7(K y4PD,S`M(Z,Srb,S)#(}+;,DKc{,S=;, D,SdvKZ,IT9C%v,SKc{4zI`v SQL JOIN od# c. ZtTS: 28 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL 7. (}Z-;u“4PI&”{"# NL*c Z>NP,(}mS;5PKc{"(e|GDtT,z^D"jIKVPD}] w# z'0K4PBPYwD=(: v (em,SMd{ SQL V"Kc{ v y]VPD}]wxP9( Z 4 N:^DCZ0k}]/PB5mD}]w Z>NP,zTCZ0k}]/PP PRCHS_PRFL_ANLYSIS B5mD4S}]wx P;)r%D|D#C}]w|,ViKc{,CKc{*s(e=SD[//}# K}]w]>K;VdMDiv,4}]/Pzm}]VbPD;!?V}],"R B5mPTr%DGM#=[/=;pTNIPkm#IZB5m}CK}]/PP D}v,m,yTB5mXkns0k# ViKc{Gd;Kc{,|C4[/P#KKc{#b SQL GROUP BY SdkI j<[//}(SUM"COUNT"AVG"MIN M MAX)iID SELECT PmaO1 DP*#*i4ICD/}V`T0*KcZ9l[/mo=,ITSViKc{t TSK,Sm.s}]wPDViKc{# < 13. “a{P”PmT>KS4mP=?jmPD3d DB2 }]Vbff> 9.1.1 LL 29 *jIK}]w: 1. r* marts-fact }]w# 2. ZC}]wDtTSZ0ZW?D SQL D>xs_# c. + SUM_ITM_STM_PRC * SUM_NBR_ITM mo=3y= SUM /}D(EZ,;s %w7(#}g:SUM(INPUT_014.SUM_ITM_STM_PRC * INPUT_014.SUM_NBR_ITM)# 5. 9C=h 4 PD=(,+ MIN /}DN}|D*mo= CG_PD_DEPT_NM#}g: MIN(INPUT_014.CG_PD_DEPT_NM)# 6. (}Z-;u“4PI&”{"# g{K}]wKPI&,rC}]/PPD 4 vmVQ0k"I)Vv# NL*c Z>NP,z(}mS;)Kc{tTTVPD}]wxPK^D# z'0K4PBPYwD=(: v ^DViKc{PD!qPm v 9Cmo=9(w4!q[//}T0(emo= < 14. T>K>NL+*^DD}]wPDViKc{ 30 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL #i 3:?pMKPCZ9(VbD&CLr Z>#iP,z+Q}]w6k=XFwP,;s?p}]Vb&CLrTcZ WebSphere Application Server 73PwHMKP|G#z9+9C DWE \mXF( 4wHM\mb)&CLr# >#iIBPNLiI: v hF}]/PDXFw v hFCZ|B ITM_TXN mDXFw v <8?p}]Vb&CLr v ?pBD&CLr v KP"wHT0`SxLMn/ '0?j jI>#iPDNLs,z+Kb4PBPYwD=(: v hF|,BPKc{DXFw: – }]w – 4P|n – |zw – gSJ~ v 4(}]Vb&CLrD?p|(<8?p) v (}9C DWE \mXF(,Z WebSphere Application Server 73P?p"KPM \m&CLr yhD1d jI>#iNP,z+9(I 4 v}]wiIDXFw#?v}]w# ZZ;vVb9(#iP,z'0KgNS Design Studio Ppv4(}]wT0KP |G#Z5yP,IT43rKP;5P}]w"mS;)&mfrT7#J1X& m?v}]wDI&r'\iv#XFwI;iCZ(eK_-DKc{iI#Z> }P,XFwXF}]/PmD0k3r#ZXFwD)2,z+EC;v4P|n Kc{,CKc{KP DB2 SQL E>Ti$ns4PDB5m0kYwDa{# BK{vXFwZjIsDb[# DB2 }]Vbff> 9.1.1 LL 31 *hFCZ0k}]/PDXFw: 1. !qhF MARTS }]w19CDGv sqlwSamplepartial }]Vbn?,r* BDXFw"+d|{* marts-flow# 2. T`,D==(eDv}]wKc{# a. +Dv}]wKc{O=p# c. + SQL E > ; C V N h C * M 'zO D C:\Program Files\IBM\dwe\samples\data\countMartTables.sql D~# d. + DB2 ,SVNhC* DWESAMP# e. Z“oO”3P,S\1!DU>G<6pMzY6p# 4. T`,D==(eDvgSJ~Kc{# a. +DvgSJ~Kc{O=- 9.1.1 LL c. (eDvgSJ~Kc{DtT# 1) 9CL(5,dkzT:DgSJ~X7w*"~KMU~K#b)VND 1!5G9Cd?,rK,kH+b)VN|D*9CL(5# 2) ZwbVNPdk Marts-time }]w'\#(9C?v>}PD`&}]w {#) 5. (enUDaxKc{# a. +ZevaxKc{O=-/f{",+z&C;a4=NNms# Z>#iP,;h*S Design Studio PKPCXFw#sfDNL+5wgN(}4 PBPYw4KPXFw:+XFw&CLr?p= WebSphere 73,;s9C\mX F(4t/XFwxL# NL*c >NL5wKXFwDK=KhF}L,CXFwCZ0k}]/P# z'0KgN,SM(eBPXFwKc{: v }]w v |n v gSJ~ v ax Z 2 N:hFCZ|B ITM_TXN mDXFw Z>NP,z+4(Z~vXFw#KXFw|,;v}]w,C}]wCZ0k} ]VbPD ITM_TXN m#KXFw9CK|zwKc{,CKc{GCZ+|zn/ X4`NDzF,|zn/|(`vdkD~"`v?3)n/NI-7#-7PDn/y]|zwKc{P hCDu~44XKP#XFw'VBPwnD|z&m: v S8(D~PA!D(g}]n} v Z8(?NLWHS^DzH0Z>LLPhFDdP;v}]w*<#K^D*;vP$ D6}rBy!,ZC6}P,XFwPSkK|z&m#Z|BsD}]wP,+ ZdP;vKXFwZjIsDb[: DB2 }]Vbff> 9.1.1 LL 33 *hFCZ|B ITM_TXN mDXFw: 1. S dwhproj n?P,r*zZO;v#iPhFD dwh-fact }]w,;s!qD ~ → mf*#+C}]w#f* dwh-fact-update.dataflowxmi# 2. !q dwh-fact-update }]w*7DZ;vKc{,;sZ“#f”3P!q+]!n# KP^DsDw1,C}] >+;vT,"R;a0kG(m#(xPK|Ds,M;h*ZKP-< dwh-fact }]w1SQ0kD ITM_TXN_STAGE mP>}P#) 6. #f"i$C}]w,+;*KP|# 7. 4(BDXFw"+d|{* itm_txn-control# 8. ZBD itm_txn-control XFwP(e;v|zwKc{# a. +;v|zwKc{O=- 9.1.1 LL e. Z|zd?VNP,%w 4%#Z“!qd?”0ZP,!q dwh_update_files d?i,;s!q dwh_itm_txn_update_file d?,SE% w ! q # Z | z w t T 3 D | z d ? V N P + T > T B d ? ( e : ${dwh_update_files/dwh_itm_txn_update_file}# 9. (e}]wKc{# a. +;v}]wKc{O=-KQjID|zwKc{"}]wKc{Max|zwKc{# b}vKc{(|zw"}]wMax|zw)9IKXFwD|z&m-7# K}]w+9C`- w P r * D ~ C:\Program Files\IBM\dwe\samples\data\sqw\DWH_ITM_TXN_update_files.txt# CD~|, T B : E ( g D D ~ { P m : DWH_ITM_TXN_update_1.txt,DWH_ITM_TXN_update_2.txt 13. T?vD~{mSj{D>X76: ZTB>}P,IZ>LL3fmHP^,y T+>X76T>*=P# C:\Program Files\IBM\dwe\samples\data\sqw\DWH_ITM_TXN_update_1.txt, C:\Program Files\IBM\dwe\samples\data\sqw\DWH_ITM_TXN_update_2.txt NL*c >NL5wKCZ|BB5mDXFwDK=KhF}L# z'0KgN9C|zwKc{ZX4-7P&m,;}]w# < 17. QjID|zwKc{"}]wKc{Max|zwKc{ DB2 }]Vbff> 9.1.1 LL 35 Z 3 N:<8?p}]Vb&CLr Z>NP,z+4(;v?p|,C?p||,zZO;ZNPhFDXFw#zZ Design Studio P4P?p<8Nq,*Z DWE \mXF(P?p&CLr,XkH jIKNq# TZ*Z WebSphere 73PKPM\mDyPVb9(Nq45,NP,z+<8?p I;vXFwiIDr%&CLr# }K!qwTb,9h*(e&CLr+*9CDJ4Md?#b)tTzm&CL rE*E"#?p<8r }]Vb&CLr# +r*“<8?p}]Vb&CLr”r<# 2. Z“!qn?”3P,!q dwhproj,;s%wB;=# 3. (e&CLrE*E",;szIzkM?p|# a. dkE*D~{ dwh_load_profile,;s%wB;=# b. +{* itm_txn-control DXFwFA!qDXFwPm,;s%wB;=# c. %wB;=,1=*=“zIzk”3*9# zITvTPdDw3#zIT!q Z“zIzk”3P/@“zIDzk”D~PDZ]# d. %wB;=T*=“zI|”3,;s8(C4#f?p zip D~D>X?<,} g C:\temp# e. %wjITzI|"jICr<# 4. (}li8(D?<,i$Q4(K?p zip D~# NL*c >NL5wKgN<8?p}]Vb&CLr# z'0K4PBPYwD=(: v (e&CLrE*E" v zI&CLrDzk v zI&CLrD?p|(IT?p= WebSphere 73D zip D~) Z 4 N:?pCZ0k ITM_TXN mD&CLr Z>NP,z+?p;v}]Vb&CLr,C&CLr(eK DWH.ITM_TXN mD 0k}L#kZ DWE \mXF(P4P&CLr?pNq# >NLi\K\mXF(,s_CZ?pM\mz<8Z Design Studio P?pD}] Vb&CLr#“?p”G;V20}L,ZK}LP,z!q?p<8}LzID zip D ~"+CD~DZ]20=KP WebSphere Application Server DFczO#ITZ DWE \mXF(Pi4M4PQ?pD&CLr# 36 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL Z?p&CLr0,Xk(eZ}]wPw*4}]bM?j}]b}CD}]4# Z>LLP,h*+ DWESAMP }]b(e*}]4# g{Z&CLr~qwOdCK+V2+T,rv1zT_PyZG+DJ1(^D C'm]G<1,E\4P3)XF(Nq#XF('V}V;,DG+:\m1" ;c\m_MYw1# *?pCZ0k ITM_TXN mDXFw&CLr: 1. 7#}Z&CLr~qwOKP WebSphere Application Server m~#*t/~qw: a. *=&CLr~qwOD ...\dwe\appserver\bin ?<# b. dk startserver server1,dP server1 G&CLr~qwD1!{F# 2. S;(k20K WebSphere Application Server DFcz`,DM'zOt/\mX F(#1!ivB,XF(D76G:http://myappsvr:9080/dweadm/,dP myappsvr G20K WebSphere DFczDwz{# 3. g{Z&CLr~qwOdCK+V2+T,rw*_P\m1G+D DWE C' G<=XF(#>NLPD3)=h*sz9C\m1G+4G<#g{4dC+ V2+T,r;h*9CyZG+DG“6-”3f# 4. r*<=wPD DWE SQL V"D~P# 5. !qJ4 > 4(}]4,;s(e DWESAMP }]4# a. Z JNDI {FVNP,dk jdbc/dwesamp# b. Z,S= WAS }]4PmrP,!qq# c. dk DB2 C'j6M\k# d. ZT>{VNP,dk dwesamp# e. Z}]b`MVNP,!q DB2# f. Z}]b{VNP,dk dwesamp# g. %wbT,S#g{,SI&,r%wjI# +T>“\m}]4”3,C3PD PmT>KB}]4# 6. ?pB&CLr: a. !q}]Vb&CLr > ?p}]Vb&CLr# b. 8(zZ Design Studio P<8?pZd4(D zip D~D;C#IT/@=C D~,2ITdkCD~Dj{76#;s,%wB;=# c. i4&CLrD**E",;s%wB;=# d. Z“#f”3P,S\1!5,;s%wB;=# e. ZT/T>K DWESAMP }]4D“}]4”3P,YN%wB;=# f. K&CLr;h*53J4,rKk%wB;=# g. S\&CLr9CDd?D105,;s%wjI# B&CLrQ?pjO," R|+T>Z“\m}]Vb&CLr”3OD&CLrPmP# 7. %wxPB._D&CLr{,TT>Q?pD&CLrDtT# NL*c >NL5wKgN?p}]Vb&CLr# z'0K4PBPYwD=(: DB2 }]Vbff> 9.1.1 LL 37 v t/ DWE \mXF("*=“SQL V"”3# v 4(&CLryhD}]4# v y]O;ZN4(D?p|4?p&CLr# v i4C&CLr0dtT# Z 5 N:KPM`S}]Vb&CLrPDxL Z>NP,z+9C\mXF(4wH}]Vb&CLrP|,DxL#z9+`S KP1zID3FE"MU># }]Vb&CLrG;ixLMn/D|0w#Z WebSphere KP173P,xLH, ZXFw,n/H,Z}]wMd{}]wYw#;\KPrw{{v&CLr,; \pvXKP|DxL#IT(}=V=(4KPxL:t/("4KP)r_wH (Z+4D1dKP,"RIThC*KP;Nr4L(1ddtKP)#KPxLM GKP|DyPn/;;\%@t/rwHn/4KP# *KPM`SxL: 1. Z DWE \mXF(P,!q DWE SQL V" > xL > KPxL# +T>xL Pm#?vxLNL 5 VSst/# 6. ZrQwHxLDPm# 8. liZ;NwHKPDa{# a. !q DWE SQL V" → z7M3FE" → i4xL5}D3FE"# b. %wQwHDxL5}D{F# +T>QwHKPDtT,|(|Dt/1d" jI1dMDC1d# 9. liQKPD itm_txn-control xLDU>D~# a. !qU>MzY → i4xLU># +T>xL0`X HTML U>D~DPm# b. %w itm_txn-control xLDxPB._DU>D~# CU>D~|,CxL Dz7KP1dv# NL*c >NL5wKgNKPM`S}]Vb&CLrPDxL# z'0K4PBPYwD=(: 38 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL v i4&CLrP|,DxLMn/ v wHxLT4L(D1dmKP v i4Z;NKPywHxL1zID3FE"MU>G< #i 4:hF OLAP *}] Z>#iP,z+4( OLAP *}]Thv`,#MPD}]#OLAP *}]9IC 44((iD_e/i/m(MQT),K_e/i/m|,$H[/D}]#Z DWE P,TZyZ,;"=e#MDi/,b) MQT \;a_T\# DB2 }]Vbf+XZX5}]DE"f"Z*}]TsP,G)Tsa)KBD}] 8S<#Z1SCJX5}]1,3)*}]Tsd1y!#d{*}]Tshvy >*}]Ts.dDX5#yP*}]TsJO,"=e#MzmX5mDX(ViMdC# >#i|,BPNL: v 4(j{D"=e#M v T“1d”,mScNa9 v 4("=e v + OLAP *}]?p= DWESAMP y>}]b v 9CE/KJLrr<44( MQT (i v ?p(iD MQT '0?j jI>#iPDNLs,z+KbgN4PBPNq: v #iLL#g{Q -jIKH0#i,;*4Pb)=h,k*=Z 1 N# g{4jIH0#i,"RkSbo*<,rh*4PBP=h# *Sbo*<9CLL: 1. ( } r * DB2 | n 0 Z " K P C:\Program Files\IBM\DWE\samples\data\setupolapandmining.bat E>,4( DWESAMP }]b DB2 }]Vbff> 9.1.1 LL 39 D J 1 f > # P X E > & \ D j8E " , k N D C:\Program Files\IBM\DWE\samples\data\Readme.txt D~# 2. 4({* Tutorial - Data Model D}]hFn?# a. (}%w*< → yPLr → IBM DB2 }]Vbf → Design Studio,r* Design Studio# b. Z Design Studio P,%wD~ → B( → n?# c. Z“B(n?”r Tutorial - Data Model n?VNGqQhC* V9.1# 3) !q(}4rhF4(,;s%wB;=# c. Z“4”3P,liGq!qK}]b!n,;s%wB;=# d. Z“!q,S”3P,!q9CVPD,S,;sSVPD,SPmP!q DWESAMP#%wB;=# e. Z“#=”3P,!P DWH M MARTS #=D4!r#%wB;=# f. Z“}]b*X”3P,%wB;=# g. Z“!n”3P,%wjI# DWH M MARTS #=VQ|,Z}]hFn?Dom}]#MP# NL*c zQjIKSbo*<9CLLyXk4PD=h#VZIT*=Z 1 N# Z 1 N:4(j{D"=e#M Z>NP,z+9(CZxP OLAP VvD"=e#M,|hvKX5}]PDX5# "=e#M9z\;(ewv=fD}],b)}]TZ JK Superstore DVvhs4 5.VX*# "=e#M(#C4m>GMX5#=r)(X5#=,+z2IT("d{#= (}gib/PMK/,)"xPE/#(}4(*}]M/rKH?MB5Tsk X5}]D`X==# 40 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL ,,S="=e#MPDB5Ts,bMqG,m,S=GM#=PDB5m;y# X5mPD}]PI;)tTm>,b)tTi/I,# Z 42 3D< 19 T>KgNy]X5m49(,#cNa9Pf"KPX,Pwc.d D`X==T0|GD9l==DE"#cNa9a)Kg,xPFcM<=D= (#?v, 9.1.1 LL 41 yP,<,S=yZGM#=r)(#=D"=e#MPDB5Ts#IT+m,S p4,T4(B5Tsr,#Z"=e#MP,IT+B5Ts,S=,#,}C| GDT&cNa9"c"tTM`X,S#B5Ts}C|GDH?"tTM`X, S#Z 43 3D< 20 T>K"=e#MP*}]Ts.dD`X==T0|G3d=` X)(#=D==# < 19. ,. y]X5m9(,D== 42 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL *S7*<4(yZX5#=D"=e#M,IT9C“lYt/”r<#Cr 9.1.1 LL 43 c. Z“:z+k}]n?J4\mwMtTS },kND< 21# 3. /@Q 9.1.1 LL m 4. (COGS) JK Superstore yPkL7`XDI>D\uR[ 5 L7~} L7D}? L7):n JK Superstore hCDL7$Zz[[q {sn Uk,v'vD?V _J{sYVH ?v[vuR%;D{sn(TYVHF) z[n M'DI:n d. Z}]n?J4\mwSZ OLAP TsD~PBf2 mD,D~PP#g{"=e#M9CKC,,rZ,E"D~PPaT>8 r2m,D,4S# e. 9*1d,4S,;s9*cD~PMcNa9D~P# zIT4=,Q-(e K;vcNa9,4“aFjHcNa9”#Z“1d”,P(eKd{c,b)c }KhvaFjHb9hvUzjH#UzjHE"TZm`5qwL45G .VX*D(e,+10 OLAP *}]4|,CE"# 4. %wD~ → +?#fT+ OLAP *}]|B#fZn?P# ZB;NP,z+*“1d”,4(Z~vcNa9Thv JK Superstore (fP9CD UzjH# NL*c Z>NP,zS XML D~NP,z+Q“UzjH”cNa9mS=Z 1 NPS< → tT# DB2 }]Vbff> 9.1.1 LL 45 2. Z“#f”3P,8(UzjHcNa9w*cNa9{# 3. Z“c”3P,8(*ZcNa9P|(Dc# a. *!qc,k%wcmO=$_8PD“mSc”4SHc v UzjH->H-B]c v UzB]UZc a>:9C$_8PDOFMBFNP,z(}mSZ~vcNa9(|TUzjH==(e1d)|BK“1d” ,#“UzjHcNa9”TZ JK Superstore D(f45+.VX*# z'0KPX,"cNa9McD*6,"'0K4(cNa9McD==# Z 3 N:4("=e Z>NP,z+4(;v{*“[qVv”D"=e,K"=e|, JK Superstore 5q Vv1yhDH?5M,#"=eG OLAP *}]DX|i~,I(f&CLr(}g Alphablox)9C# zITX49C"=e#MDi~Tc*X(&CLr4(|+7D"=e#"=e Gn+7D*}]Ts,"RGk OLAP En"=en*S|DTs#"=eG"=e #MDX(5}rS/#"=e|,;i`F+^FT|?DX(*}]Ts,b) *}]TsGS8"=e#MIzD,dP|("=e,""=ecNa9""=e cM"=eB5Ts#Z"=eP,TZ?v"=e,;\(e;v"=ecNa 9,+;v,ITPm`v*"=e#M(eDcNa9#IZZ"=ek"=e# M.dfZbVa9ODnp,yT,IT9C%v SQL od4lws?V"=e# *4(“[qVv”"=e: 1. Z}]n?J4\mwP,9* MARTS #=D“I:E*E"Vv”"=e#MB fD"=eD~P#R|%w"=eD~P,;s%wmS"=e# 2. ZtTS 9.1.1 LL a. ZtTSNP,z4(K“[qVv”"=e,C"=eI) JK Superstore D Alphablox V v&CLr9C# z'0KPX"=eD*6"KbK4PBPYwD=(: v 4("=e v +"=e,mS="=e(|("=ecNa9M"=ec) v +H?mS="=eB5Ts DB2 }]Vbff> 9.1.1 LL 47 Z 4 N:+ OLAP *}]?p= DWESAMP y>}]b Z>NP,z+T#MxPi$,;s+*}]?p=}]b# Hvu~:*+ OLAP *}]?p=}]b,Xk,S=?j}]b# *+n?D~PD*}]?p=}]b: 1. T"=e#MxPi$,7#}7X(eKyP OLAP *}]Ts"RITT|G xPE/#IT4UZ 12 3D:Z 4 N:i$om}]#M;Pi$ MARTS # =D==4i$“I:E*E"Vv”"=e#M# 2. *+ OLAP *}]?p= DWESAMP }]b,kZ}]n?J4\mwPR|% w“I:E*E"Vv”"=e#M,;s!q?p=}]b#+r*“?p OLAP T s”r<# 3. Z“8(?j}]b”3P,!q DWESAMP }]b,;s%wjI# I\aT> a>z* OLAP TsdC}]bD{"#%wGTc* OLAP TsdC}]b# dC}]bs,Ma?pz!qD OLAP Ts# DWESAMP }]bVQ|, OLAP *}]#VZ,zIT9C“E/KJLr”r<4 4( MQT (i# NL*c Z>NP,zI&Xi$K OLAP *}]"+d?p= DWESAMP }]bP# z'0KgN9C“?p OLAP Ts”r<4+ OLAP *}]?p=y>}]b# Z 5 N:9CE/KJLrr<44( MQT (i Z>NP,z+9C“E/KJLr”r<44( SQL E>,b)E>IT*"=e# M9(;i(iD_e/i/m(MQT)#MQT +-#CJD}][/=;p,TZ" vyZ SQL "_P OLAP y=Di/D&CLr(}g Alphablox)45,b\a_ i/T\# MQT 2F*\am#Z>#iP,;fX9C MQT M\amb=vuo# zITHjIXp3vi/yhD_I>FcM,S,"+C}]f"Z MQT P#Z KPIT9C$HFcD}]Di/1,DB2 E/w+QG)i/X(r= MQT#i /;h*k$HjIDFc+7%d#g{9Cr%Vv&\(}g SUM M COUNT),DB2 E/wMIT/,X[/$HFcD}]Da{#;v MQT ITz cm`;,i/Dh*#TZCJ#C}]r_f0;vr`v,rmD[/}]D i/45,9C MQT ITsya_i/T\# zZ{ JK Superstore 5qVv1G#h*z}Z*"DB(f,rKzk!I\X7 #(fDT\nQ#!\z?09;P$wNq,+ITy]H0NLPjID OLAP #M44( MQT# *9C Design Studio PD“E/KJLr”r<4E/"=e#M: 1. Z}]bJ4\mwP,(}%w#= → MARTS → OLAP Ts → "=e#M, 9* DWESAMP }]bDwNS<#Z"=e#MD~PP,R|%wI:E* E"Vv"=e#M,;s%wE/KJLr#b+@U*}]fr4i$C"= e#M#g{C"=e#MDNNiI?V^',rzaSU=;vms,"RZ E/C"=e#M0,zh*HTdxP^DT9dP'# 48 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL 2. Z“E/KJLr”rDB,,T?vcNa98(c#%w"=e,PPDc,S PmP!qJ1Dc: v *“1d”"=e,!q“UzjH”c v *“z7”"=e,!qNNc v *“Lj”"=e,!qNNc 3) %w7(# KE/,+kTrBj!y=Di/xPE/,b)i/|(zy] Alphablox (f$bDi/,|GTNN6pDz7MLj}](+b)}](#4jH [/)xPVv# d. %w7(,;s%wB;=# 3. Z“\am”3P,8(*SY|B\am#k8(CZf"\amM\amw}D mUd,;s%wB;=#ITS\1!D USERSPACE1 mUdhC# 4. Z“^F”3P,!q;8(ELUd^FM;8(1d^F,T9E/KJLrD CD1dMELUd;\^F#8(JmxP}]Iy#8(DUd"E"M1d =`,T\Da_yHMa=s#%wt/KJLrTt/“E/KJLr”#“E /KJLr”I\*(8VSD1d44((i#Z“E/KJLr”jId(i s,k%wB;=# 5. Z “SQL E > ” 3 P , Z CZ4 ( \ a m D SQL E > V N P d k C:\dwetutorial\olap\createmqts.sql w*(;D~{,ZCZ"B\amD SQL E>VNPdk C:\dwetutorial\olap\refreshmqts.sql w*(;D~{#%wj IT9C8(DD~{4#f(iD SQL E># NL*c Z>NP,z9CK Design Studio PD“E/KJLr”r<44((iD\am#T Zk DWE ;; OLAP *}]D Alphablox Vv&CLrMd{&CLrP4PD OLAP y=i/45,(iD\amITsya_dT\# z'0KXZ\amD*6,"KbK\am(iD4(=(# Z 6 N:?p(iD MQT Z>NP,z+9C DWE \mXF(4KP SQL E>,T4(zZ Design Studio PhFD(i MQT# IT9C\mXF(4jIBPk OLAP `XDNq: v ,S=}]b"7#T OLAP tCKC}]b v 9.1.1 LL 49 v KP“E/KJLr”rNP,z+'0gN9C DWE \mXF(4,S=w* WebSphere Application Server B}]4D}]b#z9+'0gNi$Q-T OLAP tCKC}]bT0? p(iD MQT# g{Z&CLr~qwOdCK+V2+T,rC';PZG<1_PyZG+DJ 1(^,E\ZXF(P4P`&DNq#XF('V}V;,DG+:\m1"; c\m_MYw1# *9C\mXF(4?p(iD\am: 1. 7#}Z&CLr~qwOKP WebSphere Application Server m~#*t/~qw: a. *=&CLr~qwOD ...\dwe\appserver\bin ?<# b. dk startserver server1,dP server1 G&CLr~qwD1!{F# 2. S;(k20K WebSphere Application Server DFcz`,DM'zOt/\mX F(#1!ivB,XF(D76G:http://myappsvr:9080/dweadm/,dP myappsvr G20K WebSphere DFczDwz{# 3. g{Z&CLr~qwOdCK+V2+T,rw*_P\m1G+D DWE C' G<=XF(#>NLPD3)=h*sz9C\m1G+4G<#g{4dC+ V2+T,r;h*9CyZG+DG“6-”3f# 4. (}4(CZ,S= DWESAMP }]bD}]bE*D~,dCC}]bTcxP \m# a. Z<=K%P9* DWE +2,;s!q}]bE*D~# b. Z“\m}]bE*D~”3P,%w4(4%T4(BD}]bE*D~# c. Z}]bE*E"{D>rP,dk dwesamp# d. !q9CB}]444(E*D~,;s%wB;=# e. Z“}]4(e”3P,8(BPhC,;s%wB;=: v S JDBC a)LrPmP!q DB2 (C JDBC }/Lr# v Z}]4{VNPdk dwesamp# v Z JNDI {FVNPdk jdbc/dwe/dwesamp# v dk dwesamp w*}]b{# f. Z“2+Ti$”3P,ITi4CZ,S=C}]bD WAS 2+TC'p{M DB2 C'j6#Z\kD>rP,a)yT>D DB2 C'D}7\k#%w4 (T4(}]bE*D~# g. Z“\m}]bE*E"”3P,(}!q dwesamp "%wbT,bTk DWESAMP }]bD,S# 5. li DWESAMP }]bDtC4,,7#T OLAP tCKC}]b# a. %w<=K%PD}]btC# b. Z}]bE*D~{VNP!q dwesamp }]bE*D~# c. !P OLAP 4!rTliGqQ-T OLAP tCKC}]b# d. %wlitC4,# 50 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL e. g{P4T OLAP tC DWESAMP }]b,rYNr*“}]btC”3,Z* tCD&\rP!q OLAP,;s%wlitC4,#Z OLAP 3P,8(X hN},;s%wtC# zQ<8C+(iD MQT ?p= DWESAMP }]bK# 6. KPCE>T+ MQT ?p= DWESAMP }]b# a. Z<=K%P%w DWE OLAP → OLAP E/# b. Z“OLAP E/”3P,!qQ4(D}]bE*D~ dwesamp T,S= DWESAMP }]b# c. Z“KP SQL E>”3P,/@=CZ4((iD\amD SQL E>(zQ+ CE>#f= C:\dwetutorial\olap\createmqts.sql D~76P)# d. %wKPE># e. Z“SQL E>a{”3P,BXKP\amE>1zID4PU>#r*4PU >,7#QI&X4(K\am# NL*c Z>NP,zZ DWESAMP }]bP4(K(iD\am#I9C Alphablox `,( fDC'"vD OLAP y=i/IT9Cb)(iD\am# z'0K4PBPYwD=(: v Z DWE \mXF(P4(}]bE*D~ v liGqQT OLAP tCK}]b v +(iD MQT ?p=}]b #i 5:9(yZ OLAP "=eD DB2 Alphablox (f Z>#iP,z+9C DB2 Alphablox 4y]O;#iP4(D Cube Views *}] 4( Alphablox "=e#z9+Z WebSphere ~qwO?p$HdCD&CLr"9 (M&m(f# hz DB2 Alphablox,IT4UBP=V==.;4((F(f&CLrMVv&CL r: v g{z;GLr1,xG5qVv1,r9C FastForward(;V(fMVv&CLr r\)44(M" 9.1.1 LL 51 +b)tThC*(F5#}g,g{+ jGPD width t ThC* 50%,r PresentBlox i~+#iIBPNLiI: v :Z 1 N:4( DB2 Alphablox "=e; v Z 55 3D:Z 2 N:Z WebSphere ~qwO?p DB2 Alphablox &CLr; v Z 57 3D:Z 3 N:(e DB2 Alphablox FastForward (f; '0?j jI>#iPDNLs,z+KbPX DB2 Alphablox Dy>En"KbBPYwD4 P=(: v 4( Alphablox "=e(|9C Cube Views *}]4(e"=e) v + DB2 Alphablox &CLr20= WebSphere ~qwP v 9C(F FastForward #e4(e(f v i4M&mu<(fPD}],T4(ICE"D8CS< yhD1d jI>#iNP,z+9C DB2 Alphablox \m3f4(eyZO;#iP4(D Cube Views *}]D Alphablox "=e“[qVv”# DB2 Alphablox 20=xa)K DB2 Alphablox Cube Server#zIT9C DB2 Alphablox Cube Server 44(MKP DB2 Alphablox "=e,b)"=eIC4T> xqM 9.1.1 LL 2. Z 54 3D:(e Alphablox Cube Server Adapter }]4; 3. Z 54 3D:(e DB2 Alphablox "=e; 4. Z 55 3D:t/“[qVv”"=e; t/“[qVv”"=es,MIT4(yZ DB2 Alphablox "9CKX5"=eD( f# NL*c Z>NP,zKbKgNlY4( DB2 Alphablox "=e# DB2 Alphablox "=eD9(}L`1D1,bGr*zh*V$(e,"c"H?M d{tT#+G,g{VP Cube Views *}]IC,rITy]$(eD*}]lY zI DB2 Alphablox "=e# z'0K4PBPYwD=(: v (e DB2 }]bDX5}]4(e v (e Alphablox Cube Server Adapter }]4 v (eyZ Cube Views *}]D DB2 Alphablox "=e v t/ DB2 Alphablox "=e (e DB2 X5}]4 h*Z DB2 Alphablox P* DB2 X5}]b DWESAMP (e}]4(e# Z>}LP,z+9CZ DB2 Alphablox Cube Server OKPD OLAP X5}]b# 9Cj+mIf>D DB2 Alphablox 1,9IT9(CJ`, OLAP }]b(|( DB2 OLAP Server™"Hyperion Essbase M Microsoft® Analysis Services)DVv&C Lr# DB2 Alphablox "=e*s+WcX5}]4$(e* DB2 Alphablox }]4#DB2 Alphablox "=eG9CX5}]bPa)D*}]M}]zID# *(e DB2 Alphablox X5}]4: 1. T5P\m1(^DC'm]G<= DB2 Alphablox \m3f#TZ>LL,kT db2admin C'm]G<# IT9C Windows D“*<”K%r DWE \mXF(4 CJ DB2 Alphablox \m3f# 2. r*BD}]4(e#%w\m!n(,;s%w}]44S,SE%w4(4 %# g{z;4=“&CLr”!n(,rm>44PXhDhC=h,XkHzc Hvu~E\Lx# 3. ZJdwK%P,*}]b~qw!qJ1D IBM DB2 JDBC }/Lr# Zs` }ivB,+!q IBM DB2 4 ` JDBC }/Lr#g{z;7(y*!qD}/ Lr,kk}]b\m1*5# 4. Z}]4{VNP,dk DWESAMP w*}]4D{F# 5. T~qw{VN"KZEVNM}]b{VN8(J1D5(}]b{&CG DWESAMP)# 6. Z1!C'{M1!\kVNP8(5# TZ>LL,kT db2admin C'm]G <#"R,+9C DB2 Alphablox C'{M\k5#t*1!hC“q”# DB2 }]Vbff> 9.1.1 LL 53 TZ DWESAMP }]b,CC'j6M\kXkP'#1 DB2 Alphablox "=e CJX5}]b1,+LL,k+tC JDBC zY5hC*q# 8. %w#f4%T#f}]4(e# 9. %wbT!qD}]44%,T7#C,S$w}## zQ-4(K DB2 Alphablox X5}]4(e,SB4+9CK(e4lw DB2 Alphablox "=eD}]"Z DB2 Alphablox (fPT>}]# (e Alphablox Cube Server Adapter }]4 *CJ DB2 Alphablox Cube Server OD DB2 Alphablox "=e,h*4(;v}] 4#Alphablox Cube Server Adapter +CJNNICD DB2 Alphablox "=e,s_ +0k9CQ(eD DB2 Alphablox X5}]4lw=D}]# *(e DB2 Alphablox Cube Server Adapter }]4: 1. 4(BD}]4(e#Z\m!n(D}]43P,%w4(4%# 2. TZJdwVN,!q Alphablox Cube Server Adapter# 3. Z}]4{VNP,dk ABXDWESAMP w*}]4D{F# 4. %w#f4%T#f}]4(e# 5. %wbT!qD}]44%# g{4T>“,SI&”{",rlihC5"7#C }]b}ZKP# VZ,z4(D ABXDWESAMP }]4IC4CJ DB2 Alphablox Cube Server OD DB2 Alphablox "=eK# ?0,zP4Z DB2 Alphablox Cube Server O4( DB2 Alphablox "=e#>NL DB;v}L+4( DB2 Alphablox "=e,C"=eICZ4(yZ DB2 Alphablox D(fMVv&CLr# (e DB2 Alphablox "=e Z>}LP,z+y]VPD Cube Views "=e*}]44( DB2 Alphablox "= e#2IT(}(e,"H?"FcDI1T0d{"=etT4TV$==4( DB2 Alphablox "=e# (}9C$(eD Cube Views *}],ITlYzI DB2 Alphablox "=eTT> WcX5}]4PD}]#Z OLAP "=eP4(DVc}]a9!vZL5C'gN 4}d5q}]# *(e DB2 Alphablox "=eD#ftT: 1. Z\m!n(O,%w"=e4S,;s%w4(4%# 2. Z DB2 Alphablox "=e\m0ZP,(eBD"=e: a. Z DB2 Alphablox "=e{VNP,dk“[qVv”# b. !P DB2 Alphablox "=e{VNT_DtC!n# !PtC!ns,C" =e+Z Alphablox Cube Server XBt/1T/t/,z2IT(}“DB2 Alphablox \m3f”gfV/t/C"=e#g{z|G!qtC4!r,M^ (t/C"=e# 54 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL c. SX5}]4PmP,!qz*>LL4(DX5}]4 DWESAMP# d. TZ>LL,k;*!P2+TG+!n# K!nICZ^F\;CJ3vX( "=eDC'# 3. tC"=eSC'gf*9CDI1 {#K!nH,Z9CO;v#iP9C DWE Design Studio 14(Dj)5# 9CTs{!n+T>z*" Cube Views "=e#M19CD{F# e. %w4%Ti4j85w# y]h*,I9C K4xPwT# g. !qZt/"X(M`-1NLPDB;v}L+t/C"=e,T9dI)C'9C# t/“[qVv”"=e zh*t/Z>NLDH0}LP4(D“[qVv”"=e# 4( DB2 Alphablox "=e"tC|.s,C"=eMaZ DB2 Alphablox Cube Server t/rXBt/1T/t/#Z>}LP,z+'0gNV$t/O;v}LP(e D“[qVv”"=e# *t/“[qVv”"=e: 1. w* db2admin C'G<= DB2 Alphablox \m3f# 2. %w#f!n(,ZKP1\m?VBf,%w DB2 Alphablox "=e4S# 3. S DB2 Alphablox "=ePmP!q[qVv"=e# 4. %wt/4%# "=et/s,“4,”VN+T>}ZKP# Z*=Z 2 N.0,k5X=Z 1 NTlixH# Z 2 N:Z WebSphere ~qwO?p DB2 Alphablox &CL r Z>NP,z+?p$(eD Alphablox FastForward &CLr#+“DWE LL”&CL r20= WebSphere ~qwO,;s+d 9.1.1 LL 55 IT+H0*"D DB2 Alphablox &CLr(}gCZ>#iD&CLr)?p='V DB2 Alphablox &CLrD WebSphere ~qw# *?pH0*"D DB2 Alphablox &CLr: 1. :Z WebSphere ~qwO20&CLr; 2. Z 57 3D:+&CLr&CLr“DWE LL”s,z+\;CJ"9CK&CLr4i4M4(VvS <# NL*c Z>NP,z20K;v WebSphere &CLr"+C WebSphere &CLr}LP,z+20 DWE 20 CD O samples ?&CLr# *Z WebSphere ~qwO20“DWE LL”&CLr: 1. r* WebSphere \mXF(#w* db2admin(“DWE LL”DC')G<#Z<= wP,%w&CLr > 20B&CLr# 2. Z * 2 0 &CL r w<8 3 P , % w / @ 4 % , ; s ! q C:\Program Files\IBM\DWE\samples\Alphablox ?>(mS)4%T+ db2admin mS=!qDPmP# db2admin C'+P>ZKG+D3dDC'5P# b. TZ AlphabloxUser G+,!PKG+DyPQO$DC'PBfD4!r# K hC+JmyPQO$DC'CJ&CLr# c. %wB;=# 6. Z=h 5:\a3P,%wjI4%# C&CLrQ20jO# 7. #f=wdC3r*s,%w#f4%# ,L.s,z+5X=\mXF(w3# 8. Z<=K%P,%w&CLr > s5&CLr"t/“DWE LL”&CLr# zQ9C WebSphere ~qw420"t/K“DWE LL”&CLr# 56 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL ZIT+bv“DWE LL”&CLrCw DB2 Alphablox &CLr.0,Xk+dNLPDB;v}L+&CLr3#ZK3P,IT!qy*KPD DB2 Alphablox &CLr#IT9CE'x>Md{ Web 3fOa)D,4S4CJ Q?pD&CLr# Z*=Z 3 N.0,k5X=Z 2 NTlixH# Z 3 N:(e DB2 Alphablox FastForward (f Z>NP,z+9C(F FastForward #e44((f,;sTC'G+^DVPD( f# L5C'h*9CTz~q(f&CLrMVv&CLr#?vC'NP,z+'0: v Z 58 3D:9C FastForward (f#e4(e(f; v Z 59 3D:y]VPD(f44(B(f; NL*c Z>NP,zw*&CLr\m1i4"(eKBD FastForward (f#z9w*L5 C'y]H04(DdP;v(f4(KB(f# z'0K4PBPYwD=(: v i4$(eD FastForward (f DB2 }]Vbff> 9.1.1 LL 57 v 9C FastForward #e44(BD$(e(f v 9CVPD(f44(B(f 9C FastForward (f#e4(e(f &CLr*"_IT4( Alphablox FastForward (f#e,by,&CLr\m1M IT9Cb)(f#e4*{GDL5C'4(B(f#Z>}LP,z+4(yZ $(eD(f#eD FastForward (f# *9C(f#e4(e FastForward (f: 1. r* DB2 Alphablox \m3f#Z“&CLr”3fO,!q“DWE LL”&CLr# d;zG9C\m1(^Gu<(f,C(fZPaOT> #!M@]z7`p,"ZPaOT>`&Dz[nM_J{sn#yT>_P3 0+D}]%*qmw}]Z(f#ey8(DP56'Z# 3. ZC(fO=D FastForward &CLr$_8O,%w\mNq4%(;Z$_8D ROG)# S<+P;*C&CLrD\m1S<# 4. Zs_<=K%O=D$_8P,%w4((f4%# +r*“`-(f”0Z,C 0Z|,I(FDVNMN}# 5. Z#ePxPBf8(D|D,;s%w#f4%#TZyPd{N},#t1! 5: {F dkLj(4z[nEP)# hv dkT>LjZy!1dNZDz[n# #e !q;%= PresentBlox# }]4 !q ABXDWESAMP# "=e !q[qVv# P, !qLj# PI1 (}v/Pm"Z4! Ctrl |DivB%w?dLj,!q ValueTrend Store 554"ValueTrend Store 782 M ValueTrend 1414#jI!qL js,kv/PmT7#!qKyPLj# P, !qH?# PI1 v!qz[n# EEFI1 !qz[n#EEF(4l#(f)y]$(eD'5rC'(}C'g f!qDP54;vT>}]%*qD5#(};vT>{OP5D5, C'IT\lR=I\h*x;=ST"bD}]# /(P5 dk 200000# /fP5 dk 250000# 3f, !q1d# 3fI1 !qyP1d(Uz)# T> !qxq# 6. $@(f: a. %w#eW?D$@4%# b+r*$@0Z,C0Zy]zZ#eP!qDh C4T>C'+4=D(f1># 58 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL b. %w$@0ZW?D5X=`-w4%# 7. %w(f#eO=D5X=&CLr4S# +5X=“DWE LL”&CLrDC'= =# 8. (}9Cs_D<=K%,Z“DB2 Alphablox Vv”!nBf!qBDLj(4z[ nEP)(f# b+r*y4(D(f# 4(K(fs,C'(Z>}P,8yP+2C')MITCJK(f#ZB;v} LP,z+y]bvVPD(f44(B(f# y]VPD(f44(B(f d;IT9C FastForward 44((f&CLrMVv&CLr,+C'-#h*+; ](f^DIT{GDX(hsrNq|PbeDB(f#Z>}LP,z+TC' m]y]H0w*&CLr\m14(D(f44(B(f# *4(yZVP(fDB(f: 1. r*“DWE LL”&CLr,;sS(f<=K%P!qLj(4z[nEP)( f# 2. Z(fs_D}]KjHP# 5. ZO=D&CLr$_8P,%w#f(f4%# 6. Z“#f(f”0ZP,+(f{|D*“Ljz[n(41dEP)- 2002 j= 2004 j”,y]h*^Dhv,"+ISThC*=P# Bf>D(f+#f*= P(f,"Rv1!qK=P!n(1,C(fEaT>Z<=K%P# 7. %w=P!n(,;s!qLjz[n(41dEP)- 2002 j= 2004 j(f# b+4U#f1Dy=T>z4(D(f# (}9C FastForward &CLrr\44((fMVv&CLr,&CLr\m1ML 5C'ITy]h*=cX(FE"# #i 6:4(Zr#M Z>#iP,z+4(;vZr#MTVv JK Superstore DM'I:wF# JK Superstore k*VvdM'DI:wFT7(,;M':rDL7iO,HdGZg w?E:rDL7iO#(}9CX*&\44(Zr#M,MIT7(D)M'Z gw?EDI:P*|*51#z9IT7(D)M'HZgw?EI:L72Zd {?ErS?EI:L7# }]Zr&\\;4l}]PDL5E"#Z Design Studio P,IT4;%==4( Zr#M"+dIS/,Sx4ls+>Vb}]PD&sE"#9IT9C Design Studio 4zI SQL zk,TFcZr#Mr?pC#MD`X@V&\#IT+K SQL zk3y= Alphablox 3frNN BI &CLrP,Sxa)6kDVv&\# DB2 }]Vbff> 9.1.1 LL 59 >#iPDZrwk“#i 2:hF&CLrT9(}]Vb”PhvD}]w`F#Z rwk SQW w9C,;v`-wM;)`,D SQL Kc{#“SQL V"”D;Viv G,9C“$&m”!CePD;vKc{4<8}]TxPZr#4}4,ITZ} ]wP9C3)ZrKc{49(Vb# '0?j jI>#iPDNLs,z+\;: v 4(Zrn? v 4(Zrw v (eZrwDZr=h – mS$&mKc{T+}]*;*JOZxP}]ZrDq= – mSZrKc{ – mSIS/wKc{ – mSKc{,Tmqq=i!#ME" v i4Zr#MDa{ yhD1d jI>#i#i g{z;k'0>#iPDNL,rIT(}4P8vrLD=h4x}>#i# *jIsx#i,XkjI>NLPD=hr_jI>#iPD`BNL#“x}># i”NLPD=h9z\;(}KPa)DE>r_(}D~48Y jIZr#M4(WN# *x}>#i: 1. Z DB2 |nP&mwP,dk db2 -tf MBA.SQL TKP MBA.SQL E># KE >Fc"f"X*fr#M MBA.RULES,"Rnd DWESAMP }]bP MARTS #=D RULES m# 2. i$GqQ,S= DWESAMP }]b#K,S9z\;kn/}]bxP;%"i 4mP5J}]Dy>#g{QjIO;#i,rK,SQfZ#g{;fZ, S,r4PBP=h: a. Z}]bJ4\mwP,R|%w,SD~P,;s!qB(,S#+r*“B (,S”r<# b. !q DB2 UDB V8.2 r DB2 UDB V9.1 w*}]b\mw# c. Z}]bVNPdk DWESAMP# d. dk DB2 C'{M\k# e. %wbT,S# f. g{,SI&,r%wB;=#g{bT'\,ri$}]bD,S8Z,| ( JDBC }/Lr"C'{M\kHE"# g. Z“}Kw”3P,!{!P{C}Kw4!r,!!!q!n,;s!qPm PD DWH M MARTS #=# h. %wjI#B,S+T>Z}]bJ4\mwP# 60 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL i. /@ DWESAMP w,Ti$}]bmIS#R|%w DWESAMP }]bPD DWH.PD m,;s!q}] → y>Z]#Z“}]dv”SCmPD ;!?VP# NL*c zQjIK>l]NL,VZ,Zr#MQ&ZzjI{v#is|y&D4,#z ITx}>#iPD`BNLK# Z 1 N:Z Design Studio P4(CZxP}]ZrDL5G\ n? Z>NP,z+Z Design Studio P4(}]Zrn?,TcITVv}]T04(M 9C}]Zr#M# zITZ Design Studio P4(n?,Tc&mL5G\bv=8D;,?V#}]n ?J4\mwGCZ9(MbTbv=8D$wUd,|ICZ&mn?#g{*( EX&mZr#M,rh*4(}]Vbn?# d;ITZ SQL V"n?P4(Zrw,+TZ>LL,z+4(%@Dn?# Hvu~:T}]btC}]Zr#S DB2 |n0ZP,Z}]byZD53OKP TB|n: idmenabledb dwesamp fenced dbcfg *4(Bn?: 1. Z Design Studio BI 8SZ}]n?J4\mwP# NL*c Z>NP,z4(K}]Vbn?# z'0K4(UDL5G\n?D=(#*4(Zrw"SE4(}]Zr#M,L 5G\n?GXhD# Z 2 N:Z Design Studio P4(Zrw Z>NP,z+Z Design Studio P4(C44(Zr#MDZrw#ZrwG;5P CZ4PZrVvD}]d;=hM}]Zr=h# *4(BDZrw: 1. Z Design Studio P,%wD~ → B( → Zrw# 2. Z“B(D~”r#iDZ 1 NP4(Dn?# 3. Z“}]Vbn?”3P,dkZrw{F(}g DWE LLZrw),;s%wB; =# DB2 }]Vbff> 9.1.1 LL 61 4. Z“!q,S”3P,,S=}]b#K,S9z\;kn/}]bxP;%"i4 mP5J}]Dy># a. !q9CVPD,S# b. S}]bPmP!q DWESAMP# c. %wjI#I\aa>dk}]bDC'j6M\k# 5. Z“}]n?J4\mw”SNLP,z4(K+C4(eZr#M=hDUZrw# z'0K4PBPYwD=(: v 4(Zrw v ,S=VP}]b Z 3 N:(eZrwDZr=h Z>NP,z+(eZrwDZr=h#}g,b)=hITG!qm"$&m& \"ZrKc{M?j# (}4PBPYw4(e?vZrw:+Kc{E= Design Studio -LLi\KX*}]Zr&\#“X*Zr”G;v}L,K}L9z\;"VM' I:DL7iOT0z7cNa9PyPcODX5#}]Zr&\"VDb)X5 Gw*X*frmvD#hzX*&\,IT4P:o:VvT=iz7W5X5, SxKb,;M'I\aI:DwVz7#Z:o:VvOBDP,>}X*frI T_PTBq=: g{:rKz7 A,r,;M'2I\a:rz7 B# }KfrTb,X*Zr&\9+Fc;)PXCfrD3FE"#Z:o6Vv P,(#9CBfb}v3FH?4(efr: 'VH X*frD'VHH?CfryJCD:o:?V#}g,g{Z 10% D:o :PR=z7 A Mz7 B,r'VH5G 0.1#KYVH5GZyfr7ZyP|,frweDiP DvV5J#K5=s,bin`X*D5JM=_#}g,Z|,z7 A D :o:P,g{P 50% D:o:|,z7 B,rCEH5G 0.5#;xT., g{3v:o:|,z7 A,rZ,;:o:PR=z7 B Dza* 50%# 62 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL a} X*frDa}5GfrCEHkZNN:o:PR=CfrD$ZCEHD HJ#}g,ZyP:o:P,g{;P 5% D:o:|,z7 B,rCfr Da}5* 10.0#a}5 10 b6E A k B `XD"zEJG<;!P B DEJD 10 6#rK,“a}”IC4H?frTfrwe$b\&DDxy H# 9IT+V`(kX*Zr&\dO9C#g{4`p+wvnVi,;s+b)` pViIS`p,Zb)n.dR=DX*Ma|Pbe#V`Da{G`pDcN a9,ZKcNa9P,n;ZnWc#KcNa9F*V`(# Z>LLP,y>}]|,c[LDz7(4?Ei/)T0M'DI:E"#dv G;vm,Cm|,X*#MPDfr,2IT(} Alphablox (f4i4b)fr# *4PX*Zr&\,Xk,19C;W6}]Mz7cNa9}]4FcyhDX *fr#Kb,Zr$_9Cz7cNa9}]4T/7(wvz7"z7Si"z 7Sikz7T0z7ikSiHH.dDX*#Zz7V`(P,yPcODX* :Z>LLP,ZrwDZr=h9C SQW PDG)Zr$&mKc{# BKQjIDZrw# *(eZrw: 1. 7#Qr*CZrw#g{P4r*CZrw,rZ}]n?J4\mwP9* n?B=DZrwD~P,;s+w DWE LLZrw# 2. +=v4mKc{mS=Zr`-w-:*+- 9.1.1 LL 63 v + ITM_TXN 4mKc{DdvKZ,S=m,SKc{D In dkKZ# v + MKT_BSKT_TXN 4mKc{DdvKZ,S=m,SKc{D In1 d kKZ# c. R|%wm,SKc{,;s%wT>tTS<# ZS)0# %w7(# BK“SQL u~9(w”0Z# f. ZtTSLLyhDPG: v PD_ID v CNTPR_ID < 23. “SQL u~9(w”0ZM SQL D>D>} 64 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL (}!qP"%w>}4%( ),}%yPGXhDP#kp>}OfP vDP,b)PG>LLyXhD# g. T?VwxPi$: 1) R|%wm,SKc{,;s!qKP=K=h# 2) Z“?V4PZrw”0ZP,!q4PzIDzk,;s!qT>y>a {#Z“}]dv”0ZP+T>y># 3) %wjI# h. Z*=B;=h.0,k#fywD$w# 4. ZZr`-w-tTS<# d. ZtTSLLyhDPG: v PD_ID v NM v PD_DEPT_NM v PD_SUB_DEPT_NM 2) (}!qP"%w>}4%( ),}%yPGXhDP#kp>}Of PvDP,b)PG>LLyXhD# 3) %w!TE( )4%T^Dmo=# 4) dkBPmo=(Z>>}P,INPUT_12 GZ?dkm{)#kZ%}E. d|(Uq: v TZ NM,dk rtrim( INPUT_012.NM ) v TZ PD_DEPT_NM,dk ’Dept: ’ || rtrim(INPUT_012.PD_DEPT_NM) v T Z PD_SUB_DEPT_NM, d k ’ Subdept: ’ || rtrim(INPUT_012.PD_SUB_DEPT_NM) || ’ in ’ || rtrim(INPUT_012.PD_DEPT_NM) 6. mS`lKc{,T}%X4DP#**V`(4((;D“S?E-?E”T, KYwGXhD#+CKc{EZZr`-w-tTS<# DB2 }]Vbff> 9.1.1 LL 65 d. %w!qP!n(,;s8(!q PD_DEPT_NM M PD_SUB_DEPT_NM P#*8(b)P,kZ!qDPPmP!q NM M PD_ID,;s%ws=r 4%( )T+y!nF=ICDPPmP# zQjIZr#MD$&m=h#BK$&m=h# 7. mSX*Kc{,TiR}]PDX5#+CKc{mS=Zr`-w-tTS<# e. Z“#M{”3D0:VNPdk MBA,"ZC3D#M{VNPdk RULES#K Kc{+4({* MBA.RULES D#M# f. Z“ZrhC”3P,8(BPhC: 1) ZiPVNP!q CNTPR_ID# 2) Znsfr$HVNPdk 4#K58(X*frPvVDnsn}#g{ 8( 4,G4,ZSU=DX*frP,frwe|,Dn;a,} 3 v, fr7P|,Dn;a,} 1 v# 3) Znsfr}VNPdk 0,K58>fr};\^F# < 24. >}:|,$&m=hD?VZrw 66 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL 4) dk 10 w*nMCEHVNDYVH5,T8(?vQzIfrDCEH sZrHZ 10%# 5) dk 0.1 w*nM'VHVNDYVH5,T8(?vQzIfrD'VH AY* 10%# g. Z“{F3d”3Dnj6PVNP!q PD_ID,"ZC3Dn{PVNP!q NM# h. Z“V`(”3O`p3dDSPVNP!q PD_ID,"Z8PVNP!q PD_SUB_DEPT_NM#TZ Category1 3d,ZSPVNP!q PD_SUB_DEPT_NM,"Z8PVNP!q PD_DEPT_NM# i. Z“PtT”3P,T{F3dVN!q{F,"TV`(VN!qG# j. Z“nq=”3P,!q1!# 8. Z-4F" KP CREATE TABLE MARTS.RULES od,2ITZ DB2 |n0ZP V$4(Cm#(ZzDFczO,KD~D76I\aPy;,#)g{ V$4(Cm,r9h*+;v?jmKc{O=-xPW+;fDl+2&#+wC{E+r*oO0Z# Zrw=h+T>ZZr`-wP# QjIDZrwgBy>: DB2 }]Vbff> 9.1.1 LL 67 NL*c zQ-*#M4(KCZVvz7X*DZr=h# z'0K4PBPYwD=(: v (eZrwDZr=h v mSM,S$&mKc{ v mSM,SZrKc{ v mSi!wKc{ v mSIS/wKc{ Z 4 N:KPMi4Zr#M Z>NP,z+KPOZNP4(DZrw#y>}]|,c[LDz7#X*&\ T>KvVDz7I:iO# *KPMi4Zrw: 1. Z}]bPKPZrw# a. %w$_8ODZ}]bP4PKZrwX* frDS<#“fr”S;vfr,"T>KXZf r`XTMJ?DH?# 2. i4Zr#M# a. %wn/OTT>HEz7Mz7/ODPm#%wu? [?E: gw]#zIT 4=,“'VH”PT> 6.4% DM'Sbv?E:rKz7# b. g{zk*KbD)M'Zgw?E:rz7D5J|_,IT%w$_8O DHkKbVivD"z5J`TZyPM' D,vyH,“xT'VH”P8>Kf0DM'}# c. !q 9.1.1 LL d. XUX*#M#1a>#fZr#Ma{1,k;*#fa{# Z“}]dv”xrP,z+4=4P}LD4,MYw#Z}]bJ4\mwP,z +4=T>DZr#MQf"Z}]bP# UUKPD#M9CKX*&\#kX*&\`,,rP#=&\M/:&\;h* T#M4P@V&\#4,C#M>mMITGnUDa{#g{*9C3v#M4 xP$b,rh*bTC#MDJ?(“bTw”Kc{)# NL*c Z>NP,zKP"i4KCZVvz7kM'I:iO.dDX*DZr#M# z'0K4PBPYwD=(: v KPZrw v i4X*#MDa{ #i 7:9(wC}]Zr#MD DB2 Alphablox (f Z>#iP,z+9C DB2 Alphablox FastForward #e4Z;%=(fS} ],b)SMiED>T0|D(fb[# Z>#iP,zk*k JK Superstore D5qVv1Md{L5C'Vm}]Zr#M a)DBE"#(}ZyZ Web D(fPT>}]ZrE",C'M\;"V}]P H0~,DE"#Z>#iP,z+9C$(eD DB2 Alphablox FastForward #e4 i4}],K}]G9CO;#iP4(D}]Zr#Mi!D# >#iIBPNLiI: v Z 70 3D:Z 1 N:?p“DWE LL”&CLrTck DB2 Alphablox dO9C; v Z 70 3D:Z 2 N:(e9C“DB2 Alphablox X5(f”i~D DB2 Alphablox FastForward (f; '0?j jI>#iPDNLs,z+mb“DB2 Alphablox X5(f”&\Dy>En"\;4 PBPYw: v (e DB2 Alphablox X5}]4 v + DB2 Alphablox &CLr20= WebSphere ~qwO v 9C$(eD DB2 Alphablox FastForward (f#e4(e(f yhD1d jI>#i 9.1.1 LL 69 Hvu~ 7#Q}7XdCK DB2 Alphablox#7#QjI20 DB2 Alphablox sXh4PD =h#209+*sCJ DB2 }]bD`& DB2 4 ` JDBC }/Lr# Z 1 N:?p“DWE LL”&CLrTck DB2 Alphablox dO 9C Z>NP,z+'0gN+$(eD Alphablox FastForward &CLr?p= DB2 Alphablox P# IT+H0*"D DB2 Alphablox FastForward &CLr(}g+CZ>#iD&CL r)?p='V DB2 Alphablox &CLrD WebSphere ~qwO#Z>NP,z+Q “DWE LL”y>&CLr20= WebSphere ~qwO,;s+dD=h#g {4jI“#i 5”,k4PbohvD=h# *?p“DWE LL”&CLrTck DB2 Alphablox dO9C: 1. (eXhD DB2 Alphablox X5}]4(DWESAMP)# *4( DWESAMP }] 4,kNDZ 51 3D:#i 5:9(yZ OLAP "=eD DB2 Alphablox (f; PDZ 53 3D:(e DB2 X5}]4;# 2. Z WebSphere ~qwO20“DWE LL”# *+“DWE LL”&CLr20= WebSphere ~qwO,kNDZ 55 3D:Z 2 N:Z WebSphere ~qwO?p DB2 Alphablox &CLr;# 3. +“DWE LL”&CLrITKP DB2 Alphablox &CLrD “&CLr”3#C'(#9CE'x>Md{ Web 3fOD,4S4r*Q?pD& CLr# NL*c Z>NP,z+KbgN4PBPYw: v (e DB2 Alphablox X5}]4# v + DB2 Alphablox &CLr20= WebSphere ~qwO v + WebSphere &CLrNP,z+9C(F FastForward #e44((f,;sTC'G+^DVPD( f# 70 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL >NkZ 51 3D:#i 5:9(yZ OLAP "=eD DB2 Alphablox (f;`F, +>N1S9CX5}],x;GT>S DB2 Alphablox Cube Server DX5"=eP IzD}]#Z>NP,z+9C;%=C'gf4T>}],Cgf9C“DB2 Alphablox X5(f”i~# *9C“DB2 Alphablox X5(f”4(eh*wC}]Zr#MD FastForward (f: 1. 9C Web /@w4r* DB2 Alphablox \m3f#Z“&CLr”0ZP,(}% w&CLr{4!q“DWE LL”&CLr# d;zG9C\m1(^Gu<(f# 3. ZC(fO=D FastForward &CLr$_8O,%w\mNq4%# S<+P; *C&CLrD\m1S<# 4. Zs_<=K%O=D$_8P,%w4((f4%# +r*“`-(f”0Z,C 0Z|,I(FD(f#eVNMN}# 5. (F(f: a. Z{FVNP,^DjbTT>c0wDZrVv# b. ZhvVNP,dk9C}]Zr#MqCDkc0wD`XDa{# c. Z“(fN}”?VBf,i$Gq8(KBP(fN}: #e !P FastForward ReportBlox >}!n# hv KVNT>XZy!(f#eDE"# ?< KVNT>y9CD FastForward #eD;C#IT9CK;C4iRI T(FD#e# }]4 !P DWESAMP }]4#g{P`v|,d{}]Zra{D}]4, rITZ(f#eP|DK5,Ty]y9CD Intelligent Miner }]Z r#M44(BD}]Zr(f# Zrm &C!q MARTS.RULES m#ZrmK%P>KICDZrm,zI TSPxP!qT4(B(f# ?E rBv/IC?EPm,za4=1!ivB!qK=v?E(?E: gwM?E:c0wD)#Z>NP,k;*|DTb=v?ED!q# g{zkx;=xP=?,IT5X=>>}""T9Cd{?E! n,Ti4}]Zr#MR=Dd{X5# 6. %w#f4%T#fC(f,)Ts9C# 7. %wR_(f#eO=D5X=&CLr4S# +5X=“DWE LL”&CLrDC '==# 8. (}9Cs_D<=K%,Z“DB2 (f”!nBf!qBD“}]Zr>}”(f# b +r*UU4(D(f# 4(K(fs,C'(Z>}P,8yP+2C')M\;CJK(f#(}i4“Z rVv”(f,JK Superstore 5qVv1\;"VYzzaT0Z,;;C 9.1.1 LL 71 (}9CK(fPDE",Vv1ITrz[M*z?EavPXgNy]c0wD ?EI:_9+Zgw?EI:L7DI\T4a_gw?Ez[?D(i#+b= v?EDL7ZEZ;p,PI\aa_gw?EDz[?# NL*c Z>NP,zw*&CLr\m1i4"(eKBD FastForward (f#z9w*L5 C'y]H04(DdP;v(f4(KB(f# z'0K4PBPYwD=(: v dCwC}]Zr#MD$(e FastForward (f v 9CK(f4"VP$Dz7z[X5 IT9C DB2 Alphablox 49(WZ9CD(f&CLr(}g>LLP9CD(f& CLr)#DB2 Alphablox 9a)Ks? JSP (FjGM Java API,*"_IT9Cb )jGM API 49(4SD&CLr,TcZE'x>&CLrPT>}]r_+}] 6k=5qwL&CLrP#*q!PX DB2 Alphablox D|`LLME",kCJ DB2 Alphablox E"PD# \a zQ-*{* JK Superstore Di9+>hF"?pK)9 DB2 }]Vb&\DL5 G\bv=8# Q'0DNL Z>LLP,z'0KBPEnMNq: v 9C Design Studio 4hFMbTbv=8 v 9C\mXF(4?pM\mbv=8 v |Bom#=hF v 9CyZ SQL D}]wMXFw4ndB}]/PDB5m v hFj{D"=e#M"?p\;a_T\D MQT v hFZr#M v 9(yZ OLAP *}]MZr#MD Alphablox (f 72 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL yw IBM I\;ZyPzRrXxa)>D5PV[Dz7"~qr&\XT#PXz10 yZxrDz7M~qDE",krz1XD IBM zmI/#NNT IBM z7"L rr~qD}C"GbZw>r5>;\9C IBM Dz7"Lrr~q#;*;V8 IBM D*6z(,NN,H&\Dz7"Lrr~q,I\Q5Pr}Zjkk>D5Z]PXDwn({#a)>D5"4ZhC '9Cb)({DNNmI#zITCif==+mIi/Dy: IBM Director of Licensing IBM Corporation North Castle DriveArmonk, NY 10504-1785 U.S.A. PX+VZ(DBCS)E"DmIi/,kkzyZzRrXxD IBM *6z(?E* 5,rCif==+i/Dy: IBM World Trade Asia Corporation Licensing2-31 Roppongi 3-chome, Minato-ku Tokyo 106, Japan >un;JC"zrNNbyDunk1X(I;;BDzRrXx:International Business Machines Corporation04V41a)>vfo,;=PNNV`D(^[Gw >D9G5,D)#$,|(+;^Z5,DPXGV("JzMJCZ3VX(C >D#$#3)zRrXxZ3);WP;Jmb}w>r5,D#$#rK>un I\;JCZz# >E"PI\|,JODBf>P#IBM ITf1T>JOPhvDz7M/rLrxP DxM/r|D,x;mP(*# >E"PTG IBM Web >cDNN}C<;G*K=cp{Ea)D,;TNN== d1TG) Web >cD#$#G) Web >cPDJO;G IBM z7JOD;?V, 9CG) Web >cx4DgU+IzTPP## IBM IT4|O*J1DNN==9CrV"zya)DNNE"x^kTzP#NN pN# >LrD;mI=g{*KbPXLrDE"To=gB?D:(i)JmZ@"4( DLrMd{Lr(|(>Lr).dxPE";;,T0(ii)JmTQ-;;DE "xP`%9C,kkBPX7*5: ;*qXJ1Du~Mun,|(3)iNBD;(}?D6Q,JOPhvDmILr0dyPICDmIJOyI IBM @] IBM M'-i"IBM zJm~mI-irNN,H-iPDuna)# © Copyright IBM Corp. 2006 73 K&|,DNNT\}]D5DC'&1i$dX(73DJC}]# f0G IBM z7DE"ISb)z7D)&L"dvf5wrd{I+*qCDJO Pq!#IBM ;PTb)z7xPbT,2^(7OdT\D+7T"f]TrNNd {XZG IBM z7Dyw#PXG IBM z7T\DJb&1rb)z7D)&La v# yPXZ IBM 44=rrbrDywK?jMb8xQ# >E"I\|,U#5q-*P9CD}]M(fD>}#*K!I\j{X5wb )>},b)>}P|(vK"+>"7FMz7D{F#yPb)K{r{Fy5 i9,gP5JDs5{FMX7kKW,,?tIO# f(mI: >E"I\|(4oTN=Dy>&CLr,b)y>5w;,Yw=(OD`L= (#g{G*4UZ`4y>LrDYw=(OD&CLr`LSZ(API)xP&C LrD*""9C"-zrV"*?D,zITNNN=Tb)y>LrxP4F" ^D"V",x^kr IBM 6Q#b)>}"4ZyPu~Bw+fbT#rK,IBM ;\##r5>b)LrDI?T"I,$Tr&\# 2b)y>LrD?]=4rdNN?VrNN\zz7,DLjr"aLj,RQZ DB2 UDB D5bPDAY;]D5P 9C: Microsoft"Windows"Windows NT M Windows UjG Microsoft Corporation Z@z M/rd{zRrXxDLj# 74 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL Intel M Pentium G Intel Corporation Z@zM/rd{zRrXxDLj# Java MyPyZ Java DLjG Sun Microsystems, Inc. Z@zM/rd{zRrXx DLj# UNIX G The Open Group Z@zMd{zRrXxD"aLj# d{+>"z7r~q{FI\Gd{+>DLjr~qjG# Linux G Linus Torvalds D"aLj#Red Hat MyPyZ Red Hat DLjMUjG Red Hat, Inc. Z@zMd{zRrXxDLjr"aLj# d{+>"z7r~q{FI\Gd{+>DLjr~qjG# yw 75 76 IBM DB2 DWE LL: DB2 }]Vbff> 9.1.1 LL k IBM *5 ZPz,kBgBPdP;vEkTk IBM *5: v 800-810-1818 r (010) 84981188 Vz 5017,IqC[0M'~q; v 800-810-1818 r (010) 84981188 Vz 5151,IqC[0M'~q; v 800-810-1818 r (010) 84981188 Vz 5200,IqC[sM'~q; z7E" P X DB2 } ] V b f D E " I ( } r , x q ! , x 7 * : http://www-900.ibm.com/cn/software/db2/# K>c|,PX DB2 z7Re"DB2 bv=8"D XHTML q=a)D# XHTML q=9z\;y]/@wPhCDT>W!n4i4D5#Kq=9Jmz9 CA;JAwMd{(zird{ DB2 }]VbfD 5DNNb{#zIT9CBPNN=(4a)b{: v 9CZ_A_b{m"MzDb{,x7*:www.ibm.com/software/data/rcf# v (}gSJ~+zDb{"MA ctscrcf@cn.ibm.com#7#|(z7D{F"z7D f>ET0i.D{FM?~E(g{JC)#g{zTX(D>Pb{,k|(K D>D;C(}g,jb"mEr3k)# v (}U(J~+zDb{"MA: IBM Pz+>O#V+>,:/?PzO#P4#P7 333 Ep2c! 10 % J~`k:200021 PXgNZ@zTbDX=k IBM *5DE",kCJ IBM r,x3f www.ibm.com/planetwide# © Copyright IBM Corp. 2006 77  LrE: 5724-E34 Pz!" S151-0413-01

下载文档,方便阅读与编辑

文档的实际排版效果,会与网站的显示效果略有不同!!

需要 20 金币 [ 分享文档获得金币 ] 0 人已下载

下载文档

相关文档