異構環(huán)境下ODS構建技術的研究與實現.pdf

1、沈陽航空工業(yè)學院碩士學位論文異構環(huán)境下ODS構建技術的研究與實現姓名：張悅申請學位級別：碩士專業(yè)：計算機應用技術指導教師：夏秀峰20060101沈陽航空工業(yè)學院碩十學位論文AbstractTwotypesofdataprocessing，operationalprocessingandanalyticalprocessingwereseperatedclearlybydatawarehousing，SOthetwo—levelarchi

2、tectureofDB—DWwascometobringButthetwotypesofdataprocessingarenotentirelydifferentInactualdemandsofuserdataprocessingissometimesmultilevelsinWhichsomeofoperationalprocessingsisnotsuitableforimplementationinoperationaldata

3、base，meanwhile，someofanalyticalprocessingsisnotfitforimplementedbasedondatawarehousSoanewdataenvironmentofOperationalDataStorewasgenerated，andthreelevelarchitectureofDB—ODS—DWwasproducedAfterintroducingtherelatedconcepti

4、onsofODS，such弱definition，characteristics，types，differencesandrelationsamongDB，ODSandDWetc，thisdissertationmainlystudiesonconstructionmethodofODS，definitionofMetadatabuildingofCube，formingofmulti—dimensionsdatareport，stra

5、tegiesofdataupdate，implementationofglobalonlinetransactionprocessing(OLTP)An0DSdataupdatestrategybasedonWANandheterogeneousenvironmentandacurrentmechanismofdataexchangebased011XMLareproposed，andthenthedataconsistencyoftw

6、otypesenvironmentisguaranteedWhileimplementingglobalOLTP，thisdissertationproposestwoupdatealgorithmstoimplementtheglobal0LTPappliedinODSandoperationaldatabasesystem，andthenthereal—timeupdateofolddatahaSbeenrealized，andco

7、nsistencyofglobaldataisensuredODSisamixedstructureofoperationalandanalyticalenvironment，SOitisamorecomplexsystemcomparedwithtraditionalOLTPDBThisdissertationonlystudiesOilseveralkeytechniquesforestablishingandmanagingODS