Ӧ
COMPUTER APPLICATIONS
1999 19 9 Vol.19 No.9 1999



ݲֿʵʩ
⡡ס
ժҪĽݼԼԪݵĸȽҵݲֲֿԣµһΪ͵ݲֿϵͳṹ
ؼʡݲֿ⣬ݼУԪ
THE IMPLEMENTATION STRATEGIES OF DATA WAREHOUSE
Yang GuangZhang LeiAi Bo
Beijing University of Posts and Telecommunications, Beijing 100876
AbstractThis paper first introduces the concepts, Data Mart and Metadata, then analyzes and compares six implementation strategies of Data Warehouse. At the end of the paper a typical architecture of Data Warehouse is presented.
KeywordsData warehouse, Data mart, Metadata
Ϊ˽ҵձڵġݼ͡ƶΪҵ߷Ա㡢Ѹٵṩ׼ȷʵϢѳΪҵǰҪ⡣ˣݲֿ⼼Ӧ˶
1ݼ
ݲֿǽҵġݼ͡ƶĺ÷гоMETA Groupо棬ȫ2000ҵе90%пҵݲֿļƻڿĹǷһЩ⡣Ϊ˽ڽݲֿٵ⣬ݼеĸ
ݼ֧ĳһŻضҵDSSӦõݼϡݼеԾݲֿݵص㡣ֻݼеרΪĳһŻĳضҵƵġݼеĽṹݲֿơһΪݼеݲֿ⡣
ݼŵ㣺
ݼеĽڶֻ̣輸£ͶСЧ죻
ûȫӵԼݼпԸҪеݣ
ûɵѡʺԼݼеľ߷ߣ
ݼеʹÿԽŶݲֿԴľߴٶȡ
2ԪݣMetadata
ݲֿд洢żG BݡЩԲͬݿϵͳھȡ(extraction)(clean)ۼ(aggregation)ת(transformation)Ȳ󱻴ݲֿ⡣Ϊҵûܸõʹݲֿ⣬Ԫݵĸݲֿ⼼С
ԪǹݵݣݵݡݲֿеԪӦһЩݣ
ԭʼݵӵߵϢ
ԭʼݵԴϢԴϵͳƽ̨ԴַϢ
ݵҵ͵÷
ȡƼ汾
ȡ֮ϵ
ݴӸOLTPݿݲֿƵʣ
ݲֿڡʱ䣻
ݲֿݵļ¼
ݲֿݵʣ
ת㷨
ݵıܼ
ݵĸʽ
ڼݵҵ
ݴOLTPԴݲֿӳϢԴıʶԵ֮ӳ䣬ԵתƵתؼֵתӶԴѡݵ㷨߼ȣ
ݻܵ㷨㷨Ľͣ
ݲֿģͼ
Ԫݾ͵ӵݲֿһͼԪþʵеĵͼָûڶＸGBݲֿݺҵԼҪݣûõݲֿеݡԪݿ԰ݲֿԱõعֿеݣݲֿԱԪ׷ٷǷݴԴɽ顣ûԪҵʵЩʵɰû֧ǵľߡ֤ͨߵóĽ۵ǷȷԼҳǵĽŵĽ۵Ĳͬԭ̵ͬݲֿ⼰߶ѭͳһԪݽ׼̵ͬݲֿ֮ͨԪݷعͽ(֯ƳMetadataı׼һ Microsoft Corp. OIMOpen Information Model, һMeta Data Coalition  MDISMetadata Interchange Standard)
ԪݲֿеҪãݲ̷ֿ׷װԪݵɺ͹ܼɵƷУγԪݵĹͼ1

ͼ1Ԫݹ
3ݲֿʵֲ
ݲֿ⼼ķչݲֿʵֲѴԭȵġԶ¡ģʽThe Top Down Modelչģʽ
3.1Զ¡ģʽ
Զ¡Ŀ(ͼ2)ָԭɢ洢ҵOLTPݿеͨȡextraction(clean)תtransformationۼaggregationȴ轨һȫݲֿ⡣ȫֵݲֿ⽫ṩûһһµݸʽһµ˵֧ݶӦðȫݿСݼд洢ΪĳŵDSSӦöרŴȫݲֿȡģȫݲֿݵһӼڡԶ¡ģʽУݼкݲֿĹϵǵģݴݲֿݼС

ͼ2Զ¡ģʽ
3.2Եϡģʽ
Եϡģʽͼ3ǴӽŻضҵݼпʼȫݲֿǽЩݼеĻϡԵϡģʽصǳͶ٣Ч졣ΪڽݼʱֻҪٵߣǽСҵ⡣ԵϡĿģʽʹһλݲֿⷢչھٵĻʽҲЧͶ֮ǰ

