摘要自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需求分析原因......................................