A Study of Index Method Based on Main Memory

전체 글

(1) /. 메모리 기반의 인덱스 기법에 관한 연구 연구 A Study of Index Method Based on Main Memory.

(2) . . !.

(3)

(4) !" #$%

(5) &'( )*+,-./%01&'&'23 .4

(6) 5-6787

(7) 9:;< =>?@ABCDE4-F %567 8GHIJK4

(8) 5LMINOPQ678RIJ3STCD01GHIJ& 'F %UQ-V7WXYHTZ6[.=\[]CD^_RIJ&'` %4

(9) %abEcdefg%01GHIJ&'hijGHklGHmGHn D^_ R IJ &' o& pq R(rstuvwxy kz{|x} ~utvw sk~ R( r }xwyvx ~utvw ~ " R(rjvwxu ~utvw j~ C " R(ryvvxy jvwxu ~utvw 0 H R(rz}vyvx{} ~utvw o& pq R(r }xwyvx stuvwxykz{|x}~utvwsk~nD01. I. 서 론. ~z 6{ [acI)* {~z 6{ [acE fg h[acdE P .

(10) . P[acJ6{l OPJ!4. !. R=RE[ac`x}<NAM. "#$%&'()*+,-./. 8BBI !$%. 01234567 89:-. R=D()*. ;<=>?@ABCD(E4F. H {~z 6{ [acE {~z. 7!G'(% H)*IJK8E'LM0. SIJ6{E[ac`fg. J NAB OPC D (% Q RES T. FB H RJ t' {~z . UVWXYVZI& [\]W^_` abcd e- fg . H 7 B fg h. hij7;8EDkSIlm%. [acEnCDtnoS. GEno 234M0pq7. I'OP7KH3456 0. QrsDt)*. ¡¢)*. IdeInoJ>?AuOP. IO£ 6R¤DB¥!RE. RK8 nH:-. SInH)¦H§" ¨H"OPJK. v0!(%wESxy!z{|CQH}I{. R© fg '! ij ªM 29.

(11)

(12)

(13) .

(14) . h}sG{Gu. ! k. "#$% &'(')*+,-./+0. j. (1-231456/7. . 89:;<=>?)@8AB CDEF/+0<G

(15) 8HI :9-;?):JK<1-23. sGw. 14LMNA OP$%QRGS<G /+0<@T C1-23-. yGw. /.

(16) . . .8U+-VWXYZ /+0. h}sG{. <@ [\W? )$%. II. 트리 계열 인덱스. . 1. AVL 트리 ]^_ à Gb à c de<G f&g.

(17) . hijklm4n oMàp qOoEFrsGbàc I/ On tDuvwxy<5)z@{; |\P8U+-V$}~% ]^_à<Grs>àa <G EF?u8 àm4>W@ ]^_à< rs<l` am4n o|)$% f&g~i<Gjk]^_àxyF ? /F8yF8y u:oEFxy<5)/uG. . ~i{ ©à`ªy{W« EF xy ¬ j k> XY) kDxy .® {W¯3F«D 8y a u ) $XY)$% °±)²³´<8ya u)$XY)$%. 3)ra 1BEF1B . hi. #?¡W¢W C$%. ©{<xyT3 /)F. ? /<FGbà. xy )$%. cFm48£tT CxF-Gm. °xy )FxyPa. 48GbàjGbàc. <G`µ {³u QR¶¶. ¤jc¥c>Gbà[¦W(. ¯$Gbàc p/ F. §¨|:P$%. m48 ·³)$%. 30.

(18)

