一種ETL應(yīng)用的自動化開發(fā)及部署框架.pdf

1、ADissertationSubmittedtoZhejiangUniversityfortheDegreeofUnlVerS1tV士OrtneUegreeO士MasterofEngineeringAuthor：叢△Q：!至壘n堡ing3uperVlsor：L』I≥壘魚墜衛(wèi)三ng，、TT^‘Subject：△墜衛(wèi)至i金魚gQ匹衛(wèi)墮主金￡!金QhnQ王QgYCol1ege：QQ迅衛(wèi)墜主金￡SQi金aQ金SubmittedDate：I壘n墜

2、壘￡Y墨，2Q!!AbsITactAbstractThepast伽odecadesI扭vebeenabloomiIlgageofinfonnationtechnologyWi也iIlcre嬲iIlgm砷ur時ofbotllthehltemct鋤dtllek畎h，乏職l／softwareofcomputcrsuIldert11eMoore，sLaw；ith嬲leadmostmdllstriesimoan抽fomlational鋤delec

3、tricwayofoperalingmaIlllerMassive螄ly仃anSactionalin】F0nI]嘶onh舔beengenerateda11d喲rediIl恤process證gsystemsa11dareeVen印噸explosiVely邪t11edaysp鵲sbynhasbecomeanu】喀entrese缸chsu巧ectforITe)【pertsonhowt0仃allsla：tet11eVaStin|’omation

4、t0hum觚一sensibleknowledgef0I。buSillessmallag鋤ent，e位CtivelyBuskssIntelligence(BI)，DataWarehouSe(D聊鋤dDataMiI血jg撇conce呻nlatbeiIlgproposedunder蚰chsceI嘶osETL(Ex仃毗Transfo衄觚dLo鋤，is也ehean趾dsoulofaBIsystemAnETLprocessIIsuallyex仃ac

5、tsllistoricalda：ta丘’omⅡledailybusinesssyStem，仃aIlsfomlsthemiIltosomecertaillSchem如and10“bmemt0aDa：ca‰housewithpre—defmedschemaThedownStreamsystemsc觚perfomqlleriesandanalysisbausedonmeDW：nisgenerallyrecogmzedmatdesi印ingan

6、ddevelopingETLprocesses0ccupies60t080perc鋤曬ofatotalBIprojectnisof伊eatsig碰cancet0leVeragemee伍ciencyofsuchwIDrksTKsp印erpr0Videst、帕approachestllatcaIl油provet11ee街ciencyofcanyingoutETLprojectSononehand，itdesignSaIldiInplemem

7、sa丘鋤eworknlatc趾helpthedeveloperswim咎殂cra：tingt_heETLjobs自omrequirememdocmnentS，automaticallyOntheot：her：I姍d，itresearChesonthed印lo舯entprocessofanETLprocessndiscusses也eCu盯即tdeploymentprocessofETL印plicationS，鋤myZestllemains

8、hortagesaIld缸allyShowsnledesigna芏ldiIIlplementationof勰automa：tedd印loyment矗鋤e、Ⅳork，w11ichgreanycurtailstlle吐me齜ldreducest11ecomplexi夠ofthed印10ymentprocess，alsot：heentiledeVelopmentofETLapplicatioIlsnpr0Vesp粕cticala盤er印pli