=Paper=
{{Paper
|id=Vol-1221/paper79
|storemode=property
|title=Güvenlik ve Gizlilik Temelinde Şirketlere Özel Bulut Depolama Çözümü (Private Cloud Storage)
|pdfUrl=https://ceur-ws.org/Vol-1221/79_Deneyim.pdf
|volume=Vol-1221
|dblpUrl=https://dblp.org/rec/conf/uyms/Yanar14
}}
==Güvenlik ve Gizlilik Temelinde Şirketlere Özel Bulut Depolama Çözümü (Private Cloud Storage)==
<pdf width="1500px">https://ceur-ws.org/Vol-1221/79_Deneyim.pdf</pdf>
<pre>
    Güvenlik ve Gizlilik Temelinde ùLUNHWOHUHÖzel Bulut
       Depolama Çözümü (Private Cloud Storage)

                                          Ömer Yanar

 .XYH\W7UN.DWÕOÕP%DQNDVÕ$ù%LOJL7HNQRORMLOHUL3Uoje Yönetimi ve AR-*(0GUO÷
     )HULWSDúD0DK.XOH&DG. Kule Plaza Kat: 9 No: 9 P.K 42060 Selçuklu / KONYA
                              omeryanar@gmail.com



       Özet. 'Q\DJHQHOLQGHYHULPHUNH]OHULQLQJHOLúLPLLQWHUQHWDOW\DSÕVÕQDHULúLPLQ
       JQ JHoWLNoH GDKD NROD\ YH XFX] ROPDVÕ PRELO FLKD]ODUÕQ JHOLúLPL YH \D\JÕQ
       RODUDN NXOODQÕOPD\D EDúODQPDVÕ NXUXPODUÕ EXOXW DOW\DSÕVÕQD \DWÕUÕP \DSPD\D
       ]RUODPDNWDGÕU gWH\DQGDQEDúWDEDQNDODUROPDN]HUHGRNPDQODUÕQÕQJYHQ
       OL÷LQHYHJL]OLOL÷LQHVRQGHUHFH|QHPYHUHQúLUNHWOHULoLQYHULOHULQoQFNLúL
       OHUOHSD\ODúÕOPDVÕE\NVRUXQWHúNLOHWPHNWH bulut çözümlerinden uzak durma-
       ODUÕQD\RODoPDNWDGÕU%XELOGLULGHNXUXPODUÕQYHULOHULQLEDúNDúLUNHWOHUOHSD\
       ODúPDN]RUXQGDNDOPDGDQNXUXPEQ\HVLQGHEXOXQDQYHULPHUNH]OHULQGHsak-
       ODQDQYHNXUXPXQJYHQOLNGXYDUÕLOHNRUXQDQGRV\DODULoLQúLUNHWH|]HObir bu-
       OXWVLVWHPLQLQ SULYDWHFORXG NXUXOPDVÕDQODWÕOPDNWDGÕU'RV\DODUÕQVDNODQPDVÕ
       \HGHNOHQPHVLYHHULúLOPHVLQGH64/6HUver FileSWUHDPWHNQRORMLVLNXOODQÕOPÕú
       WÕU*HOHQHNVHOGRV\DVLVWHPL\HULQHLOLúNLVHOYHUL WDEDQÕNXOODQÕPÕQÕQVHEHSOHUL
       ve avantajlaUÕQGDQ EDKVHGLOPLú GRV\D ER\XWODUÕQÕQ DUWPDVÕ\OD ELUOLNWH )LOH6t-
       UHDP WHNQRORMLVLQLQ YHULPOLOL÷LQLQ DUWPDVÕ ]HULQGH GXUXOPXúWXU $\UÕFD GRV\D
       ER\XWODUÕQÕQVLVWHPSHUIRUPDQVՁ]HULQGHNLHWNLVLLQFHOHQPLúELUHúLNGH÷HUEH
       OLUOHQHUHN GRV\DODUÕQ ER\XWXQD J|UH YHUL WDEDQÕ WDEORVXQGD \D GD )LOHStream
       ]HULQGH\HUDOPDVÕVD÷ODQDUDNSHUIRUPDQVPDNVLPL]HHGLOPH\HoDOÕúÕOPÕúWÕU

       Anahtar Kelimeler: %XOXW%LOLúLP%XOXW'epolama, Cloud Computing, Cloud
       Storage, Private Cloud


