基于ERP的青山MIS系统的开发研究
摘要
随着经济全球化和信息技术的迅速发展，企业生产资料的获取与产品营销范围日趋扩大，社会生产、物资流通、商品交易及其管理方式正在并将继续发生深刻的变革。特别是我国加入WTO以后，企业间面临的竞争不但是国内企业的竞争，更将面临国际跨国公司的竞争，作为我国国民经济支柱的制造业面临着巨大的机遇和挑战。利用管理信息系统(MIS)，改善其在生产、管理中的不足，以面临的越来越激烈的市场竞争，促进其生产效率能得到实际得提高，有着非常现实的意义。本文就是针对基于企业资源计划(ERP)的MIS开发来进行研究。
首先，本文从理论上阐述了MIS建设的应用基础、层次概念和设计方法，以及企业资源计划(ERP)的基本概念、原理和思想。
其次，在充分理解MIS和ERP原理基础上，结合重庆青山工业公司管理信息系统(QSMIS)的设计和开发，在系统需求分析的基础上，对系统的功能模块、数据库系统、网络拓扑及体系结构、计算模式等进行了较详细的论述；尤其是对系统开发中实施的业务流程再造、编码技术、界面设计、及系统优化等关键技术进行了较为系统的探讨，同时对系统所实施的安全策略进行了阐述；并通过设计出的QSMIS的总体框架以及系统结构图、各功能模块的逻辑流程图，对系统实现的主要功能和作用作了简要概述。
然后，对QSMIS的性能、特点逐一进行了分析，总结出了QSMIS开发的成功经验，以及QSMIS和开发过程中的不足之处。为青山公司和相关企业的MIS系统建设提供了通用的原则，还进一步得出了在ERP下，青山公司MIS构成、开发和实施的新原则。
QSMIS的开发是成功的，但它还需要不断的改进和完善。随着信息技术相关理论的不断发展，MIS开发和研究必将更加深入发展下去。
With the economic globalization and information technology improving rapidly, the obtaining of materials and the scale of product market is expending further in enterprises, social production, circulation of materials, trade and his management's way are continuing to change deeply. Especially when our country joined WTO, the competition that the manufacturing enterprises with the enormous opportunities and challenges in our country are the most important pillar in national economy have to fact is coming from trans-corporation,. To utilize the management information system(MIS) is to improve its deficiency of producing, managing in enterprises, in order to promote production efficiency and face fierce market competition .so the research about MIS has very realistic meanings. According to the MIS which based on enterprise resources plan (ERP).,This thesis carried on researching.
Firstly, it explained the constructions, applications and foundations of MIS.
Secondly, on the basis principles of MIS and ERP, combining the design and development of the management information system of the industrial company of green hill in ChongQing (QSMIS), basing the foundations of system and demands analyzing, it carried on more detailed argumentations of module designing, data system, network and structure of system, modes of calculation etc. Especially, it gave the discussing about flow rebuilding, technology of coding, interface designing, and system optimizing. At the same time, it expatiated the safety precautions of system, and explained the main ability and effects of system by the overall frames and charts of system's structure, and every logic flow chart of module of function of QSMIS briefly.
.Finally, it analyzed the specialties and capabilities of the exploitation of QSMIS singly, and summed up the successful experiences, and the weak points about QSMIS, offering some principle in common use for the GREEN HILL and other companies. Also, it got some new principles about form, developing of the exploitation of QSMIS, basing on ERP.
The exploitation of QSMIS is successful, but it still needs to continue improving and perfecting. With the development of the relevant theories of information 's technologies, MIS will be developed and researched further.
首先，本文从理论上阐述了MIS建设的应用基础、层次概念和设计方法，以及企业资源计划(ERP)的基本概念、原理和思想。
其次，在充分理解MIS和ERP原理基础上，结合重庆青山工业公司管理信息系统(QSMIS)的设计和开发，在系统需求分析的基础上，对系统的功能模块、数据库系统、网络拓扑及体系结构、计算模式等进行了较详细的论述；尤其是对系统开发中实施的业务流程再造、编码技术、界面设计、及系统优化等关键技术进行了较为系统的探讨，同时对系统所实施的安全策略进行了阐述；并通过设计出的QSMIS的总体框架以及系统结构图、各功能模块的逻辑流程图，对系统实现的主要功能和作用作了简要概述。
然后，对QSMIS的性能、特点逐一进行了分析，总结出了QSMIS开发的成功经验，以及QSMIS和开发过程中的不足之处。为青山公司和相关企业的MIS系统建设提供了通用的原则，还进一步得出了在ERP下，青山公司MIS构成、开发和实施的新原则。
QSMIS的开发是成功的，但它还需要不断的改进和完善。随着信息技术相关理论的不断发展，MIS开发和研究必将更加深入发展下去。
With the economic globalization and information technology improving rapidly, the obtaining of materials and the scale of product market is expending further in enterprises, social production, circulation of materials, trade and his management's way are continuing to change deeply. Especially when our country joined WTO, the competition that the manufacturing enterprises with the enormous opportunities and challenges in our country are the most important pillar in national economy have to fact is coming from trans-corporation,. To utilize the management information system(MIS) is to improve its deficiency of producing, managing in enterprises, in order to promote production efficiency and face fierce market competition .so the research about MIS has very realistic meanings. According to the MIS which based on enterprise resources plan (ERP).,This thesis carried on researching.
Firstly, it explained the constructions, applications and foundations of MIS.
Secondly, on the basis principles of MIS and ERP, combining the design and development of the management information system of the industrial company of green hill in ChongQing (QSMIS), basing the foundations of system and demands analyzing, it carried on more detailed argumentations of module designing, data system, network and structure of system, modes of calculation etc. Especially, it gave the discussing about flow rebuilding, technology of coding, interface designing, and system optimizing. At the same time, it expatiated the safety precautions of system, and explained the main ability and effects of system by the overall frames and charts of system's structure, and every logic flow chart of module of function of QSMIS briefly.
.Finally, it analyzed the specialties and capabilities of the exploitation of QSMIS singly, and summed up the successful experiences, and the weak points about QSMIS, offering some principle in common use for the GREEN HILL and other companies. Also, it got some new principles about form, developing of the exploitation of QSMIS, basing on ERP.
The exploitation of QSMIS is successful, but it still needs to continue improving and perfecting. With the development of the relevant theories of information 's technologies, MIS will be developed and researched further.
引文
[1] MRP是ERP的核心功能．中国机电日报．2001(2)．
[2] 王惠芬．MRP—Ⅱ系统在我国实施情况分析．中国科技论坛．1999(01)．23-28．
[3] 韩忠原．CIMS环境下MRPⅡ和PDM的集成研究．华中理工大学学报．1999(10)．
[4] 阙定胜．MRP—Ⅱ系统实施与研究．机械与电子．2000(06)．
[5] 从管理入手e化企业—上海汽车齿轮总厂MRPⅡ应用分析．计算机周刊．2000(06)．
[6] 苑蔚．MRP—Ⅱ／ERP的实际应用．电工材料．2000(04)．44-46．
[7] 杨恺琪．烟草企业管理信息系统SIEC／MRP—Ⅱ的设计与实现．计算机应用研究．2000(09)．
[8] 叶湘镛．信息化顶起汽车半片天—MRPⅡ(制造资源计划)在上海汇众汽车制造有限公司实施和应用．计算机周刊．2000(06)．
[9] 应怿人．如何看待和应用MRP—Ⅱ／ERP软件的财务管理部分．上海微型计算机．2000(09)．
[10] 王岩．以人为本：MRP—Ⅱ推广应用中应注意的问题．南京航空航天大学学报(社会科学版)2000(06)．42-45．
[11] 李津军．MRP—Ⅱ／ERP系统的实施．计算机周刊．2000(31)．28-32．
[12] 虞培元．实施MRP—Ⅱ管理系统初析．计算机周刊．2000(22)．
[13] 景绍洪．管理信息系统开发中的模块设计．山东建材学院学报．2000(02)．
[14] 党延忠．业务流程再造与信息化建设．信息化与管理变革．大连理工大学出版社．2000(03)．39-49．
[15] 芮明杰．《再造流程》ISBN 7—213—01613一X／F．255．浙江人民出版社．1997(12)第1版．
[16] 阎洁．中小企业信息化建设网络设计方案选择研究．水利电力机械．2000(04)．34-47．
[17] 黄文明．MIS用户界面设计与实现．桂林电子工业学院学报．1994(06)．20-25．
[18] 李伟．MRP—Ⅱ／ERP概述及实例分析．机械技术．2002(10)．21-23．
[19] 王素珍．MRP—Ⅱ回顾与展望．信息技术．2002(06)．62-63．
[20] 王惠芬．MRP—Ⅱ系统在我国实施情况．暨南大学学报．
[21] 李浩．MRP—Ⅱ中库存管理系统的应用方案的研究．计算机工程．2002(02)．77-80．
[22] 叶倩．基于SQL的MRP—Ⅱ系统开发．暨南大学学报(自然科学版)．2002(06)．26-29．
[23] 李穗明．烟厂自动物流系统分析与实施．计算机应用．1998(04)．15—17．
[24] 虞培元．实施MRP—Ⅱ系统初析．上海微型计算机．2001(01)．
[25] 王达恩．现代网络设计重庆大学学报(自然科学版)．2002(05)．31-35．
[26] 张华雨．以客户为中心的大型制造企业MRP—Ⅱ建设．计算机应用．2002(06)．78-79．
[27] Ullman.J.D.and Widom.J.A First Course In Database System.Prentice Hall international.Inc.
[28] Weinberg.V.Structured Analysis.Prentice Hall. 1980.
[29] Adams,D.et al. Computer Information Systemjs Development, Design and Implementation. South-Western.Co 1985
[30] Davis,W.S.System analysis and Design: A Structure Approach.Addison-Wesly Pub.Co.1983
[31] Davis,W.S.System APICS.Dictionary(8th edition).APICS.Inc.1995.P8,P32
[32] I. J. Chen. Planning for ERP Systems: Analysis and Future Trend, Business Process Management Journal, MCB University Press, 7:373-386, 2001.
[33] Y. E. Chan and V. C. Storey. The use of spreadsheets in organizations: Determinants and consequences, Information & Management, 31:119-134, 1996.
[34] S. H. Chung and C. A. Snyder. ERP Adoption: A Technological Evolution Approach, International Journal Of A gile Management Systems, 2:24-32, 2000.
[35] A. L. M. Cavaye. User Participation in Systems Development Revisited, Information and Management, 28:311-323.1995.
[36] T. Davenport. Mission Critical: Realizing the Promise of Enterprise Systems, Harvard Business School Press, page 335, 2000.
[37] W. H. DeLone and E. R. McLean. Information System Success: The Quest for the Dependent Variable, Information Systems Research, 3:60-95, 1992.
[38] J. M. Esteves and A. J. Pastor. Enterprise Resource Planning Systems Research: AnAnnotated Bibliography, Communications of the Association for Information Systems, pages 1-51,2001.
[39] P. D. Ford, E. C. Connelly and B. D. Meister. Information Systems Research and Hofstede's Culture's Consequences: An Uneasy and Incomplete Partnership, IEEE Transactions on Engineering Management, 50:8-25, 2003.
[40] J. Greenbaum. The New Frontier, Intelligent Enterprise, http://www.intelligent enterprise.com/030405/606enterprisel 1.shtml, 2003.
[41] Davis,W. S.System APICS.Dictionary(8th edition).APICS.Inc. 1995.P8,P32 4-6 December,pages 129-139, 2002.
[44] G. Burrell and G. Morgan. Sociological paradigms and organisational analysis, Heineman, London, page 6, 1979.
[2] 王惠芬．MRP—Ⅱ系统在我国实施情况分析．中国科技论坛．1999(01)．23-28．
[3] 韩忠原．CIMS环境下MRPⅡ和PDM的集成研究．华中理工大学学报．1999(10)．
[4] 阙定胜．MRP—Ⅱ系统实施与研究．机械与电子．2000(06)．
[5] 从管理入手e化企业—上海汽车齿轮总厂MRPⅡ应用分析．计算机周刊．2000(06)．
[6] 苑蔚．MRP—Ⅱ／ERP的实际应用．电工材料．2000(04)．44-46．
[7] 杨恺琪．烟草企业管理信息系统SIEC／MRP—Ⅱ的设计与实现．计算机应用研究．2000(09)．
[8] 叶湘镛．信息化顶起汽车半片天—MRPⅡ(制造资源计划)在上海汇众汽车制造有限公司实施和应用．计算机周刊．2000(06)．
[9] 应怿人．如何看待和应用MRP—Ⅱ／ERP软件的财务管理部分．上海微型计算机．2000(09)．
[10] 王岩．以人为本：MRP—Ⅱ推广应用中应注意的问题．南京航空航天大学学报(社会科学版)2000(06)．42-45．
[11] 李津军．MRP—Ⅱ／ERP系统的实施．计算机周刊．2000(31)．28-32．
[12] 虞培元．实施MRP—Ⅱ管理系统初析．计算机周刊．2000(22)．
[13] 景绍洪．管理信息系统开发中的模块设计．山东建材学院学报．2000(02)．
[14] 党延忠．业务流程再造与信息化建设．信息化与管理变革．大连理工大学出版社．2000(03)．39-49．
[15] 芮明杰．《再造流程》ISBN 7—213—01613一X／F．255．浙江人民出版社．1997(12)第1版．
[16] 阎洁．中小企业信息化建设网络设计方案选择研究．水利电力机械．2000(04)．34-47．
[17] 黄文明．MIS用户界面设计与实现．桂林电子工业学院学报．1994(06)．20-25．
[18] 李伟．MRP—Ⅱ／ERP概述及实例分析．机械技术．2002(10)．21-23．
[19] 王素珍．MRP—Ⅱ回顾与展望．信息技术．2002(06)．62-63．
[20] 王惠芬．MRP—Ⅱ系统在我国实施情况．暨南大学学报．
[21] 李浩．MRP—Ⅱ中库存管理系统的应用方案的研究．计算机工程．2002(02)．77-80．
[22] 叶倩．基于SQL的MRP—Ⅱ系统开发．暨南大学学报(自然科学版)．2002(06)．26-29．
[23] 李穗明．烟厂自动物流系统分析与实施．计算机应用．1998(04)．15—17．
[24] 虞培元．实施MRP—Ⅱ系统初析．上海微型计算机．2001(01)．
[25] 王达恩．现代网络设计重庆大学学报(自然科学版)．2002(05)．31-35．
[26] 张华雨．以客户为中心的大型制造企业MRP—Ⅱ建设．计算机应用．2002(06)．78-79．
[27] Ullman.J.D.and Widom.J.A First Course In Database System.Prentice Hall international.Inc.
[28] Weinberg.V.Structured Analysis.Prentice Hall. 1980.
[29] Adams,D.et al. Computer Information Systemjs Development, Design and Implementation. South-Western.Co 1985
[30] Davis,W.S.System analysis and Design: A Structure Approach.Addison-Wesly Pub.Co.1983
[31] Davis,W.S.System APICS.Dictionary(8th edition).APICS.Inc.1995.P8,P32
[32] I. J. Chen. Planning for ERP Systems: Analysis and Future Trend, Business Process Management Journal, MCB University Press, 7:373-386, 2001.
[33] Y. E. Chan and V. C. Storey. The use of spreadsheets in organizations: Determinants and consequences, Information & Management, 31:119-134, 1996.
[34] S. H. Chung and C. A. Snyder. ERP Adoption: A Technological Evolution Approach, International Journal Of A gile Management Systems, 2:24-32, 2000.
[35] A. L. M. Cavaye. User Participation in Systems Development Revisited, Information and Management, 28:311-323.1995.
[36] T. Davenport. Mission Critical: Realizing the Promise of Enterprise Systems, Harvard Business School Press, page 335, 2000.
[37] W. H. DeLone and E. R. McLean. Information System Success: The Quest for the Dependent Variable, Information Systems Research, 3:60-95, 1992.
[38] J. M. Esteves and A. J. Pastor. Enterprise Resource Planning Systems Research: AnAnnotated Bibliography, Communications of the Association for Information Systems, pages 1-51,2001.
[39] P. D. Ford, E. C. Connelly and B. D. Meister. Information Systems Research and Hofstede's Culture's Consequences: An Uneasy and Incomplete Partnership, IEEE Transactions on Engineering Management, 50:8-25, 2003.
[40] J. Greenbaum. The New Frontier, Intelligent Enterprise, http://www.intelligent enterprise.com/030405/606enterprisel 1.shtml, 2003.
[41] Davis,W. S.System APICS.Dictionary(8th edition).APICS.Inc. 1995.P8,P32 4-6 December,pages 129-139, 2002.
[44] G. Burrell and G. Morgan. Sociological paradigms and organisational analysis, Heineman, London, page 6, 1979.
© 2004-2018 中国地质图书馆版权所有 京ICP备05064691号 京公网安备11010802017129号 地址：北京市海淀区学院路29号 邮编：100083 电话：办公室：(+86 10)66554848；文献借阅、咨询服务、科技查新：66554700 |