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

On Mar 26, 6:15 pm, "Karen Hill" <karen_hil...@xxxxxxxxx> wrote:
X-No-Archive:yes

I see people putting XML documents in databases. Why do they do this,
what is the logic behind it? Why not just put the data into tables?
Why are the standards committees going along with this (XML SQL/
MED)? Why don't people just use tables to store the data.

The question can't be answered without knowing more about the problem
that is to be solved.

Standardized XML transport formats are commonly used for representing
messages. Consider a problem space where messages are sent from a
front office system to a back office system, and middleware needs to
keep a repository of messages to support auditing and playback. In
that case it would make perfect sense to strip out any fields required
for querying, and store them plus the message. Storing all the fields
relationally would not meet any business objective, and it might not
be possible to reliably reproduce the original message from the
relational representation.

Regards,
Daniel Parker




.

Relevant Pages

  • Re: What is the logic of storing XML in a Database?
    ... Why are the standards committees going along with this (XML SQL/ ... Consider a problem space where messages are sent from a ... front office system to a back office system, ... relational representation. ...
    (comp.databases.theory)
  • Re: Simple mapping question
    ... There isn't an XML schema ... ... the extract I attempted to type comes from an office system that simply ... <DocTypes> ...
    (microsoft.public.biztalk.general)
  • Re: Advice on Find and Replace and save as text
    ... My first piece of advice would be to simply save the document out of Word as ... the result is XML, ... Edition of Office System 2003 contains a full XML implementation. ... Please reply to the newsgroup to maintain the thread. ...
    (microsoft.public.mac.office.word)
  • Re: How to create .xml file? on Mac Word 2001?
    ... To produce XML you need Word 2003 on the PC and its companion product ... However, you are quite correct, Word "does" produce XML when it needs to. ... if you save a plain text file, you get standard HTML, ... of Office System 2003. ...
    (microsoft.public.mac.office.word)
Loading