Ϣ
Information and Control
1999ꡡ284ڡVol.28No.41999



ݲֿEISCIMSеоʵ
ΡꡡΰѦɡ

ժҪ ϢϵͳҵӦõĲϷչԽԽҵ߲쵼ѲMISMRP IIлȡϢĽҵʵӦõJS-CIMS쵼ϢϵͳȽCIMS ҵ쵼ϢϵͳȻEISĸEISCSFsͨݲֿģ ͻϣJS-CIMSEISݲֿģͼ̣
ؼʣϵͳ쵼Ϣϵͳ֧ϵͳݲֿ 
ͼţTP14ױʶ룺B
SYSTEM RESEARCH & IMPLEMENTATION OF EIS BASED ON DATA
WAREHOUSE IN CIMS
SONG Hong JIN Xinwei XUE Jinsong ZHANG Xiaoyu
(Shenyang Institute of Automation Chinese Academy of Sciences11 0015)
Abstract According to JS-CIMS executive information system(EIS) used in jiangsu steel wi re rope bloc, this paper gives the information requirement needed by enterprise director in CIMS, the concept of EIS and it's critical success factors. Based o n general model of Data Warehouse, this paper gives the model and implementat pr ocess of EIS in JS-CIMS.
Key wordsCIMS, Executive Information System(EIS), DSS, data wa rehouse

1
CIMSӦùʵʩĲ룬MISMRPCAD/CAPPϵͳĽӦõĲϷչҵϵͳеϢͺͱըͬʱȱҵ߲쵼Ϣ֧֣ԭ£
1CIMSݽ׿ƽṹκҵԷΪ߲㡢ִвΣMISMRPȸӦϵͳεҹϸҵִв㣬о ҵۺϷϢMRPϵͳṩϢҪΪƷӹɹ/ⵥҵϸĿͲƷɱϢȣΪҵҺ;ҵԱã쵼ҵʽ״Ʒгơʲծ/ϢҪ
DSSϵͳȻܽиߣһҵеĳ⣨籨DSSƷDSSͳɱDSSȣҵӪ̣ϵͳ仯ʱDSSȱ㹻ԣDSSоص㣬༯ģͣʹҵ쵼лýϴİ
2CIMSиӦϵͳļʵֻΪӣɲ˵ɲһϵܵõӦϢֲʽȱӦüܵҵ쵼ȻԽܵģ
3CIMSӦϵͳһڷֲʽݿϣģȱܡʷݣӸӦվݿгȡ쵼ҵ״ݡʷݣ쵼ǰҪѺܳʱ䣬ֱܶȡʹҵ쵼ܣ
2CIMSеEIS
2.1 EIS
쵼ϢϵͳEISǹ쵼ʹõļϵͳΪ쵼߾ʱṩ㹻ϢٷӳҵܵԪ쵼߹빤ЧʣʹҵӮþƣEISڽ϶̵ʱڣԸٹؼɹأCSFsռϢȷͻᣬȥͽ⣮ΪEISܷΪ߲쵼ṩ ؼɹйصⲿϢļϵͳ[1]
ҪɹʵEISȷؼɹأCritical Success Factors-CSFsνCSFs ߲쵼߹ĵЩϵͳĿֱϵϢ
һҵҵУCSFsЩȷҵأڲͬ͵ҵУؼɹҲмͬʹͬһ͵ҵУڲͬʱڣCSFSҲĲͬؼɹҵǰҵĴҪĸܵĹؼйأ߹յΪϵͳĺ׼
2.2 CIMSEISĹؼɹأCSFs
֪CIMSҵӪọ̈̄صҵTڣQCɱS񣩵ȷ⣬ҵгͬͲϵͳһEISCIMSһɲ֣CIMSµEISҵԴCIMSӦϵͳ俪лΪCIMS/ݿ⻷
CIMSµEISΪ쵼ṩϢǴϵ£ɴֵϸ̣ MISMRPӦϵͳ֮ϣؼɹΪۡ桢 Աȷ棬Ȼϸҵͬв죬Ҫ1ʾ.
1 CIMSEISؼɹ

ҵؼɹأCSFsҵؼɹأCSFs
.ƷƷ۶ɱ.ʲծʵȼָ
.ʽʣǷ.ʽȼָ
.Ʒʡ.ӦտӦ
.ͻֲ
.۲šҵԱҵ
.Ʒ
.¡ܼƻ״ʿ.()ƷԭϿ
Ʒֹ
.ƷƷʡ
.Эʡ.ʽռ
.мƷ./ʽ״
.ʽռ
Ӧ.ʲɹ״.Ʒϸ
.Ӧ̵ʡ.ɲ
.ʡ.Ʒ
.Ӧ̽
.ӦѸǷ״


3CIMS/EISеݲֿ
3.1 ݲֿϵṹ
W.H.Inmon1992ݲֿĸݲֹֿ֧߹̵ģģʱĳ־õݼϣݲֿĳ֣ʹΪֽ֧EISǿݻ಻ͬӦϵͳݿ⣬ӷչʷĽǶ֯ʹݣʹEISʵֳΪʵ
ݲֿϵṹͼ1˹̹Stanfordѧģ