1      *LULú

*HOLúHQ WHNQRORML LOH JHoPLúWH NXOODQÕODQ EDVÕOÕ ELOJL ND\QDNODUÕ KÕ]OD GLMLWDO RUWDPD
WDúÕQPDNWDGÕU *QP]GH ELOJLVD\DUODU LQVDQODUÕQ LVWHGLNOHUL GRV\DODUD DQÕQGD HULú
PHOHULQL VD÷OD\DQ VDQDO NWSKDQHOHU KDOLQH G|QúPú LQWHUQHWLQ GH \D\JÕQODúPDVÕ
ile dijital ortamdaki bu dosyalara birdHQoRNNLúLQLQ]DPDQYHmekân ED÷ÕPVÕ]HULúL
PLQLQVD÷ODQPDVÕQD\|QHOLNVLVWHPOHUJHOLúWLULOPLúWLU [1].
   0HYFXW GXUXP LQFHOHQGL÷LQGH NXUXP LoLQGH oDOÕúDQODU LúOHULQGH JHUHNOL GRV\DODUÕ
kuruma ait RUWDNELUGRV\DVXQXFXVXQGD\DGDLú\HULQGHNXOODQGÕNODUÕELOgisayarlarda
WXWPDNWDGÕUøú\HULQGHEDUÕQGÕUÕODQGRV\DODUDNXUXPJYHQOLNSROLWLNDODUÕJHUH÷LoR÷X
]DPDQGÕúDUÕGDQHULúLPVD÷ODQDPDPDNWDEXGRV\DODUDELUGHQID]ODNLúLQLQHULúLPLV|]
NRQXVX ROGX÷XQGD LVH SD\ODúÕP \HWNLOHQGLUPH YH HULúLP VRUXQX RUWD\D oÕNPDNWDGÕU
(ULúLOHFHNGRV\DVD\ÕVÕDUWWÕ÷ÕQGDVLVWHPLQNHVLQWL\HX÷UDPDGDQYHULPOLúHNLOGHoDOÕú




                                                814
PDVÕEDUÕQGÕUPDVÕQÕIODQGÕUPDHULúLPYH\HWNLOHQGLUPHNRQXODUÕQÕQKHSVLQLNDSVD\DQ
bir \D]ÕOÕPYHGRQDQÕPVRUXQu haline gelmektedir.
    %DúWDdosyaODUÕQKHU\HUGHQXODúÕODELOPHLKWL\DFÕROPDN]HUHGRQDQÕPED÷ÕPOÕOÕ
÷ÕQÕQD]DOPDVÕdosya GHSRODPDVRUXQODUÕQÕQD]DOPDVÕ YHULOHULQNÕVDVUHGHGDKDID]OD
NLúL\OH SD\ODúÕODELOPHVL SODWIRUP ED÷ÕPOÕOÕ÷Õ ROPDNVÕ]ÕQ YHULOHUH HULúLOHELOPHVL JLEL
JHUHNVLQLPOHUGHQGROD\Õ dünyaca QO\D]ÕOÕPYHWHNQRORMLILUPDODUÕWDUDIÕQGDQdosya
SD\ODúÕPÕNRQXVXQGDoDOÕúPDODU\DSÕOPÕúWÕU%XoDOÕúPDODUVRQXFXortaya oÕNDQuygu-
lamalar, VHUYLVRODUDNVXQXODQODUYHX\JXODPDRODUDNGD÷ÕWÕODQODUROPDN]HUHEDúOÕN
DOWÕQGDLQFHOHQHELOLU
    Servis olarak sunulan Dropbox, Google Drive, Apple iCloud, Microsoft OneDrive
gibi uygulamalar kritik verilerin NXUXPGÕúÕVXQXFXODUGDWXWXOPDVÕJHUHNOLOL÷LQGHQYHUL
JYHQOL÷LQLWHKGLWHWPHNWHúLUNHWLoLNULWLN YHULOHULQVDNODQPDVÕ QRNWDVÕQGDXOXVDO YH
kurXPVDO ULVNOHU WDúÕPDNWDGÕU $PHULND %LUOHúLN 'HYOHWOHUL 8OXVDO *YHQOLN $MDQVÕ
 16$ WDUDIÕQGDQ\UWOHQ35,60SURMHVLQLQ\ÕOÕQGDPHG\D\DVÕ]GÕUÕOPDVÕLOH
