Java与XML数据库集成：Oracle 9i WarehouseBuilder实例教程

需积分: 3 80 浏览量更新于2024-07-31 收藏 1.2MB PDF 举报

本篇文章主要探讨了Java与XML数据库整合应用的第十个教程，着重于在Oracle 9i Warehouse Builder (9.0.4) 的环境下进行操作。Oracle 9i Warehouse Builder Transformation Guide 是一个官方发布的文档，由Jean-Pierre Dijcks 主编，Shirinne Alison、Diane Smith 和 Kavita Nayar 贡献编辑，版权属于Oracle Corporation，所有使用须遵守其严格的许可协议，其中包括使用限制和保密条款。该文档的核心内容涉及到了Oracle 9i Warehouse Builder的转型指南，这个工具允许开发者将XML数据与Oracle数据库系统无缝集成。学习者可以通过这些教程了解到如何利用Java编程语言来处理XML数据，实现数据的加载、转换和存储。它可能涵盖了XML解析、DOM（Document Object Model）和SAX（Simple API for XML）等技术在Java中的应用，以及如何设计和实施XML到关系型数据库（如Oracle SQL）的映射策略。文章强调了未经许可的程序反向工程、拆解或编译Oracle软件及其文档都是禁止的，这是出于保护Oracle的知识产权考虑。此外，用户应注意，文档中的信息可能会随时更新，如果发现任何问题，应通过正式渠道向Oracle报告，同时指出Oracle并不保证文档完全无误，但会在许可协议范围内提供技术支持。通过阅读这篇教程，学习者不仅能掌握Java与XML数据库交互的最佳实践，还能理解如何处理数据迁移和ETL（Extract, Transform, Load）过程中的复杂性，这对于开发在现代企业环境中高效、可维护的数据处理系统至关重要。在实际项目中，这将有助于提升数据质量和业务分析能力。

xvi

for you to export metadata directly from Collections. The second feature is

available from the Metadata Loader command line utility. It provides you with

flexibility to specify the type of actions you want to apply when you import a

first-class object.

Process Flow Editor

Starting in this release, you can use the Process Flow Editor in Warehouse Builder to

create and define process flows. External process operators that you previously

defined in mappings are upgraded to user-defined processes and are contained

within a process flow module. Process flows now integrate in the same Warehouse

Builder design environment and no longer require you to use Oracle Workflow

design client to perform these functions. The Warehouse Builder process flow

modeler understands the semantics of your mappings and enables you to model

activities such as FTP and email.

Performance Improvements

■ Mapping User Interface: A new pre-defined display set, named Mapping, has

been added in this release. Selecting this display set causes the Mapping to only

display columns that are mapped/used.

■ Mapping Compression: This feature automatically detects unused connections

between operators and attributes in any given mapping and eliminates them

from the repository. This dramatically enhances the performance of loading and

storing large mappings that represent significant data flows.

■ Metadata Loader (Import and Export): Import and export functionality now

takes advantage of the new compression feature available for each mapping.

This means that the Metadata Loader now exports and imports only those

mapping objects that are actually used.

Oracle9i Integration

■ OLAP Integration: Warehouse Builder enables you to design, deploy, and load

multidimensional OLAP objects as ROLAP or MOLAP models from different

data sources. After the data is loaded, you can use BI tools and applications to

run complex analytical queries that answer your business questions. Using

Warehouse Builder, you can now create and manage both your relational and

and multidimensional objects from the same cube and dimension designs.

■ Advanced Queue (AQ) Integration: Warehouse Builder enables you to import

Advanced Queue definitions and to use AQs as data sources and targets while

designing your data warehouse. Through Advanced Queue functionality

xvii

coupled with the Messaging Gateways, Warehouse Builder enables you to

support messaging applications on MQ Series and Tibco as Warehouse Builder

data sources. AQs also enable you to propagate change data capture from your

source system to your target. The ability to integrate AQs lays the foundation

for providing real time data warehousing in the future.

■ External Tables: Starting in this release, you can use external tables to represent

data from non-relational file sources in a relational, read-only format. You can

