建立電子商務資料庫管理系統應用之績效評估工作量模型

全文

(1)". FilJL~ rf A$i'l!.,Iilt'jf1R* ~ i'J£,Iilt jf~ft$~ , l'\ 90' 6011Jl ' 189-212. -1. J\. *. ~JL _ -=t- rffi f9iii *4 J$ tt JI ~JJ!ffl. ;L*I~~~lJifJ!i I f'F £ ~~~. "i! ~ ~. &Ij <ti~:t. ~1-x~. ~:ll:if~¥it*~iiii~R >glj ~ ~. (Phone and Fax) +886~2-29387692. ~~ ~.M~. •• fu~*,~~~.~. ~~~~.~t~.A' ~~. ~.*. ••. ~.~~~,~~~.-~~t#. I,a~.n~~.~_. ~. ». ~mf. ~. ~~.~A~. .•.. •• ·~.~ •• ~f.'~~~~~ ~. *~~~~~. • • $~_.ff~.,*~_.~§~a~~*~~~.. ,~.~~~£. $~a. ~~~~.~~m'*. ·~*~~m~'~.. ~.~.~.$~~~.'*~~*~~ ~•• #. •••,-. .*~~~~. ~~~~.~~~~.. #.~.. ~·~~.~~~.'~~.~fu~~'~. ~$~~mo. M.~:~~~.'M~~f# • • ~o. •. •. $~'.~ • • '*~~~'L~. 1'1. - 189.

(2) '2 ~ft.+. ••• #.~.~~.ffl~_rt~~~~t.~. Benchmarking Electronic Commerce. Database Application Systems. Jia-Lang Seng. Wen-chen Cheng. Associate Professor. Dept. of Management Information Systems, National Cheng chi University. Wenshan Distinct, 116, Taipei, Taiwan ROC +886-2-2939-3090-81213. ABSTRACT. Electronic Commerce(EC) booms since 1994 with a vaiety of information technology involved and installed. Database management system and technique is one of the key enablers of EC success. Benchmarking is the vital tool to measure and evaluate the Web database application system performance. In this paper, we present a generalized benchmark method with data model, transaction model, and control model to test and appraise the Web DB. A prototype syetem is implemented to illustrate the promising perspective of our method.. Keywords : Internet, RDBMS, Electronic Commerce, Benchmark, Workload Model.. - 190 . ".

(3) ~. -3 f"l!~ 'itlt~oill. "'*'" £l '. '. ~. 90 ' 6 llJl. t.:tt.:o. iJi'S. aim. (Internet) lli:*a9.lEi:Jm;fOi~~ , :i:J:f(i:m~ (World Wide Web,WWW) oo:t5}i~~ri<{}ef.]%3~ Q~1*W~fl.*~a9~~t:ingjlj'¥ 1989 :If ' i?,i~1e~fJ+I:l:T!jo/Jm!Jr~~ (European Particle Physics Laboratory)a9 Tim Bemers-Lee ~BttJ£tI:\ TrJm)(14 J( Hypertext) ef.]$~ , §ef.]~:ffi"'§fjjEBM·&'Urf.]1se#l1Ji* ' 1f}{1~gtfftE1Z[PJ1'F*ZP:i:laf.]jiW4 fE[~illEf!j 1993 HTML 1.0 Wfi1111(3jtJ£tI:\ ' tJ;& Mosaic ill @~Jiffij ~Jtj ef.] WWW ~~'Ifj[rtt1ttl:\ (:f* Jtjaf.]~Jm)(14~~fl.thhJE ' HTTP : Hypertext Transfer Protocol) ~~lIljf~itfilID (OUI) Bf.]t;) (Browser) ; -H~zrI'l9 ' ~J:f(i:m*~Bf.f~~1**~~~~a9i~:g~1'lJ [13] [15] Q 1f~~1iJi§n'<:ill~pxJfJaf.]~i£ ' ~*TfIem~Ji~~}jiitef.]fllIDz9f- ' i:~fl.a9~.g.~~ ·{n~~*~~. 0. J:f(Wm~.fta9~~~~ojima9~.g.tE=MMlID.ff~m:~~~i:ma9mm1J~' lsem~ RWiH~~~1*W7JmJEfV:.jI. (Universal Resource Locator' URL) ef.]*JI~iI::f:* ' P"J .m~mWBf.]W~;~~'~~~7~~.a9W~'~ •• m~ff~~~ft¥~~M ~~m! ; 5}9f. ' ~J:f(W~fl.~ff1f~~~i5"~rjHtaf.].W4*7Jm ' ~RDWJ!tffiiaf.]~!)'I.jI , *~EB ~flfirta9.~,~[PJ~~~~ffn~~§rt§.a9.~~.m~_~.Jtjfirt'~ W~.~ffn~Jm)(#~a.~m~~-.Q. W~_*~~. ,~J:f(.m~a9=*H.~m~~ff=:)(#t!:\~1Jrt~~. ' tX&':t!rp /lQ]HIiHffiia9*~*~lJ.iIJ QEE1elflPJ.tlftR~1:i~tE~ • • m*~J:. ' llD~tjff~1*'I1af.]mtEMl~I~ ; ifrllD' Jm~.)(141Ief~mw'ti~ ,. 1*'11 '. ~W:Ml~I1Jrtaf.]-~'ti. ~fin'<:*a9.mtl:\~.m~ft~o~~'~W:Mlm1Jrt~-.tt'm~1euWJ'~. Mrta9)(#R~.MJEMrt~.mfirtMMl'l'. '1IeJtj~R •• ff~. .wm~iJj'l.jl. , llPt:iTiJfrz tfuMlmm{:fjcgBfn-af.]Mrtz)(f4 ' ft~1Z~~fJ:lij!az1'F .ZP:i:lU;&M~.)( • •m!.jIa9• • ~~*Mm~a.~-B'~~ •• ~a9-B' ~:t!rp /lQ]HIi!tffiia9H!f!jJ ; ~lni:t!rF /fQ]ijlij/ffilgt~jni:t~ (CIS Computing) ~flI5~~~~ • • ~,.Jtjfirt~~ZP:i:l'U;&~1eH~tt • • a9ffiW.~'.~UWJffW-~$ pMfU~~~ , ffij Web ~$Bfl~'~~3!$!Jaf.] a Jr~~J:. ' .8fl.af.]~.g.~f~ , fIeJfl~~Ji~illiiPi*I1(l*~?&.~ , ?&Tffi ' fIe1~ WWW r::Oj!4'~ollt~1'Tef.]~~ , _*{tf'TMff;:if#j:liJ;(Ji!iJ))!9lXfij: -1$J~tl ' *f@1~~~Bf.]glJ)ii~l~ ~f:J:!;¥V1tj~ff~zm ' ~f!jtjW:f*n~t'l~af.]~J:!u~~m§1Z?g~~fffPJ_*it~~Jm ' *J L1$IJ~ 0. - 191 . I.

(4) -4 ~~.+. ••. IM.*.i~.m~M~~#L~t.~. ~~.~~Mg.~&.~~m. o~~·~¥wm~~wm· o. ti 50 4f~~. fj$:~ • 1991 4~~~*f4~t!. · mtjlf4:J3i~I:l:m~~ 80. ~.~~.. ·~~m~~2~M'~.TW~0. ~~.,~~. ,~~-*~~m~~~~'~Wg~'~~.M~. ~E~MMffi~~m~0~~~wmo~¥.m~~mm*T~.'~wm~~~m. -=fJtljl9HrMfiXM 21 [20] [22] ~~Ij · iJtIDfBa~1~¥~~mt;;S::~f~ttB1I1t ' R~~~7W¥ljjjmB'J:x:te!!~B!m ' ;fi(JL\~~fm 0. ~rr~~~Hfj$:WM~M.~&.M.wm~M~.m;rr.mmt.~~E~M~' ~m~~~. ••rr.m~~te!!~B!m. ~~mo~~~,rr~E~M~¥.m~~.. Mnoo,-~mE~.~.M.wm*M~~m~M-~~~~.-=f~MB!m*M~ PJTffi1;TJ~If. 0. j§~~m.-=f~M~.f4.W:EJI!~Mrr¥~**~. .~.M.~:EJI!~M'. , !!n~i'I~.f4.wm~M~. '~~.~~WM.W:EJI!*M~~~~~M.M. .wm*M' m*M~~o~~,rr.M.~m~~&0~~~m~~~~®a'. '~m~~~M.D~&.M.wm*M~.DM. 'W. '&*.M.wm~M.~~~. •• ~~'. *.M.Wm~Mom~~~~~'~.M0~~m~'OO.~.fm~' m-=f~M~.M.wm~MB!m~,~~. •• ~~~?. U{~~!f1i'!i (Benchmarking) , Iil'6,f~R. '. !!n~~ttt~-~M1f-~mlj~A. '. .,~~~~~tt~~~M~tt~o.~~~~'~~.M.Wm*M~.~~~'. ~~~*,. '~.M.W:EJI!*M~.~~~~w~m~m~.. tE¥19}-niID ' '''''''''''AI'. ~ , ~flBJE.fiXM.~~fIem~1fMIfm.fjl~~f~~ , ~O Wisconsin, AS 3AP' TPC *Jlj ;rr~B'~E~M~WM.W:EJI!*M.ft~M~T' ,WM. /IX '. ~~fIT~f~*Jl~jt~!f1i'!i~DR:EJI!fDDR~lj. r:::1::~¥Y'In'-:7":'. b-J.:-...j'..,-J'.r.rrrrh'.7J.mtn&. f. .r..'-h=t~_.J,.t...":;'~I...L~tot:t;:r;. 0. -r-1"">'tT. fl-~..A.;-i*.rA~=,J(. o. - 192 . ". 0.

