xml-dev - RE: Embedding SQL statements in XML

[Michael Rys <mrys@microsoft.com>]

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
standardize.

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
this....

Best regards
Michael
--
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
>