资源描述:
《数据仓库(外文翻译)》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、DATAWAREHOUSEDatawarehousingprovidesarchitecturesandtoolsforbusinessexecutivestosystematicallyorganize,understand,andusetheirdatatomakestrategicdecisions.Alargenumberoforganizationshavefoundthatdatawarehousesystemsarevaluabletoolsintoday'scompetitive,fastevolvingworld.Inthelastseveralyears,ma
2、nyfirmshavespentmillionsofdollarsinbuildingenterprise-widedatawarehouses.Manypeoplefeelthatwithcompetitionmountingineveryindustry,datawarehousingisthelatestmust-havemarketingweapon——awaytokeepcustomersbylearningmoreabouttheirneeds.“So",youmayask,fullofintrigue,“whatexactlyisadatawarehouse?"Da
3、tawarehouseshavebeendefinedinmanyways,makingitdifficulttoformulatearigorousdefinition.Looselyspeaking,adatawarehousereferstoadatabasethatismaintainedseparatelyfromanorganization'soperationaldatabases.Datawarehousesystemsallowfortheintegrationofavarietyofapplicationsystems.Theysupportinformati
4、onprocessingbyprovidingasolidplatformofconsolidated,historicaldataforanalysis.AccordingtoW.H.Inmon,aleadingarchitectintheconstructionofdatawarehousesystems,“adatawarehouseisasubject-oriented,integrated,time-variant,andnonvolatilecollectionofdatainsupportofmanagement'sdecisionmakingprocess."Th
5、isshort,butcomprehensivedefinitionpresentsthemajorfeaturesofadatawarehouse.Thefourkeywords,subject-oriented,integrated,time-variant,andnonvolatile,distinguishdatawarehousesfromotherdatarepositorysystems,suchasrelationaldatabasesystems,transactionprocessingsystems,andfilesystems.Let'stakeaclos
6、erlookateachofthesekeyfeatures.(1).Subject-oriented:Adatawarehouseisorganizedaroundmajorsubjects,suchascustomer,vendor,product,andsales.Ratherthanconcentratingontheday-to-dayoperationsandtransactionprocessingofanorganization,adatawarehousefocusesonthemodelingandanalysisofdatafordecisionmakers
7、.Hence,datawarehousestypicallyprovideasimpleandconciseviewaroundparticularsubjectissuesbyexcludingdatathatarenotusefulinthedecisionsupportprocess.(2)Integrated:Adatawarehouseisusuallyconstructedbyintegratingmultipleheterogeneoussources,suchas