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