Oracle Warehouse Builder 11g Release 2 数据建模、ETL与数据质量指南
需积分: 5 70 浏览量
更新于2024-06-25
收藏 10.22MB PDF 举报
"Oracle Warehouse Builder 是一款强大的数据仓库构建工具，涵盖了数据建模、ETL（提取、转换、加载）以及数据质量控制等关键功能。本指南为11g Release 2 (11.2)版，旨在帮助用户充分利用该工具进行高效的数据仓库开发和管理。文档由Richa Agarwala作为主要作者，与Padmaja Potineni和Vishwanath Sreeraman共同完成，旨在提供详尽的使用指导。"
在Oracle Warehouse Builder 11g Release 2中，数据建模是构建数据仓库的基础。这个过程包括概念数据模型设计、逻辑数据模型设计和物理数据模型实现。概念模型关注业务实体和它们之间的关系，逻辑模型则将这些实体转化为更具体的数据库结构，而物理模型考虑了性能优化，如表分区、索引等。
ETL过程是数据仓库系统的核心部分。Oracle Warehouse Builder提供了丰富的ETL工具，用于从各种源系统抽取数据，通过转换（如清洗、验证、聚合等）处理数据，然后加载到目标数据仓库或数据集市。用户可以使用图形化的界面设计、测试和调度ETL作业，大大简化了复杂的数据集成任务。
数据质量是确保数据仓库准确性和可信度的关键。Oracle Warehouse Builder提供了数据质量工具，如数据清洗、匹配和去重，以确保输入到数据仓库的信息是准确和一致的。此外，它还支持监控和报告数据质量问题，帮助用户识别和解决潜在的错误和不一致性。
文档还强调了版权和许可协议，指出软件及其文档受法律保护，使用需遵循特定条款，禁止未经授权的复制、分发等行为。对于软件中的错误，鼓励用户书面报告以便改进。
"Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide"是数据仓库开发者和管理员的重要参考资料，它详细介绍了如何利用Oracle Warehouse Builder进行高效的数据管理和分析工作，同时强调了合法合规的软件使用。
xvi
10.1.3.2 Automatic Commit versus Automatic Correlated Commit................................ 10-8
10.1.3.3 Embedding Commit Logic into the Mapping....................................................... 10-9
10.1.4 Committing Data Independently of Mapping Design.............................................. 10-10
10.1.5 Running Multiple Mappings Before Committing Data............................................ 10-10
10.1.5.1 Committing Data at Runtime ................................................................................ 10-11
10.1.5.2 Committing Mappings through the Process Flow Editor ................................. 10-12
10.1.6 Ensuring Referential Integrity in PL/SQL Mappings............................................... 10-13
10.2 Best Practices for Designing SQL*Loader Mappings ....................................................... 10-13
10.2.1 Using Conventional Loading to Ensure Referential Integrity in SQL*Loader Mappings
10-13
10.2.1.1 Maintaining Relationships Between Master and Detail Records..................... 10-14
10.2.1.2 Extracting and Loading Master-Detail Records.................................................. 10-15
10.2.1.3 Error Handling Suggestions .................................................................................. 10-17
10.2.1.4 Subsequent Operations........................................................................................... 10-18
10.2.2 Using Direct Path Loading to Ensure Referential Integrity in SQL*Loader Mappings ....
10-18
10.3 Improved Performance through Partition Exchange Loading........................................ 10-21
10.3.1 About Partition Exchange Loading.............................................................................. 10-22
10.3.2 Configuring a Mapping for PEL................................................................................... 10-22
10.3.3 Direct and Indirect PEL ................................................................................................. 10-23
10.3.3.1 Using Indirect PEL .................................................................................................. 10-23
10.3.3.2 Example: Using Direct PEL to Publish Fact Tables ............................................ 10-24
10.3.4 Using PEL Effectively..................................................................................................... 10-24
10.3.5 Configuring Targets in a Mapping............................................................................... 10-25
10.3.5.1 Step 1: Create All Partitions ................................................................................... 10-25
10.3.5.2 Step 2: Create All Indexes Using the LOCAL Option........................................ 10-26
10.3.5.3 Step 3: Primary/Unique Keys Use "USING INDEX" Option ........................... 10-26
10.3.6 Restrictions for Using PEL in Oracle Warehouse Builder ........................................ 10-26
10.4 High Performance Data Extraction from Remote Sources............................................... 10-26
11 Scheduling ETL Jobs
11.1 Overview of Schedules............................................................................................................ 11-1
11.2 Defining Schedules.................................................................................................................. 11-2
11.2.1 Editing Schedules ............................................................................................................. 11-3
11.2.1.1 Start and End Dates and Times ............................................................................... 11-4
11.2.1.2 Defining Schedules To Repeat................................................................................. 11-4
11.2.1.2.1 By Month ............................................................................................................. 11-6
11.2.1.2.2 By Week Number ............................................................................................... 11-6
11.2.1.2.3 By Year Day......................................................................................................... 11-6
11.2.1.2.4 By Month Day..................................................................................................... 11-7
11.2.1.2.5 By Day.................................................................................................................. 11-7
11.2.1.2.6 By Hour................................................................................................................ 11-7
11.2.1.2.7 By Minute ............................................................................................................ 11-7
11.2.1.2.8 By Second ............................................................................................................ 11-7
11.2.1.2.9 By Set Position .................................................................................................... 11-7
11.2.2 Example Schedules........................................................................................................... 11-8
11.3 Applying Schedules to ETL Objects...................................................................................... 11-8
剩余819页未读，继续阅读
点击了解资源详情
点击了解资源详情
点击了解资源详情
2009-01-07 上传
2023-06-18 上传
2008-09-10 上传
2023-06-18 上传
2023-06-18 上传
2012-08-28 上传
weixin_40191861_zj
- 粉丝: 86
- 资源: 1万+
我的内容管理
展开
最新资源
- Manning - Spring in Action (2007).pdf
- 食品类公司网站建设方案
- C# 日期函数 string.Format
- SAP财务成本知识库.pdf
- 很好的 学校网站方案
- 第11界全国青少年信息学奥林匹克联赛初赛试题（C语言）
- 协会学会网站建设方案
- 网上书店管理系统详细分析
- 软件需求分析 图形解释的
- S3C44B0X 中文数据手册
- 基于FLAASH的多光谱影像大气校正应用研究
- 基于J2EE的Ajax宝典.pdf
- 如何发表SCI论文，希望对大家有帮助！
- c# 提供面试题大全
- C++ Core 2000
- The MIT Press Essentials of Programming Languages 3rd Edition Apr 2008
