Generating an Annotated Schema for Oracle 9i2

Oracle 9i2 is a database server with a native XML storage and retrieval technology called Oracle XML DB. There is no mapping between XML data and relational data. Tables, columns and abstract data types (ADT) are created from annotated schemas (XSDs). Annotated schemas are XML-coded files, targeted with an XML language and tagged with specific DBMS annotations, that allow you to store or retrieve data in an XML format, from relational databases supporting XML.

An XML model allows you to generate an annotated schema (XSD) for Oracle 9i2. Oracle 9i2 uses by default the name of the XML elements present in the annotated schema to generate SQL objects. You can override the creation of SQL objects by defining extended attributes for elements, complex types and the XML model.

To enable these extensions in your model, select Model > Extensions, click the Import tool, select the Oracle XML DB (on the XML in Database tab), and click OK to attach it.

• Oracle Extended Attributes for Elements and Attributes
  You can set extended attributes on various XSM objects to define mappings with an Oracle database.
• Generating the Oracle Annotated Schema File
  You generate the annotated schema file by selecting it as an additional target for standard schema generation.