> I would normally responsd to specific messages, but I am away from my
> email client. However, I wanted to address the question in regard to XML
> storage as well as the responses.
>
> First, storing XML in an RDBMS is not a good idea. See my article on the
> subject at http://builder.com.com/5100-6388-1051795.html.
From that article:
"The two most common solutions for storing XML in an RDBMS,
mapping the schema to database rows and storing the entire
document as a single character large object (CLOB) field, both
present limitations. In the mapping method, the database has no
awareness of the data�s context or hierarchy. Parts of the XML
document are spread around the database and physically occupy
different parts of the server. As a result, any SQL queries
involve a time-consuming search for and reconstruction of the
parts. The CLOB method, on the other hand, avoids these context
issues. Instead of mapping schema to rows, the database preserves
the data context and hierarchy in one unit. However, a SQL query
cannot look inside the field holding the document and interpret
it�the only way to examine parts of a document is to return the
whole thing in a result set."
I haven't laid hands on the final version yet, but drafts of the
SQL-2003 standard section 14 defined an XML datatype which
maintained the internal structure of the XML document. That means
you can XQuery it. And there are several implementations of such
functionality in databases.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