ͼ3Եϡģʽ
3.3ƽпģʽ
ƽпģʽ(ͼ4)ָһȫݲֿģ͵ָݼеĽȫݲֿĽͬʱСڡƽпģʽݼеĽһͳһȫģ͵ָ½еģɱڿԵݼʱäĿԣٸݼ֮Ͳһ¡ʵϣһЩڽݼеĹ⼰õľ齫ȫݲֿģӦĸı䣬Щ仯ʹڽݼʱ棬ҲȫݲֿĽ衣ڡƽпģʽݼеԶȫݿĽ衣һȫݲֿ⽨ú󣬸ŵݼнΪȫݲֿһӼȫݲֿ⽫ΪѽɺͼҪݼṩݡ

ͼ4ƽпģʽ
ƽп롰Զ¡ģʽҵеĸϣڽ϶ʱڽŵľ֧ϵͳҪʹǲõȴȫݲֿ⽨֮ŽԼݼСͬʱıڡԶ¡ģʽУݼȫݲֿϵеĸԵλڽݼйõľ齫ڶȫݲֿģ͵ŻȫݲֿĽ衣
ƽп롰ԵϡģʽڣһͳһȫݲֿģָݼеĽ裬Խݼ֮ݵĲһºͼݼ֮⡣
Զ¡ԵϡƽпģʽûпνûķϢϵطӦݼкݲֿĽСģʽֻڽݼлݲֿĹпû󡣵ûǾֹĶ¼Ӧõĳֶϱ仯ġû仯ҪٵӲõھܸߵݿѺõͼû滹Ϣݵı仯Լݵı仯⽫ݲֿݼбĳЩµԡµıѴڵıԡµ󽫶ݲֿݼеģͲӰ졣
Ϊ˽û仯⣬ģʽ
3.4зԶ¡ģʽ
зԶ¡ģʽͼ5ģʽûķΪ׶Ρһ׶û󲻶ϵرŵݼУݼиû仯ڶ׶βݼа仯ȫݲֿ⣬ȫݲֿӦı仯

ͼ5зԶ¡ģʽ
3.5зԵϡģʽ
ڡзԵϡģʽͼ6ڲȡȽ貿ݼУԸŵݼΪȫݲֿķʽˣݼܽϺõûȫݿ⽨֮ı仯Ҫݼݲֿ֮䡣ݼڷչʱעⱣ໥֮һԲܸûķϢϵԼôģʽݲֿͶʹúܼû仯Ĳ㡣

ͼ6зԵϡģʽ
3.6зƽпģʽ
ڡзƽпģʽͼ7Уڿĳʼ׶ΣԱҪȫݲֿģ͵ָ½ݼУڽ⼰ԼûϢȫݲֿģ͡ȫģָݼнͬʱҲռԱͲûķϢЩϢԼʹһ׶ȫݲֿĽ˳ؽС ͨǻΪ֡ƽпģʽУȫݲֿģӦڿʼ貿ݼ֮ǰɣҪԱĿĳʼ׶ξѸٵؿȫݲֿģͣݼеĿҲòȴȫݲֿģɺſʼ

ͼ7зƽпģʽ
ʵϣڡƽģʽĿвһҪڿݼ֮ǰݲֿģ͵Ŀԡƽпģʽ˵ȫݲֿģ͵ĿڽһݼеͬʱСΪһԼݼ֮ݵĲһ˵ҪһȫõȫģͣȫģָݼнͬʱҪȡԱûķϢԼһ沿ݼڿʹùõľڿԱȫģʱõ˽û
4ݲֿϵͳĽṹ
ҵݲֿĿҵľӪܹʹݲֿһɵľֻ֧ԻȡмֵϢӪ߶Բϱ仯ĻѸݡ׼ȷжϺҳӦĶԲߡˣѺãǿΪûǰ˹ӦЧؼɵһµݷС
ݲֿϵͳݲֿΪģͨȡߡתߡѯߡߡߡݷ򹤾ߵȣûϢĸͼ8һΪ͵ݿϵͳṹͼ

ͼ8ݲֿϵͳṹͼ
5
ļҪݼСԪݵĸҵݲֿʵʩԺݲֿϵͳĽṹжݲֿ⡢ݲֿĽṹпԵóһۣݲֿⲻǶԭеӦõĲݿݲֿͲݿҵϢгеͬ񣬷ӲͬãݲֿҪӦھ߷ԭеĲݿҪճݿ⼰ݲֿϢϵͳ;֧ϵͳĻʩûƵݿݲֿ⣬ٺõķҲӲá
߼飺⡡˶ʿо
סڣְʿо
ڣʿʦ
ߵλʵѧѧԺ100876
ο
1ݡData Warehouses and Data Marts: A Dynamic View, Author: Joseph M. Firestone, Ph. D., Executive Information System Inc. White Paper 3, March 27, 1997;(3)
2ݡBuilding the Data Mart, Author: Marc Demarest, DBMS Magazine, 1999;7(8):44
3ݡA Metadata Management How-To, Author: Terry Moriarty, Database Programming & DesignFeburary 1997: 57-60 
ո:1999-05-07(޸ĸ)
