Wednesday, 14 November 2007

XML and Oracle

The final session yesterday (sorry late post) was on Oracle XML database. The first to say is Oracle XML is not a separate product, but functionality embedded with the database, some of which has existed since version  9.

Oracle 11g has introduced a raft of new features to support XML, and also brings orders of magnitude improvements in performance. 11g also has an XML parser built into the database engine. This allows the XML to be processed quicker with specific memory management optimisations.

In previous versions either structured (that is xml data with an associated schemer) or unstructured XML was supported. Now in version 11 supports binary XML has been added. XML data can now be treated as if it was SQL data, with store, query, update and transform now being manipulated by SQL

No comments: