![](/images/new-backgrounds/1214202/214202483x1.webp)
Generating an annotated schema for Oracle 9i2
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:
1Select Model→Extended Model Definitions. The List of Extended Model Definitions appears.
2 Click the Import an Extended Model Definition tool.
230 | PowerDesigner |