Chapter 9 Generating Other Models from a PDM
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.
You can generate annotated schemas from XML models mapped or not with PDMs and linked with the appropriate DBMS extended model definition (XEM file). When a mapping is needed, you should use the XML Builder Wizard.
The following table lists the DBMS for which you can generate annotated schemas:
Targeted DBMS |
Mapping with XML Builder Wizard | Targeted XML language |
Required XEM file |
|---|---|---|---|
| Microsoft SQL Server 2000 | Yes | XSD or XDR | Microsoft SQL Server |
| Oracle 9i2 | No | XSD | Oracle 9i2 |
| IBM DB2 v8.1 | Yes | DTD | IBM DB2 DAD |
For more information on generating annotated schemas, see chapter Exchanging data with databases supporting XML, in the XML Model User's Guide .
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |