资源描述：
《data warehouse--计算机英语论文翻译毕业设计3》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。
1、DATAWAREHOUSEDatawarehousingprovidesarchitecturesandtoolsforbusinessexecutivestosystematicallyorganize,understand,andusetheirdatatomakestrategicdecisions.Alargenumberoforganizationshavefoundthatdatawarehousesystemsarevaluabletoolsintoday'scompetitive,f
2、astevolvingworld.Inthelastseveralyears,manyfirmshavespentmillionsofdollarsinbuildingenterprise-widedatawarehouses.Manypeoplefeelthatwithcompetitionmountingineveryindustry,datawarehousingisthelatestmust-havemarketingweapon——awaytokeepcustomersbylearning
3、moreabouttheirneeds.“So",youmayask,fullofintrigue,“whatexactlyisadatawarehouse?"Datawarehouseshavebeendefinedinmanyways,makingitdifficulttoformulatearigorousdefinition.Looselyspeaking,adatawarehousereferstoadatabasethatismaintainedseparatelyfromanorgan
4、ization'soperationaldatabases.Datawarehousesystemsallowfortheintegrationofavarietyofapplicationsystems.Theysupportinformationprocessingbyprovidingasolidplatformofconsolidated,historicaldataforanalysis.AccordingtoW.H.Inmon,aleadingarchitectintheconstruc
5、tionofdatawarehousesystems,“adatawarehouseisasubject-oriented,integrated,time-variant,andnonvolatilecollectionofdatainsupportofmanagement'sdecisionmakingprocess."Thisshort,butcomprehensivedefinitionpresentsthemajorfeaturesofadatawarehouse.Thefourkeywor
6、ds,subject-oriented,integrated,time-variant,andnonvolatile,distinguishdatawarehousesfromotherdatarepositorysystems,suchasrelationaldatabasesystems,transactionprocessingsystems,andfilesystems.Let'stakeacloserlookateachofthesekeyfeatures.(1)Subject-orien
7、ted:Adatawarehouseisorganizedaroundmajorsubjects,suchascustomer,vendor,product,andsales.Ratherthanconcentratingontheday-to-dayoperationsandtransactionprocessingofanorganization,adatawarehousefocusesonthemodelingandanalysisofdatafordecisionmakers.Hence,
8、datawarehousestypicallyprovideasimpleandconciseviewaroundparticularsubjectissuesbyexcludingdatathatarenotusefulinthedecisionsupportprocess.(2)Integrated:Adatawarehouseisusuallyconstructedbyintegratingmultipleheterogeneoussources,suchasr
