DB-XML Sample Query Readme
A copy of this readme is included with the
DB-XML sample in your Liquid Data installation at <WL_HOME>/liquiddata/samples/buildQuery/db-xml/readme.htm.
(The default install home for Liquid Data is bea/weblogic700.)
This readme includes the following topics:
What this Query Demonstrates
The sample for order query demonstrates how to use Liquid
Data to create an integrated view that shows the connection of two different
Enterprise Information Systems (EIS), database, and XML. Creating an integrated
view provides the ability to seamlessly access separate EISs using a single
query.
For example, a wireless service provider uses a relational
database system to manage its customer and order information. Recently it purchased
a broadband service from another company. The broadband customer and order information
is managed by an non-DBMS system, e.g., XML file system. To provide an integrated customer service system,
we use the Liquid Data engine to seamlessly access customer order information across different types of Enterprise Information Systems (EIS).
How to Run the Query
- Start the Liquid Data Samples server.
- Start the Data View Builder.
- In the Data View Builder, open the following project file:
<WL_HOME>/liquiddata/samples/buildQuerydb-xml/e2e-order.qpr
- Click the Test tab. (This shows the generated query statement.)
- Click the "Run Query" button and view the XML result.
If You Want to Re-create the Query . .
.
Configure the Data Sources in the Administration Console
- Configure the Wireless relational database data
source as follows:
- JDBC connection pool: MyWirelessPool (username=wireless,
password=wireless)
- JDBC data source: MyWirelessDS
- Liquid Data "Relational Database" data source: MyWireless-LD-DS
(Schema=WIRELESS)
- Configure the BroadBand XML data source as follows:
MyBroadBand-LD-DS
Build the Query in the Data View Builder
- Create a new project.
- Open the Data Sources you just defined: a relational database
called MyWireless-LD-DS and an XML file called MyBroadBand-LD-DS
- Add customerOrderReport.xsd from the repository as the
target schema
- Follow the steps in the Getting Started guide under "Step
6. Construct the Query" to build the Order Query. (The Getting Started
guide is located on edocs at http://download.oracle.com/docs/cd/E13190_01/liquiddata/docs11/qkstart/index.html)
- Run the query. (Click the Test tab and click Run Query
button.)
Reference
- You can view the Wireless database schema at <WL_HOME>/liquiddata/samples/config/ld_samples/ldrepository/schemas/WIRELESSP.sql
- You can view the BroadBand XML schema at <WL_HOME>/liquiddata/samples/config/ld_samples/ldrepository/schemas/b-co.xsd
- You can view the target schema at <WL_HOME>/liquiddata/samples/config/ld_samples/ldrepository/schemas/customerOrderReport.xsd
- You can view the query statement at <WL_HOME>/liquiddata/samples/config/ld_samples/ldrepository/stored_queries/order.xq