Chapter 6 Exchanging data with databases supporting XML
Microsoft SQL Server 2000 is an XML-enabled database server. It supports annotations that can be used on XSD or XDR files, to map XML data to relational data.
An annotated schema is an XML-coded file, targeted with an XML language and tagged with specific DBMS annotations, that allows 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 or XDR) for SQL Server 2000. You need first to map an XML model to a PDM, then to attach the Microsoft SQL Server extended model definition to the mapped XML model. If need be, you can complete the mapping by defining extended attributes to XML objects.
| Copyright (C) 2007. Sybase Inc. All rights reserved. |
| |