XML db vs Relation db - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: XML db vs Relation db

  1. #11
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Quote Originally Posted by hobbes
    Whenever data is transferred between disparate systems, it must be structured in some way that is understandable to the communicating systems. Structured information contains both content and some indication of what role that content plays. Tags provide structure and meaning to data.

    The article does not propose an alternative approach to data transfer that provides the key advantages of XML - flexibility, simplicity, interoperability - without the use of tags. It is the problems faced by older complex data transfer mechanisms like EDI that led to the evolution and increased acceptance of XML.

    Bottomline: The benefits of using XML in the right context outweigh the extra storage space it takes up in the database.
    You make a good argument for the use of XML as a data transmission/exchange format, which is what it is really useful for, but that is a matter independent of how the data is stored in the database. I don't recall anyone seriously arguning against the use of XML as a data exchange format, although it does have some disadvantages that ought to be acknowledged, whereas inside a database it is practically impossible to enforce consistency on it (data lengths, formats, foreign keys etc) without going to more trouble than you would experience in storing it relationally.

    An RDBMS is not just a data dump.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  2. #12
    Join Date
    May 2006
    Posts
    12
    Quote Originally Posted by RBARAER
    Just thought your answer to LKBrwn_DBA was too XML-biased
    Glad you pointed that out: perhaps I went overboard in the defense of XML as the article LKBrwn_DBA linked to was so sweepingly critical of it!


    Quote Originally Posted by slimdave
    You make a good argument for the use of XML as a data transmission/exchange format, which is what it is really useful for, but that is a matter independent of how the data is stored in the database.
    The article in the context of which this was written painted a very 'black' picture of XML, which is what prompted me to mention its benefits too. Agree with what you say about its limitations as a data storage mechanism!

  3. #13
    Join Date
    May 2006
    Posts
    12
    Do check out Sean Dillon's take on XML in Oracle here.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width