ELUOLNWHEXHQGLúHOHUL\LFHDUWPÕúWÕU [2]%Xo|]POHUGRV\DODUÕQELUVXQXFXGDWXWXOXS
IDUNOÕSODWIRUPODUGDQXODúÕODELOPHVLQLYHEXGRV\DODUÕQSD\ODúÕODELOPHVLQLVD÷ODPDNWD
ROXSELUOLPLWHNDGDUFUHWVL]RODUDNVXQXOPDNWDOLPLWVRQUDVÕKL]PHWOHULVHFUHWOHQ
dirilmektedir.
    dR÷XQOXNOD NLúLVHO YH\D NoN LúOHWPHOHULQ NXOODQÕPÕ LoLQ X\JXQ RODQ EX KL]PHt-
lerde, úLUNHWRUJDQL]DV\RQD÷DoODUÕQÕQEXVLVWHPOHUHHQWHJUHROPDVÕGHSDUWPDQUROYH
NLúL\|QHWLPLQLQHQWHJUHELUúHNLOGH\DSÕODELOPHVLPPNQGH÷LOGLU.DSDVLWHDUWÕUÕPÕ
V|]NRQXVXROGX÷XQGD\ÕOOÕNOLVDQVFUHWOHULRUWD\DoÕNPDNWDYDURODQVLVWHPOHUHen-
WHJUDV\RQNÕVÕWODUÕYHPDOL\HWOHULLOHNDUúÕNDUúÕ\DNDOÕQPDNWDGÕU [3]6LVWHPVUHNOLOL÷L
DGÕQDKL]PHWYHUPH\LNHVPHULVNOHULGROD\ÕVÕLOHKL]PHWNHVLQWLVLULVNLGHWDúÕPDNWDGÕU
    8\JXODPDRODUDNGD÷ÕWÕODQsistemlere örnek olarak ownCloud ve SeaFile verilebi-
OLU%XX\JXODPDODUDoÕNND\QDNNRGOXRODUDNGD÷ÕWÕOÕSNXUXPODUÕQNHQGLYHULPHUNH]
OHULQFHNXOODQÕOPDVÕQÕVD÷OD\DUDNJYHQOLNVRUXQXQXo|]PHNOHELUOLNWHGRV\DODUÕher
]DPDQGRV\DVLVWHPLQGHWXWPDODUÕVHEHEL\OHLúOHPVHOEWQO÷VD÷ODPDYH\HGHNOH
me iúOHPOHUL]RUODúPDNWDGÕU$\UÕFDELOGLULQLQ3. E|OPQGHEDKVHGLOHFH÷LJLELNoN
boyutlu dosyaODUÕQ 1 M% DOWÕ  GRV\D VLVWHPLQGH WXWXOPDVÕ SHUIRUPDQV VRUXQXQD GD
\RODoPDNWDGÕU [4].
    Bu bildiride GRNPDQ JYHQOL÷L YH JL]OLOL÷LQL |Q SODQGD WXWDQ banka ve benzeri
E\N |OoHNOL NXUXPODUÕQ JQON Lú KDyDWÕQGD NXOODQGÕ÷Õ GRNPDQODUÕQÕ )LOH6WUHDP
teknolojisini kullanarak kurum EQ\HVLQGHQDVÕO VDNOD\DELOHFH÷LDQODWÕOPDNWDGÕUMa-
OL\HWOHULQ D]DOWÕOPDVÕ LoLQ GRNPDQODUÕQ WXWXODFD÷Õ GRV\D VXQXFXVXQXQ KHU oDOÕúPD
E|OJHVLQGH D\UÕ D\UÕ EXOXQPDVÕ \HULQH PHUNH]L WHN ELU \HUGH EXOXQPDVÕ VD÷ODQDUDN
GRQDQÕP JLGHUOHULQLQ D]DOWÕOPDVÕQÕQ \DQÕQGD VXQXFX EDNÕPÕ \HGHNOHPH YE LúOHULQ
GDKDNROD\\DSÕODELOPHVL hedeflenmektedir.


