OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

 


 

   RE: [xml-dev] RDBMS DB export

[ Lists Home | Date Index | Thread Index ]

The mapping that was added maps rows to elements with the name of the
table.

And the column names are being encoded in case they do not fit XML's
naming rules. E.g., "Order Details" => Order_x0020_Details. Not
beautiful but effective.

Best regards
Michael 

> -----Original Message-----
> From: Berend de Boer [mailto:berend@xsol.com]
> Sent: Sunday, November 24, 2002 12:23 PM
> To: Jonathan Robie
> Cc: Debasis Das; xml-dev@lists.xml.org
> Subject: Re: [xml-dev] RDBMS DB export
> 
> Jonathan Robie wrote:
> 
> > ANSI and ISO are working on SQL/XML, which provides a standard
mapping
> > from tables to W3C XML Schema. Here's a good article on SQL/XML by
Jim
> > Melton and Andrew Eisenberg:
> >
> >         http://www.acm.org/sigmod/record/issues/0206/standard.pdf
> >
> > I believe they have added an alternative mapping since this article
> > was written.
> 
> 
> Let's hope so. This was really a mapping done by people who didn't
seem
> to know a thing about column names for example. There is no guarantee
> that your column is a valid XML tag name. Actually, a column name may
> contain spaces...
> 
> Debasis, I suggest to roll your own.
> 
> Regards,
> 
> Berend. (-:
> 
> 
> -----------------------------------------------------------------
> The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
> initiative of OASIS <http://www.oasis-open.org>
> 
> The list archives are at http://lists.xml.org/archives/xml-dev/
> 
> To subscribe or unsubscribe from this list use the subscription
> manager: <http://lists.xml.org/ob/adm.pl>





 

News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS