RE: [xml-dev] XML and databases

• From: Arthur S Bridges <Arthur_S_Bridges@...>
• To: "Michael Kay" <mike@...>
• Date: Thu, 26 Apr 2007 10:19:35 -0400

This hCard created with the hCard creator.

"Michael Kay" <mike@...> 04/26/2007 10:00 AM

To "'Arthur S Bridges'" <Arthur_S_Bridges@...>, <xml-dev@...> cc <arthursb73@...> Subject RE: [xml-dev] XML and databases

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@...]
Sent: 26 April 2007 14:27
To: xml-dev@...
Cc: arthursb73@...
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
<mailto:Arthur_S_Bridges@...> Arthur_S_Bridges@...




[attachment "C.htm" deleted by Arthur S Bridges/Guest/Progressive]