ݲֿĸ

    ݲֿĸѧWHlnmonʿ90ڡݲֿ⡷һݲֿ(data warehouse)һġɵġȶġʷݵݼϣ֧־Ӫеľƶ̡

    ָûʹݲֿоʱĵص㷽棻ָݲֿڵϢǰ֯ģΪоߵĹṩϢָݲֿеϢǴӸҵϵͳм򵥳ȡģǾϵͳӹ֤ܺݲֿڵϢǹҵһµȫϢȶָһĳݽݲֿԺһ½ڱҲݲֿһдĲͲѯ޸ĺɾ٣ʷָݲֿڵϢֻǹҵʱĳһʱϢϵͳ¼ҵӹȥĳһʱ㵽Ŀǰĸ׶εϢͨЩϢԶҵķչ̺δԤ⡣ϢɣʱṩӦĹԱݲֿĸ

    ݲֿҪãȣݲֿṩ˱׼ıͼܣеԴڲͬĶϵͳˣݲֿıͼǹҵϢıͼΣݲֶֿ֧άάͨһʵĶҪԶΪάȣʹûܷػݼݵķ߼ܶԲͬάֵݽбȽϣάʾ˶ϢĲͬǶȡӦöάһѯжԲͬ׶εݽȽϣھ߹зǳãݲֿھĹؼھҪʶݵģʽ԰ûеϢϢĻϣδ״Ԥ⡣ݲֿĻϽھ򣬾Ϳҵ״δչ׼ȷķԤ⡣

ݲֿĽṹ

     1.ݲֿ߼ṹṹ 
    ݲֿǴ洢ݵһ֯ʽӴͳݿлԭʼݣȰߵҪγɵǰݲ㣬ٰۺϾߵҪγۺݲ㡣ʱƣʱƻƽǰݲתΪʷݲ㡣ɼݲֿ߼ṹ3㵽4ɣǾԪݣMeta data֯ɡݲֿݵ洢ʽжάݿ֯ʽͻڹϵݿ֯ʽ

     2.ݲֿϵͳݲֿϵͳ(DWS)ݲֿ⡢ֿͷɣṹʽͼԴݣݲֿԴڶԴҵڲݡг鱨漰ĵ֮ⲿݡ 


           ֿȷݲֿϢȽݽģȻȷԴݵݲֿݳȡת̣󻮷άȷݲֿ洢ṹԪݲֿĺģڴ洢ģͺͶݽṹת滮ֿṹϢȡֿݵİȫ鵵ݡάָȹЩҪݿϵͳ(DBMS)Ĺܡ

              ߣʵʾĸֲѯߡάݵOLAPߡݿDMߵȣʵ־֧ϵͳĸҪ

     3ݲֿӦõC/Sṹʽ 
    ݲֿӦһ͵C/Sṹͻ˵ĹͻʽѯͱɵȡɸָߵSQLѯӵļ͸ۺϹܵȡڣһԽԽձʽṹڿͻ֮һάݷOLAPܼǿ͹淶ֵ֧ķкͼԭͻ˺DWĲֹϵͳݴ˹Чʸߡ

ݲֿĿ

    ݲֿϵͳһֽḶ́һ򵽵ֳɲƷͬҵвͬݲֿ⡣ҵԱνݲֿ⣬ֵ֧ãݲֿ⹫˾Աֲҵ񣬲֪Щ⣬ԴгȡЩݡҪ˫๵ͨͬЭ̿ݲֿ⣬һǰĹ̡̰¼(1)̡ݲֿ⹤̵Ŀ꼰ƶ̼ƻ(2)ѡʵݲֿӲԴ(3)ȷݽģݾȷ⣬ѡԴݲֿ֯߼ṹơ(4)ݲֿеݿ⡣(5)תʵִԴϵͳгȡݡݡһԸʽݡۺݡװݵȹ̵ƺͱ롣(6)ԪݡԪݡ(7)ûߵݷߡ(8)ݲֿ⻷

ݲֿĽ

    ݲֿг޴ݲֿƷܶ࣬бȽдԵĲƷУBusiness ObjectsSybasePlatinum TechnologyȵĽ

      1.Business ObjectsǼѯOLAPΪһܾ֧ϵͳʹöصġ㡱̬͡΢ʾݿеĶάݣнϺõĲѯͱܣṩȡ(Drill)ȶάֶ֧ƽ̨Ͷݿ⣬ͬʱ֧Internet/Intranetͨwwwвѯͷߡ 
      2.Sybase ݲֿ?/FONT>Quickstart DataMartSybase IQCaleton PASSPORBrio QueryConos Powerplayһϵ֧DB2MSVSAMSybaseOracleInformixȹϵݿ⣬ıʽݡܹͬʱʮϯѯBit Wiseʹֱݴ洢ʹϵͳֻضݣʹòѯٶȱȴͳĹϵݿϵͳ100 
      3.Platinum technology˾ݲֿΪҵṩһµݣԱҵߵļʱȷԡPlatinum technologyݲֿݳȡݷֲԪݹݴȡͷ(OLAPEIS)աۺӪֵ֧ȼ档ṩݲֿ⹤߰칹ݿ֮˫ƵӦϵͳInforump͹ǿĹϵOLAPInfoBeaconȣṩݲֿǰҵܽ߰ʹûܹٽʹõͼλҵϢϵͳӦõĻWindowsĲѯͱForest & TressöݿɱҵĹInfoReportsʹûڷûҵĹInfoReports ServerЩʹû̼ɲѯϵݿ⡢ݲֿļݣкǿʵԡ
