Contents for 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.
Creating an Ad Hoc Query
Sample Ad Hoc Queries
Working with XQuery Source
What is Source View?
XQuery Support
Using Source View
Finding Text
Function Navigation
Code Editing Features
Best Practices and Advanced Topics
Using a Layered Data Integration and Transformation Approach
Using Inverse Functions to Improve Performance During Updates
Sample Inversible Data
Considerations When Running Queries Against Logical Data
Improving Performance Using Inverse Functions: an Example
Leveraging Data Service Reusability
Modeling Relationships