BAZY DANYCH SQL1.pdf

64/

,VWQLHM M]\NLIRUPDOQHGRVWDUF]DMFH]ZL]áHMQRWDFMLGRUHSUH]HQWDFML]DS\WD-HGQDN*HNRPHUF\MQHV\VWHP\

ED]RGDQRZHZ\PDJDM M]\ND]DS\WDNWyU\MHVWEDUG]LHMSU]\MD]Q\GODX*\WNRZQLNDXVHUIULHQGO\7DNLPL

M]\NDPLV PLG]\LQQ\PL4%(4XHOLM]\NX*\ZDQ\ZV\VWHPDFKZ\V]XNLZDZF]\FK'DWDORJ&KFLHOLE\P\

SU]HGVWDZLüMHGHQ]QDMSRSXODUQLHMV]\FKM]\NyZED]RGDQRZ\FKMDNLPMHVW64/&KRFLD* RGQRVLP\VL GRM]\ND

64/MDNRGRM]\ND]DS\WD]DZLHUDRQUyZQLH* WDNLHHOHPHQW\MDNGHILQLRZDQLHVWUXNWXUGDQ\FKPRG\ILNRZDQLH

GDQ\FKLVSHF\ILNDFMDRJUDQLF]H ]ZL]DQ\FK]EH]SLHF]HVWZHP&KFLHOLE\P\SU]HGVWDZLüSRGVWDZRZH

NRQVWUXNFMHLNRQFHSFMH64/D,QG\ZLGXDOQHLPSOHPHQWDFMH64/DPRJ VL Uy*QLüZV]F]HJyáDFKOXEPRJ

GRVWDUF]DüMHG\QLHF]üSHáQHJRM]\ND

7áRKLVWRU\F]QH

64/RNUHODVLHELHMDNRVWDQGDUGRZ\UHODF\MQ\M]\NED]RGDQRZ\-HVWZLHOHZHUVML64/D2U\JLQDOQDZHUVMD

]RVWDáDRSUDFRZDQDSU]H],%0V6DQ-RVH5HVHDUFK/DERUDWRU\REHFQLH$OPDGHQ5HVHDUFK&HQWHU2U\JLQDOQD

QD]ZDWHJRM]\NDWR6HTXHO%\áRQ]DLPSOHPHQWRZDQ\MDNRF]üSURMHNWX6\VWHPX5QDSRF]WNXODW

VLHGHPG]LHVLW\FK-]\N6HTXHOHZROXRZDáRGNLHG\MHJRQD]ZD]RVWDáD]PLHQLRQDQD64/6WUXFWXUHG4XHU\

/DQJXDJH1DVWDQGDUG]LHM]\ND64/ED]XMHZLHOHSURJUDPyZNRPHUF\MQ\FK:U$PHULFDQ1DWLRQDO

6WDQGDUGV,QVWLWXWH$16,L,QWHUQDWLRQQDO6WDQGDUGV2UJDQL]DWLRQ,62RSXEOLNRZDá\VWDQGDUG64/DQD]ZDQ\

64/:U,%0RSXEOLNRZDáVZyMZáDVQ\VWDQGDUG64/D]ZDQ\6\VWHPV$SOLFDWLRQ$UFKLWHFWXUH

'DWDEDVH,QWHUIDFH6$$64/5R]V]HU]RQ\VWDQGDUG64/D64/]RVWDáRSXEOLNRZDQ\ZURNX

:VSyáF]HVQHV\VWHP\ED]RGDQRZHSU]HZD*QLHV ]JRGQH]ZHUVMD64/2EHFQ ZHUVM $16,,6264/MHVW

64/

:W\PUHIHUDFLHSU]HGVWDZLDP\SU]HJOG64/DRSDUW\QDVWDQGDUGDFK64/L64/

64/PR*QDSRG]LHOLüQDNLONDRGG]LHOQ\FKF]FL

x 'DWDGHILQLWLRQODQJXDJH ''/-]\NGHILQLFMLGDQ\FK''/GRVWDUF]DNRPHQGGODWZRU]HQLDL

