【摘要】：信息時(shí)代,各種數(shù)據(jù)庫(kù)系統(tǒng)正前所未有地普及,并在各行各業(yè)中有著廣泛的應(yīng)用,這使得存儲(chǔ)和事務(wù)處理變得更加容易,但是如何處理泛濫的數(shù)據(jù),仍然是困擾著組織決策者的一大難題。隨著數(shù)據(jù)倉(cāng)庫(kù)和數(shù)據(jù)挖掘的日益發(fā)展,商務(wù)智能和決策支持系統(tǒng)成為了決策者更加喜歡的數(shù)據(jù)分析工具。本課題針對(duì)某公司如今正在使用的金蝶K3 ERP系統(tǒng)以及該公司二次開(kāi)發(fā)的帆軟Fine Report決策支持系統(tǒng)的運(yùn)行速度緩慢、功能單一的現(xiàn)狀,利用SQL Server商務(wù)智能組件、開(kāi)源商務(wù)智能套件、以及JavaEE和開(kāi)源的框架來(lái)重新定制新的決策支持系統(tǒng)——“管理駕駛艙”(MVS-DSS)。論文主要完成了以下工作:研究數(shù)據(jù)倉(cāng)庫(kù)技術(shù),包括傳統(tǒng)數(shù)據(jù)倉(cāng)庫(kù)、抽取-轉(zhuǎn)換-加載(ETL)過(guò)程、實(shí)時(shí)數(shù)據(jù)倉(cāng)庫(kù)等。根據(jù)某公司當(dāng)前決策支持系統(tǒng)具有的速度慢、架構(gòu)不合理、數(shù)據(jù)源單一的缺點(diǎn)進(jìn)行了分析,并提出了優(yōu)化的設(shè)計(jì)方案。設(shè)計(jì)基于金蝶K3 ERP系統(tǒng)作為第一數(shù)據(jù)源的數(shù)據(jù)倉(cāng)庫(kù),并詳細(xì)闡述了該數(shù)據(jù)倉(cāng)庫(kù)的設(shè)計(jì)過(guò)程,包括星型架構(gòu)的設(shè)計(jì)、數(shù)據(jù)倉(cāng)庫(kù)主題的設(shè)計(jì),以及數(shù)據(jù)庫(kù)表的設(shè)計(jì)。闡述了MVS-DSS的ETL過(guò)程的設(shè)計(jì)思路,以及使用開(kāi)源ETL工具Kettle完成ETL的具體實(shí)現(xiàn)過(guò)程。并在其基礎(chǔ)上增加了Excel數(shù)據(jù)源的ETL實(shí)現(xiàn)。使用SpringMVC和Bootstrap,根據(jù)公司決策者的需求,開(kāi)發(fā)Web展示系統(tǒng),作為決策支持系統(tǒng)的展示工具。討論了MVS-DSS的系統(tǒng)集成測(cè)試(SIT)以及用戶驗(yàn)收測(cè)試(UAT)的設(shè)計(jì)過(guò)程。根據(jù)用戶反饋進(jìn)行MVS-DSS的二次優(yōu)化方案設(shè)計(jì)以及實(shí)現(xiàn)。通過(guò)上述方面的研究與實(shí)踐,本文實(shí)現(xiàn)了基于金蝶K3 ERP數(shù)據(jù)庫(kù)以及Excel數(shù)據(jù)源等多元數(shù)據(jù)源的數(shù)據(jù)倉(cāng)庫(kù),將某公司的數(shù)據(jù)進(jìn)行了合理的整合轉(zhuǎn)換與利用。并通過(guò)所開(kāi)發(fā)的展示系統(tǒng),將數(shù)據(jù)倉(cāng)庫(kù)中數(shù)據(jù)轉(zhuǎn)化為決策支持系統(tǒng)可用數(shù)據(jù),初步實(shí)現(xiàn)了MVS-DSS,為某公司的管理者合理管理公司提供了信息化的方法和手段,也為決策者對(duì)公司進(jìn)行決策提供了輔助決策依據(jù)。
[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.
【學(xué)位授予單位】：東華大學(xué)
【學(xué)位級(jí)別】：碩士
【學(xué)位授予年份】：2017
【分類號(hào)】：TP311.13

【參考文獻(xiàn)】

相關(guān)期刊論文 前10條

1 王朝霞;郭宇棟;談昨非;孟月昊;;基建工程數(shù)據(jù)倉(cāng)庫(kù)構(gòu)建與應(yīng)用研究[J];中國(guó)管理信息化;2016年21期

2 劉亞娟;張相羽;郭勤;劉乃豪;;數(shù)據(jù)倉(cāng)庫(kù)技術(shù)的應(yīng)用[J];通訊世界;2016年20期

3 陳立勇;于來(lái)行;;電信行業(yè)數(shù)據(jù)倉(cāng)庫(kù)邏輯模型構(gòu)建研究[J];數(shù)字技術(shù)與應(yīng)用;2012年07期

4 鮑玉斌,孫煥良,于戈,嵇曉,王大玲;星鏈ER模型:一種數(shù)據(jù)倉(cāng)庫(kù)概念設(shè)計(jì)模型[J];小型微型計(jì)算機(jī)系統(tǒng);2005年02期

5 張寧,賈自艷,史忠植;數(shù)據(jù)倉(cāng)庫(kù)中ETL技術(shù)的研究[J];計(jì)算機(jī)工程與應(yīng)用;2002年24期

6 馬麗娜,劉弘,張希林;數(shù)據(jù)挖掘、OLAP在決策支持系統(tǒng)中的應(yīng)用[J];計(jì)算機(jī)應(yīng)用研究;2001年11期

7 袁長(zhǎng)河,吳永明;基于數(shù)據(jù)倉(cāng)庫(kù)的決策支持系統(tǒng)研究與建設(shè)[J];計(jì)算機(jī)工程與應(yīng)用;2001年16期

8 李建中,hlju.edu.cn,高宏;一種數(shù)據(jù)倉(cāng)庫(kù)的多維數(shù)據(jù)模型[J];軟件學(xué)報(bào);2000年07期

9 吉根林,帥克,孫志揮;數(shù)據(jù)挖掘技術(shù)及其應(yīng)用[J];南京師大學(xué)報(bào)(自然科學(xué)版);2000年02期

10 謝榕;基于數(shù)據(jù)倉(cāng)庫(kù)的決策支持系統(tǒng)框架[J];系統(tǒng)工程理論與實(shí)踐;2000年04期

相關(guān)碩士學(xué)位論文 前5條

1 朱彬;居家醫(yī)健通系統(tǒng)的數(shù)據(jù)倉(cāng)庫(kù)設(shè)計(jì)及其分析應(yīng)用研究[D];東華大學(xué);2016年

2 賈艷凱;多源異構(gòu)增量數(shù)據(jù)抽取方法研究與設(shè)計(jì)[D];哈爾濱工程大學(xué);2013年

3 舒琦;ETL過(guò)程優(yōu)化與增量數(shù)據(jù)抽取的研究[D];湖南大學(xué);2011年

4 肖裕洪;實(shí)時(shí)數(shù)據(jù)倉(cāng)庫(kù)關(guān)鍵技術(shù)的研究與實(shí)現(xiàn)[D];華南理工大學(xué);2011年

5 盧碩;數(shù)據(jù)倉(cāng)庫(kù)和數(shù)據(jù)挖掘在決策支持系統(tǒng)中的應(yīng)用研究[D];西安電子科技大學(xué);2006年

，

本文編號(hào)：2423113