Working with XML and Databases

Many relational databases now support XML so that you can store or retrieve data through XML files. You can use an XML model to generate an annotated schema that will allow you to store or retrieve data in such a database.

The following databases are available :

By attaching the SQL/XML extensions to an XML model mapped to a PDM, you can also generate SQL/XML queries to retrieve data in an XML format, from relational databases supporting SQL/XML.

• Mapping Database Objects to an XML Schema Via the XML Builder Wizard
  You can create an XSM to generate an annotated schema from a PDM via the XML Builder.
• Generating an SQL/XML Query File
  SQL/XML is an XML extension of the Structured Query Language, which allows you to retrieve relational data using extended SQL syntax, and produce an XML result. You can generate SQL/XML queries for global elements in your XSM, whatever the targeted XML language (XSD, DTD or XDR).
• Generating an Annotated Schema for Microsoft SQL Server
  Microsoft SQL Server is an XML-enabled database server, which supports annotations that can be used on XSD or XDR files, to map XML data to relational data.
• 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.
• Generating a DAD File for IBM DB2
  IBM DB2 v8.1 (or higher) is a database server with an add-in for XML storage and retrieval called IBM DB2 Extender. XML data (elements, attributes) are mapped to relational data (tables, columns) through Document Access Definition files (.DAD).