Re: Database schema

Hi,

Mansour Al Akeel <mansour.alakeel@gmail.com> writes:

> Is there a way that I can transform these xml sxhemas to database
> schema and use an orm mapping and/or xml binding to process the
> objects.

One approach would be to use an XML database with an XML data binding
layer generated from your schemas on top of it. A big advantage of
this setup is that you can use various query mechanisms (e.g., XPath,
XQuery) normally provided by XML databases in addition to the object
model. For example, you can select a subset of XML documents or a
subset of elements in a particular XML document based on some criteria
using XPath and then work on the results using the object model.

If the integration is tight then this can also be quite efficient
in that instead of DB-to-XML and XML-to-OM (OM for object model),
in a tightly-integrated setup it can be just DB-to-OM. For example,
our CodeSynthesis XSD[1] works on top of Berkeley DB XML[2]. DB XML
exposes XML data as DOM fragments and XSD-generated object model can
load/store from/to these DOM fragments. You can get an idea on how
the application code might look like from this guide:


http://www.codesynthesis.com/projects/xsd/documentation/cxx/tree/dbxml/


[1] http://www.codesynthesis.com/products/xsd/
[2] http://www.oracle.com/database/berkeley-db/xml/index.html

Boris

-- 
Boris Kolpackov, Code Synthesis Tools
Open source XML data binding for C++:   http://codesynthesis.com/products/xsd
Mobile/embedded validating XML parsing: http://codesynthesis.com/products/xsde