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

On 29 mar, 22:54, Bernard Peek <b...@xxxxxxxxxxxxxxxx> wrote:
On 2007-03-29, David Cressey <cresse...@xxxxxxxxxxx> 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...@xxxxxxxxxx
In search of cognoscenti


.

Relevant Pages

  • Re: What is the logic of storing XML in a Database?
    ... the context of a DBMS, if you could do them inside the context of a DBMS? ... If all database systems had a standard interface to do that with then we ... I understand that ODBC uses a primitive dialect of SQL to select data ...
    (comp.databases.theory)
  • XML in und um TeX
    ... Docbook zu verwenden (vermtl. ... XML Kram sein). ... Meine Frage ist nun ob ConTeXt da eher für taugt. ... Für LaTeX gibt es ja FOPs, tbook und obige Programme. ...
    (de.comp.text.tex)
  • Re: chooses not to generate code at all
    ... >context of execution rather than the DBMS' data. ... >In this context relational algebra provides a meta-meta-model. ... >meta-model that provides the specific mappings necessary for the ... >are Caesar's and render unto the DBMS the things that are data storage. ...
    (comp.object)
  • One cheer for XML ...
    ... the prospect of XML inside the DBMS is ... Subject: Relatively speaking .... ... organizing the XQuery() thingie and embedding it within the SQL ...
    (comp.databases.theory)
  • Re: One cheer for XML ...
    ... one fairly obvious way in which XML in the DBMS makes sense. ... Subject: Relatively speaking .... ... organizing the XQuery() thingie and embedding it within the SQL ...
    (comp.databases.theory)