Oracle WarehouseBuilder用户指南11g Release 1

需积分: 0 139 浏览量更新于2024-07-30 收藏 7.24MB PDF 举报

"Oracle Warehouse Builder User's Guide 11g Release 1 (11.1) B31278-06" Oracle Warehouse Builder 是一个集成的数据仓库构建工具，用于设计、构建和管理数据仓库解决方案。这个用户指南是针对11g Release 1 (11.1)版本的，其文档编号为B31278-06，发布于2009年1月。该指南提供了关于如何有效利用Oracle Warehouse Builder来优化企业数据管理和分析的详细指导。 Oracle Warehouse Builder 主要功能包括： 1. **数据建模**：它支持创建和管理星型和雪花型的数据仓库模式，帮助用户设计复杂的多维业务模型。用户可以定义实体、关系、属性和键，以及进行物理和逻辑数据模型的设计。 2. **ETL（Extract, Transform, Load）工具**：Oracle Warehouse Builder 提供了一套完整的数据抽取、转换和加载工具。用户可以设计和执行数据清理、转换规则、数据映射和工作流，确保从源系统到数据仓库的数据质量。 3. **元数据管理**：它维护了关于数据仓库结构和过程的元数据，这些信息有助于理解和管理整个数据生命周期。元数据的存储和共享促进了跨团队的合作和知识传递。 4. **自动代码生成**：Oracle Warehouse Builder 自动化了PL/SQL代码的生成，如存储过程、触发器和索引，从而减少了开发时间并降低了出错的可能性。 5. **性能优化**：该工具提供了性能监控和调优功能，帮助用户分析数据加载速度和查询效率，以便对数据仓库进行优化。 6. **可视化界面**：Oracle Warehouse Builder 的图形用户界面使得非技术背景的业务用户也能轻松地参与到数据仓库的构建过程中。 7. **版本控制**：它支持版本管理，允许用户跟踪和管理数据仓库项目的变化，便于回滚和协作。 8. **数据安全**：提供角色和权限管理，确保只有授权的用户能够访问和操作数据仓库组件。 9. **集成性**：Oracle Warehouse Builder 可以无缝集成到Oracle数据库、其他Oracle产品以及第三方工具，形成一个完整的数据仓库解决方案。 10. **可扩展性和灵活性**：工具支持不同规模的数据仓库项目，从小型企业到大型企业级实施，都具有良好的适应性。在使用Oracle Warehouse Builder时，用户应遵循文档中的步骤和最佳实践，了解软件许可协议，遵守知识产权法律，并注意软件的错误报告和更新。对于美国政府或其他代理机构，可能还需要遵守特定的使用条款和权利规定。请注意，由于这个用户指南是2009年的版本，因此在使用时可能需要结合最新的版本或更新来获取最新的功能和解决方案。随着技术的发展，Oracle可能会在后续的版本中引入新的特性和改进。

Overview of Oracle Warehouse Builder

1-2 Oracle Warehouse Builder User's Guide

Before loading data into a new data store, you can optionally profile the data to

evaluate its quality and appropriateness. Subsequently, you can match and merge

records using rules that you devise. You can validate name and address data

against postal databases. This process of changing poor quality data into high

quality information is introduced in "About the Data Quality Management

Process" on page 23-1.

■ Ability to implement designs for diverse applications

Using Warehouse Builder, you can design and implement any data store required

by your applications, whether relational or dimensional. The process of designing

your data store is described in "Designing Target Schemas" on page 12-1.

■ Audit trails

After consolidating data from a variety of sources into a single data store, you are

likely to face the challenge of verifying the validity of the output information. For

instance, can you track and verify how a particular number was derived? This is a

question often posed by decision makers within your organization and by

government regulators. The process of accessing deployment and auditing

information is described in "Auditing Deployments and Executions" on page 27-1.

See Also: Oracle Database Licensing Information for details about

options and licensing for Oracle Warehouse Builder

Getting Started with Oracle Warehouse Builder 2-1

2 Getting Started with Oracle Warehouse

Builder

Oracle Warehouse Builder is a flexible tool that enables you to design and deploy

various types of data integration strategies. Projects commonly implemented using

