[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Primary and Foreign Keys

• From: "Bullard, Claude L (Len)" <clbullar@i...>
• To: xml-dev <xml-dev@l...>
• Date: Fri, 20 Jul 2001 14:30:18 -0500

A more fun question:

Given a relational database for which one creates a 
parallel XML schema, how do others think key relationships 
should be described:

1.  Simple types with the insurance that corresponding 
values exist in both tables (doesn't seem very strong to me).

2.  Key/keyrefs

3.  ID/IDREFs (probably a non-starter given the caveat)

4.  XLinks

Caveat:  It is usually the case that the schema will be broken 
up into multiple schema given that the original is 
for a very large (field and table wise) relational 
system. Also note, this is going from relational to 
XML Schema, not the other way around.

Len 
http://www.mp3.com/LenBullard

Ekam sat.h, Vipraah bahudhaa vadanti.
Daamyata. Datta. Dayadhvam.h

• Follow-Ups:
  • Re: Primary and Foreign Keys
    • From: "Thomas B. Passin" <tpassin@h...>
  • Re: Primary and Foreign Keys
    • From: Ronald Bourret <rpbourret@r...>

• Prev by Date: Question re: unwanted whitespace and html output
• Next by Date: Re: Blueberry is not "closed" (was: Closing Blueberry)
• Previous by thread: Re: Question re: unwanted whitespace and html output
• Next by thread: Re: Primary and Foreign Keys
• Index(es):
  • Date
  • Thread