dotnet xml: Hi All,

I've searched the web for an article explaining the many tradeoffs between
storing your XML in a database vs the filesystem but I haven't really found
anything of note.

This is the little I've come up with:

FileSystem Pros:

1) more scaleable than db, although I haven't seen data on how much more
2) you can index your xml files using third party tools (although from what
I've found there seems to be a distinct dearth of these for the windows
platform. LOTS for unix and co.)

FileSystem Cons:

1) if you have any data in a db you must be very careful with integrity.

DB Pros:

1) many dbs now (and Yukon later) will allow you to do xpath or xquery
against xml. not sure what the indexing support is like...
2) if you have other data in db then you can get it from a single source

DB Cons:

1) xml support seems to have been grafted on to most major rdbms, and is
still a big question mark...
2) less scaleable than filesystem

If anyone can point me to resources that address this question I would be
grateful. References to good xml file indexers for windows, case studies on
performance differences, details on Yukon + xml, etc. would all be very
useful...

--
Lucas Fletcher
lucas@dealersinnotions.com
http://dealersinnotions.com

See below for some additional datapoints.

Best regards
Michael Rys

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.



[quoted text, click to view]
We will support indexing of native XML datatypes.
And if your XML represents relational data, you can already use XPath
against annotated schema views to query your data...
[quoted text, click to view]

There are some additional advantages such as recovery, concurrency control
etc, that you don't get from a basic filesystem.

[quoted text, click to view]
Actually that is not the case anymore (at least not for Yukon and for
Oracle).
[quoted text, click to view]
This depends on what you use as your scaling criteria. If you scale query
performance, then the DB should be better.

[quoted text, click to view]

For public details on Yukon you currently have to either enroll into the
Beta1 release (which is full, but wait list places are still available if I
remember correctly) or wait until early next year when the public beta
ships.

As to resources: Did you look at Ron Bourret's web page on XML and
databases?
[quoted text, click to view]