Warehouse Builder involve mission critical operational systems, migration scenarios,

integration of disparate operational systems, and traditional data warehousing. This

chapter provides an introduction to using Warehouse Builder. It provides a starting

point for using Warehouse Builder for the first time user and serves as a road map to

the documentation.

If you have already read the Oracle Database 2 Day + Data Warehousing Guide, you may

recognize some of the same content repeated here in an expanded format and with

additional information for long-term planning and maintenance of not only data

warehouses but data integration solutions in general.

This chapter includes the following topics:

■ Understanding the Basic Concepts

■ Implementing a Data Integration Solution

Understanding the Basic Concepts

Oracle Warehouse Builder is comprised of a set of graphical user interfaces to assist

you in implementing solutions for integrating data. In the process of designing

solutions, you create various objects that are stored as metadata in a centralized

repository, known as a workspace.

The workspace is hosted on an Oracle Database. As a general user, you do not have

full access to the workspace. Instead, you can access those workspaces to which you

have been granted access.

You log in to a workspace by starting the Design Center, which is the primary

graphical user interface. Use the Design Center to import source objects, design ETL

processes such as mappings, and ultimately define the integration solution.

A mapping is an object in which you define the flow of data from sources to targets.

Based on a mapping design, Warehouse Builder generates the code required to

implement the ETL logic. In a data warehousing project, for example, the integration

solution is a target warehouse. In that case, the mappings you create in the Design

Center ultimately define a target warehouse.

After you complete the design of a mapping and prompt Warehouse Builder to

generate the code, the next step is to deploy the mapping. Deployment is the process

of copying the relevant metadata and code you generated in the Design Center to a

Understanding the Basic Concepts

2-2 Oracle Warehouse Builder User's Guide

target schema. The target schema is generically defined as the Oracle Database which

will execute the ETL logic you designed in the Design Center. Specifically, in a

traditional data warehousing implementation, the data warehouse is the target schema

and the two terms are interchangeable.

Figure 2–1 illustrates the Warehouse Builder components.

As previously noted, the Design Center is the primary user interface. It is also a

centralized interface in that you can start from it all the client based tools, including

the Control Center Manager. A secondary user interface is the web-based Repository

Browser. In addition to browsing design metadata and auditing execution data, you

can view and create reports.

For the purposes of this illustration, the target schema and the repository exist on the

same Oracle Database; however, in practice, target schemas often exist on separate

databases. To deploy design objects and subsequently execute the generated code, use

the Control Center Manager, which is the client interface that interacts with the target

schema through the control center service.

Figure 2–1 Warehouse Builder Components

This screenshot shows the Warehouse Builder components. This screenshot is divided

into two halves. To the left half is the client consisting of the following, from top to

bottom: Design Center which also contains the Control Center Manager, and the

Repository Browser. To the right half is the server consisting of the following from left

to right: the Control Center service, and the Oracle Database. The Oracle Database

contains the following: to the left is the repository which contains the language

settings and Workspaces that contain the design metadata and the control center data.

To the right is the target schema which contains the generated code, cubes,

dimensions, tables, views, mappings, and packages to execute the ETL process.

SERVERCLIENT

Control Center

Manager

Design Center

Repository

Browser

Control Center

Service

Deployment

ORACLE DATABASE

Warehouse Builder

Repository

Language Setting,

Table Space Settings

Workspaces

Design Metadata,

Control Center Data

Target Schema

Generated Code,

Cubes, Dimensions,

Tables, Views, Mappings,

Packages to execute

ETL Processes

剩余763页未读，继续阅读

wl468dede

粉丝: 4
资源: 36

Oracle WarehouseBuilder用户指南11g Release 1

Oracle Warehouse Builder 11g

转：Oracle Warehouse Builder

OWB(Oracle Warehouse Builder)详细介绍

Oracle+Warehouse+Builder+11g教程

Oracle+WareHouse指南

Oracle_WareHouse_Builder操作指南

Data+Warehouse+Design_+Modern+P+-+Matteo+Golfarelli

Oracle Warehouse Management User’s Guide Release 11i

The+Data+Warehouse+ETL

Oracle WareHouse Builder

最新资源