【财务-ORACLE】ORACLE数据仓库建设.pdf

ORACLE 数据仓库建 设 摘 要 自20 世纪 90 年代以来,计算机技术发展迅猛,各通信商逐步开发出新的 BI 系统。实现给通信领域提出了充分利用数据仓库技术，将现有的海量数据构造成 为可用、可控、可扩展的数据组织, 以适应通信领域各级主管和业务人员的分析 需要。 在本论文中从数据仓库需求分析包括参与成员、各个成员所起到的作用；逻 辑模型建设通过软件设计，确定表之间的关系；物理模型建设中对表和过程进行 详细的审核，用来支持所提出的需求；数据仓库设计以 ODS、DWD 、DWA 为 层次，采用横向分层纵向分域的理念，进行具体的实施建立，并在后期提供了错 误的应急措施、数据仓库的维护和优化。 关键词： 数据仓库，物理模型，维护和优化 English abstract Since the nineteen ninties, computer technology is developing rapidly, the communication business gradually developed a new BI system. Reality to communication field is presented for fully using data warehouse technology to existing data structures become available, controllable, scalable data organization, to adapt to the field of communication at all levels of managers and business analysis. In this paper from the data warehouse requirement analysis includes the participation of members, each member of the role played by; logic model construction through software design, to determine the relationship between tables; physical model construction process table and detailed audit, used to support the proposed requirement; data warehouse design with ODS, DWD, DWA levels, the horizontally stratified longitudinal domain concept, specific implementation of the establishment, and in late stage provides error emergency measures, data warehouse maintenance and optimization. Keywords ： data warehouse, physical model, maintenance and optimization 目录 第一章 数据仓库概述0 1.1 本论文采用数据仓库的目的0 1.2 数据仓库的定义和特点0 1.3 数据仓库与数据库1 1.5 元数据2 1.5.1 技术元数据2 1.5.2 业务元数据2 1.5.3 元数据的作用3