电信行业etl系统的分析设计与实现

《电信行业etl系统的分析设计与实现》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、TiUe：Major：N锄e：Supervisor：ResearchandDesi印oftheETLSyStemofTelecomIndusnySof融areEn西neerh喀DongⅥ胁ⅥY抽g(AssocialePfofesSor)ABSTRACT111erapiddevelopmentandapplicationofcomputer觚dne柳orktecllIlologyhaSprovidedenterprisesvast锄ountsofCIa_taresources，Wtlichconstitutea

2、Valuableassetoftheente叫se．However，systems枷ch1ackcommllllicationwitheachotherareofbenunablet0worktogether，aIldtheycannotintegrateandusetheacc啪ulateddatae伍：ctively．Today，morearldmoreente印risesarebuildingda：tawa肥housest0meet恤irdecision．m越ngrequir锄ent．Therefore

3、medatacollectedorgeneratedby砌ependentsystemsShouldbeintegrated．AsaIlinte伊ationsolutionofbuildingdatawarehouse，ETLprocedureprovidesservicesthatex仃acting(E)data舶mdatasources，cle撕ngaIld仃ansfoming(T)d砒aIldloading(L)dataintothetargetdataⅥ瑁‘re量louse．Firstly'mispa

4、pergivesabriefin舡oductionaboutthebasicconc印tofETLprocedure，t11eresearchsta：tusofETLa11ditssigmficancetomeindus仃y．Secondly’蛾anETLup铲adingprojectofteko㈣ications酞lus蚵as馈lebackground，仕Iep印ershowsatop·dowrIlaIldst印wiserefinedaIlalysisandaIlobject。orientedUML．bas

5、edvisualmodeling．7111irmy，accordingtotherequirementofthesystem，wegive也edesi萨of也esyste啦arcKtecture，thedesignofpfocess雒d也edesi莎ofkeymodel，aIldpresemadetaileddesignofthesystembaSedonthem．Fo删y，weimplementtheETLsystem．Withcharacteristicsofobject-oriented，1ikeirl

6、lleritallce，p01ymo印msmandsoon，thesystemhaSacleararchitecture．Fi矗hly，证lisp印erpresentsthenl血ng．tiIlleinte舭eoftheETLsystemandthecon觚tbe骶饥itaIldtlleoldone．Inmetestenvironment，theefficiencyinthenewsystemisslightlylo、ver仕姗the01done，butitmeetsthesystemrequirements

7、aIldhaSgoodplatfo硼independence．Finally，wedrawaconclusioninthemobilepaymentsystem，aIldmal【eaforecaStonthemobilepaymentservicesand如tureresearclling．Beforeup铲ading，theSystemistooprofessioI“tooperatebecauseitisimplementedinC++andnlebusiness109icofETLprocedureis

8、directlycodingintheprograIn．7111isp印erin仃oducesanode-caChe仃a11sf．o肌ingmodel，Whichbreaksdownmebusiness109icofETLprocedureintonodesandETLprocedureisexecutedinthenode．cachemodel．T11enodesarecompiledintoby