Oracle Warehouse Builder 11g Release 2 数据建模、ETL与数据质量指南
需积分: 5 178 浏览量
更新于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 上传
2019-03-23 上传
weixin_40191861_zj
- 粉丝: 84
- 资源: 1万+
我的内容管理
展开
最新资源
- 高清艺术文字图标资源，PNG和ICO格式免费下载
- mui框架HTML5应用界面组件使用示例教程
- Vue.js开发利器：chrome-vue-devtools插件解析
- 掌握ElectronBrowserJS：打造跨平台电子应用
- 前端导师教程：构建与部署社交证明页面
- Java多线程与线程安全在断点续传中的实现
- 免Root一键卸载安卓预装应用教程
- 易语言实现高级表格滚动条完美控制技巧
- 超声波测距尺的源码实现
- 数据可视化与交互：构建易用的数据界面
- 实现Discourse外聘回复自动标记的简易插件
- 链表的头插法与尾插法实现及长度计算
- Playwright与Typescript及Mocha集成：自动化UI测试实践指南
- 128x128像素线性工具图标下载集合
- 易语言安装包程序增强版：智能导入与重复库过滤
- 利用AJAX与Spotify API在Google地图中探索世界音乐排行榜