PRG\ILNRZDQLDVWUXNWXU\ED]\GDQ\FKL]DZDUWRFLWDEHO

x ,QWHUDFWLYH'DWD0DQLSXODWLRQ/DQJXDJH'0/-]\NPDQLSXORZDQLDGDQ\PL=DZLHUDUyZQLH*

NRPHQG\ZVWDZLDQLDXVXZDQLDLPRG\ILNRZDQLDUHNRUGyZZED]LHGDQ\FK

x (PEHGGHG'0/2VDG]RQDIRUPD64/D]DSURMHNWRZDQDGRX*\FLD]WDNLPLM]\NDPLSURJUDPRZDQLDMDN

3/,&RERO3DVFDO)RUWUDQL&

x 9LHZGHILQLWLRQ64/''/]DZLHUDMDF\NRPHQG\GRGHILQLRZDQLDZLGRNyZ

x $XWRUL]DWLRQ64/''/]DZLHUDMF\NRPHQG\VSHF\ILNXMFHSUDZDGRVWSXGRUHODFMLLZJOGXZGDQH

x ,QWHJULW\64/'//]DZLHUDNRPHQG\VáX*FHGRVSHF\ILNDFMLZDUXQNyZLQWHJUDOQRFLNWyU\FKGDQH

SU]HFKRZ\ZDQHZED]LHPXV] SU]HVWU]HJDü=PLDQ\QDUXV]DMFHWHZDUXQNLV QLHGR]ZRORQH

x 7UDQVDFWLRQFRQURO64/]DZLHUDNRPHQG\VSHF\ILNXMFHUR]SRF]\QDQLHLNRF]HQLHWUDQVDNFML1LHNWyUH

LPSOHPHQWDFMHSR]ZDODM UyZQLH* ]DEORNRZDüGRVWSGRGDQ\FKGODNRQWUROLZVSyáELH*QRFL

:W\PUHIHUDFLHSU]HGVWDZLP\LQWHUDNW\ZQ\'0/LSRGVWDZRZHFHFK\'//Z64/X:V]\VWNLHSRQL*V]H

SU]\NáDG\GRW\F] SUREOHPXREVáXJLSR*\F]HNZEDQNDFK8*\ZDP\ZQLFKQDVWSXMF\FKWDEHO

x ILOLH QD]ZDBILOLLPLDVWRDNW\ZD

x NOLHQFL QD]ZDBNOLHQWDXOLFDBNOLHQWDPLDVWRBNOLHQWD

x SR*\F]NL QD]ZDBILOLLQXPHUBSR*\F]NLZDUWRü

x SR*\F]NRELRUF\ QD]ZDBNOLHQWDQUBSR*\F]NL

x NRQWD QD]ZDBILOLLQUBNRQWDELODQV

x GHSR]\WRU]\ QD]ZDBNOLHQWDQUBNRQWD

6WUXNWXU\SRGVWDZRZH

5HODF\MQDED]DGDQ\FKVNáDGDVL ]H]ELRUXUHODFML.D*GD]QLFKPDVZRMDXQLNDOQDQD]Z64/XPR*OLZLD

X*\ZDQLHSXVW\FKZDUWRFLGODR]QDF]HQLD*HZDUWRüMHVWQLH]QDQDOXEQLHLVWQLHMH6 SRGMWHSHZQHNURNLDE\

XPR*OLZLüX*\WNRZQLNRZLVSUHF\]RZDQLHNWyUHDWU\EXW\QLHPRJ SR]RVWDüSXVWH:UyFLP\GRWHJRWHPDWXQLHFR

Sy(QLHM3RGVWDZRZDVWUXNWXUD64/RZ\FKZ\UD*H ]DZLHUDWU]\HOHPHQW\VHOHFWIURP LZKHUH

x VHOHFW NODX]XODVHOHFWRGQRVLVL MHVWUyZQRZD*QDGRRSHUDFMLSURMHFWLRQ U]XWRZDQLHZDOJHEU]H

