Leveraging xCBL, ebXML

[IanBruk]

I have an .xdr file from xCBL which lists over 1800 XML elements which cover most all needed information for any common business process. These elements, as far as I understand, correspond to fields in database tables. I am looking for a database that has been designed using these xCBL elements. Has something like this been done or is there an inherent problem with this approach?

 

[jimbopalmer]

I wrote a one line SQL statement to extract each XML statement (I use OAGIS XML but xCBL would be the same) then I store these select statements as rows in my database. for each XML statement I can lookup how to construct it. Is that close to what you were thinking? The one thing you can't give for your heart's desire is your heart. - Lois McMaster Bujold

 

[IanBruk]

Would you be able to share those SQL statements or examples?

What we have done is written a parser to parse out the XML files and build database tables and fields based on xCBL elements. We do not, however, have any link back to the structure of the XML file.

 

[jimbopalmer]

SQL> desc doc_values
Name Null? Type
------------------------------- -------- ----
NAME NOT NULL VARCHAR2(25)
TYPE NOT NULL VARCHAR2(255)
TEXT NOT NULL VARCHAR2(255)
QUERYELEM VARCHAR2(255)

TRANSTERMS QUERY mp5.r5orders ord_fobpoint

The name is the XML the type allows SQL or constants then Table and Column

TELEPHO QUERY apps.po_vendor_sites_all area_code || '-' || phone

here the column is really a concatination of columns


UOM TEXT EACH

Here is a sample constant it is TEXT rather than QUERY
The one thing you can't give for your heart's desire is your heart. - Lois McMaster Bujold