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


Help: OASIS Mailing Lists Help | MarkMail Help



   Re: [xml-dev] CLOB with side tables

[ Lists Home | Date Index | Thread Index ]

Hi Helena

we do similar things, but with a bit of work

use a doc based parser to extract the index elements and then use
uuencode or some other base 64 encoding program to create regular, ascii
text records for storing in the database

works well for us a general technique and it's good for any sort of
blobs/clobs not just xml



On Mon, 2003-09-15 at 22:35, Helena Forsberg wrote:
> Hi
> Is there any other database than DB2 that supports the storing of an XML document as a BLOB/CLOB with some key elements stored in relations? My queries will only involve 6 or 7 elements in a doument of possibly 100 elements, so I want to store them on the side for querying and then get the whole document as an answer to my query. I'm especially interested in Informix or MS SQL Server since that is our current investments. 
> Thank you,
> Helena
> -----------------------------------------------------------------
> The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
> initiative of OASIS <http://www.oasis-open.org>
> The list archives are at http://lists.xml.org/archives/xml-dev/
> To subscribe or unsubscribe from this list use the subscription
> manager: <http://lists.xml.org/ob/adm.pl>


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

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