(5) •. -5 'f1£~'i1K"'$.'. K 90, 6l!1l. ,*m~~.~.~~~MM$'.M• • g~~.m~m~;~~'ttm ~®.M• • g~~~Mtt'. • • ~&.m~.~;*m~~~m.M • • g~~. ~~~g~~ • • ,.~~~mnu~~.~,m~MEM~.M • • ~~M.~~~ ~~~'~~U~~~.~.~o. It "~~fM~iI:*~~~I'~~Jt - .. !D!-~Ji**~~!I'**1tmJtt;~. .M•• g~M~.~'~~~~~./~~.~.'~~ff~$~~~~/OO ijli~t~fl~j. ,. WWW QM;l! ' iiaf.J~.mfJ! ' f!ppff~~a"J=Jlrt.~~f~ (Three-Tier. Architecture) -51px~~~ (Client) 'Web iE]NIi~ (Web Server) , ~1ir'IiM• • ll~~ lE]~Ii~ (DB Server) -=lI1!lJl~*.~. 0. $IJ§Mr:iJj;J)t:1JD~·Ji~.mlE]RIi~ (Application. Sever) j;J3re:l~11::*jI,IJ (Business Logic) ~gr:iJ j;J~ff~$ lJlJ~jit Jtf~f¥.m f¥rtpffmaf.JjU4. '. 0. :Jt$ , .*4• •ll~*'ft. Web 1E]ijli~ nlJ~jit .1E]RIiJ}Jg~~~fFlj)ij~Jfaf.J~. , ffi:i~~~Iffl{~~~IJmirlJI:~lj)ijlE]RIi~lfflil~ , ~~*~}]!af.J:&.~lI~rt~f~m:f3lj)ijlE] Nliftlffl~OW*4 • •ll~rJti~~/~~iPlfffi JJ!mf¥rtr:iJ~f~iflE]RIi~m¥A1T CGI ' tJ:l. 0. r:iJ1f~p~lfflr:iJ j;JJA1T~~~D Java ~~:&rt:&f£af.J Script. $rt.g!utE1;£rt~f~af.JM5. '. .-. ~1N~D~-pfT~. 0. Jl:tfm~.r:iJj;J~)tIi~i5" T~. :. • • •W#• • ~*~~#~. fIT ;ff J.t JfH.l J\ 'f ' 1t Jf] J.t Jf] ;f.l:A. ,l.X it ~ ~ ~. II lJt '. ~ f' ~ R-I-;ff 5~J. ~l'Ioo-15r... i1f ,!:,,{ 1tJf] ~ftJ.t Jf] if.!:A.. • *4 ~ 'f ;{f 1it. .~~;ff~.#~~~._~'f~~'. 5l ~ , 1t. 0. 3=.1,t ~ ~ 'i # "Hit ~ M,f'!; lltif- i1' 4H1. ' ~f.Jl1f- :.§:. f' ~ i1f ,!:,,{ ~ .l!~ ~nt ~. •• ~~. l:I:PJt. 0. OO~~f.JI. .*4J.f .J:! *4J.f. ~Mt. J.t Jf] ;f.! J\ tt1:& ~ ::? 1t '1'1.. , 17>Ho Netscape '. IE ;. t. J:!~Mt::?oo' i1f#&-.1;;Ul~3!3&~~o ODBC,. JD~C :f.~1!1f-oo '#lft~M!J!A~~jf*4J.f-f.~Mt. 0. ~a~3=.~:A.~~~~J.tJf].J\-~tt1:&'~~;ff~f' ~~S~~*.o~k.Jf]~-~~.,a~R-I-~~. .~~it~~.'ffl;ff:'§:'f'~~i1f~*Jf]~.Jf]if.!:A.~. ,. 1ii#JT1:&t.. '. Jt~~ ',W; *1?:#JT4f.. - 193 ii.. ~. ~.. l. 0. I.

(6) -6 .~~~. •• IM••• *~.m~. ••. ~~1~t.~. ~DMpff~ , pff~I11B'J. rWeb jj*4nii:g~I~*1tJ ii]mfEl&BJE~~~it6r:pB'J*:l:B'J HTML o~ITfj , B~ ~ ~ B 'Web EJiJft~B'Jjj*4nii;g~I~~fmz:fr*S-@!, APls ' tfl 1ft 'DBA '~~~lE3 ' ~mJt~ Web jjNnii;gJJ!!~*1t ~ITfj , E8;(j~:±JH~E8 • • u.~nI~'ff~bjjN~;gJJ!!~~r:p'~.E8MJE~~W.~~nftoo*~ oWeb jjf4nii;g~!~*1t~E8 HTML flrA~~J.6~*~n ; ffiJff!f!HEA~JJ~~~ CGI B'JnAfEf~m~ftffil ' $(;~~~~li Scripts fE~Fftffil~MT JJ!f!HRA"6Jf~~~~t Rf!Bt~~~ 0. 0. ¥jjN~&~~¥m~'~~~.mM.¥jjN~U.~~~*~A~-$ffiD-e jjNnii~JJ!!~*1t~~~~~jjN~;gJJ!!~*1t~tt.~~=AAffi:. .;. .~.4w#.*m'~.-ftw#.*m'~~AM~~(~~.m) -~~lf*+,*. I.. *t~. fF. -f~. ~t1t.~.. ~ ~~~ffir. ~'dJt. (SQL). .11"1'#-" ~ ~t Two-Tier (Client +Server (With Database) ). • fflH/ij ~ 1f. *+,If. T I.! ~ ,*,. CGI ' JAVA &~:li ScripH~ir ~flt. Four-Tier (Web Client +Web Server + Application Server +Backend Database Server). =,~~~~.~~.~~~~~~ (-)~j(ltiag i~1!~f~. ~~jjNniiW~~*1tAAfi~R'.~~*~~ff.~.ti.~'~~ • • ~F~ ~~~~b~NUWjjN~~~*s'U~fijjN~noAAU~F~jjN~n~ff ~1S/IlfifIJ3!1t. .l. ' )(ftfpq~,~RX. ' nij(~ Web {i5]~~U~.*4niiWJJ!!~*1tra'B'Jttlj.i!lHf~1J fEf~A m:n~~*1t , Wi§ftB'Jttlj.;li!g~fM : WWW f~m~U~itMftffil HTTP flrA~)(f* ; Wit ODBC/JDBC "6J¥j¥~~pq~ ; ODBC/JDBC i§M811.§7f!mjj*4niiW 0. ~~*1t*.~m~.N*A=JE'"6JU~~fE~.~.NniiW~~*1t.l.~~n~~ffo. - 194. 4.

