Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2011
    Posts
    2

    Post Unanswered: relational DB vs Flat DB vs XML Based DB

    Hi !!
    I need to store big xmls in a db and query them.
    The relational model would require myriad of tables and joins
    So i guess , i'll have to choose between a document oriented or a xml oriented db.

    I have been going through the mongo model and pure XML db.
    Which one would be a better option ?
    I don't have much of an idea about these.

    Thanks

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    What is the purpose of the 'big xmls' ?

    IF you were to completely parse the xml data and store each element in separate tables, then, yes, it would take a lot of work. However, most modern relational databases support xml field types, so, you can often add key identifying fields and store the XML in a table.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  3. #3
    Join Date
    Dec 2011
    Posts
    2
    hii

    We have like 4K tags , so storing them into tables doesn't sound like a good idea.Also, mostly need to query the xmls based on tags.

  4. #4
    Join Date
    Mar 2003
    Posts
    280
    DB2 (I think others as well) has a built-in xml engine that let's you combine xpath/xquery with sql or run them as is. Don't know whether it will suit your needs, but here's a link to some samples:

    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

Posting Permissions

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