ͼ1Stanfordݲֿϵṹ

ײǶϢԴͨݿϵͳʷݣⲿݵȣָѱصϢݲֿʹõģͣලԱָԱϢԴȡݼ仯Զ̽⣬Ǳ輯ϢװݲֿУ
3.2 JS-CIMS EISеݲֿ
StanfordģͣϽո쵼Ϣʵģͼ2ʾ. 

ͼ2JS-CIMS쵼Ϣϵͳݲֿģ

УϢԴJS-CIMSϵͳиӦϵͳݿ⣬ϢԴеݾ任뼯ɣװ뼯ɵĹϵݿУȻӼݿȡݣEISϵͳϢҪװݲֿУûͨǰˣClient߻Ӧ÷ݲֿ⣬ԳClient˷ḻݷߣ
ݲֿ⽨Ĺؼݱ任뼯ɣͼ3ʾ.

ͼ3ݱ任뼯ɹ
ݶ弰ȡҪɶݲֿԴȡģ͵ݲֿݡṹͻ壮
ڹȷԴ֤ݵһԣųɵ⣮
ۼ򰴹ùϵݿ⣬SQL淶ı任ת
֤תݽ걸ԡݼԼϵݵһԡȫԺʱԵȷļ鼰
ݼؽȡװĿݿ⣬Ŀ¼άݣ
3.3 EISݲֿе
ݲֿҵģΪӦõصʵ֮ǰ ҪȶԷݱıˢµĹɷ飮һҵΪһ¼⣬ҵڶ¼⣬ҵҵб仯ȶݲֿģȫͨļ⣬Ϊڶ¼⹹Ƶۺ·ʵֶάݷͼ4һƷ۵.

ͼ4 ۶ά

ͼ4пԵóܲΣָ꣨˰ӦտڲƷ ࡢ񣩣ͻλţšԱʱ䣨 ¡գĲͬεĻܣ
4JS-CIMS쵼Ϣϵͳ
JS-CIMSǽոŹ˾CIMṢͨգصϵͳMRP ݿΪProgressϵ⣬ϵͳFOXPROݿ⣮
JS-CIMS쵼ϢϵͳJS-CIMSݿ⻷֧£ϵͳͲϵͳϣΪ˾쵼ֱṩйۡ桢ӦͲ񡢾Ӫȶ෽Ϣ֧֣ͼĲïķʽҵ쵼ߣ
JS-CIMS/EISǰ̨лΪWin95.Delphi3.0̨ݿΪProgressFOXPROݿ⣮ϵͳѧԺã䣬㣬ѾڽոŹ˾õӦãõûաļۣ
4.1 JS-CIMS쵼Ϣϵͳṹ
JS-CIMS쵼Ϣϵͳͼ5ʾϵṹMRPϵͳPROGRESSϵݿȡصݣFOXPROݿȡصݣֶԵͳһԵ֤ʱǣ¼ԻܣԶάݵķʽݲֿ⣮

ͼ5JS-CIMS쵼Ϣϵͳϵṹ

JS-CIMS쵼Ϣϵͳǰ˲ѯݲֿ⹹һ͵Ŀͻ/ֲʽӦýṹODBCӿݲֿ⣮
JS-CIMS쵼Ϣϵͳ۴ϵͳУǴӲϵͳгȡݣǵķݣģ飬תݲֿ⣮
4.2 ϵͳܼ
JS-CIMS쵼ϢϵͳṩάġɴּϸͬݲѯƷʱϿꡢ¡գΧɴӹ˾ţˣƪϵͳ书ܰͳơͻͳơҵԱͳơƷƷͿͻƷ
ϵͳɰʱ䣨ꡢ¡գƷ͹񣩣ͻȡάݽвѯͷݺͼʾ
5
ѾMISCIMSҵʶϵͳд洢Ĵ淶ҵԴγھЩԴѳΪʶǽJS-CIMSӦʾ̣˻ݲֿ쵼Ϣϵͳõûļۣ⽫ΪCIMSϵͳṩ飬ԼӿϢԴĳã
߼飺Ρ꣬33꣬У߼ʦоΪCIMSERPȷо뿪 
ΰ26꣬УνʵֹʦоΪݲֿ⣬̵ȷо뿪
Ѧɣ60꣬УоԱʿʦоΪCIMSϵͳ̣ɢ¼۵ȣ
ߵλпԺԶ110015
ο
1Watson H J,Kelly Rainer R, George Houdeshel. Executive Information Systems EmergenceDevelopmentImpactJohn Willy & SonsINC1992
2 Inmon W H. Building the Data Warehouse. John Willy & SonsInc
3 ΰCIMSEISӦопԺԶ˶ʿ,1998
4 ǿȣݲֿ⼼ľ֧ϵͳоӦãϵͳʵ, 1998
5 863/CIMSӦùռĵ. JS-CIMS̼. пԺԶ ոŹ˾1998.4
ո:1998-08-19
