二維“學(xué)生信息”的多維分析和處理
1.3萬(wàn)字 30頁(yè)
包括開(kāi)題和任務(wù)書(shū)



摘 要
OLAP技術(shù)是數(shù)據(jù)報(bào)表系統(tǒng)的進(jìn)一步發(fā)展，是商業(yè)智能數(shù)據(jù)分析的核心技術(shù)，是企業(yè)決策支持的最佳選擇。它提供復(fù)雜計(jì)算、趨勢(shì)分析和多維建模能力，為用戶顯示直觀、易理解的圖形化數(shù)據(jù)分析，顯示企業(yè)當(dāng)前的綜合信息形勢(shì)，以便企業(yè)管理者及時(shí)作出正確科學(xué)的決策，從而在激烈的競(jìng)爭(zhēng)中勝出。
本設(shè)計(jì)的主要內(nèi)容是對(duì)數(shù)據(jù)分析商業(yè)智能解決方案所需技術(shù)和方法進(jìn)行初步的探討和實(shí)現(xiàn)。論文以微軟SQL Server 2005 Business Intelligence技術(shù)為背景，通過(guò)選取和比較相關(guān)技術(shù)，探討最適當(dāng)用于實(shí)現(xiàn)數(shù)據(jù)分析商業(yè)智能解決方案的方法。同時(shí)，針對(duì)多維數(shù)據(jù)倉(cāng)庫(kù)的構(gòu)建標(biāo)準(zhǔn)和方式，對(duì)其應(yīng)用實(shí)現(xiàn)進(jìn)行詳細(xì)的分析；通過(guò)比較加深對(duì)OLAP商業(yè)智能系統(tǒng)優(yōu)點(diǎn)的認(rèn)識(shí)和理解。最后，設(shè)計(jì)對(duì)二維“學(xué)生信息”的多維分析和處理系統(tǒng)進(jìn)行初步實(shí)現(xiàn)，使此學(xué)生基本信息的多維分析和處理系統(tǒng)具備多維數(shù)據(jù)分析和處理的特征，包括商業(yè)智能，統(tǒng)一維度模型和數(shù)據(jù)的提取、轉(zhuǎn)換和加載等。根據(jù)具體實(shí)現(xiàn)中所展現(xiàn)的數(shù)據(jù)分析OLAP商業(yè)智能強(qiáng)大功能和優(yōu)勢(shì)，相信OLAP技術(shù)將在未來(lái)得到廣泛的應(yīng)用和發(fā)展。
關(guān)鍵字：OLAP，數(shù)據(jù)倉(cāng)庫(kù)，BI，多維數(shù)據(jù)庫(kù)，ETL

Two-dimensional “Students’ Information” Multidimensional Analysis and Processing
Abstract
The olap technology is the further development of data reports analysis, it's the core technology of business intelligence data analysis, and the best choice of enterprise decision support. It's apply complex calculate, trend analyze and multi-dimension modeling capability, supply users vertical, easy understanding graphical data analysis, show the current institution of enterprise, let the enterprise manager make correct society decision in time, and then win in the modern fierce competition.
The main content of the present design is to discuss and realize the techniques and methods requested by the data analysis business intelligence solution. On the background of the technique of Microsoft SQL server 2005 business intelligence, this paper discusses the best way of carrying out the data analysis Business Intelligence solution, by selecting and comparing with the relevant techniques. At the same time, aiming at the standards and methods of building multi-dimensional data dataware, and then performs detailed analysis on how to implement the application, by further recognizing and understanding the merits of olap business intelligence. At last, the present design implements two-dimensional “students’ information” multi-dimensional analysis and processing system, which enables reservation system to realize lots of characteristics of multi-dimensional analysis and processing , including business intelligence, uniform dimensional model , and data extracting , cleaning, transporting, loading and etc. According to the powerful function and advantages of olap Business Intelligence shown in the process of implementation, we believe that the techniques of olap will be widely used and develop rapidly in the near future.
Key words:OLAP ,Dataware ,BusinessIntelligence ,Multi-dimentional Database ,ETL

目 錄
1． 緒論 1
1.1 項(xiàng)目背景 1
1.2 國(guó)內(nèi)外研究情況 1
1.3 相關(guān)概念和理論背景 3
2． 系統(tǒng)分析與實(shí)現(xiàn)的關(guān)鍵技術(shù) 5
2.1 商業(yè)智能 5
2.1.1 商業(yè)智能概念 5
2.1.2 微軟商業(yè)智能體系結(jié)構(gòu) 6
2.1.3 微軟分析服務(wù)開(kāi)發(fā)工具下的商業(yè)智能 6
2.2統(tǒng)一維度模型 8
2.3 數(shù)據(jù)提取、轉(zhuǎn)換和加載 9
3． 二維“學(xué)生信息”的多維分析和處理實(shí)現(xiàn) 12
3.1 系統(tǒng)開(kāi)發(fā)工具的探討 12
3.2 系統(tǒng)開(kāi)發(fā)環(huán)境及配置 13
3.2.1 系統(tǒng)硬件要求 13
3.2.2 系統(tǒng)軟件要求 13
3.2.3 SQL Server 2005 13
3.2.4 AdventureWorks示例數(shù)據(jù)庫(kù)與示例教程 13
3.2.5 SQL Server 2005 Reporting Service報(bào)表服務(wù)器配置 14
3.3 項(xiàng)目管理工具：Mindjet Manager Tool 14
3.4微軟OLAP系統(tǒng)解決方案 14
3.4.1 OLAP系統(tǒng)設(shè)計(jì) 14
3.5 創(chuàng)建“學(xué)生信息”O(jiān)LAP解決方案 15
3.5.1 系統(tǒng)設(shè)計(jì)文檔 16
3.5.2 Cube多維數(shù)據(jù)集和維度設(shè)計(jì) 16
3.5.3 生成關(guān)系架構(gòu) 17
3.5.4 ETL數(shù)據(jù)提取、轉(zhuǎn)換和加載 18
3.5.5 多維模型分析和處理 19
3.5.6 前端數(shù)據(jù)展現(xiàn) 21
3.6 測(cè)試 23
3.6.1 驗(yàn)證數(shù)據(jù)源導(dǎo)入是否合理正確 23
3.6.2 驗(yàn)證多維分析和處理是否科學(xué) 23
結(jié) 論 24
致 謝 25
參考文獻(xiàn) 26



參考文獻(xiàn)
[6] 張友生．軟件體系結(jié)構(gòu)[M] ．北京：清華大學(xué)出版社，2004：15-18 ，31．
[7] Clifford A．Shaffer．?dāng)?shù)據(jù)結(jié)構(gòu)與算法分析[M] ．北京：電子工業(yè)出版社，2002：15-18 ，31．
[8] 鄔建榮．上海雙菱“智能”集中客戶數(shù)據(jù)[J] ．計(jì)算機(jī)世界(第C14版) ， 2004，12(10A) ：23-27．
[9] 王誠(chéng)．醫(yī)院經(jīng)營(yíng)管理中收入多維分析模型的設(shè)計(jì)[J] ．中原工學(xué)院學(xué)報(bào)，2006，12(6A) ：15-21 ．
[10] 沈榮．SQL Server 2005 OLAP技術(shù)研究與實(shí)現(xiàn)[J] ．電腦知識(shí)與技術(shù)，2006，48(36A) ：20-47 ．
[11] 程黃維．基于數(shù)據(jù)倉(cāng)庫(kù)、聯(lián)機(jī)分析處理(OLAP)和數(shù)據(jù)挖掘的新決策支持系統(tǒng)[J] ．財(cái)經(jīng)界(下半月)