Jump to content

Triangle => Square

NewsBot
 Share

Recommended Posts

NewsBot Newbie

NewsBot

Posted
Posted

Has anyone here experimented with modelling XML (or some reasonable subset of the XML Information Set) as SQL tables? I know there are support for XML in some databases, but for those that don't have support, how'd you do it? [Actually the underlying database does support it, but the application platform over it does not.] I'm thinking the simplest solution is to have a nodeId, a nodeParentId, a nodeName, a nodeType (att, elem, text, cdata, pi, comment, ...) a nodeValue and possibly some more (maybe XS types). Binary nodes could be encoded as BLOB and output as Base64 encoded text. However, if you had such a structure it would be very convenient to also have an XPath implementation to query over it. That would be the next problem...

 

More...

 

View All Our Microsoft Related Feeds

View All Our Microsft Related Feeds
  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...