RE: [xml-dev] XML and databases
We are also worried about multiple user access and asynchronous updates
Arthur Scott Bridges
IT Security — SCD
[email protected]
Mayfield Village , Ohio , 44143 USA
This hCard
created with the hCard
creator.
| "Michael Kay"
<[email protected]>
04/26/2007 10:00 AM |
|
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:[email protected]]
Sent: 26 April 2007 14:27
To: [email protected]
Cc: [email protected]
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:[email protected]> [email protected]
[attachment "C.htm" deleted by Arthur S Bridges/Guest/Progressive]