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



ݲֿģ͵
񷼡
ժҪȾݲֿ봫ͳϵݿһ򵥱ȽϣȻһʺݲֿƵķ
ؼʡݲֿ⣬ģͣݿ
DESIGNING THE DATA WAREHOUSE
Zhang YufangXiong Zhongyang
College of Computer Science and Engineering , Chongqing University, Chongqing 400044
AbstractThis paper first compares data warehouse with traditional relation database,then introduces a method for designing data warehouse.
KeywordsData warehouse, Data model, Database design
1ͳݿݲֿıȽ
ͳĹϵݿRDBѭһµĹϵģͣеݣ¼Աķʽ洢ͳһSQLԽݷʣӦóΪOLTPOn-Line Transaction Processص˲ʱûӦϵݿܹݿ⣬ܽ򵥵ضѻֱΪݲֿʹá
ݿҪǶάݣҲΪάݿ⡣άݿ෴зʽ洢ûͳһĹɿѭҲûͳһĶάģͿѭûͳһĴȡԻԽӿڣAPIãάݿֻܰйࡣӦ˵άݿӦþ߱ǿĲѯϵݿȣάݿд洢Ϣ㣬ɵһOLAPOn-Line Analysis Process˲׷˲Ӧʱ䣬޵ʱӦϿɡʵϣOLAPʽݲѯŶַ꣨drill-downʽɹ뵽ײϸϢϡݲֿеϢǶάģȻ󻯵ıʾ
1˴ͳݿ洢ݲֿ洢֮
1ݲֿݿݵıȽ

Ƚ ݲֿ
ʱڶ̣仯ڴڣԾ̬
ȡ¼ĴȡԾۼʽļϴȡ˱RDBѺ
ȡʽȡģʽڵرʽضѯ
޸ķʽʵʱ޸Եش޸װ
ʽ¼̲֧
дֻ
ģGBɴ100GB+

ݲֿ봫ͳݿ֮˴Ĳ죬ݲֿⲢȫ¯еĴͳݣнϢļɣӶ㲻ͬݲֿ⡣ݴӶ̬ġǰ¼Ĵͳ̬ġʷݵݲֿ⡣˵ӲвԵ뵽ڵݿת䣬ܵʵʴ洢ͼƣʵǲܵģӲзȡݽݲֿ⡣
ϸأΪ֤OLTPܣ뽫ݲֿ봫ͳ룬Ϊ˻ݲֿеݣȱݲֿơ
2ݲֿ
ĽܵԶµƷʵݲֿĶǣͻƷԵȶάնûͨάȡҵݣʱؼάȡݲֿƷͬͳݿһ˸ģơ߼ģƺģ׶Σݲֿ⣬ֱӦݲֿеϢͼơͼģƺģơ2ݲֿݿ⿪нģ͸׶βõƷ
2ݲֿݿ׶εƷ

ƽ׶ݲֿݿ
ģϢͼͼ
߼ģͼģʵͼ
ģģģ

ֱݲֿģƽ׶βõĸּ
2.1ģơϢͼ
ģҲͨ˵ûĹУȷݲֿҪʵϢЩϢǰԼʷصݡ׶ȷݡԴԼһЩݣģͣЧɲѯ֮ӳ䡣
ݲֿĶάԣôͳͼѲҪ壨hypercubeóάıʾһȻ߱άԣȫݲֿĶάԡ϶·һĲΪ
ȷģҪץסҵ̣ۻ۹̣
ȷҪֵɱЩϢͨһЩֵ
ȷݵȣ༴ҪһϸϢ
ڳڱȱֱԣ䵱άȳάݵĲɼͱʾȽѣǿԲһֳΪϢͼķƽչ壬öάӳάϢͼṩһάռ佨ûϢģ͵ķṩ˳Ŀӻʾ
ϢͼӵҪָꡢάȺָάȿռϢһַһάΪṩϸģеĳԱΪ˱ضݶ衣ϢͼûϢҪݺҪָ֮ܲĹϵĿûҪϢͼƸģҪȷݣ
. ȷָꡣָǷݲֿĹؼڣûĵϢɹϢԱ֤ûϢлȡҪĸָ
. ȷάȡάṩûݲֿϢ;Ӧÿһ棬λϢͼĵһеÿһĿС
. ȷʾһάȰϸϢһάײĿõķֳΪϸ
ԿһƽԪصĶάԣеÿһάƽĳбʾͨάǣʱ䡢ص㡢Ʒ͹˿ͣϸеĶʱάȵϸꡢ¡գСʱƽеһԪأӦеһԪ񣩿Աʾĳĳ·ݣĳ̵ĳƷ۶ϢͼʱҪȷ߲ͲϢԱƳҪݲֿ⡣
ڸӵҵҪʱʱһϢͼܷӳҪƲͬϢͼȫ󣬴ʱӦñ֤ϢͼгֵάϢϢȫһ¡
2.2߼ģơͼ
ڴͳݿ߼ģУ׶λõͼʵģתΪʵERͼǰݲֿ׶λõϢͼͬʱݲֿҪṩǲѯִвѯ߼ģƹͼ˿ͼݲֿ߼ģ͡
ͼǶ֧ߵĹ۵㶨ʵ壬ݲֿƵҪϢͼΪͼṩ걸ĸͬϢͼеӦͼӵ߼ʵ壺άȡָ
λͼĵʵָʵ壬ӦϢͼеָûĵĻʵͲѯģΪûṩݡÿָʵһϵʵһָĹܣһ´һʵۺˮƽÿάȵһӦλͼǽϵʵάʵ壬ӦϢͼеάȶûĲѯݹʹôָʵѯؽٵУӶСʷΧһʵϸʵ壬ӦϢͼеһάڵÿԪһ𣬴άڵһΣҪϸϢûҪӦݿṹӳ䡣
Ӹģ͡Ϣͼת߼ģ͡ͼҪȷʵ:
. ָʵ塣ʹÿһָ꣬ͬʱȷǷ洢ָꡣ
. άʵ塣һάʵӦָʵеĶָꡣûάʵָʵ壬ʵʶӦ߼ʵ壬һάʵӦϢͼеһС
. ϸʵ塣Ӧʵĳһʵ塣
ͼУûͨάʵָʵݣָʵάʵϵͨÿάеһϸʵӡ
ϢͼתͼʱܳάʵĽصΪ˱֤ʵһҪͳһȷͬһʵڲͬϵݷӳͬʵ塣άʵزҴڹʱҪϲΪһָʵ塣
2.3ݿģơͼתΪģ
߼ģ͡ͼתģƣȫѭͳݿƷһ˵ͼеָʵϸʵͨתΪһݿάʵΪѯο˺;ۺʹãֱͨתΪݿģƽ׶ΣҪȷ:
ݱ׼淶ݲֿеĸ;
ʵʵʵеһ;
ģȷ͸Ƶʡ
ģƽ׶ΣԶ幤磺SdesignerPowerDesignerݹøý׶ĵϡ
3С
Ϣͻͽطչδ洢άʹϢԽԽҪݲֿĽԵԽԽҪĽһݲֿƷݲֿĲͬƽ׶ΣΧݲֿ⣬봫ͳݿƽ׶Ӧ˸׶εľƷ
߼飺񷼡ʦְʿоҪ¼ݿӦüоͽѧ
оԱҪϢϵͳͲмȷо
ߵλѧѧ빤ѧԺ죨400044
ο
1ݡTom Hammergren. ݲֿ⼼.йˮˮ磬1998,2 
ո:1999-03-12(޸ĸ)
