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] XML Storage Architecture

[ Lists Home | Date Index | Thread Index ]

Jason,

There are some good solutions for this...someone will be along in the
near future to talk about SQL/XML and XQuery.

Over to Jonathan...

Kind Regards,
Joe Chiusano
Booz | Allen | Hamilton

Jason Kohls wrote:
> 
> Greetings,
> 
> We're looking at a content management system, which stores all of the content/metadata in a single, 1 MB XML file on disk or as separate records (for each parent element) in a two-field table in SQL, out-of-the-box. Based on our rough content estimates, however, we can see this file growing to over 100 MB easily.  The CMS provider says that anything over 30 MB should use the SQL backend.
> 
> The one thing that we do not like is the schema/data model (or lack of) for the SQL storage option.  Coming from the relational camp, this seems odd to us, and even on disk, hierarchically, it seems to make more sense to break up this single XML file into smaller files (per parent element) in a directory structure with an index.
> 
> ...But then again, you guys are the experts :)
> 
> Can anyone see any problems with this storage architecture from a performance/stability/scalability standpoint?
> 
> Thanks in advance!
> 
> Jason Kohls
> 
> -----------------------------------------------------------------
> 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>
begin:vcard 
n:Chiusano;Joseph
tel;work:(703) 902-6923
x-mozilla-html:FALSE
url:www.bah.com
org:Booz | Allen | Hamilton;IT Digital Strategies Team
adr:;;8283 Greensboro Drive;McLean;VA;22012;
version:2.1
email;internet:chiusano_joseph@bah.com
title:Senior Consultant
fn:Joseph M. Chiusano
end:vcard




 

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

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