User manual

Generating an annotated schema for Oracle 9i2
230 PowerDesigner
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. You just need to attach the Oracle 9i2 extended model
definition to the XML model. 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.
Caution
The following procedure assumes you have an XML model open in the
workspace and targeted with XSD.
 To generate an annotated schema for Oracle 9i2:
1 Select Model→Extended Model Definitions.
The List of Extended Model Definitions appears.
2 Click the Import an Extended Model Definition tool.