搜索
摘要I摘要基于数据仓库的高职教务管理系统的设计与实现随着数据库系统的广泛应用，数据规模与日俱增，从大量复杂的业务数据中更加有效的分析提取可用的信息就变得尤为重要。从当前的发展趋势上看，数据处理的侧重点己从传统的业务过程的实现逐步扩展到对业务数据的联机分析处理，并从中得到用于统计和决策的信息，因此决策支持系统便应运而生。数据仓库技术经过多年的发展，已变得比较成熟，近些年，出现了基于数据仓库技术，并运用联机分析处理技术(OLAP)和数据挖掘工具的决策支持系统(DSS)。数据仓库技术、联机分析处理技术和数据挖掘技术的应用，对决策支持系统起到了有力支撑作用，他们的结合成为了决策支持系统研究的热点和重点。本文回顾了数据仓库的结构、数据组织及相关技术的发展，对基于数据仓库的决策支持系统体系结构的理论与难点进行了分析，并对其中的设计方法、实施策略等数据仓库建设方面的关键问题进行研究。通过对系统的分析和设计，提出了符合高职教务管理实际的数据仓库设计和实施方案。成功解决了在数据分散、数据量大、基础环境复杂的环境中数据抽取的问题，并对得到的数据进行转换和清洗，将数据加载到预先定义好的数据仓库模型中。最后以决策需求为基础，从业务分析的角度作为切入点，选用SQLServer2000构建数据仓库，选用AnalysisServices2000对OLAP应用进行实现。通过本课题研究的工作，建设了科学合理的高职教务管理数据仓库，有效地促进了高职信息化的发展和数据的综合运用能力，使得高职管理和决策的合理性和科学性得到了增强，具有非常现实的意义。关键词：数据仓库；决策支持系统；教务管理AbstractIIAbstractTheDesignandImplementationofAnTeachingManagementSystemBasedonDataWarehouseWiththewidespreaduseofthedatabasesystem,thescaleofdataisincreasingrapidly,it’sveryimportantthatwecanextracteffectiveinformationfromalargenumberofcomplexbusinessdata.Intheviewofthecurrentdevelopmenttrends,thefocusofdataprocessinghasdevelopedfromthetraditionalbusinessprocesstotheprogressiveextensionofthebusinessdataon-lineanalyticalprocessing,andtoobtaininformationforstatisticaldecision-makingsupportsystemwillthereforebeshipped.Datawarehousetechnologyhasbeendevelopedformanyyears,itbecomemorematureinrecentyears,therehasbeenthesystemthatbasedondatawarehouse,onlineanalyticalprocessingapplication(OLAP)anddataminingtools,itshortfordecisionsupportsystem(DSS).Datawarehouse,onlineanalyticalprocessinganddataminingtechnology,decision-makingsupportsystemhasplayedastrongsupportingrole,andtheircombinationintoadecisionsupportsystembecomesthefocusandemphasisofthestudy.Thispaperreviewsthestructureofthedatawarehouse,dataorganizationandrelatedtechnologydevelopment,Datawarehouse-baseddecisionsupportsystemarchitectureandthedifficultiesofthetheoryareanalyzed,andoneofthedesignmethod,implementationstrategythekeytobuildingthedatawarehouseissues.ThroughsystematicanalysisanddesignmeettheEducationalAdministrationproposedtheactualdatawarehousedesignandimplementation.Successfullyresolvedinthedatadispersion,datavolume,complexenvironmentsbasedonenvironmentalissuesinthedataextraction,conversionanddataobtainedandcleaning,toloaddataintopredefineddatawarehousemodel.Finally,decision-makingneeds,basedonanalysisfromabusinesspointofviewasastartingpoint,thechoiceofSQLServer2000tobuildadatawarehouse,useAnalysisServices2000OLAPapplicationsrealized.Wehavebuiltascientificandrationaleducationaladministrationdatawarehousethroughthisresearchwork,andpromotedthedevelopmentofuniversityinformationanddataontheintegrateduseofcapabilitieseffectively.TherationalityandscientificalnessoftheUniversitymanagementanddecision-makinghavebeenenhanced,Theresearchiswithveryrealsense.Keywords：Datawarehouse,DecisionSupportSystem,TeachingManagement目录I目录摘要..................................................................IABSTRACT.................................................................II目录..................................................................I第1章绪论..........................................................11.1选题背景及意义......................................................11.2国内外发展现状......................................................21.3论文研究内容及意义..................................................41.4论文安排............................................................5第2章教务决策支持系统的需求分析........................................62.1项目情况分析........................................................62.2项目难点分析........................................................8第3章教务决策支持系统的设计...........................................103.1系统总体框架设计...................................................103.1.1多维数据集创建..................................................103.1.2数据采集模块....................................................103.1.3系统开发模块....................................................103.1.4数据仓库的设计..................................................113.2数据仓库方案设计...................................................133.2.1自底向上法......................................................133.2.2自顶向下法......................................................133.2.3混合法..........................................................133.3数据仓库架构结构...................................................14第4章基于数据仓库的教务决策支持系统实施...............................164.1业务模型的分析.....................................................174.2业务模型与关系模型的映射...........................................194.3数据仓库的建设.....................................................204.3.1维表............................................................204.3.2事实表..........................................................224.4数据的抽取、转换和装载.............................................264.5OLAP应用程序的开发................................................264.5.1分析立方体的建立...............................................274.5.2分析立方体的简单使用...........................................274.5.3基于Web的OLAP应用程序设计.....................................28第5章结论与展望........................................................30参考文献...........