SQL database table structure for encoding XML documents?

[Paul Janssens]

Tony McDonald wrote:
> 
> Well, the subject says it all really.
> 
> Does anyone have a structure that works for them that they're willing
> to share? ie

No, but from the top of my head:

ENTITYNAMES
tag,   name

ENTITY
uniquekey,   tag,parententitykey,index

ATTRIBUTE
ownerentitykey,name,   value

CONTENT
ownerentitykey,index,   data

You don't have validation, but you do have referential integrity, and
you can render back to XML with a simple transitive closure.

xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev at ic.ac.uk
Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/ and on CD-ROM/ISBN 981-02-3594-1
To (un)subscribe, mailto:majordomo at ic.ac.uk the following message;
(un)subscribe xml-dev
To subscribe to the digests, mailto:majordomo at ic.ac.uk the following message;
subscribe xml-dev-digest
List coordinator, Henry Rzepa (mailto:rzepa at ic.ac.uk)