Learn XQuery

Relational Insurance Model Using ACORD Standards

In the example described in these pages, the insurance related data is stored in a relational database, the relevant tables and primary key/foreign key relationships of which are illustrated in the following figure.

Use DataDirect XQuery™ to query and update relational data

This model is clearly over-simplified, but it is complete enough to show the set of operations on ACORD messages that are at the core of our example. It comprises six tables:

ACORD_PARTY
ACORD_PERSON
ACORD_ADDRESS
ACORD_PHONE
ACORD_POLICY
ACORD_RELATION

Download SQL Scripts for this Relational Model

You can create this set of tables on your own system, which will allow you to run the examples on your own machine. To do this, download and execute the SQL scripts as described in Running the Examples on Your Machine.

What's Next

Go to XQuery Operation Examples for an ACORD Insurance Application to learn about the XQuery operations that are performed using the data in these tables by the ACORD application example described in these pages.

Next: "XQuery ACORD Examples"

DataDirect XQuery FAQ

This informative DataDirect XQuery® FAQ answers frequently-asked questions about DataDirect XQuery® , including questions about performance, scalability, use-cases, resources, and more.

If you're more of a hands-on learner, then download a free copy and start exploring DataDirect XQuery® today!

New Case Study

Gevity produces sales proposals in real time using DataDirect XQuery® . See how Gevity uses DataDirect XQuery® to combine Web service data from SalesForce.com with relational data in Oracle in a pricing engine for HR management.

Feeds

Multimedia

Newsletter