(7) ". .7 'f"'-~ 'jflf1."':fil. ' J;\. 1~nli~ LWeb -_ _ _----.J 1. <=> I. 90, 6 ~Jl. HTTP/ODBC~:~BC-,*;f~ni\. ODBCIJDBC ~:tn~i\. SQL16JJllU~. Microsoft Access. ,!\j;fM.Ii(.. ~~ lfJJ ~.¥. ;\.. Jt.f1!!. ~fJJ~i(.. Access jf#,If. ~. ~~~J. ~. . - %b~.B.~#.. (.::.)1t JfX. 1';f+. "*. l~~~~~*.. $. ~/t M] ~!ij Ji :il1'1. ~~.~~W~~~.ff.M.V~*H~M~ff~?-&.M • • ~*M~. ;ffifi*~'~~R~M~'*$ffi.~ .~mm~M*~~'%b.M.Vm*H~ff~m~~~m~M~~~m~ffM ~. , fIf!ffltfriJ t)JIJJtHJ)tJJi!IIJ~JJ!;ii,f~~*ffii£~akJ~~~~~~:f@-ff.f4~~A~. .~4.~~~il]. Q. ~R~~~.*4.V!j!*Hz~~~fffi' g¥1:iJt):7f1jH~ SQL ~~$ijiJtff~fF. 'ib'-.,]'i;-iI<iH-\-. DB AP il9:~ttfPJT~)t~t~ HTML ~f~FfJfuilA~1'F ' PJT!lf$:fIJ,j;m~. ~8~M.~.A • • mffiiE;.An~~a.,g¥.~m~ffltf.~:7f~mW~ ~ff~ii~jU4.. Q. ~. iRt~ffl*M~~~.*4.' HTML $akJ<Forrn>~~i:t~<rable>. ~~7:t~~~m~. , -flIJ.!±E~ilH]~f~*[J*a5fb~&~ , -flIJft~f~~1t~A~:f@-Aft~tl:\ ~.M.AZ.,~:f@-~3.~ffm~~• • ' • • ~.M.V~*H1:iJm.~ 0. M~~ffiWZ~~~$;.".~~*H~~~ffii~;~ffii':7fR~~~~.H~ akJ.~4~~g~*. ' fIl]8&~fffittL 1:iJ :1iJ~~~1~~fffi.*4.p;jakJ-Jft;Jn4 • • ~m~*a~~~. - 195 . I.

