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

On Mar 30, 6:05 pm, "Aloha Kakuikanu" <aloha.kakuik..._at_yahoo.com>
wrote:
> On Mar 29, 11:04 pm, "Cimode" <cim..._at_hotmail.com> wrote:>> > On 29 mar, 22:54, Bernard Peek <b..._at_alpha.shrdlu.com> wrote:> > > 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?>> You don't need ODBC to copy the data from one database to the other.> You need to execute 2 commands:>> create database link remoteDB <connection details>;>> create table Emp as> select * from Emp_at_remoreDB;>> You can even join 2 tables from different databases. The details how> database support it are not important.
Agreed.
Check my post for more detailed info...Besides comparing a file format
(XML, CSV, TXT) to a middleware (providers) seems odd to me.
Received on Fri Mar 30 2007 - 12:27:46 CDT