Data Services Developer's Guide

Introduction to Data Services

Data Services and the Enterprise

Data Access Integration Architecture

Data Services Platform Applications and Projects

DSP: Roles and Responsibilities

DSP: Typical Development Process

Examples, Samples, and Tutorials

Data Services Platform Projects and Components

DSP-Based BEA WebLogic Projects

Creating a DSP-based Application

Adding a DSP Project to an Existing BEA WebLogic Application

Major Components of a DSP Project

Using the WebLogic Workshop IDE

Survey of DSP Additions to WebLogic Workshop

Building and Deploying Applications, EARs, and SDO Mediator Clients

Building, Deploying, and Updating Applications

Creating the SDO Mediator API

Refactoring DSP Artifacts

Artifacts Supporting Refactoring

Setting Refactor Options

Impacts of Various Refactoring Operations

Obtaining Enterprise Metadata

Creating Data Source Metadata

Identifying DSP Procedures

Obtaining Metadata From Relational Sources

Importing Relational Table and View Metadata

Importing Stored Procedure-Based Metadata

Using SQL to Import Metadata

Importing Web Services Metadata

Testing Metadata Import With an Internet Web Service URI

Importing Java Function Metadata

Supported Java Function Types

Adding Java Function Metadata Using Import Wizard

Creating XMLBean Support for Java Functions

Inspecting the Java Source

How Metadata for Java Functions Is Created

Importing Delimited File Metadata

Providing a Document Name, a Schema Name, or Both

Using the Metadata Import Wizard on Delimited Files

Importing XML File Metadata

XML File Import Sample

Testing the Metadata Import Wizard with an XML Data Source

Updating Data Source Metadata

Considerations When Updating Source Metadata

Using the Update Source Metadata Wizard

Archival of Source Metadata

Designing Data Services

Data Services in the Enterprise

Physical and Logical Data Services

Data Service Functions

Data Service Design View Components

XML Types and Return Types

Creating a Data Service

Adding a Function to Your Data Service

Adding a Procedure to Your Data Service

Adding a Private Function to Your Data Service

Adding a Relationship to Your Data Service

Working with Logical Data Service XML Types

Creating an XML Type

Managing Your Data Service

Refactoring Data Service Functions

Finding Usages of Data Services Platform artifacts

Setting Update Options

Adding Security Resources

Caching Functions

Notable Design View Properties

Modeling Data Services

Model-Driven Data Services

Logical and Physical Data Models

Rules Governing Model Diagrams

Building a Simple Model Diagram

Displaying Relationships Automatically

Generated Relationship Declarations in Source View

Modeling Logical Data

Building Data Service Relationships in Models

Direction, Role, and Relationships

Working with Model Diagrams

Model Right-click Menu Options

Creating Relationships in Model Diagrams

Locating Data Services in Large Model Diagrams

Generating Reports on Your Models

Zoom Mode

Editing XML Types in Model Diagrams

How Changes to Data Services and Data Sources Can Impact Models

How Metadata Update Can Affect Models

Working with the XQuery Editor

Role of the XQuery Editor

Data Source Representations

XQuery Editor Options

Creating a New Data Service and Data Service Function

Key Concepts of Query Function Building

Data Sources

Source Schemas and Return Types

XQuery Editor Components

Setting Conditions

Using XQuery Functions

Setting Expressions

Managing Query Components

Working With Data Representations and Return Type Elements

Mapping to Return Types

Modifying a Return Type

Testing Query Functions and Viewing Query Plans

Running Queries Using Test View

Using Test View

Limiting Array Results

Starting Client Transaction Option

Validating Results

Disregarding a Running Query

Auditing Query Performance

Analyzing Queries Using Plan View

Using Query Plan View

Analyzing a Sample Query

Working With Your Query Plan

Simply mouse-over the highlighted section of the plan to view the information or warning.