资源描述：
《data warehouse--计算机英语论文翻译毕业设计3》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。
1、DATAWAREHOUSEDatawarehousingprovidesarchitecturesandtoolsforbusinessexecutivestosystematicallyorganize,understand,andusetheirdatatomakestrategicdecisions.Alargenumberoforganizationshavefoundthatdatawarehousesystemsarevaluabletoolsintoday'scompetitive,fastevolvi
2、ngworld.Inthelastseveralyears,manyfirmshavespentmillionsofdollarsinbuildingenterprise-widedatawarehouses.Manypeoplefeelthatwithcompetitionmountingineveryindustry,datawarehousingisthelatestmust-havemarketingweapon——awaytokeepcustomersbylearningmoreabouttheirneed
3、s.“So",youmayask,fullofintrigue,“whatexactlyisadatawarehouse?"Datawarehouseshavebeendefinedinmanyways,makingitdifficulttoformulatearigorousdefinition.Looselyspeaking,adatawarehousereferstoadatabasethatismaintainedseparatelyfromanorganization'soperationaldatabas
4、es.Datawarehousesystemsallowfortheintegrationofavarietyofapplicationsystems.Theysupportinformationprocessingbyprovidingasolidplatformofconsolidated,historicaldataforanalysis.AccordingtoW.H.Inmon,aleadingarchitectintheconstructionofdatawarehousesystems,“adatawar
5、ehouseisasubject-oriented,integrated,time-variant,andnonvolatilecollectionofdatainsupportofmanagement'sdecisionmakingprocess."Thisshort,butcomprehensivedefinitionpresentsthemajorfeaturesofadatawarehouse.Thefourkeywords,subject-oriented,integrated,time-variant,a
6、ndnonvolatile,distinguishdatawarehousesfromotherdatarepositorysystems,suchasrelationaldatabasesystems,transactionprocessingsystems,andfilesystems.Let'stakeacloserlookateachofthesekeyfeatures.(1)Subject-oriented:Adatawarehouseisorganizedaroundmajorsubjects,sucha
7、scustomer,vendor,product,andsales.Ratherthanconcentratingontheday-to-dayoperationsandtransactionprocessingofanorganization,adatawarehousefocusesonthemodelingandanalysisofdatafordecisionmakers.Hence,datawarehousestypicallyprovideasimpleandconciseviewaroundpartic
8、ularsubjectissuesbyexcludingdatathatarenotusefulinthedecisionsupportprocess.(2)Integrated:Adatawarehouseisusuallyconstructedbyintegratingmultipleheterogeneoussources,suchasr
