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

 


Help: OASIS Mailing Lists Help | MarkMail Help

 


 

   [xml-dev] XML Storage Architecture

[ Lists Home | Date Index | Thread Index ]
  • To: <xml-dev@lists.xml.org>
  • Subject: [xml-dev] XML Storage Architecture
  • From: "Jason Kohls" <jkohls@infotechresearchgroup.com>
  • Date: Thu, 11 Sep 2003 08:48:48 -0400
  • Thread-index: AcN4QYuL6NCS92NsTfeaG50LVXhTwwAH4wfQ
  • Thread-topic: [xml-dev] XML Storage Architecture

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




 

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

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