import an existing external table from an Oracle9i database. Or you can create

an external table in Warehouse Builder based on a flat file definition. Warehouse

Builder will generate the right DDL for you to deploy you external table to an

Oracle9i database.

■ Oracle9i Multiple Table Inserts: Warehouse Builder takes advantage of

Oracle9i database functionality and generates a multiple-table insert statement

when the target database is Oracle9i. This enables you to optimize mappings to

insert data into multiple tables in one operation.

■ Oracle9i Table Functions: Warehouse Builder introduces the Table Function

operator that enables you to improve performance when loading your target

system. Use this operator to develop custom code that can manipulate a set of

input rows and return another set of rows possibly of different cardinality.

Unlike conventional functions, table functions output a set of rows that can be

queried like a physical table.

Enhanced Support for Flat Files

■ Unbound Flat Files as Targets: In this release, you can create a new, unbound

flat file object as you create your mapping. Warehouse Builder creates a new

comma-separated, single-record-type flat file in the specified location. This

feature makes it easier to load the contents of a relational object into a flat file.

■ Outbound Reconcile for Flat Files: Outbound reconciliation makes it possible

to create a new repository object from a mapping flat file. This results in a new,

comma-separated file to be created where specified, provided that the flat file is

new to that repository. This feature makes it easier to "quickly dump" the

contents of a relational object to a flat file.

■ Logical Records for Delimited Files: The Flat File Sample Wizard has also been

enhanced to display an improved user interface that allows you to define

logical records for delimited files.

■ Position-Based Master-Detail Loading: Position-based master-detail flat files

are now easier to load with the use of additional mapping operators.

xviii

■ SQL Property Extensions: You can now specify SQL properties for flat files you

import into Warehouse Builder. This enables you to pre-define SQL property

values for each flat file field. Thus, if mapping a flat file source to a relational

target, the target column will default to these pre-defined SQL property values.

These values will be used when building a relational target column or when

creating an external table column.

Mapping Editor Enhancements

■ Mapping User Interface: A new set of property tabs is now available for you to

quickly create and edit mapping operators and attribute properties.

■ Pivot and Unpivot Operators: Starting in this release, you can add a pivot

operator or an unpivot operator to a mapping. The pivot operator allows you to

transform a single row of attributes into multiple rows. The unpivot operator

converts multiple input rows into one output row.

■ Name and Address Operator Enhancements: The Name and Address operator

has been enhanced to include new input roles and output attributes. The United

States Postal Service Code Accuracy Support System (CASS) reporting is also

supported starting with this release.

Warehouse Builder Is Now Available on UNIX Platforms

Starting with this release, Warehouse Builder is available on UNIX (Solaris and

Linux), as well as Windows (NT, 2000, and XP) platforms. This applies to all the

components of Warehouse Builder, with the exception of the Name and Address

libraries, which are not available on Linux in this release. (Note that the OLAP

Bridges feature is only available on Windows platforms and the Name and Address

Server is only available on Windows and Solaris platforms.)

Conventions

In this manual, Windows refers to the Windows NT, Windows 2000, and Windows

XP operating systems. The SQL*Plus interface to Oracle9i may be referred to as

SQL.

In the examples, an implied carriage return occurs at the end of each line, unless

otherwise noted. You must press the Return key at the end of a line of input.

Table 0–1 lists the conventions used in this manual.

剩余141页未读，继续阅读

zhou_q123

粉丝: 0

Java与XML数据库集成：Oracle 9i WarehouseBuilder实例教程

Java与XML数据库整合应用：TP312 S458.rar

xml.rar_XML java_java xml_xml_xml 数据库

JAVA与XML技术在异构数据库WEB访问中的应用

Java实现XML导入不同数据库，从数据库导出数据到XML

Java程序设计 EJB、XML与数据库

Java自动生成数据库表实体类和mybatis接口以及xml文件

java编程.数据库.j2ee架构与模式等电子书整合(2)

JAVA与XMLpdf资料

基于Java语言的数据库课设源码及前后端技术整合实践

Java实现XML数据导入数据库

最新资源