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


Help: OASIS Mailing Lists Help | MarkMail Help



   RE: Embedding SQL statements in XML

[ Lists Home | Date Index | Thread Index ]
  • From: Michael Rys <mrys@microsoft.com>
  • To: Michel Rodriguez <mrodrigu@ieee.org>, xml-dev@lists.xml.org
  • Date: Wed, 15 Nov 2000 23:01:40 -0800

Besides the reference to the excellent overview page at
http://www.rpbourret.com that was already mentioned, I would like to point
you to the template mechanisms that many database vendors provide (some
tool-vendors already pointed to theirs). Examples are the SQLX templates in
Oracle 8i (that you already found), DADs in IBM DB2 and last but certainly
not least the query templates of SQLServer 2000 (that I find to be the best
of the bunch but then I am biased :-)).

There is currently no standardization of the mechanism for various reasons.
The SQL community is now starting to investigate XML related issues to

I do not think that it is the W3C's role to issue recommendation on
relational database specific technology, but then again, I may be wrong on

Best regards
Program Manager, SQL Server XML Technologies
mrys@microsoft.com, rys@acm.org
We store the Web and more...

> -----Original Message-----
> From: Michel Rodriguez [mailto:mrodrigu@ieee.org]
> Sent: Tuesday, November 14, 2000 11:07 AM
> To: xml-dev@lists.xml.org
> Subject: Embedding SQL statements in XML
> Hi,
> I was wondering whether some work, maybe standardization 
> work, has been
> done on embedding data from a relational database into an XML 
> document.
> The document is processed to generate the complete XML 
> document, but the
> non-processed version is the one that is edited and managed 
> in the system.
> I have found no trace of public work on that topic, although 
> I know of a
> couple of old SGML implementations.
> I realize that various type of results can be required, from a single
> value to a complete table, through one or more rows or 
> columns (columns
> being even trickier than rows). Plus the queries can be variously
> parametrized and connection to the DB is always a problem. But I am
> surprized not to find _anything_ on the subject.
> I am looking at something like standard fragments looking like 
> <p> text <sql_value db="db1" query="select price from book where
> isbn=123456"> more text</p>
> for single values and like
> <tr><sql_row db="db2" query="select title, price from book where
> isbn=123456"></tr>
> for rows
> Would anyone know of anything in this area?
> Thank you
> Michel Rodriguez
> Perl & XML


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

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