xml-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paulo Gaspar" <paulo.gas...@krankikom.de>
Subject RE: Microsoft XML stuff
Date Fri, 14 Jul 2000 17:34:13 GMT
Make it ADO instead of ODBC.

ADO 2.5 directly generates XML from data. It is even very strong at
generating SHAPEd data. But SAHPEd data in ADO terminology means
hierarchical data.


The MS SHAPE OleDB Data Provider is a kind of a filter on top of
another OleDB data provider which uses a wrapping syntax to
agregate hierarchical data from multiple SQL queries.

It is a quite interesting ADO functionality:
 - The syntax is such that it allows any kind of SQL that the
   "filtered/real" data provider supports;
 - Can build hierarchies in a iterative way - which demands many
   round trips to the database but is very flexible;
 - Can query all the data for each SQL statement and then build the
   hierarchy in memory - which is not so flexible but is damn fast,
   due to less roundtrips.


And then you can convert the nested datasets into XML, of course.


Oracle has something similar. The best interface to check Oracle's
data-to-XML tools is the XSQLServlet. Very very interesting too.
And its Java.


Have fun,

Paulo Gaspar


> -----Original Message-----
> From: Scott Boag/CAM/Lotus [mailto:Scott_Boag@lotus.com]
> Sent: Thursday, July 13, 2000 06:29
>
>
> No.  It means an API that is set up to be friendly for table-shaped data,
> as in an export from ODBC rowsets, rather than irregular data as you might
> find in a document.  At least 50% of XML used in business transactions is
> likely to be table-shaped-regular, so this makes sense.  For the database
> crowd.  Not sure of details.



Mime
View raw message