[XML-DEV Mailing List Archive Home]
[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
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
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.
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
This http://microformats.org/wiki/hcard created with the http://microformats.org/code/hcard/creator.
04/26/2007 10:00 AM
|"'Arthur S Bridges'"
|RE: XML and
25,000 records x 12 fields x 20 bytes = 6Mb which is certainly
a single XML document loaded into memory, unless you need
transactional updates and concurrency etc. Multiply by 10 and
straining it a bit. I think I'd go for an XML
From: Arthur S Bridges
Sent: 26 April 2007 14:27
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.
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
which needs to be kept up to date with personnel
We plan to use XQuery/XSLT as well as C# for
out there had to deal with a project of this size?
We are planning to run a web service fro Query and update
Thank you for any response and
Arthur Scott Bridges
Security - SCD
[attachment "C.htm" deleted by Arthur S
| [Thread Prev]
| [Thread Next]
| [Date Next]
| [Thread Index]
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format
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