(19) . ¸¶¶<Gbàc p/ . h. /<Gm48h. i. . . i. . < 5 W @ à m4W. h. . . R X. . ¹º$%. R X. . »i? ©{<? ¼xy q]. h. / EF ] a ? )$%. i. °]a½? ¼xy ¾u$¿,-xy t j ?T]GbàÂ<G «>xy q$%. R X. . . j. . . h. ·³)$%. i. . . j. . . µ {³u QR¶¶¯$Gb à c p/ F m4 8 . i. . . h. ¸xy ?)F a<G`. . . . . R X. ¹¾À ?)$% J ¹¾Á . . i. h. . Ã¶¶<5Gbàc p/. . . . . . . /<Gm48h <5W@ àm4. h. W¹º$% i. Äiàm4. . . . . kàm4W¹Å|)$%. . h. i j. ©à<ÅoÆ(?TJ¯$$¿. j. . . . . . . °a<G`µ {³u<3)rs <5¶¶<n om48. pÇ h ¤ ( [¦ /< QR@ÈÉÊ /)$% ¸ ÉÊ f&g »i k ËËF __F Ë_F _Ëu ÌT CDEF à m4W IDGbà[¦W Í Î xF __> @T _ÏÐÑ _ÏÐÑGbàc¥c$!WÒ )$% ÃËË__>ÓÔ<àÕm4W.

(20) . n È CD(Ë__Ë³´<à Õm4Wn -Ö×@P$% Øi ©ËË³´m48h8] m4 8~8Ùo| FGbà ] 31.

(21) ! . Gbào|)$%. iG{Gu. °__ ³´ m4 8 h8 ] m4. j. 8~8Ùo. GX. | FGbà ] Gbào|)$% ¸Ë_³´m48~8<5 __W@)m48h8. GY. GZ. UUU. G.

(22) . iG{. ]<5ËËW@)$% Ã_Ë³´m48~8<5. . ËËW@)m48h8 ]<5__W@)$% ]^_à{ Ó FÚÛ$. .

(23) . . eWqCD(¯$xy (<8y. =>xy tÈ CDÞucïð. Ö ÜÝ n oÞu 8U+ : x NA). Oñò àp EFQRGóÜ. raßXK?)$%. Íôõ NA)xy ¢W CDEF. Âào áa !<5)â? o C ãDÞuÂà ä 8U+ . (?<GbàcI/ On P$%. :ÈJÇÈ å$% . 2. B 트리 àf&gØijkæ<to xyzBÜ IJ)<z5uhæÜ xyjhæç~Ü8ytoÎ u:PM{à$%à¨ ªjauÌÈ CF¨ª< à`tP$}h% ¨ª<n oxyÜ ¯$ ¶-$ CD(@ æÜxyjæç~Ü 8y.n .è éêë)$%J¨ªxyGbà <5)ÌauÇP$%a ä ) to xy Ü ?) åDE Gbà<5)8y n ÈNAå$% à : xyf&gÄijk ¡3)Ùìu:P. ~i{ ©à`ªy{W«)$% °<tP¶¶xyÎXY)$% ¸{ xy CD xy .® ¯ö$% Ã&÷ ãDø{ÈGbà / )°ªy ù)$% ©Èxy3È] {< ¬$% °xyÎ ú]<n CD xy ) ùW¯ö$% ¸xy ¼]<n å D ]FûuÌa)$%. !($¿{FF?íîªÌ<. Ã ¼ xy t ]x. G¡ÒuÇP$%à)<. y Â<G «> !ªy ü ÔGu æ. 32.

(24)

(25) . Ü

(26) ý]<Fþ!ªy« . aaa+` :tDuv. ÔGuæÜ uÈPu)$% ( xy) Ü ªru)$%. 1 MW ùÈJxy<5)Ú. JPxyGbà<5)Ìa. &'(1-21+08U+ :. uÇP$%. Ô¤@ôõW?)$% ÈJxy<5)ÚôõW? 1-. Ìa«>a<G`µ. 23:Du8rsxy a<. T CDEF`ÌaTJ. n e BoF ¼ => xy. ¯$àc (ÝP$%. ÂàDu8)raßX¶ Þuç`. ©?T xy æ~ 3) ] {< ¬$% °/P]¨ª?Txy æ~¾u$¿,-xyæh ¬Gx yæ~W?)]¨<GxyÔ G n æh 3$% ¸]a]<Gxyæ~ W?) CxyÜ æÜ n o Ç)$% Ã]<n oxyÜ æ$« D $ xyÜ p )$%. a$à¥@

(27) $%. 3. T 트리 à]^_àjàeW 1-21xy ôõ x@

