If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Other > relational DB vs Flat DB vs XML Based DB

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-22-11, 13:18
voldemort1 voldemort1 is offline
Registered User
 
Join Date: Dec 2011
Posts: 2
Post 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
Reply With Quote
  #2 (permalink)  
Old 12-22-11, 16:10
loquin loquin is offline
Super Moderator
 
Join Date: Jun 2004
Location: Arizona, USA
Posts: 1,797
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

Reply With Quote
  #3 (permalink)  
Old 12-24-11, 16:45
voldemort1 voldemort1 is offline
Registered User
 
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.
Reply With Quote
  #4 (permalink)  
Old 01-03-12, 09:43
lelle12 lelle12 is offline
Registered User
 
Join Date: Mar 2003
Posts: 86
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On