【正文】 I / 40摘 要基于數(shù)據(jù)倉庫的高職教務(wù)管理系統(tǒng)的設(shè)計與實現(xiàn)隨著數(shù)據(jù)庫系統(tǒng)的廣泛應(yīng)用，數(shù)據(jù)規(guī)模與日俱增，從大量復(fù)雜的業(yè)務(wù)數(shù)據(jù)中更加有效的分析提取可用的信息就變得尤為重要。從當(dāng)前的發(fā)展趨勢上看，數(shù)據(jù)處理的側(cè)重點己從傳統(tǒng)的業(yè)務(wù)過程的實現(xiàn)逐步擴(kuò)展到對業(yè)務(wù)數(shù)據(jù)的聯(lián)機(jī)分析處理，并從中得到用于統(tǒng)計和決策的信息，因此決策支持系統(tǒng)便應(yīng)運而生。數(shù)據(jù)倉庫技術(shù)經(jīng)過多年的發(fā)展，已變得比較成熟，近些年，出現(xiàn)了基于數(shù)據(jù)倉庫技術(shù)，并運用聯(lián)機(jī)分析處理技術(shù)(OLAP)和數(shù)據(jù)挖掘工具的決策支持系統(tǒng)(DSS)。數(shù)據(jù)倉庫技術(shù)、聯(lián)機(jī)分析處理技術(shù)和數(shù)據(jù)挖掘技術(shù)的應(yīng)用，對決策支持系統(tǒng)起到了有力支撐作用，他們的結(jié)合成為了決策支持系統(tǒng)研究的熱點和重點。本文回顧了數(shù)據(jù)倉庫的結(jié)構(gòu)、數(shù)據(jù)組織及相關(guān)技術(shù)的發(fā)展，對基于數(shù)據(jù)倉庫的決策支持系統(tǒng)體系結(jié)構(gòu)的理論與難點進(jìn)行了分析，并對其中的設(shè)計方法、實施策略等數(shù)據(jù)倉庫建設(shè)方面的關(guān)鍵問題進(jìn)行研究。通過對系統(tǒng)的分析和設(shè)計，提出了符合高職教務(wù)管理實際的數(shù)據(jù)倉庫設(shè)計和實施方案。成功解決了在數(shù)據(jù)分散、數(shù)據(jù)量大、基礎(chǔ)環(huán)境復(fù)雜的環(huán)境中數(shù)據(jù)抽取的問題，并對得到的數(shù)據(jù)進(jìn)行轉(zhuǎn)換和清洗，將數(shù)據(jù)加載到預(yù)先定義好的數(shù)據(jù)倉庫模型中。最后以決策需求為基礎(chǔ)，從業(yè)務(wù)分析的角度作為切入點，選用 SQL Server 2022 構(gòu)建數(shù)據(jù)倉庫，選用 Analysis Services 2022 對 OLAP 應(yīng)用進(jìn)行實現(xiàn)。通過本課題研究的工作，建設(shè)了科學(xué)合理的高職教務(wù)管理數(shù)據(jù)倉庫，有效地促進(jìn)了高職信息化的發(fā)展和數(shù)據(jù)的綜合運用能力，使得高職管理和決策的合理性和科學(xué)性得到了增強(qiáng)，具有非常現(xiàn)實的意義。關(guān)鍵詞：數(shù)據(jù)倉庫；決策支持系統(tǒng)；教務(wù)管理II / 40AbstractThe Design and Implementation of An Teaching Management System Based on Data WarehouseWith the widespread use of the database system, the scale of data is increasing rapidly, it’s very important that we can extract effective information from a large number of plex business data. In the view of the current development trends, the focus of data processing has developed from the traditional business process to the progressive extension of the business data online analytical processing, and to obtain information for statistical decisionmaking support system will therefore be shipped. Data warehouse technology has been developed for many years, it bee more mature in recent years, there has been the system that based on data warehouse ,online analytical processing application (OLAP) and data mining tools, it short for decision support system (DSS). Data warehouse, online analytical processing and data mining technology, decisionmaking support system has played a strong supporting role, and their bination into a decision support system bees the focus and emphasis of the study. This paper reviews the structure of the data warehouse, data anization and related technology development, Data warehousebased decision support system architecture and the difficulties of the theory are analyzed, and one of the design method, implementation strategy the key to building the data warehouse issues. Through systematic analysis and design meet the Educational Administration proposed the actual data warehouse design and implementation. Successfully resolved in the data dispersion, data volume, plex environments based on environmental issues in the data extraction, conversion and data obtained and cleaning, to load data into predefined data warehouse model. Finally, decisionmaking needs, based on analysis from a business point of view as a starting point, the choice of SQL Server 2022 to build a data warehouse, use Analysis Services 2022 OLAP applications realized. We have built a scientific and rational educational administration data warehouse through this research work, and promoted the development of university information and data on the integrated use of capabilities effectively. The rationality and scientificalness of the University management and decisionmaking have been enhanced, The research is with very real sense. Key words： Data warehouse, Decision Support System, Teaching ManagementI / 40目 錄摘 要 ..................................................................IABSTRACT .................................................................II目 錄 ..................................................................I第 1 章　 緒 論 ..........................................................1 選題背景及意義 .......................................................1 國內(nèi)外發(fā)展現(xiàn)狀 .......................................................2 論文研究內(nèi)容及意義 ...................................................4 論文安排 .............................................................5第 2 章　 教務(wù)決策支持系統(tǒng)的需求分析 ........................................6 項目情況分析 .........................................................6 項目難點分析 .........................................................8第 3 章　 教務(wù)決策支持系統(tǒng)的設(shè)計 ...........................................10 系統(tǒng)總體框架設(shè)計 ....................................................10 多維數(shù)據(jù)集創(chuàng)建 ..................................................10 數(shù)據(jù)采集模塊 ....................................................10 系統(tǒng)開發(fā)模塊 ....................................................10 數(shù)據(jù)倉庫的設(shè)計 ..................................................11 數(shù)據(jù)倉庫方案設(shè)計 ....................................................13 自底向上法 ......................................................13 自頂向下法 ......................................................13 混合法 ..........................................................13 數(shù)據(jù)倉庫架構(gòu)結(jié)構(gòu) ....................................................14第 4 章　 基于數(shù)據(jù)倉庫的教務(wù)決策支持系統(tǒng)實施 ...............................16 業(yè)務(wù)模型的分析 ......................................................17 業(yè)務(wù)模型與關(guān)系模型的映射 ............................................19 數(shù)據(jù)倉庫的建設(shè) ......................................................20 維表 ............................................................20 事實表 ..........................................................22 數(shù)據(jù)的抽取、轉(zhuǎn)換和裝載 .............................................26 OLAP 應(yīng)用程序的開發(fā) .................................................26 分析立方體的建立 ................................................27 分析立方體的簡單使用 ............................................27 基于 Web 的 OLAP 應(yīng)用程序設(shè)計 .....................................28第 5 章 結(jié)論與展望 ...............