ORACLE数据仓库建设VIP免费

摘要自20世纪90年代以来,计算机技术发展迅猛,各通信商逐步开发出新的BI系统。实现给通信领域提出了充分利用数据仓库技术，将现有的海量数据构造成为可用、可控、可扩展的数据组织,以适应通信领域各级主管和业务人员的分析需要。在本论文中从数据仓库需求分析包括参与成员、各个成员所起到的作用；逻辑模型建设通过软件设计，确定表之间的关系；物理模型建设中对表和过程进行详细的审核，用来支持所提出的需求；数据仓库设计以ODS、DWD、DWA为层次，采用横向分层纵向分域的理念，进行具体的实施建立，并在后期提供了错误的应急措施、数据仓库的维护和优化。关键词：数据仓库，物理模型，维护和优化EnglishabstractSincethenineteenninties,computertechnologyisdevelopingrapidly,thecommunicationbusinessgraduallydevelopedanewBIsystem.Realitytocommunicationfieldispresentedforfullyusingdatawarehousetechnologytoexistingdatastructuresbecomeavailable,controllable,scalabledataorganization,toadapttothefieldofcommunicationatalllevelsofmanagersandbusinessanalysis.Inthispaperfromthedatawarehouserequirementanalysisincludestheparticipationofmembers,eachmemberoftheroleplayedby;logicmodelconstructionthroughsoftwaredesign,todeterminetherelationshipbetweentables;physicalmodelconstructionprocesstableanddetailedaudit,usedtosupporttheproposedrequirement;datawarehousedesignwithODS,DWD,DWAlevels,thehorizontallystratifiedlongitudinaldomainconcept,specificimplementationoftheestablishment,andinlatestageprovideserroremergencymeasures,datawarehousemaintenanceandoptimization.Keywords：datawarehouse,physicalmodel,maintenanceandoptimization目录第一章数据仓库概述.............................................................................................................11.1本论文采用数据仓库的目的.........................................................................................11.2数据仓库的定义和特点.................................................................................................11.3数据仓库与数据库.........................................................................................................21.5元数据............................................................................................................................31.5.1技术元数据.............................................................................................................31.5.2业务元数据.............................................................................................................31.5.3元数据的作用..........................................................................................................41.6数据仓库发展方向.........................................................................................................51.6.1数据仓库的产生和发展..........................................................................................51.6.2数据仓库发展趋势..................................................................................................71.6.3数据集市、集市群—行业的发展方向..................................................................81.6.4基于Internet2、光处理器计算机和GGG技术的DW.........................................111.7建设数据仓库的必要性...............................................................................................14第二章数据仓库需求分析...................................................................................................152.1需求分析原因......................................