Re: [ubl-dev] Tools for database support for UBL?

["David RR Webber" <david@drrw.info>]

Stephen,

I realized these issues many years ago that you listed
in your original post at bottom here.

That is why we have created the OASIS CAM template
system to allow you to manage the BIE mechanisms as
XML templates.

We are also right now working on noun formats for
ebXML Registry - so that you can store these nouns
in the registry and then assemble them as directed
by the CAM templates.

Better yet - you can leverage the association mechanisms
in registry to find usage and group relationships - and
you can also directly query the XML of the CAM templates
themselves - to extract usage patterns and rules associated
with usage.

You can download the open source CAM implementation
from http://www.jcam.org.uk  and you can find sample
templates and examples of using jCAM with Hermes ebMS
and Cyclone ebMS from the recent XML2004 Interop here:

 http://ebxmlbook.com/interop

For the latest OASIS work on CAM and the noun schema
layout visit

 http://www.oasis-open.org/committees/cam

Enjoy, DW



---- Original Message ----- 

From: "Stephen Green" <stephen_green@bristol-city.gov.uk>
To: ">" <"'ubl-dev@lists.oasis-open.org'"<ubl-dev@lists.oasis-open.org>
Sent: Thursday, December 16, 2004 5:30 AM
Subject: [ubl-dev] Tools for database support for UBL?


Dear UBL-DEV, Hi

If anyone has interest in the possibility of developing tools to help store
UBL
and UBL-based instances in a relational database I've been thinking along
the
following lines:

1. What sort of tables could UBL map to? What would be the relational
mapping, say?

2. Need to map Schemas to 'CREATE' SQL and develop a generator for that

3. Need to map instances to 'UPDATE' SQL (etc ...?) and develop a generator
for that

I wonder if any have thoughts of devloping something like the above, perhaps
as opensource
or priced attractively to foster wider UBL / UBL-like Schema adoption (the
key to successful
use of UBL perhaps).

What worries me is the complexity of UBL but there's the challenge and the
drive I suppose.
It would seem obvious to just treat every ABIE as a table and every document
as an
ABIE/table too. The relationships are where I get a bit lost.

Another key factor would be to make the tools generic - to handle any
Schemas built
by the UBL NDR rules and from the UBL spreadsheets (e.g. see UBLish from
softml.com
which uses a scripting language similar to perl).

All the best

Steve