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

Re: CLOB with side tables

• To: Helena Forsberg <helenaforsberg@h...>
• Subject: Re: CLOB with side tables
• From: Rick Marshall <rjm@z...>
• Date: Tue, 16 Sep 2003 07:35:29 +1000
• Cc: xml-dev@l...
• In-reply-to: <1063629341.4e133500helenaforsberg@h...>
• Organization: Zenucom Pty Limited
• References: <1063629341.4e133500helenaforsberg@h...>
• Reply-to: rjm@z...

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

regards

rick

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>
> 

• References:
  • CLOB with side tables
    • From: "Helena Forsberg" <helenaforsberg@h...>

• Prev by Date: Re: XML Spy and mixed content
• Next by Date: Ann: ebxmlrr 2.1-final1 open source ebXML Registry
• Previous by thread: Re: CLOB with side tables
• Next by thread: RE: CLOB with side tables
• Index(es):
  • Date
  • Thread