[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: RDBMS DB export

• To: "Berend de Boer" <berend@x...>,"Jonathan Robie" <jonathan.robie@d...>
• Subject: RE: RDBMS DB export
• From: "Michael Rys" <mrys@m...>
• Date: Mon, 25 Nov 2002 09:34:35 -0800
• Cc: "Debasis Das" <debasis.das@e...>,<xml-dev@l...>
• Thread-index: AcKT95P+5deYW2PLQ2+QNNFSOxG8QwAq4N3g
• Thread-topic: RDBMS DB export

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@x...]
> Sent: Sunday, November 24, 2002 12:23 PM
> To: Jonathan Robie
> Cc: Debasis Das; xml-dev@l...
> Subject: Re:  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>

• Follow-Ups:
  • Re: RDBMS DB export
    • From: Berend de Boer <berend@x...>

• Prev by Date: Re: XML, Rich Internet Apps
• Next by Date: Re: RDBMS DB export
• Previous by thread: New XSV release
• Next by thread: Re: RDBMS DB export
• Index(es):
  • Date
  • Thread