[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: Can xsd ???
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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|