[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: XML and databases

  • From: "Michael Kay" <mike@s...>
  • To: "'Arthur S Bridges'" <Arthur_S_Bridges@p...>
  • Date: Thu, 26 Apr 2007 16:05:54 +0100

RE:  XML and databases
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

From: Arthur S Bridges [mailto:Arthur_S_Bridges@p...]
Sent: 26 April 2007 15:20
To: Michael Kay
Cc: arthursb73@g...; xml-dev@l...
Subject: RE: 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
Mayfield Village , Ohio , 44143 USA

This http://microformats.org/wiki/hcard created with the http://microformats.org/code/hcard/creator.

"Michael Kay" <mike@s...>

04/26/2007 10:00 AM

"'Arthur S Bridges'" <Arthur_S_Bridges@p...>, <xml-dev@l...>
RE: 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


From: Arthur S Bridges [mailto:Arthur_S_Bridges@p...]
Sent: 26 April 2007 14:27
To: xml-dev@l...
Cc: arthursb73@g...
Subject: 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

We plan to use XQuery/XSLT as well as C# for access/update

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@p...> Arthur_S_Bridges@p...

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

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


Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
First Name
Last Name
Subscribe in XML format
RSS 2.0
Atom 0.3

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.

Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.