OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   Re: [xml-dev] Can xsd ???

[ Lists Home | Date Index | Thread Index ]

uzair ahmad wrote:

> Can a XML Schema Document perfectly describe some Database Schema. More
> specifivally , doese it have the enough vocabulary to decribe MetaData
> constarints (classes, attributes, relationships, datatypes ).

Describe, yes. Perfectly describe, no.

1) Tables can be described with elements with complex types.

2) Columns can be described with elements with simple types.

3) Nullability can be described by optionality of child elements.

4) Primary keys and primary key / foreign key relationships can (sort
of) be described by key/keyref. (I say "sort of" because key/keyref
applies to a single XML document. If your XML documents correspond to a
single row of data, key/keyref is insufficient for enforcing uniqueness
and referential integrity.)

5) The following cannot be described: cascading update/delete, triggers,
catalogs, schemas (in the catalog/schema/table sense), indexes, and all
of the database-specific things you find in CREATE TABLE statements.

-- Ron

  • References:
    • Can xsd ???
      • From: "uzair ahmad" <letsjoin@hotmail.com>


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS