RE: [xml-dev] XML and databases

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

Come to think of it, you didn't mention whether there was any characteristic of the data that means you can't store it in a relational database. (I tend to forget about ancient technologies but they still work...)

 

My experience of hybrid relational/XML databases is that there's a lot of awkward language switching involved - you constantly have to remember whether you're in SQL mode or XQuery mode, which function calls and operators are available in which mode, and how to escape your multiply nested quotes. Unless you actually have hybrid relational/XML data (and perhaps even then), they wouldn't be my first choice.

 

(And I might be wrong, but I didn't think SQL Server 2005 had any useful level of XQuery support anyway.)

 

For 11Mb I'd be happy to use an in-memory approach (e.g. Saxon) if it's essentially read-only, but I'd think twice about it if there's significant concurrent update traffic. 

 

Michael Kay

http://www.saxonica.com/

---

From: Arthur S Bridges [mailto:Arthur_S_Bridges@progressive.com]
Sent: 26 April 2007 15:20
To: Michael Kay
Cc: arthursb73@gmail.com; xml-dev@lists.xml.org
Subject: RE: [xml-dev] XML and databases

Unfortunately, the company's preferred platform is SQL Server, but with v 2005's XML capabilities, we may make it work.

Also just rechecked, 18 fields and many descriptions are detailed. -  11 Mb -

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]