动车组维修决策系统数据仓库的研究与应用

《动车组维修决策系统数据仓库的研究与应用》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、北京交通大学硕士学位论文动车组维修决策系统数据仓库的研究与应用姓名：赵虹申请学位级别：硕士专业：计算机科学与技术指导教师：张春20090601北京交通大学硕士学位论文ABSTRACTABSTRACT：Atpresent,therearetwoproblemsofEMUmaintenancedecision-making：First,whileapplyingseveraldifferentinformationsystems，decision-makingstuffscouldonlyrelyonmanpowertointegrateinformationfromdifferentsys

2、tems；Second，alargeanaountofhistoricaldataisaccumulatedindependentlyinthedatabasesystemduringtheprocessofinformationsystemapplication，andcouldnotbeconvertedintovaluableinformation．Inthisthesis，datawarehouseandOLAPtechnologyisintroducedintoconstructionofEMUtobuildadecisionsupportsystem，whichcouldin

3、tegratedataeffectively,makeuseofdatasufficiently,displayrepairparts，maintenanceinformation，faultrecordsandrelateddatatohelphumantomakefinaldecision．Inthispaper,dataorganizationofallkindsofexistinginformationsystemsofEMUandbusinessprocessesisanalyzed，atthesametime,stateanalysisofEMUkeycomponents，m

4、aintenanceanalysis，failurestatisticanalysisandmaintenanceanalysisareidentified，whilecombinedwithmulti·dimensionaltheory,logicalmulti-dimensionalmodelisdesigned．Duringphysicalmodelsdesigningprocess，thispaperdesignsstoragestructure，dimensiontablesandfacttables，anddiscussesthepossibilitiestooptimize

5、theperformanceofsystembasedonzoningandindexingtechnology．·Inthispaper,three-modeofdatawarehouse—·OLAP·-BIsystemWasadoptedtoconvertdatatoknowledge．AccordingtothetheoryofETLprocessofdatawarehouseandOLAPcube，sourcedataiSconvertedtomulti-dimensionalmodel，andthenconvertedtodatacubestructure，andfinally

6、displayedthroughBIEEperformancelayer、Ⅳinltheformatofdatareportandanalysismap．Three-tiermodelofWarehousebuilder109，OLAPlOgandBIEEdevelopmentplatformisusedduringthedevelopmentprocess．EMUmaintenancedecision-makingsystemincludingthreeparts，datawarehouse，OLAPcubeandfront-endinterfaceofBIEEthatoredesig

7、nedbythispaperiscompletedbyrealdataofEMU．Thesystemfunctionswerepreliminarytestedandperformedcorrect．Itwillbeexpectedtoprovidemaintenancedecision-makingstuffswitheffectiveinformationsupporting．KEYWORDS：EMU；DataWarehouse