[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
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/
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@p... 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
|
To
| "'Arthur S Bridges'"
<Arthur_S_Bridges@p...>,
<xml-dev@l...>
|
cc
| <arthursb73@g...>
|
Subject
| 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 http://www.saxonica.com/
_____
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 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@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]
|
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
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.
|
|