RE: [ebxml-dev] SQL4

This kind of functionality is exposed by the OASIS CAM specification.

If you go to http://www.jcam.org.uk - you can download the jCAM implementation.

You should be able to add your SQL4 as an <Extension> and use Maven to link in your SQL4 processor.

I already built something very similar - for XML scripting into Oracle SQL database - as a demo - but we did not release it.

<Extension> is used already for lookup codelists - so if you add a codelist to a CAM template - you will see how the jCAM engine handles that - and how the <Extension> xml is created by the Eclipse editor.

Basically you have implemented what the CAM specification calls the <DataMapping> extension.

Once you have that plug-in working - we can look at potentially standardizing this through the OASIS process.

Essentially though - not everyone will want to publically expose their database mappings. I envision this more of an <as:include> that points to the mapping internally - but that is not necessarily made public - depends on the choice of the customer.

However - I do see that package vendors - such as SAP and QuickBooks and so on - would want to make CAM templates available that map from standard Windows accounting products to XML invoices and POs and so on.

You can extend the Eclipse editor to build the SQL4 xml syntax using drag-and-drop field association between the XML structure and the backend SQL database table(s).

Seems like SQL4 can definately provide that capability - with the open standard processing engine to support that.

You can find the current CAM specification at http://docs.oasis-open.org/cam

Thanks, David Webber

Chair OASIS CAM TC.

"The way to be is to do" - Confucius (551-472 B.C.)

-------- Original Message --------
Subject: [ebxml-dev] SQL4
From: Dmitry Turin <sql4-en@narod.ru>
Date: Fri, September 28, 2007 2:34 am
To: ebxml-dev@lists.ebxml.org

Good day.

I have invented programming language SQL4 for DBMS,
which __simplifies e-business__ by merging SQL and XML:
it put XML into database and get XML from database via HTTP
(tree's model of data is over rational model).
http://sql40.chat.ru/site/sql40/en/author/introduction_eng.htm
http://sql40.chat.ru/site/sql40/en/author/determination_eng.htm
http://sql40.chat.ru/site/sql40/en/author/inout_eng.htm
I already have wrote to SC32 to
Mr. Dr. Timothy SCHOECHLE sc32-sec@jtc1sc32.org, timothy@schoechle.org,
Mr. Bruce BARGMEYER bebargmeyer@lbl.gov,
to Russian National Body to N.P.Pankratova info@gost.ru, npankratova@gost.ru
and to SC22 to Sally Seitz SSeitz@ansi.org.
Really Russian never took part in jtc1sc32 WG3 and others WG.
Thus i must to find other organization (ANSI or X/Open) to standardaze.
I don't find any Work Groups or mailing lists of ANSI or X/Open,
so i ask you to help.

Please prompt me how to standardize SQL4.
What procedures i must to execute ?

I will very thankfull to you for any help.

Dmitry Turin
SQL4 (4.3.0) http://sql40.chat.ru
HTML6 (6.4.1) http://html60.chat.ru
Unicode2 (2.1.0) http://unicode2.chat.ru
Computer2 (2.0.3) http://computer20.chat.ru