UHODFML-HVWX*\ZDQ\GRZ\OLVWRZDQLDDWU\EXWyZ]DGDQ\FKZUH]XOWDFLH]DS\WDQLD

x IURP RGSRZLDGDRSHUDFMLSURGXNWX.DUWH]MDVNLHJRZDOJHEU]HUHODF\MQHM:\OLVWRZXMHVSLVXMHUHODFMH

NWyUHPDMDE\üEUDQHSRGXZDJ SU]\Z\OLF]DQLXZ\UD*HQLD"

x ZKHUH RGQRVLVL GRZ\ERUXSUHG\NDWXZDOJHEU]HUHODF\MQHM=DZLHUDSUHG\NDWREHMPXMF\DWU\EXW\

UHODFMLNWyUDSRMDZLáDVL ZNODX]XOLIURP

7\SRZH64/RZH]DS\WDQLHPDSRVWDü

6HOHFW $$$Q

)URP UUUP

:KHUH 3

*G]LH$LUHSUH]HQWXM DWU\EXW\ULWDEHOHD3MHVWZDUXQNLHPMDNLPXV] VSHáQLDüZ\SLV\ZDQHUHNRUG\-H*HOL:KHUH

MHVWSRPLQLWH3PDZDUWRüWUXHGODZV]\VWNLFKUR]SDWU\ZDQ\FKUHNRUGyZ64/WZRU]\LORF]\QNDUWH]MDVNL]WDEHO

Z\SLVDQ\FKSRVáRZLH)URPGRNRQXMHVHOHNFMLX*\ZDMFZDUXQNX]DZDUWHJRZNODX]XOLZKHUHDQDVWSQLHWZRU]\

Z\QLNZ\ZLHWODMFSROD]DZDUWHZNODX]XOL6HOHFW:SUDNW\FH64/SRWUDILNRQZHUWRZDüZ\UD*HQLDGR

RGSRZLDGDMFHMLPEDUG]LHMHIHNW\ZQHMIRUP\DOHQLHEG]LHP\VL W\PZWHMFKZLOL]DMPRZDü

.ODX]XODVHOHFW

6NáDGQLD

6(/(&7 >$// _',67,1&7 _@

)520 WDEHOD

:+(5( NU\WHULD

',67,1&7SRPLMDUHNRUG\NWyUHPDM WDNLHVDPHZDUWRFLZZ\EUDQ\FKSRODFKWDEHO

$//Z\ELHUDZV]\VWNLHUHNRUG\VSHáQLDMFHNU\WHULXPSRVáRZLHNOXF]RZ\PZKHUHRSFMDGRP\OQD

:NODX]XOL6HOHFWPR*HZ\VWSLü]QDN]DVWSXMF\ZV]\VWNLHSROD]WDEHOZ\PLHQLRQ\FKZNODX]XOL)URP

0R*HRQDUyZQLH* ]DZLHUDüZ\UD*HQLDDU\WPHW\F]QH1SUH]XOWDWHPZ\UD*HQLD

6HOHFW QD]ZDBILOLLQUBSR*\F]NLZDUWRü

)URP SR*\F]NL

%G]LHWDEHODSR*\F]NL]DZLHUDMFDQD]ZHBILOLLQUBSR*\F]NLRUD]ZDUWRüSRPQR*RQ SU]H]

.ODX]XODZKHUH

6NáDGQLD:+(5( NU\WHULXP

.U\WHULXPZ\UD*HQLHNWyUHVSHáQLDM UHNRUG\ZáF]DQHGRZ\QLNX]DS\WDQLD

3U]\NáDG\

:KHUH QD]ZDBILOLL .UDNyZDQG ZDUWRü!

$QGMHGHQ]RSHUDWRUyZORJLF]Q\FKRUQRW

:KHUH ZDUWRü DQG ZDUWRü!

/XEPR*QDWR]DSLVDüLQDF]HM

:KHUH ZDUWRüEHWZHHQ DQG

.ODX]XOD)URP

6NáDGQLD)URP WDEHOH

