某公司决策支持系统的设计及优化
发布时间：2019-02-15 07:41
【摘要】：信息时代,各种数据库系统正前所未有地普及,并在各行各业中有着广泛的应用,这使得存储和事务处理变得更加容易,但是如何处理泛滥的数据,仍然是困扰着组织决策者的一大难题。随着数据仓库和数据挖掘的日益发展,商务智能和决策支持系统成为了决策者更加喜欢的数据分析工具。本课题针对某公司如今正在使用的金蝶K3 ERP系统以及该公司二次开发的帆软Fine Report决策支持系统的运行速度缓慢、功能单一的现状,利用SQL Server商务智能组件、开源商务智能套件、以及JavaEE和开源的框架来重新定制新的决策支持系统——“管理驾驶舱”(MVS-DSS)。论文主要完成了以下工作:研究数据仓库技术,包括传统数据仓库、抽取-转换-加载(ETL)过程、实时数据仓库等。根据某公司当前决策支持系统具有的速度慢、架构不合理、数据源单一的缺点进行了分析,并提出了优化的设计方案。设计基于金蝶K3 ERP系统作为第一数据源的数据仓库,并详细阐述了该数据仓库的设计过程,包括星型架构的设计、数据仓库主题的设计,以及数据库表的设计。阐述了MVS-DSS的ETL过程的设计思路,以及使用开源ETL工具Kettle完成ETL的具体实现过程。并在其基础上增加了Excel数据源的ETL实现。使用SpringMVC和Bootstrap,根据公司决策者的需求,开发Web展示系统,作为决策支持系统的展示工具。讨论了MVS-DSS的系统集成测试(SIT)以及用户验收测试(UAT)的设计过程。根据用户反馈进行MVS-DSS的二次优化方案设计以及实现。通过上述方面的研究与实践,本文实现了基于金蝶K3 ERP数据库以及Excel数据源等多元数据源的数据仓库,将某公司的数据进行了合理的整合转换与利用。并通过所开发的展示系统,将数据仓库中数据转化为决策支持系统可用数据,初步实现了MVS-DSS,为某公司的管理者合理管理公司提供了信息化的方法和手段,也为决策者对公司进行决策提供了辅助决策依据。
[Abstract]:In the information age, various database systems are becoming more popular than ever, and widely used in various industries, which make storage and transaction processing easier, but how to deal with the flood of data, It is still a difficult problem for the decision makers of the organization. With the development of data warehouse and data mining, business intelligence and decision support system have become more and more popular tools for data analysis. This subject aims at the current situation that a company is using Kingdee K3 ERP system and the sails soft Fine Report decision support system which is developed by the company now, which has a slow running speed and a single function, and makes use of SQL Server business intelligence component and open source business intelligence suite. As well as JavaEE and open source frameworks to recustomize the new decision support system, Managing cockpit (MVS-DSS). The main work of this paper is as follows: research on data warehouse technology, including traditional data warehouse, decimation-transform-load (ETL) process, real-time data warehouse and so on. According to the shortcomings of a company's current decision support system, such as slow speed, unreasonable architecture and single data source, an optimized design scheme is put forward. This paper designs a data warehouse based on Kingdee K3 ERP system as the first data source, and describes the design process of the data warehouse in detail, including the design of star architecture, the design of data warehouse subject, and the design of database table. The design idea of ETL process of MVS-DSS and the implementation of ETL with open source ETL tool Kettle are described. On the basis of this, the ETL implementation of Excel data source is added. SpringMVC and Bootstrap, are used to develop the Web display system according to the needs of the decision makers, which is used as the display tool of the decision support system. The design process of MVS-DSS system integration test (SIT) and user acceptance test (UAT) are discussed. According to user feedback, the quadratic optimization scheme of MVS-DSS is designed and implemented. Through the above research and practice, the data warehouse based on Kingdee K3 ERP database and Excel data source is realized in this paper, and the data of a company is transformed and utilized reasonably. Through the developed display system, the data in the data warehouse is transformed into the available data in the decision support system, and the MVS-DSS, provides the method and means of information for the reasonable management company of a company. It also provides a basis for decision-makers to make decision-making for the company.
【学位授予单位】：东华大学
【学位级别】：硕士
【学位授予年份】：2017
【分类号】：TP311.13
本文编号：2423113
[Abstract]:In the information age, various database systems are becoming more popular than ever, and widely used in various industries, which make storage and transaction processing easier, but how to deal with the flood of data, It is still a difficult problem for the decision makers of the organization. With the development of data warehouse and data mining, business intelligence and decision support system have become more and more popular tools for data analysis. This subject aims at the current situation that a company is using Kingdee K3 ERP system and the sails soft Fine Report decision support system which is developed by the company now, which has a slow running speed and a single function, and makes use of SQL Server business intelligence component and open source business intelligence suite. As well as JavaEE and open source frameworks to recustomize the new decision support system, Managing cockpit (MVS-DSS). The main work of this paper is as follows: research on data warehouse technology, including traditional data warehouse, decimation-transform-load (ETL) process, real-time data warehouse and so on. According to the shortcomings of a company's current decision support system, such as slow speed, unreasonable architecture and single data source, an optimized design scheme is put forward. This paper designs a data warehouse based on Kingdee K3 ERP system as the first data source, and describes the design process of the data warehouse in detail, including the design of star architecture, the design of data warehouse subject, and the design of database table. The design idea of ETL process of MVS-DSS and the implementation of ETL with open source ETL tool Kettle are described. On the basis of this, the ETL implementation of Excel data source is added. SpringMVC and Bootstrap, are used to develop the Web display system according to the needs of the decision makers, which is used as the display tool of the decision support system. The design process of MVS-DSS system integration test (SIT) and user acceptance test (UAT) are discussed. According to user feedback, the quadratic optimization scheme of MVS-DSS is designed and implemented. Through the above research and practice, the data warehouse based on Kingdee K3 ERP database and Excel data source is realized in this paper, and the data of a company is transformed and utilized reasonably. Through the developed display system, the data in the data warehouse is transformed into the available data in the decision support system, and the MVS-DSS, provides the method and means of information for the reasonable management company of a company. It also provides a basis for decision-makers to make decision-making for the company.
【学位授予单位】：东华大学
【学位级别】：硕士
【学位授予年份】：2017
【分类号】：TP311.13
【参考文献】
相关期刊论文 前10条
1 王朝霞;郭宇栋;谈昨非;孟月昊;;基建工程数据仓库构建与应用研究[J];中国管理信息化;2016年21期
2 刘亚娟;张相羽;郭勤;刘乃豪;;数据仓库技术的应用[J];通讯世界;2016年20期
3 陈立勇;于来行;;电信行业数据仓库逻辑模型构建研究[J];数字技术与应用;2012年07期
4 鲍玉斌,孙焕良,于戈,嵇晓,王大玲;星链ER模型:一种数据仓库概念设计模型[J];小型微型计算机系统;2005年02期
5 张宁,贾自艳,史忠植;数据仓库中ETL技术的研究[J];计算机工程与应用;2002年24期
6 马丽娜,刘弘,张希林;数据挖掘、OLAP在决策支持系统中的应用[J];计算机应用研究;2001年11期
7 袁长河,吴永明;基于数据仓库的决策支持系统研究与建设[J];计算机工程与应用;2001年16期
8 李建中,hlju.edu.cn,高宏;一种数据仓库的多维数据模型[J];软件学报;2000年07期
9 吉根林,帅克,孙志挥;数据挖掘技术及其应用[J];南京师大学报(自然科学版);2000年02期
10 谢榕;基于数据仓库的决策支持系统框架[J];系统工程理论与实践;2000年04期
相关硕士学位论文 前5条
1 朱彬;居家医健通系统的数据仓库设计及其分析应用研究[D];东华大学;2016年
2 贾艳凯;多源异构增量数据抽取方法研究与设计[D];哈尔滨工程大学;2013年
3 舒琦;ETL过程优化与增量数据抽取的研究[D];湖南大学;2011年
4 肖裕洪;实时数据仓库关键技术的研究与实现[D];华南理工大学;2011年
5 卢硕;数据仓库和数据挖掘在决策支持系统中的应用研究[D];西安电子科技大学;2006年
，本文编号：2423113
本文链接：https://www.wllwen.com/kejilunwen/ruanjiangongchenglunwen/2423113.html
