Re: What is the logic of storing XML in a Database?

On 29 mar, 22:54, Bernard Peek <b..._at_alpha.shrdlu.com> wrote:
> On 2007-03-29, David Cressey <cresse..._at_verizon.net> wrote:
>
> > You've gotten lots of answers to that question, but all of those answers
> > beg the following question: why would you want to do those things outside
> > the context of a DBMS, if you could do them inside the context of a DBMS?
>
> Good question.
>
> If I could manage the transfer inside the DBMS I would. There is little
> point in translating the data into XML then back into native format again.
>
> If all database systems had a standard interface to do that with then we
> could just connect the databases together and move data around.
>
> In fact there are already two systems that do that. One is XML, the other is
> ODBC. I understand that ODBC uses a primitive dialect of SQL to select data
> for transmission. If it could be replaced by a better language then it might
> be usable.
I am curious about this statement. More than 4 ou of 5 dbms's (namely ORACLE, DB2, SQL Server) can perfectly communicate db to db using ODBC, OLE DB or Native providers. Why exactly would XML be necessary on all of them because one out of 5 minor technologies do not use XML? Is there any *good reason* XML is necessary?

> b..._at_shrdlu.com
> In search of cognoscenti
Received on Fri Mar 30 2007 - 08:04:09 CEST