:NODX]XOL)URPZ\PLHQLDP\WDEHOH]NWyU\FKSRELHUDP\GDQH

2SHUDFMD]PLDQ\QD]Z\

6NáDGQLDVWDUDBQD]ZDDVQRZDBQD]ZD

DVPR*HUyZQLH* E\üSU]\GDWQHSU]\SRUyZQ\ZDQLXUHNRUGyZZWHMVDPHMWDEHOL

6HOHFW GLVWLQFW7QD]ZDBILOLL

)URP ILOLHDV 7ILOLHDV 6

:KHUH 7DNW\ZD!6DNW\ZDDQG 6PLDVWR .UDNyZ

3RZ\*V]\SU]\NáDGZ\SLVXMHQD]Z\ILOLLNWyU\FKDNW\ZDV ZLNV]HQL* QDMPQLHMV]H]ILOLL.UDNRZVNLHM

2SHUDFMHQDáDFXFKDFK]QDNRZ\FK

6NáDGQLDZKHUH SROH>OLNH _QRWOLNH@Z]RU]HF

:]RU]HFPR*H]DZLHUDüVSHFMDOQH]QDNL

]DVWSXMHGRZROQHMGáXJRFLáDFXFK]QDNyZ

B]DVWSXMHMHGHQGRZROQ\]QDN

?]QDNWHQZ\VWSXMF\SU]HGNWyU\P ]H]QDNyZVSHFMDOQ\FKVSUDZLD*HMHVWRQWUDNWRZDQ\MDNRQRUPDOQ\

3U]\NáDG

6HOHFW QD]ZDBNOLHQWD

)URP NOLHQFL

:KHUH XOLFDBNOLHQWDOLNH ZDFNLHJR

6RUWRZDQLHZ\ZLHWODQ\FKUHNRUGyZ

6NáDGQLDRUGHUE\SROH>GHVF _DVF @

.ODX]XODWDVRUWXMHUHNRUG\ZJSRODZSRU]GNX

'HVFPDOHMF\P

$VFURVQF\PGRP\OQLH

3U]\NáDG

6HOHFW

)URP SR*\F]NL

2UGHUE\ DNW\ZDGHVFQUBSR*\F]NLDVF

:\QLNLHPSRZ\*V]HJRSU]\NáDGXMHVWSRVRUWRZDQDOLVWDUHNRUGyZ]WDEHOLSR*\F]NLPDOHMFRZJDNW\ZyZD

QDVWSQLHURVQFRZJQXPHUyZSR*\F]NL

2SHUDFMHQD]ELRUDFK

8QLRQ VáX*\GRVXPRZDQLDGZyFK]ELRUyZUHNRUGyZ$XWRPDW\F]QLHHOLPLQXMHGXSOLNDW\-HOLFKFHP\

]DFKRZDüZV]\VWNLHGXSOLNDW\PXVLP\X*\üXQLRQDOO]DPLDVWXQLRQ3U]\NáDG

VHOHFW QD]ZDBNOLHQWDIURP GHSR]\WRU]\

XQLRQ

VHOHFW QD]ZDBNOLHQWDIURP SR*\F]NRELRUFD

LQWHUVHFW LORF]\QGZyFK]ELRUyZUHNRUGyZ8*\FLHDQDORJLF]QH

([FHSW Uy*QLFD]ELRUyZ

)XQNFMHDJUHJDFML

DYJ Z\UD*HQLHOLF]\UHGQL DU\WPHW\F]Q ]ZDUWRFL]DZDUW\FKZRNUHORQ\PSROX

&RXQW Z\UD*HQLH]ZUDFDOLF]E UHNRUGyZEGF\FKZ\QLNLHPNODX]XOLVHOHFW1RWDFMDFRXQW

]ZUDFDLORüZV]\VWNLFKUHNRUGyZZWDEHOL

0LQPD[ ]ZUDFDPLQPD[ZDUWRüGDQHJRSROD

6XP Z\UD*HQLHVXPXMHZV]\VWNLHZDUWRFLZGDQ\PSROX