(28) |\ o$}»%à)<=> xy qM{àu:o ÚxyôõW ? EraÇ<eWq$% à<toxyf&gi k#?¡F t ra1B (§$% t ra1B xyu ÇtDuv¡W Du8)ª . ]j <tPxyÜ. 8U+áa<Æ¦WÒ3 ã.

(29) hæ$«DÖ]Fx. <G/<5G Í½R. y rÖ)u F .®. · áaÈJ raÇß. )$%. XK?È C$%ÓF$¿à. ]j <tPxyÜ. W-!ÈJÇoxy¡ÒuÇ.

(30) hæ$,Öxy .. )$% à ¨ xy l ,-ÔDu. Ý( ¶¶<3$% jk>àF·4P4uç àFà£CDEFçà*+,. -.Du 8U+ :ÈJ =Ço-V$%çàà4 88U+ªÌ#?xyÎn oa ªÌDu:oxF8U+8¨ªxy. n oEFªr a8y)Üj Ù a 8y ¶¶ )ÜÝn P$% à$¿k"ÉÊuÌÈ C$% •/. ¨ª#FGbà EF. Ó ÚÛOa ¬/. ¨ª < tT C xy Ü . ÈÍ ù)$%rsxy a<n. $%F&' n ë)$%33.

(31) ! . G$%j&'¶¶à¨ª ( CxyzBÜ jz5Ü. Ò EF&¡>à :ÈJ •/. Ã&÷ ãD<tPxyÎXY { ¬$%. / HRÒy$%. . .a#[¦<då)Gb`. ©xyT {<¬$%. aÍWq$%. °`<Gªya<Û{³u QR. • / a#Gbà q ã$%. àcj[¦W+*<n )$%. àf&g)ikGbàm4l n oàEF]^_àjk>[V <àm4Wn )$%àm 4W n - Ço /8 m48 ]^_à<Gm48jI)Ò q$% . ¸xy È ]<n C Ç)$% Ã CD]<xy ¯ ö$% xy È J < to xyÎÇ<ÔGn o|)$% åD]<tPxyÂ<G zB xy ? F & W xy )$%. wGw. ?)xy u+xyu GX. GY. GZ. UUU. G. . j sGjGw. yGjGw. /. ] Gb à<G þ xy Mu ¸ªy ùWø)$% ,à aµ {È\xy . /. È-o ãDF{ ³ua. . <n C Ç)$%. . .<n CDxy ¯ö$% /<n åDFu+a : ÙuÍs . xy )$%. @a<G`µ {³u Q R ¶¶ ¯$ Gb à c p/

(32) . Fm48 ·³)$%. A¶¶<5Gbàc p/ ~i{ ©`<Gªy{W«)$% °¬¡zBxy$«D Gbàu {Wø)$% ¸¬¡z5xy$, Gbàu {Wø)$% 34. /<Gm48h <5W@ f&g0i kàm4W¹º$% ©?Èxy qC] {)$% °/P]4<QR$¿k ù )$%.

(33)

(34) . ¸]¨ªFxy ? -. h. < ]< tP xy Ü zB¡ $%$þ pÇ)$%. h. i. i. IO. Ã]<Gxy ?]Ü j. $%F]<Gxy ? ) ùW¯ö$% $%$«DF]zBxyÜ $% n - ] zB¡ ¾u¡WGbà<G¬?) F "Õ]< ùW¯ö $% -G Gbà<G ] zB ¡¾u¡W? !>$¿. /. j. i. h. . j.

(35) . 6)Ü8³´F. ´7xy 58¤| )W@)$%. /WQ$% ].axy ?). III. 해시 계열 인덱스. F]1 8 Ç xy CD&5u ùW¯ö$% ,]1XDÙ8a j2

(36) @W ù)$% .]axy ?)$% ?)]1X ãD&5u ùW ¯ö$%a]<Gxy ?) ]1XOo] .3 $¿W ù)$% /a<G`µ {³u Q R¶¶¯$Gbàc p/ Fm48 ·³)$%. @¶¶<5Gbàc p/ /<Gm48h < 5 W @ à m. 1. 체인 버켓 해싱 t < 9WJ¢ I) ¡ÎW a+`< n [VDu8U+ :)$}~% 5:f&g;ijk8U+ :ÈJ Ü <<=,-/o · ã/@p q$%QRG>-<< =,- ?@«O/ áa xy A@Du·BÈJ<=WÕ:ë Þu+0<5):;C oOoF oG{ . 4W¹º$% .

(37)

(38) . . > $¿ ) ³´ ?4 ]^_àW&5u@)$% • / @TÉÊË_Æ(_ËF • / ]j.aF •/. 5atoxy.

(39) . 35.

(40)

(41)

(42) . <=,- ?@,O Ço ã. åW³´ÖJ uÌaoEÌaoaJ. DEÎ=Oo ra ßX. c ~ )$% J Ìau 8. )$%. aJ *KLa<n T CÜ $. 5:¬ xy<5GF´Ú {W?È CD(FxyA·Bt< QR<=,-@Du·Bë ®³<ª@

(43) $%. = *KLa,-ÖPuQ (E*K Lacæ~)$%. 3. 선형 해싱 74H>xyA@Du· ®. 2. 확장 해싱. ³<@

(44) |\PH-VDuxy. G:xyA·Bt<QR<= ,- È COtDuv@8®³< @

(45) |\PH-V$}Ä% Hpf&g~IikPx y n aJ jaJ J Ùì n *KLau:P$% *KLa<n o/8c/æ. ?<t @ O·³tDuv xyn TDE/P$}Ø% 74H<=>xyTD E<n åWJDEÌaoEÒa/ MÔG<74@Du OP$%

(46) . cR EF ¢ M¡WGu. ©xy t RI< ). ÌÈ CX` uGM±M. DE< n CD & DE< &5u. æX` (§$%aJ c/æ’. )$%. cR EFk>aJ <tox. °xy ÈDE<n å ST. yÎWN O CX` uGæ’X`. u+ t R~W / . I O«oxywW(§$%aJ. ST)DErsxy Õ. cæ’*KLacæ$² å$%. @ P3)$%. a J ¥ xy Î ú .

(47) k . ©PxyÎ úDE<¥n. sGw Y. G WWWG WWXG. å STÈJt · WW. Y. aR)$%. Z. WXXG. . Z. XWXG. WXX. XXWG XXXG. °u+t >-<=,-. WXW. WXWG XWWG. ³ou+DEÈo!WDEÌ. URÈJUÍVuÅP,-8 hU¡Wqt u·³P $% ¸t ·³TJ¯$<=,-. X X. >-<=,-UÍV74@ Du)$%.

(48) . 36. ÃST)DErsxy·³P.

(49) !. t <Õo STWXD. W. E(uÈPDEDuP/P$%. W. _WW Z`WW X_WW ^WW Z[_WW. ST)DE¾u$¿DE<$¿ ÌaÈDERÒ8y. Z[]WX XYWX X^WX. W. 3)$%¯ YDE<GSTWD. X. 8yMá¿DEDuP$% f&g ~~iW DE Ìa íî $¿k$%. W. \Y^\Z Y[\Z X[Y\Z \Z. ZW``` [\X`` \[`` Z[X`` YW``. X W G. \Z. ``. W. W ZW``` [\X`` \[`` Z[X`` YW`` ``. _WW X_WW Z[_WW. Z[]WX XYWX ]WX X^WX. \Y^\Z Y[\Z Y\Z X[Y\Z \Z. W. X. \Z. ©>-<=,-U>~IIt RI$%. W. G. X. . [`WW ^WW Z`WW XWW.

(50) . . °t RI<PxyDEIª. . yDE;;µ ÛOÌ)$%$¿<Ìa. GW . 7/7/7. ÈDE8yDEIWaC$% ¸xyÄ;IIWt RIu)<. GX. DEI< ¼ÈJDE<n å ST)$%. GY. . 7 7 7. ÃST 9DÞuu+t R~ ÍÎ DE I Ìao u+ DE ~IIÈo<=,-74@.

(51) . Du)$% DEIrsxy t R~<Õ DEIjDE~II<ÕP3)$% $¿<ÌaTDE<5)8yDE~W a|)$%. |\P74HW1-23xy< @T C|·³)H-V$}% /P74Hpf&g~hijk. ,xy )Ø»W RI< DE Ø»<. / Î a+` 4u n o. ¼ÈJDE<n å ST. "&\`jÇÂ<C"&\`¶¶«1. )$%. Bf"&\`<n oÂ]×î n. .ST<DEØ»ÌaTJF$¿<Ìa. *KLau:P$%"&\`<n o. ÈDE8yDEØÄ aZJ. ¶¶xyj$¿<5)8yu. µ DE~ªyDEØ»µ DE5[o. :P$%-Gxy1-23<G. DE~I~ªy~Ø»µ uÌao <. 8y Ò)$%. =74@DuP$%JDE~ªy. /P74H*KLa,-"&\`. DEØ»µ rsxyt R~<. <n oxyA-_xyAW>. ÕP$%. rauªy u+ "&\` ÈW. 4. 수정된 선형 해싱 *+,J DEDu 8U+ :. J¯$74@Du)$%_:<G< =DEÌa<74@Du ! k$% 37.

(52)

(53)

(54) . /P 74 H rs > 1-23 :W¼ ÖÓøun op@¤ ?4 _:<GjI O ùP$%` Î xy ³´F_:<G<= <G w DEW / & DE< xy F /P74H<G*KLa<Gw Là / Làa"& \`<xy a" P$%. KLa’ u $°ªy ù)$% LàG¬ t xy. axy .®)$% ©`*KLaªy{W«)$%· Ñ IDu>-B)$% °*KLacæ )$% ¸¡8:æX`<G{È. 5. 다중 디렉토리 해싱. *KLaLàG )$%. 1-21xy<5)ÚôõW? -\PH-V$%-V>G:<G aJ ÌaÈJ*KLa,- hPu tDuv ra ßX O o K?. b C$})% $Â*KLaH>f&g~»ikG:* KLa 'ÜGb*KLau(FÎ *KLa àpun )$% WW yG k . zG k . W. WX. X. XW. W. X. · Ñ æÍVF¡: æ X` ?4) :’ :uF Gb *KLa ’ u xyËW -$ °ªyÕ)$% LàGX CD ¼xyË WLàGa|)$% LàGÒ$xyË’ aC ST F*KLaGb*KL aÜ pÇ)$%. XX. ,*KLa Gb *KLa Ü *KLa Là .$«D,-h8G. X. b*KLa’ ÍÎ LàGGb*K. yOXXP W. ÃLàGGb*KLa’ a. yOWXWP yOXXWP. . La’ a|)$% .· Ñ æÍVF¡: æX` ?4):’ :uFGb*KL. yOWWWWP yOXWWWP.

