mda方法在etl技術中的研究與應用

1、大連交通大學碩士學位論文MDA方法在ETL技術中的研究與應用姓名：閆曉嵐申請學位級別：碩士專業(yè)：計算機應用技術指導教師：宋旭東20091222人連交通人學T學碩：學f眵論文AbstractInformationiSoneofthemostimportantresourcesforEnterpriseswhichiSthebasisofscientificmanagementdecisionmakingandanalysisThetrad

2、itionaltransactionorientedbusinessssystemarealwaysinaquateonhowtousetheseinformationwhileaccumulatingdataDataWarehouse(Dw)isasystembasedonthebusinesssinvolved，desigedtohelpusertotakefulladventageofthevaluableinformationr

3、esourcesandmakerightdecisionsAmongservalcomponentsinDW，theperformanceofE]rListhekeyfactorofthesuccessfullyimplementingtheDWsystemDevelopingtheETLisalsothemosttimeconsumingandworkconsumingpartofthewholedevelopmentofDWHowe

4、vertherearealwaysseveralproblemsinpresentETLtools，themosttypicallyisfailedtocompletebetweentheETLandothercomponentsofDWinconceptuallevelthoughtheyareverypowerfulToovercometheproblem，thispaperpresentstheMDAfModelDriyenArc

5、hitecture)methodusedinthedesignanddevelopmentoftheETLInthispaper，theMDAisappliedinETLtechnology；weputforwardtheDWdevelopmentframeworkbasedonMD八thenwiththehelpofUMLprofileandCommonWarehouseMetamodel，modelPIM(PlatformIndep

6、endentModel)modelandPSM(PlatformSpecificModel)modelandusetheQVT(Query／View／Transformation)specificationoftheRelationlanguagedefinethetransfcIrmationbetween011PIMandPSMofETLAndimplementthistransformationintheopensourcetoo

7、l—mediniQVTMoreover，implementstransformationfromPSMtoSQLunderEMF(EclipseModelingFramework)iswhichpresentedbyIBMThereby，tealizeamodeldrivendevelopmentprocessbasedonthemodelInthisway，thedesignofE11Lcanbespecifiedintheearly

8、stagesofaDWproject，thusreducingthedevelopmenttimeandcostAndapplythismethodonordersaleofanironandsteelenterpriseItindicatesthatthemethodinthepaperincreasetheefficiencyofSystemDevelopmentcomparestothetraditionalmethodThere