銀行企業(yè)數(shù)據(jù)倉庫中數(shù)據(jù)模型設計的研究.pdf

1、華南理工大學碩士學位論文銀行企業(yè)數(shù)據(jù)倉庫中數(shù)據(jù)模型設計的研究姓名：陳厲周申請學位級別：碩士專業(yè)：計算機系統(tǒng)結構指導教師：姚耀文20050501AbstractDatadesignisthemostimportantstepinconstructingoneenterprisedatawarehouseItisacomplexlongtermandcombinesvariousdatadesigntechnologieswithdatad

2、esignapproachThequerytype，querydetaillevel，queryefficiencyandresponsetimedependonthequalityofdatadesignItcanbesaidthatthedatamodelisthefatefulelementinenterprisedatawarehouseFirstly，allentiredataarchitectureanddataflowof

3、enterprisedatawarehouseiSdesignedCombiningtheadvantageoflogical—drivenapproachwiththeadvantageofthephysicaldrivenapproach，weutilizethehybridapproachtomanagethegenerationandchangesofdatamodelOnthebasisofusingtheincrementa

4、literativedesignapproach，theprocessofmappingbetweentheIFFfiletotheconceptualmodelanddoingtheETLdesignandconstructioncanbedoneinparalleltoimprovethedesignpaceofdevelopmentSecondly，entiredataarchitectureofdatamartsandmulti

5、dimensionaldatamodelaredesigned，Weputforwardeffectivesolutionsofsomekeydesignofdatamodelinganddimensionmodelconstructing，suchasheterogeneousproducts，slowlychangingdimensionsanddrillthrou曲queryThirdly，consideringtheclassi

6、ficationsandcharacteristicsofmetadatainbankenterprisedatawarehouse，weputforwardthesolutionformetadatadesignandimplementationincludingdetaildesign，dataextract，datastoragestrategyanddataapplicationThesuccessfulapplicationo