3U]\NáDG

6HOHFWDYJ ELODQV

)URP NRQWD

:KHUH QD]ZDBILOLL .UDNyZ

)XQNFMHWHPR*HP\VWRVRZDüUyZQLH* QDSRODFKSHZQHMJUXS\UHNRUGyZWDNLFKZNWyU\FKGDQHSROHSU]\MPXMH

MHGQDNRZ ZDUWRü'RWHJRFHOXVWRVXMHVL NODX]XO JURXSE\-DNRLOXVWUDFMHUR]ZD*P\]DS\WDQLH

=QDMG(UHGQLVWDQNRQWZND*G\PRGG]LDOH

=DSLV]HP\WRZQDVWSXMF\VSRVyE

VHOHFW QD]ZDBILOLLDYJELODQV

IURP NRQWD

JURXSE\ QD]ZDBILOLL

.ODX]XODKDYLQJ PR*HVáX*\üGR]DZ*HQLDGDQHMJUXS\GRUHNRUGyZVSHáQLDMF\FKSRGDQ\ZDUXQHN

3XVWHZDUWRFLQXOO

'ODRNUHOHQLDF]\MDNLH SROHMHVWSXVWHPR*HP\X*\üRSHUDWRUDLVQXOO ,VWQLHMHUyZQLH* RSHUDWRULVQRWQXOO

=DJQLH*G*RQH]DS\WDQLD

64/GRVWDUF]DPHFKDQL]PXPR*OLZLDMF\]DJQLH*G*DQLH]DS\WD3RG]DS\WDQLDPDM UyZQLH* IRUPDWVHOHFWIURP

ZKHUH7\SRZH]DVWRVRZDQLDWRWHVWRZDQLHF]áRQNRVWZDSRUyZQ\ZDQLHLFDUGLQDOLW\&DUGLQDOJáyZQ\

SRGVWDZRZ\

&]áRQNRVWZR

2SHUDWRULQ WHVWXMHZ\VWSRZDQLHSRODZGDQHMWDEHOLDQRWLQ MHJRQLHREHFQRü

6NáDGQLD

6HOHFW DWU\EXW\

)URP WDEHOH

:KHUH DWU\EXWLQ_QRWLQSRG]DS\WDQLH!

*G]LHSRG]DS\WDQLHPDSRVWDü]Z\NáHJR]DS\WDQLDVHOHFWIURPZKHUH

3U]\NáDG6]XNDP\ZV]\VWNLFKNOLHQWyZNWyU]\PDMD]DUyZQRSR*\F]N MDNLNRQWRZEDQNX

6HOHFW GLVWLQFWQD]ZDBNOLHQWD

)URP SR*\F]NRELRUF\

:KHUH QD]ZDBNOLHQWDLQ VHOHFW QD]ZDBNOLHQWD)URP GHSR]\WRU]\

7HQSU]\NáDGXND]XMHGX* SODVW\F]QRü64/D7HVDPH]DGDQLDPR*HP\]UHDOL]RZDüQDUy*QHVSRVRE\FRSR]ZDOD

X*\WNRZQLNRZLP\OHüRGDQ\P]DS\WDQLHZVSRVyENWyU\MHVWGOD1LHJRQDMEDUG]LHMQDWXUDOQ\

,QQ\FLHNDZ\SU]\NáDG

6HOHFW GLVWLQFW QD]ZDBNOLHQWD

)URP SR*\F]NRELRUF\

:KHUH QD]ZDBNOLHQWDQRW LQ .RZDOVNL1RZDN

3RUyZQ\ZDQLH

6NáDGQLD

:KHUH SROH>_!_ _! _ _!@>VRPH_DOO@SRG]DS\WDQLH

8*\FLHMHVWLQWXLF\MQHQS]DS\WDQLH

6HOHFW GLVWLQFW7QD]ZDBILOLL

)URP ILOLHDV 7ILOLHDV 6

:KHUH 7DNW\ZD!6DNW\ZDDQG 6PLDVWR .UDNyZ

