6.4. Using XSU for Fine-Grained Storage

Handling XML documents in a fine-grained manner is supported by Oracle's XSU (XML SQL Utility). XSU is a programmatic interface for Java and PL/SQL programs. XSU supports two directions:

  1. XSU transforms data from object-relational tables or views into XML; XML documents are generated out of relational data.

  2. Splitting XML documents into pieces and storing them in tables the other way around.

6.4.1. Canonical Mapping

The basis for both directions is a schematic mapping from relational structures to XML. Given an SQL query related to any tables or views, an XML document is produced:

  • The whole query result is enclosed by <ROWSET> . . . <σ/ROWSET>

  • Each tuple of the result is put in <ROW> . . . </ROW>

  • Attribute values ...

Get XML Data Management: Native XML and XML-Enabled Database Systems 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.

Start your free trial