Ibm db2 conceitos

,





W
W






/D 

K


,

E
E

K ^z>
/D^ K





K


K

E









E



&





&

/D ^

^
Z
/D 

:

^


K 

^' ^

D

'



/D :
>ht >
K^


h

^



t
W

/D





K^
^

/y ,W hy


DWW 
K



/D

/D
 :

yD>

D

t

W

/D
K^ 

s




K



,
^Y> KEEd

1RPH GR 3URFHVVR

'HVFULomR

GEV\VF /LQX[
GEV\VFV :LQ

2 SULQFLSDO VLVWHPD FRQWURODGRU RX HQJLQH GR '% 2 '%  WHP
DSHQDV XPD PXOWLWDUHID SULQFLSDO QR SURFHVVR HQJLQH SDUD WRGD D
SDUWLomR 7RGD (QJLQH'LVSDWFKDEOH8QLWV ('8V VmR WDUHIDV
GHQWUR GHVWH SURFHVVR 6HP HVWH SURFHVVR R VHUYLGRU GD EDVH GH
GDGRV QmR IXQFLRQDUi

GEDFG

&RPSXWDomR DXW{QRPD GDHPRQ e XWLOL]DGD SDUD H[HFXWDU WDUHIDV
DXWRPiWLFDV SDUD R FOLHQWH WDLV FRPR D PRQLWRUDomR D PDQXWHQomR
DXWRPiWLFD GRV XWLOLWiULRV H R FURQRJUDPD GR DGPLQ (VVH SURFHVVR
HUD FKDPDGR GEKPRQ

GEZGRJ

2 '% ZDWFKGRJ 2 ZDWFKGRJ p R SDL GR SULQFLSDO SURFHVVR GD
HQJLQH GEV\VF (OH OLPSD RV UHFXUVRV VH R SURFHVVR GEV\VF
ILQDOL]DU DQRUPDOPHQWH

GEYHQG

2 IHQFHGYHQGRUSURFHVV IRL LQWURGX]LGR QR '%  7RGR FyGLJR
QmR ,%0 p H[HFXWDGR QHVWH SURFHVVR IRUD GD HQJLQH (VWH FyGLJR
GH WHUFHLURV VmR SURJUDPDV QmR ,%0 TXH SRGHP LQWHUDJLU FRP R
'% FRPR SRU H[HPSOR R DUTXLYR GH ORJ SRGH VHU JHUHQFLDGR SRU
FyGLJR QmR ,%0 DWUDYpV GD HVSHFLILFDomR GH XP SDUkPHWUR GH
VDtGD GH XPD URWLQD TXH DSRQWH SDUD HVWH FyGLJR

GEIPS

3URFHVVRV ³IHQFHG´ TXH H[HFXWDP FyGLJRV GR XVXiULR QR VHUYLGRU
IRUD GR ILUHZDOO SDUD VWRUHG SURFHGXUHV H IXQo}HV GHILQLGDV SHOR
XVXiULR (VWH SURFHVVR VXEVWLWXL WDQWR R SURFHVVR GEXGI TXDQWR R
GEGDUL TXH IRUDP XWLOL]DGRV QDV YHUV}HV DQWHULRUHV GR '%

GEV\VF

6LVWHPD FRQWURODGRU GH WDUHID (VWD WDUHID p UHVSRQViYHO SHOD
LQLFLDOL]DomR ILQDOL]DomR H JHUHQFLDPHQWR GD LQVWkQFLD

GEWFSFP