bea.com | products | dev2dev | support | askBEA |
|
e-docs > Liquid Data for WebLogic > Building Queries and Data Views |
Building Queries and Data Views |
W3C XQuery, XML, and Liquid Data
XQuery Use in Liquid Data and Data View Builder
The Role of XML in Creating Global Business Solutions
Supported XML Schema Versions In Liquid Data
Learning More About the XQuery Language
Advantages of the Data View Builder
How the Data View Builder Works
Key Concepts of Query Building
Different Kinds of Data Sources
Data Views—Using the Result of a Query as a Data Source
Anatomy of a Query: Joins, Unions, Aggregates, and Functions
Predefined Namespaces in XQuery
Other XML Namespace References
XML Namespaces in Liquid Data Queries
Namespace Declarations in XQuery Prolog
Namespaces in Target Schema Definitions
Data Sources that Require Namespace Declarations
Migrating Liquid Data 1.0 Queries
Starting the Builder and Touring the GUI
Starting the Data View Builder
Overview Picture of Design Tab Components
1. Menu Bar for the Design Tab
Overview Picture of Optimize Tab Components
Overview Picture of Test Tab Components
4. Query Parameters: Submitted at Query Runtime
5. Query Results - Large Results
To Make a Project Portable, Save Target Schema to Repository
Saving a Project is Not the Same as Saving a Query
Using Schemas Saved With Projects
Special Characters: Occurrence Indicators
Next Steps: Building and Testing Sample Queries
Opening the Source Schemas for the Data Sources You Want to Query
Mapping Source and Target Schemas
Example: Query Customers by State
Supported Mapping Relationships
Using Constants and Variables in Functions
Enabling and Disabling Conditions
Adding or Deleting Parameters in a Condition Statement
Exceptions to Automatic Type Casting
Example: Return Customers by Name
View the XQuery and Run the Query to Test it
Example: Query Customers by ID and Sort by State
Open the Data Sources and Add a Target Schema
Map Nodes from Source to Target Schema to Project Output
Specify the Order of the Result Using the Sort By Features
View the XQuery and Run the Query to Test it
Understanding Scope in Basic and Advanced Views
Basic View (Automatic Scope Settings)
Advanced View (Setting the Scope Manually)
When to Use Advanced View to Set Scope Manually
Task Flow Model for Advanced View Manual Scoping
Saving Projects from Basic or Advanced View
Understanding Query Design Patterns
Target Schema Design Guidelines and Query Examples
Examples of Effective Query Design
Why is source replication necessary?
When is source replication necessary?
When should you manually replicate sources?
Using the Features on the Optimize Tab
Example: Source Order Optimization
Using Parameter Passing Hints (ppleft or ppright)
Specifying Large Results for File Swapping
Saving a Query to the Repository as a "Stored Query"
Naming Conventions for Stored Queries
Simple and Parameterized Data Views
Using Data Views as Data Sources
Creating and Saving the Query to the Liquid Data Repository
Configuring a Data View Data Source Description
Adding a Data View as a Data Source
Creating a Parameterized Data View
Using Complex Parameter Types in Queries
Understanding Complex Parameter Types
Understanding CPT Schema and Data
Notes on Hand-Crafting CPT XQueries
XQuery of type element Declaration
Creating a Complex Parameter Type
Step 2. Create Your Runtime Source
Step 3. Define Your CPT in the Administration Console
Complex Parameter Type Query Samples
Defining Stored Procedures to Liquid Data
To Define Stored Procedures to Liquid Data
Stored Procedure Description File Schema
Schema Definition File for Stored Procedure Description File
Element and Attribute Reference for Stored Procedure Description File
Rules for Specifying Stored Procedure Description Files
Rules for Element and Attribute Names
Rules for Procedure Names Containing a Semi-Colon
Rules and Examples of <type> Declarations to Use in the <function> return_type Attribute
Example 1: Type Definition with No Return Value
Example 2: Type Definition with Simple Return Value
Example 3: Type Definition for Complex Row Set Type
Example 4: Type Definition with Complex Return Value
Example 5: Type Definition with Simple Return Value and Two Row Sets
Rules for the mode Attribute output_only <argument> Element
Rules for Transforming the Function Signature When Hand Writing an XQuery
Sample Stored Procedure Description Files
DB2 Simple input_only, output_only, and input_output Example
Oracle Cursor Output Parameter Example
DB2 Multiple Result Set Example
Stored Procedure Support by Database
Using Stored Procedures in Queries
Define Stored Procedures to Liquid Data
Example: Defining and Using a Customer Orders Stored Procedure
Step 1: Create the Stored Procedure in the Database
Step 2: Create the Stored Procedure Description File
Step 3: Specify the Stored Procedure Description File in the Liquid Data Console
Step 4: Open the Data View Builder to See Your Stored Procedures
Step 5: Use the Stored Procedure in a Query
Ex 1: Step 1. Verify the Target Schema is Saved in Repository
Ex 1: Step 2. Open Source and Target Schemas
Ex 1: Step 3. Map Nodes from Source to Target Schema to Project the Output
Ex 1: Step 4. Create a Query Parameter for a Customer ID to be Provided at Query Runtime
Ex 1: Step 5. Assign the Query Parameter to a Source Node
Ex 1: Step 6. Join the Wireless and Broadband Customer IDs
Ex 1: Step 7. Set Optimization Hints
Ex 1: Step 8. View the XQuery and Run the Query to Test it
Ex. 1: Step 9. Verify the Result
Ex 2: Step 1. Locate and Configure the "AllOrders" Data View
Ex 2: Step 2. Restart the Data View Builder and Find the New Data View
Ex 2: Step 3. Verify the Target Schema is Saved in the Repository
Ex 2: Step 4. Open the Data Sources and Target Schema
Ex 2: Step 5. Map Source Nodes to Target to Project the Output
Ex 2: Step 6. Create Two Query Parameters to be Provided at Query Runtime
Ex 2: Step 7. Assign the Query Parameters to Source Nodes
Ex 2: Step 8. Add the "count" Function
Ex 2: Step 9. Verify Mappings and Conditions
Ex 2: Step 10. View the XQuery and Run the Query to Test it
Ex 2: Step 11. Verify the Result
Example 3: Date and Time Duration
Ex 3: Step 1. Verify the Target Schema is Saved in Repository
Ex 3: Step 2. Open Source and Target Schemas
Ex 3: Step 3. Map Source to Target Nodes to Project the Output
Ex 3: Step 5. Create Two Query Parameters for Customer ID and Date to be Provided at Query Runtime
Ex 3: Step 6. Set a Condition Using the Customer ID
Ex 3: Step 8. Set a Condition to Include Only "Open" Orders in the Result
Ex 3: Step 9. View the XQuery and Run the Query to Test it
Ex 3: Step 9. Verify the Result
Ex 4: Step 1. Verify the Target Schema is Saved in Repository
Ex 4: Step 2. Open Source and Target Schemas
Ex 4: Step 3. Clone the Orders Element of the Target Schema
Ex 4: Step 4. Create a Query Parameter for a Customer ID
Ex 4: Step 5. Assign a Query Parameters
Ex 4: Step 6. Define Source Relationships
Ex 4: Step 7. Project the Output to the Target Schema
Ex 4: Step 8. Add Optimization Hints
Ex 4: Step 9. View the XQuery and Run the Query to Test it
Ex 4: Step 10. Verify the Result
Ex 5: Step 1. Verify the Target Schema is Saved in Repository
Ex 5: Step 2. Open Source and Target Schemas
Ex 5: Step 3. Find Broadband and Wireless Customers with the Same Customer ID
Ex 5: Step 4. Find the Count of the Wireless Customers
Ex 5: Step 5. Set a Condition that Specifies the Output of "count" is Zero
Ex 5: Step 6. View the XQuery and Run the Query to Test it
Ex 5: Step 7. Verify the Result
Example 6: Complex Parameter Type (CPT)
Ex 6: Step 1. Verify the Availability of Schemas and Sample Data Stream
Ex 6: Step 2. Open the Target Schema and CO-CPTSAMPLE CPT
Ex: 6: Step 3. Create an orderLimit Query Parameter
Ex 6: Step 4. Save the Project
Ex 6: Step 5. Test Access to the Complex Parameter Source
Ex 6: Step 6: Determine the Total Amount of New Orders
Ex 6: Step 7. Create the Necessary Joins and Mappings to the Target Schema
Ex 6: Step 8. Determine the Amount of Currently Open Orders
Ex 6: Step 9: Determine the Total Amount of All Open and New Orders
Ex 6: Step 10: Test If Open Orders + New Orders Exceeds the Order Limit
Ex 6: Step 11: Determine If the Order is Accepted or Rejected
Ex 6: Step 12: View the XQuery
Ex 6: Step 13. Run the XQuery to Verify the Result
About in Liquid Data XQuery Functions
xfext:date-from-string-with-format
xfext:dateTime-from-string-with-format
xfext:time-from-string-with-format
Type Casting to a Numeric Target
Type Casting to a Non-Numeric Target
Type Casting Function Parameters