(8) -8. ~:tL 't.:r-m-fli*+J.J!fl!.';;!9!.fi.! III. f~J:\ '. o. f4)JJF*l~~lJI1.~JHf:1;h1'F. 0. CGI ~jM!~~ Jf€J~A± ~OlWpfi~. , 1E]H~~ffijtE:j:~alj~F~ffija91!E§iiJ~~3ft~1& ' ~J:!nfljJtHi'iJm:Hffija9 r!f!FIH~J:\J *~m! ¥l1;fj):~~JH~Jtl ~tEt;l'jf HTML ' UJ J;JtMitE Web Server ~ffijS9!f!Jtlf~J:\ (Server-Side Application) , fJHrHjij;Lm:tt:~ftt.'J'iirlID (Common Gateway Interface' 1m 0. fL~~fBi HTML. CGI )oCGI 'CGI CGI. Server ¥A1ia9B!Jtlf~A.I§-"i'iJf1J.~ CGIo. Perl' C'. ~tE~~~ffi.~1!E§iiJ.~,~~~~-&~~. server a9@Jffgmif$ll::1J-f~iilll]!!1I '. - '. o. Web B!Jtlf~A. 0. Jiil~.~!I~*ftIl~~!ji1o .~~~tE • • ~ffiru~~m.'UJ~mS9~~.S9~~.~'. mAS9~~o ;"J-.v?:E~:;:1h 1-1-. '.~~~ffiru~S9~.M)JJ~~~m~.~, I'll\... -;1'~~nr.:rT'rl-_l',l.L..._"'±'......l!.. El.L9} ,. (Experimented Factors) : tEi1lIJ~A~f~t:p' UJTtJc;9JfS9~~~~m~J:l~' ~fLjn4)JJ m:ktJ\ (Size) , ]t~ii] (Query) a91<1~N ' ~*1Ca9~c t£ . (Configuration) (-)@. (=-)*J~:j:~f~ (Performance Metrics) : i1lIJ~rta9£t±l*a*' !-:Jj~f~10AljjDJUJ{,ttttf.x' -~fffi~ , *J~:j:~.UJ J;J~ilt±l. (Throughput) , @JJi!~rF.l9 (Response Time) ,. ~JJHt. 0. (Price/Performance Ratio). 0. (Experimental Design & Measurement Techniques) : o. ~tEM~~~F*l'. o• • •~~~~~.fi~~E.~~W.S9I 1):.i.fj!A I1'F:l:tE~F*l~~UJ7t~=fi' 7tJJIJ~A~S9I1'F:I: (Synthetic Workload)' .~89I~:I: (Empirical Workload) ~~ifS9I~:I: (Mixed Workload) 0. 0. ~S9m~~'X7t~~gm10'-~~ttm~.AS9I~:I:;LE.'~-~OOJtl~m. .@~S9.~~~M.AS9I~:I:;tE.~*~'~7~if~~m.~ftU'M*g~ ~&:\~Ji~it~~t±la9I~:l:S9-t;JJ*HI. I¥bfth;;"+~~~1Ll.."'C. 0. (Analysis) : tEfJj:l:~a* '. - 196. ". ,. ~+~.ti=l;.!E!.

(9) ". -9 'If J!$t lt11l-!f:'*l ' !\ 90 ' 6 M o pfi;pfl¥J*i~~!fii!i¥&E. • =,_.". , **1CI¥J*J1~-&pfi;pf!3 Wllfdlqiia. 0. •§ ,;;al,j'l:;t~ Wisconsin Benchmark'. Benchmark. ~ )Ii- ~ 17 lID. a. tJ-& fAi~fHtB.~iWAI¥J~mjjrt~~fi]f~¥ AS3AP. :X:il ff~ ~!f g~ ~ ~ WI. •. Performance Council ' ~~f{l} TPC). : TPC-A '. ~Ur. TPC-B. W TPC-C. Wi Eff1fB.~0:g2E"Jf~~;pf :. TPC *37IJZf~¥. (Transaction Processing. ; 13X. TPC mWIE"J~~n~F'f. ' TPC-D ' TPC-H ' TPC-R ' TPC-W. 0. ~,n~~m~~~w*~~~~~ 1fjt~t1i;. Wisconsin Wisconsin. (Bitton and. 1988) , ~:1:~1¥J § o. , mlj1iii*4ff!f~17rt~u~. Wisconsin *1~~!f1i!itJ 32 @~miirt~gfi]~:1:~E"Jmlj1iit*. mIJ~it§"fl~~8fi]pfi1£.I¥JB~rl3' ~f£~ Wisconsin IIrz:blhlJ!ffl1:t:S-~~~x$ 0. H J:a"J~.LUiIJff1f '. ~U~A**ft. '. •. , ~ITf.i~*:!l;pf~5t:. i1!IJ~1\jn4fjgf!**!C*/J\~ 5 megabytes ~. 0. (.::..) AS AP ~. jt ~t1i; 3. AS AP (ANSI SQL Standard Scalable and Portable) *1:X:il~!f1i!i17i*:1:f!itllH~-@~ 3. • tJ8!f it Wf4fj~lm*~E"JJ1&f!:X:ilff~ • 1ft)li-~;pf~titE. lID '. (Scalability). • Mz~l~ Equivalent Database Size ff.fV~*4J1El'1ijj.J.l¥Jf~fj. d_"+I::..j,<ffi-+IHiI+l-rlr~~ l'I..el.-I-;:zl!<~1 ,*fth'7'aFlI'l"P. o. LlJAmlj~\. (Portability). AS 3AP. • 12 IJ\~pql¥J~R*IJr' ~,AJi!]!W~ Ali!]!. I¥Jmljgit!:tJ Jt~~l~f~*J1 : IJAmlj~\W~ Amlj~. :. ('Elt3. Aggregates, Bulk Updates ~). i1!!Jgit. 0. Joins, Projections,. a. 2.~ Ai1!lj~: 1f~ A7J{ljgitB"Jf~*£lr' !:tJit5t~1~/fIBl~Jilli!8"Jjn4Jl~l'**!cI1'f:l: f~rt. '. :1:f!i;pf*17~.1.~~J1&l'IfF; (OLTP) ,. (Mix). OR) 'rfH~iI1'F:l:fj!rt. 0. ("') TPC. ~.j:t~t1i;. l.TPC-A. -& TPC-B. The. all1>a\..UVll. Processing Performance Council (TPC). - 197 . 1988 if.. '. I.

(10) l. '10 .~t+. •• I#.~.l~.m~*~w~~~t.~. 1!. 1. If!fiIiXM!H~jtij~ffIJ*Jlpx ' .lIUEU~ft:1 § fj!Jt:t~tij!*IJkj;{f4}ij!~JI;jU!t (Database System) (Transaction Processing) akJ ~~*i~~H6t~~. *1 ~ ~zp iii. TPC-A. 'TPC-A. tJ. 9: ~ ~ J]t[ ~ $1t. 0. TPC. 1989 1f.. (On Line Transaction. Processing,OLTP) ~::t~ft:17MIJ~A~J:l OLTP akJ~J:lN'§.~~$~~ffil~ , j;{f4W1iAWlite ' 0. '~m~~ft:1~~~.~.-' • • &£~W.M~ft:1~~.::t, OLTP akJ~~~J:l ' fEl.BP~~!W\1~fl~akJ~~~fi~~ff~ZPfii. 0. tE~. ~ ~ffilfJakJ ~ $1tJi J:j! , TPC-A *jf~jt fir .:I::flH"'. ~fypJT iC px akJ ~ ~ ~ (Transaction Per Second: tpsA). 0. Z132 TPC tbhWr~. 1990 1f.~~~=f~UI~jt~ZPlii TPC-B ' TPC-B. OLTP ~::t~okJl~IJ~~J:l' ftfr"iiHtt~tl~tJ Database Stress 7MIJ~Al~ttakJ~Jl~~zpfii' (tpsB) .::t[34][35] 2..TPC-C. ft~r,.H;:",. TPC-C ::t~a'lmIJ~Jtj:~:t#:~j;J~fJl~a"J OLTP. ~~ ,. 0. TPC-A. fD. 0. TPC-C. TPC-B fE/tt ' TPC-C akJj;{f4}ij!~JI~*!t7MIl~AtJlfJH~*ll~WTjjpHfiijJ*i. ~gZPlii' 1l~9: ~ ~~i:M~~flWo. , Em : ~n. ~ ~ (New-Order. Transaction) " JJ!~:Iz ~ if,x 9: ~ (Payment Transaction) , n . iJJ ~J (Order-Status Transaction) ,. (Delivery Transaction) ,. (Stock-Level Transaction) TPC-C 0. akJ~Jl~jtfij.:l:mt~~7HMpJTI~iUlakJn. (Transaction Per Minute: tpmC). [36]. 0. 3.TPC-D "-"""orr.',, 1995 1f. ' ~W. TPC-D xm~~ (DSS). (On Line. Analytic Processing,OLAP) .::t (Transaction Processing Performance Council, 1998) [37]. 0. 4. TPC-H TPC-H. TPC-D ~J.jfffj* ' ~~~~ 1999. 'l2SI.lI:t~i:!H~:tJ¥RJ~xm~*!t. ~::t~~~~.~'M~~ft:1.~.flW.~'&-~tt.f4£iJJM~o-~*~,. ~.xm~$1tft:1N~~*.:I:ft:1.M'flWtt~ft:1.~'&fi• • ft:1.~OOMmmM~ ~[38]. 0. 5. TPC-R. TPC. TPC-D 1l:&211= 2132' ~~ 7 TPC-D TPC-D *Jl~~ZPfii '. 0. - 198 . ... 2.1 ';}x1r'lj)'f!m~ TPC-R °TPC-R TPC-R. i.

(11) ". -11 f'lf.,lIl- 'il1!1."'~1l ' ~ 90 ' 6 jI}j. .M~ftg*M~~~~.~.~~~~TIGHm~'R~~~~~M.*~~~. ~~~Jf:l~§a":J: TPC-H ~m:1BtUt£tfl¥Ua":J~ZPfi5~; ~lffi5~[39]. fffi TPC-R J.'IIJ1±1B-&*B-m-a":J¥IH~. 0. 6.TPC-W *1~~lffi5 TPC tbh~UHJ!H3M*~lf&~r;tJI:' :x:~*~ritfi~n!Jf:l.fl' ~Jj,!T-*'~§lffi5'. Jf:l~m~~aM~~~'M.-Dtl~:X:~ft~*~~~o~~.~.~m.a~~ ~i~Jf:l~~*~JtllmtJ (Web Interaction Per Second: WIPS) *Of.m/~:fzijat. 0. jffillU.l~. ~~.*~§.1±1Btt~§OOffiOO~Rfi~MMn!Jf:l~.~~~~~~~~a. $ ,. fiff~J5)Ii. - " I {'F• •:a: ,~~n~MM~~Iwao~._M~'IW.~~'~~ f~*f~~PffrJipx 0 ~IlP , 1±~3=.If'PI:~:i\a":J~f~. , ftfl'~1Z\~jHt<Ff,@,3=.~OT=f;f~~ :. I... t~. 11'. ~ II ~ UU]. ~. ~. ~. iL. tJl.. 4t .I..1t i: ~t i(, ;F ;t I. 1f~'Hl1! (Data Model). .W§ • • M~ftg*M~~~.M'~••~Mtto :g , tB #& t± :g ffiHJi! f'P ~!(f:g. *. )M~~'Jh. 2. ~j{. 2. '*. ~. :Jt1l1H~~. lij..::.. .1.. ~lI ~ '1f *4. a. - 199. I,.

(12) '12 ~A.~. ...fi.*••. (.: :. ) £ !h ~~ ~ ~~§. ~.m~_~~~L~t.~. (Transaction Model). •• ~.ft$~~~~WID~~~o~~~~~~~~·m.~~~~~. ~t~fl&}JH5~. 0. (:=).:J?t"*H~~ (Control Model). •• ~.ft$~~rrft$~~~M~mlli*~Mtto~~.~.~.ft$ ~~m~~~~m'~~~M •• M~~~~~~o ~~§. rrIW.m~~n~&'.W~~.~.ft~~~~~n·~&~~X~~~n, TIft~c~1k&~MFPJTWmIJ~A~fjpJT~t1~EI'J~~fD$J~' ~D~j~::Q:t~l~Uli~X~¥A1TEI'JJI~Ff~ £§Jf~fJH&IiI=PJT~' ~=flIDg~f515t~IJ~ ~~ (Transaction Generator) g~fJ}m~~DT. : l.mIJ~A.*4.. W3.mlj~A~IJJ~. 0. (Test Database) • 2.X~j£. (TestDriver) ~.f'Fg~f51. 0. E~,t~=@. :. (-);11. iJl'J ii.. jf;f+ J.f ~~~@~.~.~~~W.A.~'Wm*.~~~~~.W~~~*~*~o. (.:::..)£!h;11. 3 ~~~~~MW~~ft~x~'Wm~~~~§o. (::)iJl'J i<-\,~~ 1fJ 3 .. •. ~~~~m$~~.~.'~.m~~~*o. =,mfi~~~~~M~~WM~~m *m~~~~~M.~.ft~~~~m'~5tm~T~.W~~(a~m~,~. TEI'J. r~~J mjlt~W~IH£EI'J;mWJ.). (-);1,fp ~ iF ~~. :. Jf (Product Display). •• ~~~~Mfi£*·fi~.~~~n~orr~@5t •• OO'~M~~7m~ m~ •• *'6.~~.~·6.~M~j£~~~mg·j£~~m~we§~.~~ -~;~~~m~~~~m~$~W~'~~~~~m~~~~*IJJ~~ •• ~m~ mg;~~~m~.~·~j£~ffM·0~~a~~nWmMorr~~nOO'~~~ 6g~~~.~~&~m~IJJ~~~o~~~~ma~X~m~1l'K~~Wm~. *4.ft}JI!~*JC. ' @J*f~m HTML flr~f~fftmm. - 200. ". 0.

(13) •. -13 "f}.!~i'lll."tI.. ' R 90' 6 ~Jl. (.::..)a ~Jt -4 ~1@) ~ (Product Search) ~7 • • ~n,. fi~W.~W~2.ff~m~o. ,mr~£. •• ~~J. '~m~~~ft~M*~(~.~~~m~~~H.9~)Wli~'.~H. •• ¥~£~mm'W~~~~~.~D-~~~' MlmJf~ J;J*,ijln~QX~m.¥fii!l~gIiJ~1& ' *~~fQ]~&~fIJmf~frfj~~~!t"~ SQL W gIiJ~ff~1&liffii~f4Jj.9*'*1t 1~¥IJ~~*55fH& ' ~!t~p.xf~~1t*[¥]~ ,. .¥.~~;mn~.~m.fi. a. ~D. £& ~1@) ~ (Product Transaction). (::)a Ji.. •• mm.~~, ftP~IJrr*;RJ:ilHT:9:JlJ ;1J;ftP , r££:9:JlJ~~J ~mrr. ,~~mm~~0~. ••• QX.. ~J{3IJ~*]EI3m.~ft~3§~~~.JH4. ~~~m;*~.~.~mm~QX!t~ID~M~~M~n~'~m~~~~M.~~ nH~tiftf4~'11. 0. f.!ltl1EE~$:rtJ7¥ljfi~ft~~~~Li&;'11~r4~{'~. iljH:t'!¥Ij~f41l1j.a\J~3d1. (l!S)a Ji. .i!lI{1t ~~. , mJ;Jm~J{*f¥lJT~&\. a. ( Package. Track). rr-@tt.M~~~M.m~'~~~£~~~~~W£~~3§'~mfiWm@. •• mm,rrffw~~,m~~~~3§~~£rrm@~.D~w,m.~~o~o~ rr.J:mm~2~~£mrr~mrr~;~~~2mn.~~£,mrr.~W~3§~mo. (Ji)a ~ 1t1r ~~. Jf (Product Broker). ~rr~.~M~.aQX@A'~~fi~2~~£ff~'~~ffl~-@.fr:9:~~ ~~~,~.#.~~.n.nw.~,~~.~.mo~A~~'.~~~o. ~ftM~. •• '. 2JlJ~M~~~~:~.MMm.~~.m'*w*~~~. ~.~~~p.x;~ftP,mm~AM8~£~~~,~~rr.J:ftatt~&.~:9:~~. •• ~no (/\)JULff ~Iif j1 1Ilf ~~ Jf (Registering) oom~rr.~.~~~~ r,,'Rj-_m1'jl'~~a\J~am. a. ••fti&;m~~,nH~~*f¥l~ff~~W~.m,~rr. [2;j~ , lIt~J{ij&mft~±tffi*f¥l~~§~~!tf1Uti~ r~£J ~~ffj~. ~~Q~ijam; ~ftP, fR!mfi~tJrrrJRJ:n~,. ,nmFs'W; , w@~~m~~~ifiIJ. m.~~•• ~@A.M~tttffi,n~OOm~*f¥lM~.m'~: 1itf~.MJ!i!. (. )a. - 201 . a. '.J:.~'. I.

(14) ~. -="'. "r>J. "*. ~. ~. ~ ~. ~ <~. ~. 1\ltI.. -llll~. \~. ~. Oil. * tl. tl. ~1t. ~. w. ~ ~ -t\ll~ ~. 111t1. 1~. ~. ~ :tm: ;qnl. ~~1. ,. -<. fI!t. * {+ ~ ~. -€. ~. ~. au. Oiltl. ~~. ~. ~ "!WI. ~. i€ :;&. 1t fx. -s). 1~. ::th. ~ ~ ~11ll( ~11ll(. ::th. ~. :t. tJ -m:r. -40. .. ~. ~,. t:rf. ~. Oiltl. ~. <~. ,-..,. 'I:' Q). '""' co ...... 8. ~. ~. Oiltl. t:. <~. \m(. ~ '-'. "'0. ::;j. u. 0. ~. \m(. '-'. ro p... u. ~. ~. Q). ~. ro. u. ~. '4'f1. -II'b>. ::th iQ ~ ~ -C"' '4'f1 ~ ~. .~ -40 ~ ~ ~ iQ 1J!t ~ ~ ~ :¢ ~ ~~ ~ ~ ~ ~ ~ ~ ::th -40. ~. ... ~ ' ,. -m. c8. "'0. ::;j. ~......u. ro r:n. u. gil!\ ~ ~ ~ ,-.., c .S ...... ,-..,. 0. >.. ro. r:n Q). ...... Ui U ::;j. is...... U ::;j. "'0 0. 8 ~. \m(. "!WI. ~. ~~ Oiltl. ~. Oil. ~ tl. ~. Oiltl. ~. ~. ~. *. \m(. '-'. '""'. "'0 ~ '-'. \m(. ~. \~. ~ Oiltl. ~. .fx. ~. t+. ~ iliff' \oolt. {~;j. ~~. ~ ~. ill(. ::th :.i'. « ~. -<. ~ ,-..,. Q). '""'. C. OJ). ...... r:n .,.... OJ) Q). ~. '-'. \m(. ~. -1+\. It 111 t!. ~. $ ~. t:!l!!. 1::1. !!W &i t:\ !mK Ht' '*". ,-. • III. ~ ,IT. $. 4IR\. :i;R I£:. "* <1tI. "*'. .. r. t:I2! =. ~. !lI!!I-. ~. .-. ~ ~. ~'" t~ ~ , DlIll(. r. W :ltl M!. 51 M! i\? i\? ,. ~I. ~ 0 ::\:1' ~ fi{II I~ ~ ' ~ EtE = ~ ~ ~ ~ r. ,~ ~. ~. we. l::I l;l t~ .J::l< =' ~ Ml 411::' = ~ ~ K<{ ~ EE M! ~ +H r ~ 11Ittl ~ ~ ~ ~ ~ .. H r ~ -N ~ oEl ~lE !t8 ~. m. ~. -Y. III. ~. we. ~. ~. ,. 9!!!1.K. ,. \fiJ. 111Hl. ~. 0. w. ~ oEl ~ ~ oEl ~. \ME Sf ~. ~ -N ~ ~ .. -N DEl. m. DEl. ?llil. DEi. ~ ~. :l=tH ......... ~ ~. m. \lntt. F;?:l. R:R. DEl ~ ~ ~ ~ =.. mRl:'. ~ ~. I~. rna;:. t~. ~ ~ DEl ~ ~ ~. 1l1~. Ill!2> 1~ ~ IIIl r f(Im: -l«If)! DEl DEl ~ !lI!!I-. r<. oEi. 1~ ~ ~. ,. 11[:. ~. of\! $lE. ... IT. ~. ---. ... l::I. $.l ~ '*". .ijlJ. oEl !t8 -Y. 1'lli1 W. ~ ~ ~ ~ ~ -Y 111!tl ~ +H ~. K<{ K<{. ~. ~. {<{. 0 r ~ ~ ,~ IT ~~?( ~. !!!. r. 0. ~!Ill\ -l7' -m. tcr. \ME. \llltl. N :g; iiF ir::: +H. ~ ~ ~ ~ $.l. -N. ~ :juj(. DEl tl- W. f(Im: f(Im: *" ~ 1~<{. ~ t=. ~. ~. ~. K«. ~~ [IT ~ ~. -l7'. -In. ti:i. Ii? ..... we. {<{ ~ ~ -Y ~ i!!i K<{ ~ rtJ K<{ E ~ "lit:! rtJ rK :I:H 111m. +H. M!. ~. J.'I+\. ?llil ='. DEl. /:'-.. ~. 1l1~. []J. -. K<{ ~ fW /:'-. DR i1;~ t\ .. V. ~. llil!t ~ ~ ~ ~ f(Im:. ~. ... ill. .@'J ~. Wi -In. -l7'. lll~. ~. I"-- ~ i\? lilM ~. r« ~ 1111t1 ~ ~ :I:H ~ ~ III t!1i W ~ K<{ ~ -Y -N DEi ¢:: ~ -Y , K« ~ , 0 ~ l;l ffil( 0 W -aoEi l;l ~ ~ R) ~ 4< i1t:' 1~ ?llil ~ t!1i $ ~ = = it< ~ ffil( DEl it< ~ K<{ ~ ~ oEi ~ ~ ~~\ ~ .. K<{ -= ~~ 1~<{ ~ :@.!. -f:~. -Y. ~. '*" 1!111'. l::I. -- --. ... $.l ~ ~. ~. ~. S ,. 'a. .-. ~ ~. M!. ~ ~ ~ .@'J ~ F;?:l ,,'1::' IhlC: " ~ ~III: = f(Im: ~ ~. ~. Ml q:: tiIJll. -l7'. ~. -In. '* '*. }L- ~ ~ rK ~ W llil!t ~ -m:*" ~ ~ f(Im: f(Im: ~ -N M:r :lIE -= ~\ ~ 111 ~ ~ ~~ .. W M! ~ ~ t\ i\? f(Im: ~ ~ r M! :juj( ~ ~ IT ~ = f(Im: *" ~ 1 ]fit. :i;R t.1JIl ~. "*. I£:. ~. t:I2!. =. C"'l. 0. C"'l.

(15) to. -15 'f.<!~'it'I1.$~. , K 90, 6 jlJj. o. (1ill)151&mH~fjU4. : 5(~. , ~~8915f&~[i!:mft{!(lJfJCI¥JR[i!fH~§3~;f6~~~3. ~~'~.~M.~7~~~m#ml¥J~~:MQW~~.MoMQ~H~~~'B. ' FAQ ;fj,ff!} 'FAQ ' FAQ FAQ PfT~t~tl¥J~~ji*4 ; jffl~1Ifcj.*4 ' ~ll~{I~~m~~~IM9~MtjjU4 ' f§IJ~o : ~~I¥J~.&.'~H~~I¥J•• 'ffi.~;~~#~~.M •• '~~.M~,ff!},~ ~'ffirp'l¥Jrp9~~Wt~. ,. FAQ. ~.M~~'~&~~.MM~~I¥J~~.Mo ~.~5(~~.M:ft~.~~~I¥J~.fi~'. ·~~MMI¥J_.fifi.~.. ••~*~'~*Y~.I¥J,mti~~m ~~g~MI¥J.~~&~;~.~~~.~ •• jffl~~.ml¥J~no.~5(.~.M .~I¥JM~,~ml¥J#:.~ •• '.~~.~~M'~~ ,.~~~~§.~ ~~J{~IJ ' j;)&~,'@,~1~¥11I¥J@J~ ; , ~§C.~ ••~~-I¥J.*4 (t;)*M~}jpfTi&~.f4 : EB~*~MI¥J{itfIJ ' **1C~}j~~~JJ!BNIA±~-mj;)EB~ !iffii1¥ll:\t.*4.~}j*M ' f'F~H~Mz~\~89~J! ; t&!f4t~IJ~5t-flWijUJC~J1f!89.*4tJjf, , • ft••*M~J1f!~~.EB~.1¥~.M.~J1f!**1C~' **1C~J1f!I¥J.MW~J1f!~ •• '~J1f!~~;fj·~J1f!~ •• &~.·~~~.~· *.~*wm.~w,mft._.~~W~. 0. -:#':ff~H~rfJ9. 0. 1f;ifHli\z~ El. if+. fit if+ l.~:.f;£*. lift. ~ $-M'a~. , ~ :.f;:!d.:t ' ,tiJ.lIJ ' lf~ , i! tfl.l:t!!.:la.\: ' it 1'" ;flL~ , _1: 11' ~ J.lIJ ' )jft;f! -¥-1ft ' J-X lit ~~~~. 1t- Jt ' Email '. Q. j{ ~Hl1t#. 3.x¥J. 4.FAQ fitjf+ S.ft{;ltffit#. J'afit jf+. 0. ~M'at'i~~.~~M'i~~g'i~#W~A£I#Ui , ~if~fitif+. ~~.lf- jlJ l;!] @7. Q. - 203. I.

(16) lal5. ~. 11. tiII1I ~. ;j;<!. !ll; t:( ~. '"'. iI£ ~. $!. """ll\I. *I'!!l: :¢. ~. -\1!i:. $. *'. 'O~. 'iii!. -'.1:;\. 1:::1. !!!! ~. iii. IK ~ ~~. §1. .. ~. i1$. = $'S l\IllI , ,. ili.::. f.R. ~. -m. .!7'. I!W;. +H. ~. 0. Dg m]:!<. ?WJ. .;.;,-. Zf.. W 12. =' Iffi. OIl. ~. =. !;!;: ;\f,B DEi ~~a. tw. ::. ... ~. /».,.. ~. ~. =. =. ~. :jrrJ(. 1'lliJ ill.::. m]:!< t@ I~ ~ ~ =' J::[J. *. ~. =. ~. ~. *". SIt --. 1lmt og rr 1'lliJ h~. ~ ~. ~. * -<. ::. ~. ~ ... ~. {jJ]~. r.f.P( ~. ~ 0 ~ ~ :tja ~ I~ 1M\!!; ~~ ~ ~~. I:'. "4 ~ c::r rr ~ , .,.". t{nn. \W. *" *" ~. ~. I~. • Zf.. r<. ~. IJt:: ~ ill {~ ~ ¢:: ~ i$ll !t{ DE! ~ {~ ~ ..>...l 1'lliJ ~ !t{ -==. IDK !JI; e ill \+Ill 9l1liDg fI{rr $ 111lrI fi1i' ~ 1l11tl Elf ~ i~ :tja ~ Dg ~ ~m: f,nlu ll!lg ~ i~ ~ flCI W i,qr: ~ ~ I:' :gj mllF ~ ill.:: ~~ ~ {~ !t{ ~~ f'--. ~ i::; ~ e [IT Bltt l~ ~ Zf. I ~ ~ m~ .. lilIa ~~ ~ Bltt ~FW\ ~ ~ C " iiit ~ $ \j;g lffr ~ IlnIT (~ :jrrJ( f'--. ~ ~ f~ ~ ~ ~ iiit .. \j;g ~ 0. i,qr: ~~~ ~ ~ iiit (~ ~ ~ ~\ a~ ~ ~ pQ ~~ ~. ll.>J -tor. "4 ~. -N -N. -. ~ ~ I. ill. ILf'. Jig ~. iiit. II. -N. 1~. 0. DE!. W:!ll. 0. ~. 1\1 :jrrJ~ {~. ~. -Y. ,.. ~. ~ ~f::i ~ ~K '~m: h UDI( {~. ~ H~ rK ,. r ~. tll1a. ~ ~ $K ~ -N ~ rQ$ r~. ~~u. ilml. ~. ~. H. Dg JDI: -N c::r Zf. ~ ?WJ ~ '*'" ~g W !;!;: ~. ili.::. -::::=>. *--. W I:' -Y -N $ ~ ~ og ~ , W ~ Dg ?WJ .,." =. l~ *" -£ ~ 1'\Il!l\lliJ -N. Iffi UIlF. ~. ~. = e. 0. 0. 1. -N. ~. ~ i$ll ili.:: {~ nIDI( !t{. -N g;:. Elf ,. ~. -< = ~ ~. {~. ~~. -N Q±S:. DEi. og. ?WJ ~. ~ ?WJ ~ ~. .!7' -m. -R ~. pQ. ll! ;tr,']. ~. *lHt Zf. w. ~. ~. CI. ill CI ~, m]:!<. =. ... ... i1$ ~[J ~ ''''"" Zf. ~ ~ ;I;!j pQ ~ R:II ~ ~ ~ ffi ll! ~ ~ ~( -Kml =. :t: ~ ljUQ 111 ~ ~ ~ l!'i W ,:::1 -j{l\ .!7' -m ffi£ i,qr: , -N DE! DE! ~n ~ ~ Wll iii -Y ~ {aB! {!IE \j;g Wll W r< .. ~ W ~g ~ -N :jrrJ( ~ ~ :jrrJ( -N 9IIlI .qrr ll.>J og 4Dr ~ $ 0 \j;g Bltt ~ "4 Wll ~ \Il!l\ ~ ~ (~ H. i::;. W. ~. .!7' -m. :%. ~. ~. ~ ~ ~ ~ ~ ..u ~ I~ ..1..\. -::::=>. ~. ,..:;>.. ~ (-.4 ~ li?. -. c +< tnl(- ~ []~ OIl ~ .,." g;: l~ :iQ g;: ~ :jrrJ( .. .;.;,- 12 i1$ ~ Zf. -Kml !IIiK '*'" ~ ~ rn!( "4 KIITI( ~~ ~ -N ~ m! I]nIT -N g :!f DEi W\ -N DEi % ili.:: ~ rr ~ i$ll rr l!!l ~ ~ *-< '*'" *" ~ iiit ~ ~ I±§I Wll C H~ Wll £W ~ 9IIlI- t:~ = -Y ~ 1\1 I:' iiit ~ Dg -Y $'S Iffi \j;g -N ~ ~ ~ ~ ll.>J ~.~ ~ W ~ -tor ~ Wll ~ -N C :jrrJ~ ~ l\IllI f'--. ~ gr :tf ~ DEi -N , 111 ,~. t:~ r~. -Y. ~. 0. ~. Wa. ~. i$ll. ~. U::\ 119 !HlIf. -N ffi£ +H ffi£ #fh ~ ~m~. :fu W hlta. i=l. -<. li!j -ill- ~~ ~ i,qr: -N =. )0 ~. ~. ~. ~. ~. r<. ~ W ~ 1 ill ~ -N ~ , ~ ~ ~ ~ /Xal )0 ~ IDK ~ -N ~ ~. Bltt -tK -N. 1)-> '-..- ~ ~. ll.>J 4Dr. t:~ ~. {1= ,'l';>. ii: -N. ~ \j;g. tr iiit. ~ "4 ~m~ tfg ~ . , J:X ~ ~ =~ ~. ~ ... ll.>J -tor ~. "4 = OIl. :tt!. -N :tt!. .;.;,-. .. /Xai nIDI(. Zf.. ?;t. *". •• --< ~. ". -*". *". Zf. .!7' -m ~ ~lE ~ ~ I±§I iiit :jrrJ~ :jrrJ( \j;g ~ r< -N ~ r< ,$ ~ ~ ~ rr. }~. -N. -Y. ~ UIlll{. IlIll\ -N rr. :jrrJ(. ~ ~ 0 ~ rr. r<. I±§I. • ----<. w. W. W Bltt ~. =.. ~ ~. -,. .\1"f::>. r<. *" fE -£ ~. DE! ill 1'lliJ L. .!7'. ... ~. fI{rr. *12Zf. W !ll£W. )ml( = ~ -tIl ~ '5lP ~ ~ -N §E ~~ !ll£ ~ "'* ~1 ~ -Y ~ i,qr: ~. r<. *. •. ~ .,.... ~ ~c@ ~ -::::=> ~ Elf K~ <-!:1 -N -:!:i!": ~ g;: ~ ~ ~ {1= ~nn ~II@ .>:;> t~[J ~ \lW UIlll{ f+:! t.~ ~ §I 1( ~ ~nn ~ ~ Bltt ~ ~ 1fr. fI{rr. "'" ~ -N. ~fih. .J7' m -m. N. "<T 0.

(17) •. -17 ~.~I. ••• ·~OO·6M. 3t ~ It}\.Z ~#.Ji ltJt. ~ El J}lj. 1?~ .fe. ' #{. -'-11t !il<. #{. AA J}lj t~ nut :f: ~t ~ t-:!<f A. £ (Jlt. nUt i~' A.J'cr-¥-11t); J:i 91' ' ~AA. "ocr J~AE PIT {H~ Q 1f-.tlA. J'a.z.X ~ -&. ~ .t~A. £ (~~h ) ~f11. PIT 1L{ "ocr. 2.. n~;'5~. .z.X~. ;. ~-&.'.~~~~~.z.W#'~~.~Q. 4. t1tm.t~.z.~A;I:/J~s. ~ ~1iJ FAQ'. FAQ. 5. ;f; fL. x;fii..z.~El n~;I:/J f8s. :t ~1iJ A. J'a tHitT if4 ' ffl nUt:f::t ~1iJ. Q. SfL.z.~A.*.'.~~A.z.;f;fL,:t~~. ~.z.@]{;.Q. tt-mr A~ t- Ji. 6.. Ii .,. ' 1tffl ~i±.~~h. Wif.4. o. ~ffiUtl;P;mJ~n. jU4fl):t!'Ji!X~flA*fiJE;L1&. '. fRtJI ;. 1j::lli"'=I"6h{fj"~ a. , 1t~ii]s":J;J::~fonWiFf t);& ~~S":JfrllIAfmi.~[J~;\pfT3jIJ~ : ~~S":JB~r,,9 ' (Query Request) ~~9:¥IJ1t ( Query Response) PJT*!l!!1ls":JB~r,,9 ' (Response Time) ili~*fl.lIJs":J~ , }xfr~~'rj\U[ij~~U~~~~N~;L iffl)( , 1f~teg~* ' @¥IJ f~~9:@JJflS":JB~ra9 ; fffi]t~J1&llB~r,,9~IJ~fO]mHtffl~~ HTML i1i'm]fgii]~):ts":JB~r,,9 ' 1Ja.t'l' ~ Query pfT1H":JB~r,,9 ' ft1Ja.t]t~*a5f!"ft!!)1x HTML s":JB~r,,9 1ZJ1lt ' &JflB~ra91~f!j!~ 0. 0. 0. ~J1&ll~~,~m~~~~~~ffiftR~~Mo. ~]t~~~~'.Ff:~~S":J~~mJE : ~-~~ Cold Result ; fEfF*~iJm Warm Result. ~.ft~.Ff'~~'.A~A~N~'. !f.e~1T. 'ffi~ft~~~, a. ~)1i-. '. :l!:t~li]S":JnWiFf11'f~S":J~X. ,~@~~~m~~-. '. .?I::-tf~±~~~.t tuple ~. , ftf1XlltJl[te~~;ji4~~Jfl~. '. a. - 205. I.

(18) · 18 ~~.~. ••• •• M.~. ~.m~~~~~~~t.a. *-~. t{;j::k-tt. ~lM ~. iliH~~}t*~1!I EI. iJlH'«'4iJ!Atag::k-tt. *t~B~r,,'. Ib 1t m:$ request i. *t{;jJIIJiJf. ~f. * tiJ ag f;;p.... tt. iMt.«.J-*1-,**-+ '. , 1i- .f'14:tf ag response f'fi' ~!R!l ~. ~. iJ!1t'«'~ ;t;f~)'~Jf. Q. 0. ~M~J-*4lf-ag pq ~. 0. U'~~~iOmJiLtJ. :£~iIi'J J(. ~~~Ji$. Wif4lf. f-JJ! ~ Nt.~~tf1i;. ffi t.t Mi. -1'1. 1d~ If tJt:ft. I A.. A. a. a. "" W. <t". 13. 13 013. <t" ". ,,13. ""'. ""'. W. W. *4. #. Sl. Tl. AS}. 01. C1. S2. T2. AS2. 02. C2. ~. ~. # Bl B2. S3 I. I~. I T3. r.*~4MI~*.~~~M.1. - 206. ". a" ". Jf #. M. 0.

(19) ". 1fJf.~ w&l!.!t*1t. 1£lt~ii]I¥'l*IHOII~rf1f~ ~,. , ~im'.t'!~¥AtT Cold. -19 ' t\ 90 - 6l!ll. Result fa Wann Result I¥'l~~. ,~. ,m~.~.~*,m-*~M~~~~~~~~~~ffi~~~;. 2 ' 3 ' 4 ;:J\flIJ~iiJfl~:tfujjil¥Ji1T~~. 0. Cold Result ' ~~j{~4ftij. IJ'j\fm '. *it§~ Cache ; t~rT*a'g=;:J\~lj~ Wann Result ' "6J~;!tqs:l:~~i-t~. 0. &B!lR¥rf'l'Wlt~. ~:Ela~rf'l'~~*J~1f~f~. ; &B!a~rf'l'~iJJ'il~~Ml¥AtTI¥'l Script flil.:A*:M~ ; ffijlt~~:EI a~r~'~IJEEfiiJa~~~MlI¥'lB!fflflil.:A (ASP) *1i~~ , ](zM~*a5fH'@1*f;tJJ.~~1¥'l Scripts' EE Scripts *H~*\1ti~ §t~tH&H!a~rf'l'tJ&lt~~:Ela~rf'l'~t~ , W4ilE~rf'l'I¥'l~Jj!niiJ~)t :jjH~N~i'ilia'ga'ifrf'l'T ~-tJlj~4§.*lt~ii]qs:t~~:EJ!lR¥rf'l' , 5t~ Cold Result Wann 0. 0. Result. 0. !.-1::. 1f.lW1:;;!ll~~~*~1t#. -----. JJ +Ut. QT. Bl. Cold Result. Wann Result 1. Wann Result 2. Wann Result 3. RT. QT. RT. QT. RT. QT. RT. 18. 31. 9. 26. 8. 19. 9. 20. B2. 21. 40. 9. 23. 10. 23. 8. 22. SI. 1. 2. 1. 3. 2. 4. 3. 5. S2. 16. 19. 4. 14. 4. 15. 4. 14. S3. 0. 1. 0. 1. 0. 1. 1. 1. AS}. 3. 4. 1. 2. 1. 1. 1. 1. AS2. 2. 2. I. 2. 1. 1. I. 2. 1. 2. •. ----. 1. 1. }. 01. 1. 1. }. 02. 3. 4. I. 2. 1. 1. 1. 2. Cl. 29. 32. 31. 32. 29. 29. 30. 31. C2. 1. 2. 1. 2. 1. 1. 0. 1. QT is for Query process time; RT is for Response Time.. EE BI fa B2 l:t~ffij i§ , 1J~El31e Bl ~J:Jjff~:gm*1JFrf' ffij B2 ~tJjff~¥il* ; ffijjff~:gffij1iiVjff,;t~jff~j{~4~~a'g.:tI!~ Clustered Index Key ; ~lIt Bl f'y~ .It B2 ffi~Y-l!.l~1:!I~II!W¥T ~9'i- ' RT 7k~*1e~~1e QT ~J!lf5J:a&~8'g , 1El~[J* ~ RT=QT ' 1J~1e*i@J~a'g~W~ 0 ' 1£.:t~J:¥A1T:t~~"6H1~ ~9'i--niID ' ')(:~1!! 0. 0. ~iiJ~A. •• ,j{fi.iiJ~A*-~o - 207. I.

(20) -20 .~t+. •• I#.*.'a.m~*.~~1~. ••. i if. ~. "f!. 1 IJ: . :t:tEE. 1.Ll " lfiC iic. ••M.m~M~g.~. ·-m~~~.~~~·.~OO~~ftff~.m·.. ~.Rm~W~~.fio~.M.m~M~g.m~.~~a~g.·~~~~M~ m~m~ff~~OOg~~h~mo. ••• fi~.~~~.M~ •• '~mw.mo§. M~.~·~~~.MImWm.Im~~nOO~m~·~mA7*.~m~Aho. ~~m~Aft~**~.~tli*fi.W~~.*~~~~*oa~ffim·~W** ~.M11te'9iE:*~~aW<li**6flL. • *~~~W.*4J!f!~JI~Mte{].ffl~~~::t~fiU) •. a~~~Mft·. o~E~M-~~m**~.fiM~·. w.~.m.~.~o.~.*~.~W~~~R.®~· :AE:~1JD~I·t~;f[J$J Ii. MIf'F.fl.it. . 0. *x ~lM5lftg~-JJiJ:J.~[{ijaa~~e'9~E~M.*4J!f!WJI~. ,. 3<:~fl.it. '. "'n+tetloIH~::.-t' - 4l- 0 I" z,..:r~,*,"T1. ••~~~.~·~ft •• ·~~.~M*·.~~m· .~E~M.M.Wg~M~~-•• ~[{ijax~.M.Wg~M~~~ • .it.g~. M.M.~g~M.Em ~. • JtJ:j::l~!1iI1M':j~~~W!lie'9mW'l. • mi:tt~tl~~Jiii'i;f[J~i#l1 • J:J&.mfj[J:\rm®:e'9~~,*WIJ •. J:Jmfi1ll~~. 0. $~3Z1IX [1] . Bakos, J.y', " A Strategic Analysis of Electronic Marketplaces, " MIS Quarterly, Vol. 10, No.3, Sept. 1991, pp. 295-310. Balasubramanian,. v.,. Designing a WWW. Min Ma, B., Joonhee, Y., "A Systematic Approach to. T'lT'Ihrl1tlrln. "Communications ofthe ACM, Vol. 38, No.8, 1995,. pp.47-48. [3] . Baty, lB., II, and Lee, R, " InterShop: Enhancing the Vendor/Customer Dialectic in Electronic Shopping, " Journal ofManagement lriformation Systems, Vol. 11, No.4, Spring 1995, pp. 9-32.. [4] . Beat, F.S., "Requirements for Electronic Markets Architecture, " Electronic Markets, Vol. 7, No.1, 1997, pp. 3-6.. - 208. ". :j.

(21) ". . 21 f-l£~Jfll1.-!¥:~. • 1\ 90·6. jIJJ. Bell, G. and Gemmell, " J. On-ramp Prospects for the Information Superhighway. Dream, " Communications ofthe ACM, Vol. 39, No.7, July 1996, pp. 55-6L. Daniel, M.D.,William, K.,Rajat, M., and Renu, Tewari.,"A Scalable and Highly. Available Web Server, "Proceedings ofCaMPCON, 1996, pp. 85-92.. David 5., "Building Your Online Storefront," lrifoWorld, Vol.20, No.5, Feb. 2, 1998,. pp.45,47.. [8] . David 5.5., "Wake Up to Web Brands," Marketing, Oct 16, 1997, pp.28-29.. [9] . Dorian,S., Petra,S., " Web Assessment. A Model for the Evaluation and the. Assessment of sucessful Electronic Commerce Applications, " Electronic Markets, Vol. 7, No.3, 1997, pp. 46-48. [10] Gray, J., The Benchmark Handbook for Database and Transaction Processing. Systems, Morgan Kaufmann, Inc., 1993. [11] Jim, C., "Commerce Demands Cooperation," lrifoWorld, Vol. 19, No.1, Jan 6, 1997, pp.45-46. [12] Jim, J., "Taming the Wild Transaction," Business Communications Review, Vol. 26, No.4, Apr 1996, pp. 95-98.. s. [13] Laura. L., "Putting Technology to Work," Advertising Age Business Marketing, Vol. 82, No.2, Oct 1997, pp. 17, 22. Marc, F., "Electronic Commerce: Tie.s that Bind," lrifoWorld, Vol. 19, No. 14, Apr 7, 1997, pp. 59-62. Marfa, M.L., Krishnakumar, R.N., and Gopal, K.R., " A Domain Analysis of Web Browser Architectures, Languages and Features, " Proceedings of SouthCon, 1997, pp. 168-174. [16] Mark 5.; Orryn 5., Microsoft SQL Server 6.5 DBA Survival Guide, 1996. [17] Mark,S., World Wide Web Database Developer's Guide, Sams.net, 1996. [18] . Markus, L., Alexander, R., " Permanenet IT-support in Electronic Commerce Transactions, " Electronic Markets, Vol. 7, No.1, 1997.. [19] Mary, B., "Uncommon Commerce," Computerworld, Apr 29,1996, pp. 18-19. l20] Michael M., " Electronic Service Markets, " Electronic Markets, Vol. 7, No.1, 1997, pp.6-11.. - 209. I.

(22) ·n ~~.~. [21]. ••• #.*ml~.m~.~~~L~ •• ~. Mitch, W, "Firms: Open the Store, Lock the Safe," Computerworld, Vo1.31, No.16, Apr 21, 1997, pp. 59-60.. [22]. Morris, E., "The Electronic Commerce Juggernaut," Communications News, Vol. 34, No.9, Sep 1997, pp.86-87.. [23]. Nabil R. A., and Yelena Y., Electronic Commerce:Current Research Issues and. Applications, Springer ,1995. [24]. Nora, K., " State of the Art and Classification of Electronic Produce Catalogues on CD-ROM, " Electronic Markets, Vol. 7, No.3, 1997, pp. 16-21.. [25]. Paul, H., and Brian, H., "Internet: the Marketing Challenge of the Twentieth Century,". Internet Research, Vol. 7, No.2, 1997, pp. 95-100. [26]. RalfKramer, "Databases on the Web: Technologies for Federation Architectures and Case Studies, " Proceedings ofSfGMOD, 1997.. [27]. Ravi, K., Andrew, B.W, Electronic Commerce-A Manager 50 Guide, 1997.. [28]. Richard,. v., Balaji, K., Rado, G., "Internet Can Be Useful As a Marketing Medium,". Wood Technology, Vol. 123, No.3, May 1996, pp. 27-29. [29]. Rosemary, C., "Busting Loose," Computerworld, Vol. 30, No. 16, Apr 15, 1996, pp. 92-96.. [30]. Steven P.K., Hector G., "Making Trust Explicit in Distributed Commerce Transactions," In Proceedings of IEEE Twentieth Annual International Computer. Software & Applications Conference, 1996, pp.270-281. [31]. Terry, T., "Credit Information-Superhighway to the Future," Credit World, Vol. 84, No.3, JanlFeb 1996, pp. 18-21.. [32]. Tiziana C., "Interacting with Databases in the Global Information Infrastructure",. IEEE Communications, May 1997, pp.72-76. [33]. Tom, Q., "OAG to Define 12 More Specs for Commerce," InfoWorld, Vol. 18, No. 16, Apr 15, 1996, p.3.. [34]. TPC-A Standard Specification, 1990.. [35]. TPC-B Standard Specification, 1990.. [36]. TPC-C Standard Specification, 1992.. [37]. TPC-D Standard Specification, 1995.. - 210. 4.

(23) ". -23. 9.AI ••• ·~OO·6M TPC-H Standard Specification, 1998. TPC-R Standard Specification, 1998. TPC-W Standard Specification, 1999.. I - 211 .

(24)