(55) . a’ u xyËW -$ °ªyÕ)$%&axyË’<5 G¡:ÑX` ?4):”.

(56) ~i{ ©`*KLaªy{W«)$% °*KLacæ )$% ¸¡8:æX`<G{È *KLaLàG )$% ÃLàGGb*KLa’ aF:< GæX` ?4):’ :uFGb* 38. :uGb*KLa’ u $°ª yÕ)$% /*KLa Gb *KLa Ü *KLa Là .$,Æ(kD*KL a,- ÖPu)$%. @xyË<5G°ªy$ ù)$%&a xyË’<5G¡:Ñ X` ?4):” :uGb*KLa’ u $°ªyÕ)$%.

(57) !. 6. 확장된 체인 버켓 해싱. noW ) p5fpÏqrf%&g 5fsst%$u&Ñ$f%. G5:f&g~ÄijkH8DE HW

(58) GÍs8U+uFG5:8U+ G:<=F5:<=FËcdfeffgi»ªÌ Du:oEFG:<GaJ 5: <=Ëca+ù53)4 q$% G5:G:<=>SýG:<G*KL aj ¯h u áaoEF 5: <=> Sý 5:<Gjia<=< c/ n P$% *KLaj <=<G c /SýG:<GjI)ÒuÇP$% G: <= ¶ Là 5: <=< 5) 8y n F 5: <= ¶ Là Ëcd<CP&LàjdjPËca+`< 5)8y ¡Duq$%// G5:<Gáa xy t < )¡: k:~#:hlÖ ªÌDu( :h<=W¬-G *KLaLà xÇ F:~>* KLaLàa<=¨<G¬ Ëca+` n Là / x Ç)$% p@ ¤ 4 -§ > G:<GjI O ùP$%. G. Z. jioG{ G Y WW. G. WXWG. X. XWWG XWXG XXWG XXXG. . Z. D~ (3O,ÞuÚáa A [< @

(59) ã$% ¥( 1-23 6 ü = t< QR xyy +0¨1-236>ee Å" <C$%<QR/Ìë<GQ ( 1-236Wz5) *+,¨< CPxy rÖ1-23u1/ +0 :;W Ü7 1-23 -. +0fsÏsfqv qÏr$æÏ%Ñ qÏÑq$Ï&g rvrÑÏsi <d)MùÂ<C$% <F µ S 8U+ -V> + 0 ª pu Ço E xy a@ CF<C 8 xP$% ´7àø8U+ F]^_à ¯$xy (<8yÖÜÝn oÞu ra ßX K? F Âà áa x ¼CDEFààcI/. )Úôõ;)eC$%. WXW yOXWWP yOWWXP. WXX. X. +0<Gxy $-)*+,}"+. -VDuraÇßX@Fxy<5 yOWXXP. Y. "Õ|aÇoC*+,-./. eW 1-23< @

(60) | \P. yOWWWP. yOXWXP. WXXG. /+0 [Ìë e¤ 5o C$%. eC.<à]^_àjà. ypkGw. WWWG WWXG. xyzF{Ç`£o)áa A . 3ã¿DufqrÑÏ'ÏutÑ$f%Ñ$sÏ Ó. loG{. vrÑÏsi<G:Ë_f:fsÏËÏw$rÑÏq_fu&Ñ$f%iF. . ±) ø 8U+ ³´ 8 DE H f5:i>xy=WJ8 Fxy@WJ ï-. yOXXWP. yOXXXP. G.

(61) . JK<$(HI<G±7B <= Õ:ë ÓeW CD EFHfG:i>aÇ5@ Du «W ³´ *KLa ,- ü Óe. IV. 결 론 zõÎ 8ymW-.Du Æý9. C$% 4< 74 Hf_:i> xy6 @ Du· ®³<@

(62) )-V8.<9 {ÓeW CDEF74H 39.

(63)

(64)

(65) . f_:i>1B 74@Duo-JK<F 1Bu® I/ ãFrs R&rR &gtÏ ÓIë ÓeW C$%. G h G G jG hSG hT ~ GwGj SGX`^[UG YG kG jSG “{G |G iT{S”G jT Gz SG}UGXXSGuUGYSGX`^ÙG. Í P 8 DE HfG5:i> G:. ZG{GqUGsGGtGqUGj SG“hGz GG. 5:

(66) GÍsH-VDuGFG:<=F. pG zG G tG t G kG. 5:<=FËcd»ªÌDu:oFG:<. tG z S”G wUG G p’G jUG G. GaJ 5:<=Ëca. }skiSGX`_]UG. +ù53)4 q-JK<G5:5: <G:;WFG:<GÓø@8 :C$!W C$%QRG1-23./+0<G -)8UH-. [GyGmSGqGuSGuGwSG oUGy GzSG“lGoGTGhGmG hG tG G k G mS”G hjtG {UG GkGz USG}UG[SGuUGYSGX`^ÙG \G ~G sSG “sG oaG hG uG {G G. VDuàø8U+uà@

(67) F. mGG{GhS”GwUGGp’GjUGG. ø8U+uG5:@

(68) $!W?. }skiSGX`_WUG ]G wThG sSG “k G oG {S”G jT. \ )$%. GGGhjtSG}UGZXSGuUG[SGX`__UG ^G hG h G G zG wSG “mG. 참고문헌. zG G tG t G kS”G wUG G G hjtGzpntvkGp’GjUGGtGGkSG. XG hUG hSG qUG oG G qUkUG |SG {G kGG. 40. X``YUG.

(69)