2      FileStream Teknolojisi

FileStream, veri taEDQÕRODUDN0LFURVRIW64/6HUYHUNXOODQDQX\JXODPDODUÕQ, dokü-
PDQYHUHVLPGRV\DODUÕJLEL\DSÕVDOROPD\DQYHULOHULdosya sistemi ]HULQGHWXWPDVÕQÕ
VD÷OD\DQ WHNQRORMLGLU [5] %|\OHFH X\JXODPDODU KHP LOLúNLVHO YHUL WDEDQÕ sistemleri




                                            815
WDUDIÕQGDQ VD÷ODQDQ LúOHPVHO WXWDUOÕOÕN WUDQVDFWLRQDO FRQVLVWHQF\  KHP GH GRV\D VLV
WHPOHUL WDUDIÕQGDQ VD÷ODQDQ \NVHN SHUIRUPDQVOÕ YHUL DNÕúÕ VWUHDPLQJ  LPNDQODUÕQD
D\QÕDQGDNDYXúPXúROXUODU [6].
    Veri depolama uyJXODPDODUÕQDELU\D]ÕOÕPVRUXQXRODUDN\DNODúÕOGÕ÷ÕQGD, ilk ve en
|QHPOLNRQXYHULOHULQQHUHGHWXWXODFD÷ÕGÕUøONDNODJHOHQo|]POHUGRV\DODUÕQLOLúNL
sel YHUL WDEDQÕ WDEORODUÕ LoHULVLQGH \D GD GRV\D VLVWHPL ]HULQGH EXOXQGXUXOPDVÕGÕU
Günümüzde birçok YHULWDEDQÕ sistemi, BLOB (binary large object RODUDNDGODQGÕUÕ
ODQWLSWHYHULWXWXOPDVÕQDLPNDQYHUPHNWHGLUDQFDNGRV\DER\XWXE\G÷QGHGRV\D
VLVWHPOHULQH NÕ\DVOD FLGGL SHUIRUPDQV VRUXQODUÕQD \RO DoPDNWDGÕU [7]. Öte yandan
genel (public cloud) ya da özel (private cloud) fark etmeksizin bütün veri depolama
o|]POHULNXOODQÕFÕ\DVLVWHPGHWXWXODQGRV\DODUKDNNÕQGDELUWDNÕPHNELOJLOHUVXQDU
ODU2OXúWXUXOPDWDULKLROXúWXUDQNXOODQÕFÕVRQGH÷LúWLULOPHWDULKLJLEL\DSÕVDOYHULOHU
LOLúNLVHO YHUL WDEDQÕ WDEORODUÕQGD DVÕO YHUL\L LoHUHQ YH \DSÕVDO ROPD\an dosyalar ise
performans sorunundan ötürü JHQHOOLNOHLOLúNLOLROGXNODUÕ \DSÕVDOYHULOHUGHQD\UÕROD
UDNGRV\DVLVWHPOHULQGHWXWXOXU$QFDN\D\JÕQRODUDNNXOODQÕODQEX\DNODúÕPLOLúNLVHO
YHUL WDEDQÕ VLVWHPOHULQLQ VD÷ODGÕ÷Õ ELUoRN DYDQWDMÕQ ND\EHGLOPHVLQH \RO DoPDNWDGÕU
'RV\DODUÕQ YHULWDEDQÕ WDEORVX\HULQHGRV\DVLVWHPLQGHVDNODQPDVÕNÕVDFD$&,'ROD
UDNDGODQGÕUÕODQYHYHULWDEDQÕ LúOHPOHULQLQGR÷UXYHJYHQLOLUELoLPGHLúOHPHDOÕQDUDN
VRQODQGÕUÕOGÕ÷ÕQÕJDUDQWLHGHQVLVWHPLVHNWH\H X÷UDWPDNWDGÕU [8] çünkü dosya sistemi
YHULWDEDQÕLúOHPVHOEWQONNRQWURODOWÕQGDGH÷LOGLU.
    9HULOHULQDUúLYOHQPHVL\HGHNOHQPHVLYHLKWL\DoGXUXPXQGD\HGHNOHUGHQG|QOPHVL
LVH D\UÕFD HOH DOÕQPDVÕ JHUHNHQ ELU VRUXQGXU 9HULOHULQ WDEOR LoHULVLQGH WXWXOPDVÕ KD
linde, YHUL WDEDQÕQÕQ yedeklenmesi bu sorunun çözümünü ROGXNoD NROD\ODúWÕUPDNWD
GÕU]LUD\D\JÕQRODUDNNXOODQÕODQELUoRNYHULWDEDQÕ sistemi otomatik yedekleme özel-
OL÷LQH VDKLSWLU Üstelik KHP \HGHNOHPH KHP GH \HGHNWHQ JHUL G|QPH LúOHPL GH \LQH
\DSÕVDO EWQON LoHULVLQGH VD÷ODQGÕ÷ÕQGDQ YHULOHULQ VD÷OÕNOÕ ELU ELoLPGH WXWXOGX÷X
JDUDQWLDOWÕQDDOÕQPDNWDGÕU$QFDN\XNDUÕGDGDEDKVHGLOGL÷LJLEL\D\JÕQRODUDNNXOOD
QÕODQ \|QWHPGH GRV\DODUOD LOJLOL \DSÕVDO YHULOHU YHUL WDEDQÕQGD WXWXOXUNHQ GRV\DODUÕQ
kendisi dosya sistemlerinde tXWXOPDNWDGÕU'ROD\ÕVÕ\OD\HGHNOHPHLúOHPLYHULWDEDQÕ
QÕQ \DQÕQGDGRV\DVLVWHPLQLQGH\HGH÷LQLDOPD\ÕJHUHNWLUPHNWHEXLúOHPOHU\DSÕOÕUNHQ
LNLVLVWHPDUDVÕQGDVHQNURQL]DV\RQXQER]XOPDGÕ÷ÕQGDQHPLQROXQPDVÕJHUHNPHNWHGLU
Bu zorunluluk neticesinde ya yedeNOHPHYH\HGHNWHQG|QPHLúOHPOHULNDUPDúÕNSUR
VHGUOHUGHQROXúPDNWD\DGDEXLúOHPOHUHVQDVÕQGDVLVWHPHHULúLPGXUGXUXOPDNWDGÕU
    )LOH6WUHDPWHNQRORMLVLWDPRODUDNEXVRUXQDRGDNODQPDNWDGÕUYHKLEULWELUo|]P
VXQPDNWDGÕU)LOH6WUHDPile %/2%RODUDNWDQÕPODQPÕúELUYHULWDEDQÕNRORQXQDRNX
PD\D]PDLúOHPOHULJHUoHNWHWDEOR]HULQGHGH÷LOGRV\DVLVWHPL]HULQGHJHUoHNOHúWL
ULOPHNWHGLU7DEORNRORQXQGDLVHEXGRV\DQÕQ\HULQLJ|VWHUHQELULúDUHWoLWXWXOPDNWD
GÕUgWH\DQGDQWPRNXPD\D]PDLúOHPOHUL\LQHYHUL WDEDQÕVXQXFXVXWDUDIÕQGDQ\D
SÕOGÕ÷ÕLoLQLúOHPVHOEWQONVD÷ODQPDNWD YHVLVWHPLQ$&,'|]HOOL÷LNRUXQPDNWDGÕU.
FileStream içeren bir YHULWDEDQÕ \HGHNOHQGL÷LQGHVLVWHPRWRPDWLNRODUDNLOJLOLGRV\D
VLVWHPLQLGH\HGHNOHPHNWH\HGHNWHQJHULG|QPHLKWL\DFÕ GR÷GX÷XQGDHNVWUDGDQVHQN
URQL]DV\RQNRQWUROLKWL\DFÕQÕRUWDGDQNDOGÕUPDNWDGÕU )LOH6WUHDPWHNQRORMLVLQLQ\DSÕ
VÕWHPHORODUDNùHNLO 1’deki gibi gösterilebilir.




                                              816
                                 ùHNLO 1. FileStream <DSÕVÕ

Özetlemek gerekirse, FileStream WDEORODUÕQGD veri NRORQGD GH÷LO dosya sisteminde
tutulur. Ancak yine de YHULWDEDQÕWDUDIÕQGDQVD÷ODQDQLúOHPVHOEWQlük kontrolünde-
dir.


3      Veri Modeli

Verilerin tablo kolonunda ya da FileStream RODUDN GRV\D VLVWHPLQGH WXWXOPDVÕQÕQ
FLGGLSHUIRUPDQV IDUNODUÕQD \RODoDELOHFH÷LQGHQ|QFHNLE|OPGHEDKVHGLOPLúWLU $Q
FDNEXSHUIRUPDQVIDUNÕVLVWHPGH\HUDODFDNRODQGRV\DER\XWODUÕ\OD\DNÕQGDQLOLúNL
lidir. FileSWUHDPWHNQRORMLVLQLQNXOODQÕOPDVÕ, veri boyutu ortalama olarak 1 MB üze-
ULQGHROGX÷XYH doküman okuma KÕ]ÕQÕQ\D]PDKÕ]ÕQGDQGDKD|QHPOLROGX÷Xsistem-
lerde önerilmektedir [9] %X QHGHQOH GRV\D ER\XWODUÕQÕQ VLVWHP RNXPD YH \D]PD
KÕ]ÕQÕ QH|OoGHHWNLOH\HFH÷LQLJ|UPHNDPDFÕ\OD IDUNOÕER\XWODUGDGRsyalarla okuma
ve yazma testleri \DSÕOPÕúWÕU0XOWL-thread bir uygulama ile her biri 4 çekirdekli ol-
mak üzere 5 IDUNOÕ LVWHPci bilgisayardan, 16 çekirdekli bir veri WDEDQÕ VXQXFXVXQD
EHOLUOHQHQ GH÷LúLN ER\XWODUGDNL dokümanlar D\QÕ HULúLP \|QWHPOHUL\OH okXQPXú ve
\D]ÕOPÕúWÕU +HU ELU LVWHPFLGH  WKUHDG ROPDN ]HUH WRSODPGD  WKUHDG oDOÕúWÕUÕO
PÕúWÕU7HVWOHUtoplam 5 milyon doküman ve 2 TB boyutunda veri içeren bir veri taba-
QՁ]HULQGH\DSÕOPÕú ROXSYHULWDEDQÕQGDNLNXOODQÕODELOLUWRSODPGLVNDODQÕ7% boyu-
WXQGDGÕU


3.1    Tablo kolonu üzerinde BLOB

9HULOHULQ WDEOR VWXQX ]HULQGH %/2% RODUDN WXWXOPDVÕQÕQ VRQXoODUÕ Tablo 1’de gö-
UOPHNWHGLU+HPRNXPDKHPGH\D]PDKÕ]ODUÕQÕQGRV\DER\XWXQXQDUWPDVÕ\ODD]DO
GÕ÷ÕJ|]OHQPLúWLU%XVRQXoODUGDQKDUHNHWOHE\NER\XWOX\DSÕVDOROPD\DQYHULOHULQ
YHULWDEDQÕWDEORODUÕQGDVDNODQPDVÕQÕQSHUIRUPDQVDoÕVÕQGDQ \DQOÕúELUWHUFLKRODFD÷Õ
VRQXFXQDYDUÕODELOLU




                                            817
          Dosya Boyutu        'RV\D6D\ÕVÕ         Okuma               Yazma
              (KB)               (adet)             (MB/s)              (MB/s)
               100                7180               718                 605
               500                1348               674                 635
               750                 820               615                 586
              1000                 586               586                 439
              1500                 351               527                 439
              2000                 235               469                 371
              5000                 83                415                 391

                           Tablo 1. Tablo kolonu üzerinde BLOB


3.2    FileStream Tablosu

'RV\DODUÕQ )LOH6WUHDP WHNQRORMLVL LOH GRV\D VLVWHPLQGH WXWXOPDVÕQÕQ VRQXoODUÕ 7DElo
¶GHYHULOPLúWLU7DEORNRORQXQGD%/2%RODUDNWXWPDQÕQDNVLQH)LOH6WUHDPLOHRNX
PDYH\D]PDSHUIRUPDQVÕQÕQGRV\DER\XWXQXQDUWPDVÕ\ODDUWWÕ÷ÕJ|]OHQPLúWLU Ancak
EXDUWÕúDUD÷PHQ)LOH6WUHDP0%DOWÕQGDNLGRV\DODUGDKDOHQGDKD\DYDúNDOPDNWDGÕU

          Dosya Boyutu        'RV\D6D\ÕVÕ         Okuma               Yazma
              (KB)               (adet)             (MB/s)              (MB/s)
               100                3130               313                 273
               500                 948               474                 293
               750                 723               542                 330
              1000                 576               576                 508
              1500                 430               645                 542
              2000                 332               664                 547
              5000                 166               830                 659

                                Tablo 2. FileStream Tablosu




3.3    Hibrit Model
<XNDUÕGDNLWDEORODUGDQJ|UOHFH÷L]HUHküçük boyutlu dosyalarda 1. yöntem, büyük
boyutlu dosyalarda 2. yöntem daha uygun görünmektedir. 'RV\DODUÕQ NXOODQÕFÕODU
WDUDIÕQGDQ KHUKDQJL ELU DOW OLPLW ROPDGDQ \NOHQHELOHFH÷L ELU EXOXW GHSRODPD o|]
münde, RUWDODPD GRV\D ER\XWXQXQ QH RODFD÷ÕQÕ WDKPLQ HWPHN oRN RODQDNOÕ GH÷LOGLU
øúWHEX\]GHQKHULNLVLVWHPLQGHDYDQWDMÕQÕNXOODQPDN]HUHKLEULWELUPRGHOkulla-
QÕOPDVÕGDKDX\JXQJ|UQPHNWHGLU. %XPRGHOHJ|UHGRV\DODUER\XWODUÕQDED÷OÕRODUDN
YHULWDEDQÕQGD \DGDGRV\DVLVWHPLQGHWXWXOPDNWDGÕU'ROD\ÕVÕ\ODEXD\UÕPÕ yapabil-
PHNLoLQELUHúLNGH÷HUHLKWL\DoYDUGÕU ùHNLO 2’de her iki yöntemin okuma ve yazma
KÕ]ODUÕ NDUúÕODúWÕUÕOPDNWDGÕU %XUDGDQ GD J|UOHELOHFH÷L JLEL  0% GRV\D ER\XWXQGD
her iki yönteminde SHUIRUPDQVÕ\DNODúÕNRODUDND\QÕROPDNWDGÕU




                                            818
             ùHNLO 2. 2NXPDYH<D]PD+Õ]ODUÕQÕQ'RV\D%R\XWXQD*|UH'H÷LúLPL

%XUDGDQKDUHNHWOH0%HúLNGH÷HUVHoLOHUHNEXGH÷HULQDOWÕQGDNLGRV\DODUGR÷UXGDQ
YHULWDEDQÕNRORQXQGDVWQGHNLGRV\DODU)LOH6WUHDPRODUDNGRV\DVLVWHPLQGHWXWXOD
FDN úHNLOGH ELU PRGHO JHOLúWLUiOPLúWLU %X PRGHO KHU ELU GRV\DQÕQ IDUNOÕ YHUVL\RQODUÕ
olDELOHFH÷LQLGHJ|]|QQGHEXOXQGXUDUDNELUYHUVL\RQODPDVLVWHPLGHLoHUPHNWHGLU
*HOLúWLUGL÷LPL] PRGHOLQ GRV\D YHUVL\RQ YH GRV\D LoHUL÷LQL EDUÕQGÕUDQ WDEORODUÕQÕQ
WDVDUÕPÕ\DNODúÕNRODUDNùHNLO 3’deki gibidir.




                                  ùHNLO 3. Hibrit Veri Modeli

FileContent tablosu, verileri BLOB olarak tablo kolonunda, FileContentFS tablosu ise
)LOH6WUHDPNXOODQDUDNGRV\DVLVWHPLQGHWXWPDNWDGÕU(NOHQHQKHU\HQLYHUVL\RQ0%
YHDOWÕQGDLVH)LOH&RQWHQWWDEORVXQDVWQGHLVH)LOH&RQWHQW)6 WDEORVXQD \D]ÕOPDN
WDGÕU




                                              819
4      Sonuç

%XELOGLULGHJYHQOLNYHJL]OLOLN ND\JÕODUÕQHGHQL\OHNXUXPGÕúÕEXOXWGHSRODPDçö-
zümlerinden uzak GXUDQúLUNHWOHULQ)LOH6WUHDP teknolojisini kullanarak kendi ihtiyaç-
ODUÕQDJ|UHJHOLúWLUHELOHFHNOHULELU|]HOEXOXWGHSRODPD SULYDWHFORXGVWRUDJH o|]P
]HULQGH GXUXOPXúWXU )LOH6WUHDP WHNQRORMLVLQLQ JHWLULOHULQGHQ ID\GDODQÕODUDN KHP
E\N ER\XWOX GRV\DODUÕQ GRV\D VLVWHPLQGH WXWXOPDVÕ VD÷ODQPÕú KHP GH LúOHPVHO
EWQON WUDQVDFWLRQDOFRQVLVWHQF\ \HGHNOHPHYH\HGHNWHQG|QPHLúOHPOHULQLQYHUL
WDEDQÕVHYL\HVLQGHNDOPDVÕ\ODNDUPDúÕNSURVHGUOHUHRODQLKWL\DoRUWDGDQNDOGÕUÕOPÕú
WÕUgWH\DQGDQNoNER\XWOXGRV\DODUGD)LOH6WUHDPWHknolojisinin performans soru-
QXHOHDOÕQPÕúYHKLEULWELUPRGHOJHOLúWLULOPLúWLU

*HUHNELOGLULNDSVDPÕQGD\DSÕODQoDOÕúPDODUJHUHNVHND\QDNoDGDEHOLUWLOHQDUDúWÕUPD
ODUYHWHVWOHUJ|VWHUPHNWHGLUNL0%DOWÕQGDNLGRV\DODUGDHQL\LSHUIRUPDQV, dosyala-
UÕQ YHUL WDEDQÕ WDEOR NRORQXQGD %/2% RODUDN WXWXOPDVÕ\OD elde edilmektedir. Daha
büyük dosyalarda ise dosya sistemini kullanmak daha iyi sonuç vermektedir. (÷HU
VLVWHP WDVDUÕPÕ HVQDVÕQGD GRV\DODUÕQ RUWDODPD ER\XWX WDKPLQ HGLOHELOL\RUVD EX LNL
yöntemden uygun RODQÕWHUFLKHGLOHELOLU$QFDNGR÷UXELUWDKPLQLQPPNQROPDGÕ÷Õ
GXUXPODUGDELOGLULGHNXOODQÕODQKLEULWPRGHOLNXOODQPDNKHULNL\|QWHPLQGHDYDQWDM
ODUÕQDD\QÕDQGDVDKLSRODUDNRSWLPXPYHULPOLOLNVD÷OD\DFDNWÕU


5      Kaynakça
 1. White, C.: Consolidating, Accessing, and Analyzing Unstructured Data. Business Intel-
    ligence Network (2005)
 2. Lee, T.B.: Here’s everything we know about PRISM to date
    http://www.washingtonpost.com/blogs/wonkblog/wp/2013/06/12/heres-everything-we-
    know-about-prism-to-date/
 3. Fabian K.: Cloud Services Review
    http://cloud-services-review.toptenreviews.com/
 4. $]HPRYLü, J.: Varbinary vs. Filestream and other BLOB issues
    http://technet.microsoft.com/en-us/library/bb895234.aspx
 5. Filestream Overview, http://technet.microsoft.com/tr-tr/library/bb933993(v=sql.105).aspx
 6. Sebastian J., Aelterman S.: The Art of SQL Server FILESTREAM. DBA Handbooks,
    Simple Talk Publishing (2012)
 7. Sears R., Ingen C.V., Gray J.: To BLOB or Not To BLOB: Large Object Storage in a Da-
    tabase or a Filesystem. Technical Report, Microsoft Research, University of California at
    Berkeley (2006), http://research.microsoft.com/apps/pubs/?id=64525
 8. Ramakrishnan R., Gehrke J.: Database Management Systems, McGraw-Hill (2002)
 9. Shanmugam B.: Using SQL Server FILESTREAM to store BLOBs. White Paper,
    http://www.infosys.com/microsoft/resource-center/Documents/SQLServer-
    FILESTREAM-BLOBs.pdf




                                            820

</pre>