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

【參考文獻】

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

，

本文編號：2423113