0R*HP\]DSLVDü]DS\WDQLHP]X*\FLHPVRPH

6HOHFW QD]ZDBILOLL

)URP ILOLH

:KHUH DNW\ZD!VRPH VHOHFW DNW\ZD)URP ILOLH:KHUH PLDVWR .UDNyZ

3RGREQLHSU]\NáDGX*\FLDDOO

6HOHFW QD]ZDBILOLL

)URP ILOLH

:KHUH DNW\ZD!DOO VHOHFW DNW\ZD)URP ILOLH:KHUH PLDVWR .UDNyZ

:SRZ\*V]\PSU]\NáDG]LHZ\ELHUDP\ZV]\VWNLHILOLHNWyUHPDM ZLNV]HDNW\ZDRGZV]\VWNLFK .UDNRZVNLFK

7HVWRZDQLHF]\Z\QLNSRG]DS\WDQLD]DZLHUDMDNLHNROZLHNUHNRUG\

3U]\NáDG

6HOHFW QD]ZDBNOLHQWD

)URP SR*\F]NRELRUF\

:KHUH H[LVWV VHOHFW )URP GHSR]\WRU]\:KHUH GHSR]\WRU]\QD]ZDBNOLHQWD SR*\F]NRELRUF\QD]ZDBNOLHQWD

3RGREQLHX*\ZDP\QRWH[LVWV

7HVWRZDQLHQDREHFQRüSRZWDU]DMF\FKVL UHNRUGyZ

6NáDGQLD

:KHUH XQLTXH SRG]DS\WDQLH

=ZUDFDWUXHMHOLZZ\QLNXSRG]DS\WDQLD]QDMG]LHVL MDNLNROZLHNGXSOLNDW

8QLTXHQRW G]LDáDRGZURWQLH

:NODX]XOLIURPPR*HP\X*\ZDüSRG]DS\WDMHGQDNQDOH*\ZyZF]DVQDGDüZ\QLNRZLWDNLHJRSRG]DS\WDQLDQRZD

QD]ZPR*QDWDN*H]PLHQLüQD]Z\DWU\EXWyZ

3U]\NáDG

6HOHFW QD]ZDBILOLLVUHGQLBELODQV

)URP VHOHFW QD]ZDBILOLLDYJELODQV)URP GHSR]\WRU]\*URXS E\ QD]ZDBILOLL

$V Z\QLNQD]ZDBILOLLVUHGQLBELODQV

:KHUH VUHGQLBELODQV!

:LGRNL9LHZV

:LGRNLZ64/XGHILQLXMHP\SU]\SRPRF\NODX]XOL

6NáDGQLD

FUHDWHYLHZ YDV ]ELyUUHNRUGyZ!

=ELRUHPUHNRUGyZPR * HE\üZ\QLNG]LDáDQLDQD]ELRUDFK

0RG\ILNDFMDED]\GDQ\FK

x 8VXZDQLHUHNRUGyZGHOHWH

6NáDGQLD

GHOHWH IURPUZKHUH3

*G]LH3ZDUXQHNUQD]ZDWDEOLF\

3U]\NáDG

'HOHWH IURPSR*\F]NL

:KHUHZDUWRüEHWZHHQDQG

x :VWDZLDQLHLQVHUWLQWR

6NáDGQLD

LQVHUWLQWR WDEHOD

9DOXHV ZDUWRüZDUWRü

3U]\NáDG

,QVHUWLQWR NRQWDQD]ZDBILOLLQUBNRQWDELODQV

9DOXHV .UDNyZ$

/XE

,QVHUWLQWR NRQWD

9DOXHV QXOO$

x 2GZLH*DQLHVáX*\GR]PLDQ\]DZDUWRFLSyOZWDEHOL

6NáDGQLD

8SGDWH WDEHOD

6HW SROH Z\UD*HQLH

:KHUH ZDUXQHNPR*QDSRPLQü

3U]\NáDG

8SGDWH NRQWD

6HW ELODQV ELODQV

:KHUH ELODQV!

7KLVLVWKHHQG

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: