RE: [xml-dev] XML and databases

["Michael Kay" <mike@saxonica.com>]

25,000 records x 12 fields x 20 bytes = 6Mb which is certainly doable using a single XML document loaded into memory, unless you need fine-grained transactional updates and concurrency etc. Multiply by 10 and you're straining it a bit. I think I'd go for an XML database.

 

Michael Kay

http://www.saxonica.com/

---

From: Arthur S Bridges [mailto:Arthur_S_Bridges@progressive.com]
Sent: 26 April 2007 14:27
To: xml-dev@lists.xml.org
Cc: arthursb73@gmail.com
Subject: [xml-dev] XML and databases

I am working on a large data classification dictionary in XML and I am wondering at what point do I need to use a database as a back end.

Project Profile:
        From a 'table' point of view, I have about a dozen fields and 25,000 records which we project to grow to 250,000+
        Each record contains resource profiles and descriptions as well as ownership information which needs to be kept up to date with personnel changes.
        We plan to use XQuery/XSLT as well as C# for access/update programming

Has anyone out there had to deal with a project of this size?

We are planning to run a web service fro Query and update functions.

Thank you for any response and Suggestions

Arthur Scott Bridges
IT Security — SCD
Arthur_S_Bridges@progressive.com