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

 


Help: OASIS Mailing Lists Help | MarkMail Help

 


 

   Re: SQL database table structure for encoding XML documents?

[ Lists Home | Date Index | Thread Index ]
  • From: Paul Janssens <paul.janssens@skynet.be>
  • To: Tony McDonald <tony.mcdonald@ncl.ac.uk>
  • Date: Mon, 29 Mar 1999 16:00:50 +0200

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@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@ic.ac.uk the following message;
(un)subscribe xml-dev
To subscribe to the digests, mailto:majordomo@ic.ac.uk the following message;
subscribe xml-dev-digest
List coordinator, Henry Rzepa (mailto:rzepa@ic.ac.uk)





 

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

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