【正文】 rtant 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é)論與展望 ........................................................30參考文獻(xiàn) .................................................................32II / 40致 謝 .................................................................341 / 40第 1 章　緒 論 選題背景及意義教務(wù)管理工作作為高等學(xué)校教學(xué)管理的核心工作，負(fù)責(zé)學(xué)生的學(xué)位管理、成績管理、學(xué)籍管理；具體指導(dǎo)校教學(xué)督導(dǎo)組的工作擔(dān)負(fù)教室調(diào)度、全校的排課、全校日常教學(xué)的動態(tài)管理，組織各院、系、教學(xué)部(室)的教學(xué)評估；組織各學(xué)院、研究所制定各專業(yè)的教學(xué)大綱、教學(xué)計劃、培養(yǎng)方案，編制每學(xué)期的開課計劃，檢查執(zhí)行情況；與各個學(xué)院和相關(guān)部門配合，對學(xué)生的社會實踐、實習(xí)、生產(chǎn)勞動進(jìn)行安排，這些工作即瑣碎又繁雜。通過對系統(tǒng)的分析和設(shè)計，提出了符合高職教務(wù)管理實際的數(shù)據(jù)倉庫設(shè)計和實施方案。從當(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ù)據(jù)量大、基礎(chǔ)環(huán)境復(fù)雜的環(huán)境中數(shù)據(jù)抽取的問題，并對得到的數(shù)據(jù)進(jìn)行轉(zhuǎn)換和清洗，將數(shù)據(jù)加載到預(yù)先定義好的數(shù)據(jù)倉庫模型中。伴隨著我國高等教育的深化改革，國家不斷加大教育投資。正是這種需求的存在，使得教務(wù)管理的系統(tǒng)的開發(fā)工作變得尤為迫切，教務(wù)管理系統(tǒng)的開發(fā)工作在這一需求的推動下，取得了較快發(fā)展，各高職通過教務(wù)管理的使用，使得教務(wù)管理工作取得了長足的進(jìn)步，辦公的效率大大提高，工作也變得更加順手，教務(wù)管理系統(tǒng)的應(yīng)用還可以使分散的教務(wù)數(shù)據(jù)得到集中管理，對提高管理水平、減輕管理負(fù)擔(dān)有很大的幫助。 國內(nèi)外發(fā)展現(xiàn)狀國外對高職管理信息系統(tǒng)的研究工作開展得較早，早在上個世紀(jì)六七十年代，國外變開始了這方