Moodle教学平台客户端的设计与实现

摘要论文题目：Moodle教学平台客户端的设计与实现学生姓名：指导教师：摘要数据仓库是决策支持系统和联机分析应用数据源的结构化数据环境。数据仓库研究和解决从数据库中获取信息的问题。数据仓库的特征在于面向主题、集成性、稳定性和时变性。数据仓库是集成的，数据仓库的数据有来自于分散的操作型数据，将所需数据从原来的数据中抽取出数据仓库的核心工具来，进行加工与集成，统一与综合之后才能进入数据仓库；数据仓库中的数据是在对原有分散的数据库数据抽取、清理的基础上经过系统加工、汇总和整理得到的，必须消除源数据中的不一致性，以保证数据仓库内的信息是关于整个企业的一致的全局信息。数据仓库系统是一个信息提供平台，他从业务处理系统获得数据，主要以星型模型和雪花模型进行数据组织，并为用户提供各种手段从数据中获取信息和知识。从功能结构划分，数据仓库系统至少应该包含数据获取、数据存储、数据访问三个关键部分。根据题目的要求，掌握数据预处理技术，对应数据获取部分；掌握数据立方体建立方法对应数据存储部分；掌握olap操作对应数据访问部分。本文将以此为依据，逐步设计moodle教学平台数据仓库并实现。关键词：数据仓库；数据预处理技术；数据立方体；OLAP操作西安交通大学本科毕业设计（论文）IITitle:Moodlelearningplatformdatawarehousedesignandimplementationname:Supervisor:ABSTRACTDatawarehouseenvironmentisstructureddataanalysisdecisionsupportsystemapplicationsandonlinedatasources.DataWarehousingresearchandobtaininformationfromthedatabasetosolveaproblem.Datawarehouseischaracterizedbyasubject-oriented,integrated,stabilityandtimevariability.Adatawarehouseisintegrated,datawarehousehavedispersedfromtheoperationaldata,extracttherequireddatafromtheoriginaldatainacentraldatawarehousetools,processingandintegration,unityandthenintegratedintothedatawarehouseto;Datainthedatawarehouseisdispersedintheoriginaldatabasedataextraction,clean-upthroughthesystemonthebasisofprocessing,aggregationandconsolidationwasnecessarytoeliminateinconsistenciesinthesourcedatatoensurethattheinformationwithinthedatawarehouseisabouttheentireenterpriseconsistentglobalinformation.Datawarehousesystemisaninformationdeliveryplatform,heobtainedthedatafromthebusinessprocessingsystem,mainlysnowflakestarmodelandmodeldataorganization,andtoprovideuserswithavarietyofmeanstoobtaininformationandknowledgefromthedata.Functionalstructureisdividedfromthedatawarehousesystemshouldatleastcontaindataacquisition,datastorage,dataaccess,threekeyparts.Accordingtotherequirementsofthesubject,masterdatapreprocessingtechniques,thecorrespondingdataacquisitionsection;masterdatacubemethodofestablishingthecorrespondingdatastoragesection;masterolapoperationcorrespondstothedataaccesspart.Thisarticlewillusethisasthebasis,graduallylearningplatformmoodledatawarehousedesignandimplementation.Keywords:datawarehouse;datapreprocessingtechniques;datacube;OLAPoperations目录目录1.绪论.......................................................................................................................................51.1课题背景........................................................................................................................51.2研究现状........................................................................................................................71.3作者的主要工作............................................................................................................81.4本文的构成...................................................................................................................82相关技术介绍.......................................................................................................................92.1数据仓库的理论............................................................................................................92.2企业级数据仓库解决方案的架构................................................................................92.3数据仓库的基本数据模型..........................................................................................112.3.1事实表和维表........................................................................................................112.3.2星形模式................................................................................................................122.3.3雪花模式................................................................................................................132.4数据预处理技术........................................................................................................132.4.1数据清理..............................................................................................................132.4.2数据集成................................................................................................................142.4.2数据变换................................................................................................................142.4.2数据规约................................................................................................................142.5OLAP分析...................................................................................................................153系统需求分析.....................................................................................................................163.1总体需求.....................................................................................................................163.1.1数据仓库的建设目标...........................................................................................163.2其他需求.....................................................................................................................174系统设计和逻辑模型设计.................................................................................................184.1数据仓库整体解决方案..........................................