XML.orgXML.org
FOCUS AREAS |XML-DEV |XML.org DAILY NEWSLINK |REGISTRY |RESOURCES |ABOUT
OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index]
RE: [xml-dev] XML and databases


We are also worried about multiple user access and asynchronous updates

Arthur Scott Bridges
IT Security — SCD
Arthur_S_Bridges@progressive.com
Mayfield Village , Ohio , 44143 USA

This hCard created with the hCard creator.


"Michael Kay" <mike@saxonica.com>

04/26/2007 10:00 AM

To
"'Arthur S Bridges'" <Arthur_S_Bridges@progressive.com>, <xml-dev@lists.xml.org>
cc
<arthursb73@gmail.com>
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@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

<mailto:Arthur_S_Bridges@progressive.com> Arthur_S_Bridges@progressive.com




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


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index]


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

Copyright 1993-2007 XML.org. This site is hosted by OASIS