Tools for database support for UBL?

[Aleksei Valikov <valikov@gmx.net>]

Hi.

I'm leading the HyperJAXB project aimed to provide relational 
persistence layer for XML Schema-driven XML documents.

https://hyperjaxb.dev.java.net/

The solution is already implemented and works with a great variety of 
schemas.

This week, one of the users decided to try HyperJAXB with UBL schemas. I 
helped him and today UBL schema is finally deployed as one of the 
HyperJAXB tests.

Yet another user crossposed your mail from ubl-dev concerning the 
database support for UBL. I think what we did with HyperJAXB for UBL 
schemas is exactly what you're looking for.

In brief, the solution functions as follows:

Sun's JAXB implementation + HyperJAXB add-on are used to produce Java 
classes representing constructs of the UBL XML Schema. HyperJAXB add-on 
augments the generated code with Hibernate XDoclets. After that 
Hibernate toolset is used to produce Hibernate object-relational mapping 
and database schema.
JAXB allows Java object representation to be unmarshalled 
from/marshalled to XML documents. Hibernate allows Java objects to be 
saved into/loaded from a relational database. These two parts together 
basically allow XML documents to be persisted in a relational database.

I suggest that you take a look at HyperJAXB - might happen that it is 
the solution you need.

Feel free to contact me with any questions.

Bye.
/lexi

-------- Original Message --------
Subject: [ubl-dev] Tools for database support for UBL?
Date: Thu, 16 Dec 2004 10:30:52 +0000
From: Stephen Green <stephen_green@bristol-city.gov.uk>
To: <"'ubl-dev@lists.oasis-open.org'" <ubl-dev@lists.oasis-open.org>>

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