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 ]

You certainly can use SQL Server for this type of processing.  In the past we have designed repositories that use the Text or nText datatypes to house the XML file while defining relationships to other tables that contain metadata about the document.  All pretty straightfoward stuff.
 
However, if you have a need for more XML aware processing take a look at Oracle's 9i+ platform (XDB).  XDB provides the ability to store XML in it's native format and query using XPath, etc.  
 
Good luck!
 
 
 
 
 

	-----Original Message----- 
	From: Murali Mani [mailto:mani@CS.UCLA.EDU] 
	Sent: Mon 9/15/2003 9:04 AM 
	To: Helena Forsberg 
	Cc: xml-dev@lists.xml.org 
	Subject: Re: [xml-dev] CLOB with side tables
	
	


	I believe DB2 XML Extender will provide you *exactly* what you asked for.
	best regards - murali.
	
	On Mon, 15 Sep 2003, 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>
	>
	
	
	-----------------------------------------------------------------
	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