Skip navigation.

Data Services Developer's Guide

  Previous Next vertical dots separating previous/next from contents/index/pdf Contents View as PDF   Get Adobe Reader

Introduction to Data Services

Just as the BEA WebLogic Application Server freed application developers from the tedium associated with managing multi-user applications across the Internet, BEA Aqualogic Data Services Platform allows data application developers to concentrate on developing and extending enterprise information without a need to directly program to the underlying physical data sources.

Data Services Platform (DSP) takes advantage of emerging standards to enable you to create hierarchical, enterprise-wide data services which can be accessed by any Web-based application.

Specifically, data services enable you to:

Note: DSP was initially named Liquid Data. Some artifacts of the original name remain in the product, installation path, and components.

Figure 1-1 BEA Integrated Development Environment

BEA Integrated Development Environment


 

 


Data Services and the Enterprise

In modern enterprises data is generally readily available. While this has reduced that need to move physical data into data warehouses, data marts, data mines, or other costly replications of existing data structures, the problems of dynamic data integration, immediate secured access and update, data transformation, and data synchronization remain some of the most vexing challenges facing the IT world.

DSP provides a comprehensive approach to this challenge by:

DSP can be used to create, refine, and validate logical data structures through a process of importing data sources, creating physical and logical models, and designing queries for use by applications in an infrastructure that provides for easy maintenance, while enhancing security and performance.

Through standardized Service Data Objects (SDO) technology, web-based applications can automatically read and update relational data. Through simple Java programs DSP update capabilities can be extended to support any logical data source.

Data Access Integration Architecture

In contemporary enterprise computing, data typically passes through multiple processing and storage layers. While enterprise data can easily be accessed, turning that data into useful information economically and efficiently, particularly updateable information, remains a difficult and high-maintenance task.

Figure 1-2 Data Services Platform Component Architecture

Data Services Platform Component Architecture


 


 


 

DSP approaches the problem of creating integration architectures by building logical data services around physical data sources and then allowing business logic to be added as part of easily maintained, graphically designed XML query functions (also called XQueries).

Using standard protocols such as JDBC, DSP automatically introspects data sources, creating physical data services and corresponding schemas that model a physical data source. Optional model diagrams capture relationships between relational data sources, such as primary and foreign keys.

Any WebLogic Workshop application can include DSP-based projects. And any application can access DSP queries — including update functions — through a mediator API or a Data Services Platform Control. In the case of relational data, updates can be performed automatically through Service Data Objects (SDO) (For details see Programming with Service Data Objects in the Data Services Platform Application Developer's Guide.)

DSP provides for the development of integrated queries within any WebLogic Workshop application. Each application can contain multiple Data Services Platform-based projects, as well as any other types of projects offered by WebLogic Workshop.

Figure 1-3 Sample Data Service

Sample Data Service


 

Data Services Platform Applications and Projects

DSP query and model development services are available through a DSP-based WebLogic Workshop project. After you have installed DSP (see the Installation Guide), you have two options:

Services Available to a Data Services Platform Based Project

A DSP-based project is comprised of a number of interrelated data services used in developing models and query functions. Service components are designed to enable rapid development, prototyping, and deployment of these services and functions in your applications.

Table 1-4 Survey of Major Services Provided by Data Services Platform

Service

Feature

Data Modeling

  • Physical models

  • Logical models

  • Relationships

  • Data services

  • Read functions

  • Navigation functions

  • Roles

Metadata Management

  • Browse metadata

  • Search metadata

  • Impact analysis

  • Reports

Import Metadata

  • Relational, web services, XML files, delimited files, Java

  • Metadata update

Query Management

  • Graphical development

  • Testing

  • Plan analysis

  • Performance reporting

  • Source editing

Application Services

  • Mediator API

  • Data Services Platform control

  • JDBC

Service Data Objects (SDO)

  • Automatic read-write to relational sources

  • Custom update


 

For more information on WebLogic Workshop applications and projects see Applications and Projects in WebLogic Workshop online documentation.

DSP: Roles and Responsibilities

DSP: Typical Development Process

The following steps summarize a typical Data Services Platform-based project development cycle.

  1. Create your project. Create a DSP-based project in a new or existing WebLogic Workshop application as described in Creating a Data Services Platform-based Application and Adding a DSP Project to an Existing BEA WebLogic Application.
  2. Import metadata. Metadata can be obtained for any data source that is available through your local application or BEA WebLogic Server. This may include relational data, web service data, delimited files (spreadsheets), custom Java functions, and XML files. See Obtaining Enterprise Metadata.
  3. Create a data model. You can graphically build a data model that shows the relationships and cardinality between the data services you have selected (see Modeling Data Services for details). In the data model, you can also modify and extend relationships between various data services as well as their return type.
  4. Develop data services. You can elaborate on existing physical data through queries that span multiple physical and/or logical data services (Using Data Services Design View. The built-in XQuery Editor (Using Query Editor View) includes standard XQuery functions and language construct prototypes. Using the editor you can map source elements or transformations to a return type.
  5. The Data Service Palette provides access to all data services available to your application. Queries and data service logic are maintained in a single, editable source file that is fully integrated with your data service (Using Source View).

  6. Test your function. The data service functions you create can be tested at any time. You can select any query in the current data service, add a simple or complex parameter (if required), run the query, and see the results (Testing Query Functions and Viewing Query Plans). If you have appropriate permissions, you can also update source data through Test View.
  7. Review the query plan. You can view the query plan prior to or after running your query. The query plan describes the generated statements used to retrieve and update data. Execution time statistics are also available (Analyzing Queries Using Plan View on page 7-13).

Examples, Samples, and Tutorials

Samples and examples used in this book are based on the Sample Retail Application (RTLApp) that is included with DSP. See also the Sample Retail Application Overview in the DSP Installation Guide.

A number of examples of DSP technology can be found in the DSP Samples Tutorial. This tutorial is also based on RTLApp.

To access the tutorial see the DSP e-docs page:

http://download.oracle.com/docs/cd/E13167_01/aldsp/docs20/index.html

 

Skip navigation bar  Back to Top Previous Next