ݲֿ⡪ƪ
2001-01-23 19:22:42 ̴ÿܵԱ 

--------------------------------------------------------------------------------



Ϊֹݲֿʵû߹˽ʮ̣ڳɹ֮ƪģﵽTӦ鼰ͨšҵԼҵݲֿĹģԽԽ󣬱㷺Ӧڸ߾ȵݷСݲֿ֧żҲµĽչ 

ҵط 

ҵǴӲѯ߽ѯΪҪĿĶݿʹߣOLAPܡھΪ书ܡṩһݿֶεǰ˹漰֧ûľ֧֡ṩַ̽չսԹչ 

չĹҪ¼㣺 

 OLAPں OLAP봫ͳıܼܹӶݲֿļʵOLAPͱڸ׶ξߺͱ任ݡ 

 ʶOLAP ȥеķ߶Ǹ֧ضOLAPݿ⣬ڳֶ̨֧OLAPݿĿѡߡԼ̳йȥOLAPʲҿ¼֧ŵOLAPɡ 

 ԴļɣExcel ݺıļ ˷ʴͳRDBMS⣬ԴûеExcel ݺıļȡݡͬһϣƳɴݲֿõʵݺExcelԤݵȣݵʡ 

 ھܵļ ӴĿ˿ΪƵԤ˿͵Ĺ۶νھ򡣽ռھܼڱϣݹعϵṩδΪϢЧӦھߡ 

 ṩҵϢŻ ֪ʶʵṩߣ߱ۺṩÿûҪݺϢĹܡ߱ҵϢŻܣڱУһṩݲֿĽṹݡǽṹHTMLĵԼⲿϢȡ 

ûȺݲֿʹõĹߣݻΪȫҵϢӦûˣҪͳһΪûͨWebݲֿͷǿУߺͷʹӦWebḶ̌˳ĿǰеĹ߶ӦWeb 


ETL 

ݲֿ⹹УͳҵճǴҵݿݲֿȡ任ݵҵԭΪ˴ӸֲͬʽҵӦóȡ任ݣ洢ݲֿ⣬ҪҪݵά͹ 

ETL߾ݵĳȡ֮󣬽ݵġνݵġǶԴӶͬҵݿȡݣƵͳһλͳһͳһʽͳһظݡETLߵĹԽԽ߼֧ݵġܡݼӹܺԶйܣ̵ļءȺⲿҵȣֶ֧ԴԶʵݳȡ 

ĹʽĽչݲֿҵӦãԸŵϢӦǹġĵǰŴݲֿгȡмӹĹߣṩݲֿԶݵĳ任ܣETLܣԴЧʡ 

Ӧģݲֿ 

TݲֿҪƽ̨ݿϵͳͱݽڳʵ 

Tģݲֿе֧ƽ̨ô͵UNIXгݲֿϵṹУSMPMPPNUMAcc NUMA߿ԼȺSMPֽṹɹѡ 

SMPSymmetrical Multi Processing SMPԳƶദڵһϵͳöCPU1-64OSӦúݿCPUʵֲдھRDBMSƷһSQLļٽϸֺCPU߲дSMPϵͳŵǳģ򵥣Լ򵥵ͨCPU׷ܡ 

MPPMassive Parallel Processing MPPģдǾжCPUOSI/OʵִĲлȥлǲõϵṹͨ߿ԣǣڲдĸCPUƵͨźпܻƿģҲҸӡˣҪöOSݿϵͳ 

NUMAccNUMA NUMANon-Uniform Memory AccessǾȴ洢ʣǶSMPĳģάֹʵCPU߿ԵϵͳϵͳĻĳʽɴڴɵĴԪĳԪͿԼڴһԪڴ档νccNUMANUMAииٻԱ֤Ԫڴʵһԣ߷ٶȡȥڴͿѧжǲֽṹݲֿҲ㷺ĲֽṹŵǶִеĳκαͿڵһOSóٸCPUвд˶ʹеRDBMSҲԴĴҪƵSMPľޣҪģTʮTݲֿļУԤƽҪccNUMAϵͳĳϻӡ 

߿ԼȺ Ϊͨл߿ԣϵͳɼȺһ2-8ϵͳڵ(SMP)ɡͨͨEthernetFDDI/CDDIȵ١ӳٵлҪOLTPݲֿеĿԡݲֿԽԽΪҵвȱٵļݲֿҲҪڹؼӦãԶݲֿĿԵҪԽԽߡ 



SMPϵͳ SMPֳΪϡϵͳ򡰼ȺϵͳΪ˳ַSMPسSMPľ޶ϵͳSMPϵͳϵͳøٹͨϵͳڵ㣬ڵͨSMPϵͳȫͬOSĿǰInformix OnLine-XPSOracle OPSSybase Adaptive Server MPPȵҪݿĲдѡѾʵSMPϵͳеĳдڵSMPͿԱ֤ɼǧCPUʵֵĳдInformixOracleSybaseȴͳݿмԡ 

ݲֿķչһҪģҪйؼӦáԣϵṹҪĳ̶ڿҪø߿ԵSMPһռSMP⣬ݲֿNUMAccNUMAȼͶгɴݲֿκЩںϣԺҲΪעĽ㡣 

ݿϵͳ 

ڴģݲֿļУҪòдûѯݿϵͳͨڿϵͳгɫʵRDBMSĳлȥרûʵֵĲдSMPͲSMPUNIXWindows NTҲʵˡ 

νлָöCPUԼI/OԴһѯSMPccNUMAȺMPPϵṹʵܷԾÿѯУݱĴСCPUĸʵļȣԶ̬ľжȡ 

ڴͳRDBMSҲװּݲֿٶȵĹܣҲΪݲֿרõRDBMSҪУ 

᷽ ṩλͼɢȡ 

ܱʾ 

 ضıз޶ֻԼķмųЧļܡ 

ӦɶάOLAPMOLAP͹ϵOLAPROLAPзԺҪгϳ۵ĿѡƷʵ⣬̨˼MOLAPROLAPֹܵĻͲƷ 

