XML-Enabled Databases
The latest releases of most popular RDBMS systems include some form of direct XML support. Microsoft's SQL Server 2000 includes features such as the OpenXML() function and the FOR XML extension to the SELECT statement. These two features allow XML data to be incorporated into relational queries in addition to returning query results in XML format. Oracle's 8i and 9i products provide comparable functionality.
Retrieving query results from the database server directly in XML format is the most efficient way to integrate XML into an application. Figure 9.4 illustrates how an application can take advantage of an XML-aware database server.
Figure 9.4. Application using XML-aware database and drivers.
Currently there is a lack ...
Get Strategic XML now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
