【正文】 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 國(guó)內(nèi)外發(fā)展現(xiàn)狀 .......................................................2 論文研究?jī)?nèi)容及意義 ...................................................4 論文安排 .............................................................5第 2 章　 教務(wù)決策支持系統(tǒng)的需求分析 ........................................6 項(xiàng)目情況分析 .........................................................6 項(xiàng)目難點(diǎn)分析 .........................................................8第 3 章　 教務(wù)決策支持系統(tǒng)的設(shè)計(jì) ...........................................10 系統(tǒng)總體框架設(shè)計(jì) ....................................................10 多維數(shù)據(jù)集創(chuàng)建 ..................................................10 數(shù)據(jù)采集模塊 ....................................................10 系統(tǒng)開(kāi)發(fā)模塊 ....................................................10 數(shù)據(jù)倉(cāng)庫(kù)的設(shè)計(jì) ..................................................11 數(shù)據(jù)倉(cāng)庫(kù)方案設(shè)計(jì) ....................................................13 自底向上法 ......................................................13 自頂向下法 ......................................................13 混合法 ..........................................................13 數(shù)據(jù)倉(cāng)庫(kù)架構(gòu)結(jié)構(gòu) ....................................................14第 4 章　 基于數(shù)據(jù)倉(cāng)庫(kù)的教務(wù)決策支持系統(tǒng)實(shí)施 ...............................16 業(yè)務(wù)模型的分析 ......................................................17 業(yè)務(wù)模型與關(guān)系模型的映射 ............................................19 數(shù)據(jù)倉(cāng)庫(kù)的建設(shè) ......................................................20 維表 ............................................................20 事實(shí)表 ..........................................................22 數(shù)據(jù)的抽取、轉(zhuǎn)換和裝載 .............................................26 OLAP 應(yīng)用程序的開(kāi)發(fā) .................................................26 分析立方體的建立 ................................................27 分析立方體的簡(jiǎn)單使用 ............................................27 基于 Web 的 OLAP 應(yīng)用程序設(shè)計(jì) .....................................28第 5 章 結(jié)論與展望 ........................................................30參考文獻(xiàn) .................................................................32II / 40致 謝 .................................................................341 / 40第 1 章　緒 論 選題背景及意義教務(wù)管理工作作為高等學(xué)校教學(xué)管理的核心工作，負(fù)責(zé)學(xué)生的學(xué)位管理、成績(jī)管理、學(xué)籍管理；具體指導(dǎo)校教學(xué)督導(dǎo)組的工作擔(dān)負(fù)教室調(diào)度、全校的排課、全校日常教學(xué)的動(dòng)態(tài)管理，組織各院、系、教學(xué)部(室)的教學(xué)評(píng)估；組織各學(xué)院、研究所制定各專業(yè)的教學(xué)大綱、教學(xué)計(jì)劃、培養(yǎng)方案，編制每學(xué)期的開(kāi)課計(jì)劃，檢查執(zhí)行情況；與各個(gè)學(xué)院和相關(guān)部門配合，對(duì)學(xué)生的社會(huì)實(shí)踐、實(shí)習(xí)、生產(chǎn)勞動(dòng)進(jìn)行安排，這些工作即瑣碎又繁雜。通過(guò)對(duì)系統(tǒng)的分析和設(shè)計(jì)，提出了符合高職教務(wù)管理實(shí)際的數(shù)據(jù)倉(cāng)庫(kù)設(shè)計(jì)和實(shí)施方案。從當(dāng)前的發(fā)展趨勢(shì)上看，數(shù)據(jù)處理的側(cè)重點(diǎn)己從傳統(tǒng)的業(yè)務(wù)過(guò)程的實(shí)現(xiàn)逐步擴(kuò)展到對(duì)業(yè)務(wù)數(shù)據(jù)的聯(lián)機(jī)分析處理，并從中得到用于統(tǒng)計(jì)和決策的信息，因此決策支持系統(tǒng)便應(yīng)運(yùn)而生。數(shù)據(jù)倉(cāng)庫(kù)技術(shù)經(jīng)過(guò)多年的發(fā)展，已變得比較成熟，近些年，出現(xiàn)了基于數(shù)據(jù)倉(cāng)庫(kù)技術(shù)，并運(yùn)用聯(lián)機(jī)分析處理技術(shù)(OLAP)和數(shù)據(jù)挖掘工具的決策支持系統(tǒng)(DSS)。成功解決了在數(shù)據(jù)分散、數(shù)據(jù)量大、基礎(chǔ)環(huán)境復(fù)雜的環(huán)境中數(shù)據(jù)抽取的問(wèn)題，并對(duì)得到的數(shù)據(jù)進(jìn)行轉(zhuǎn)換和清洗，將數(shù)據(jù)加載到預(yù)先定義好的數(shù)據(jù)倉(cāng)庫(kù)模型中。伴隨著我國(guó)高等教育的深化改革，國(guó)家不斷加大教育投資。正是這種需求的存在，使得教務(wù)管理的系統(tǒng)的開(kāi)發(fā)工作變得尤為迫切，教務(wù)管理系統(tǒng)的開(kāi)發(fā)工作在這一需求的推動(dòng)下，取得了較快發(fā)展，各高職通過(guò)教務(wù)管理的使用，使得教務(wù)管理工作取得了長(zhǎng)足的進(jìn)步，辦公的效率大大提高，工作也變得更加順手，教務(wù)管理系統(tǒng)的應(yīng)用還可以使分散的教務(wù)數(shù)據(jù)得到集中管理，對(duì)提高管理水平、減輕管理負(fù)擔(dān)有很大的幫助。 國(guó)內(nèi)外發(fā)展現(xiàn)狀國(guó)外對(duì)高職管理信息系統(tǒng)的研究工作開(kāi)展得較早，早在上個(gè)世紀(jì)六七十年代，國(guó)外變開(kāi)始了這方