T
T
tushev2014-02-24 07:19:30
SQL
tushev, 2014-02-24 07:19:30

Which database to choose for storing a large number of XML documents?

I have a task of choosing a database to store a large number of XML documents. There will be several dozen different document structures. The amount of data is hundreds of gigabytes. Recording to the database will occur in small portions, probably once a day.
In the future, it is required to do tricky searches for documents according to sets of criteria. For example, searching by keywords, searching by attributes, in some nested XML element, etc.
I really don’t want to convert each type of document into my own set of SQL tables (long and tedious), so I asked myself the question of choosing a document-oriented noSQL database. The first thing that came to mind was to convert XML to JSON and store JSON documents in MongoDB.
Tell me, what other convenient and harmonious options should be considered?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
E
egor_nullptr, 2014-02-24
@egor_nullptr

www.exist-db.org
https://github.com/BaseXdb/basex

Z
zxmd, 2014-02-24
@zxmd

postgresql.ru.net/manual/datatype-xml.html - why not satisfied?

S
svd71, 2014-02-24
@svd71

What prevents the same structure from being stored in a text or blob field and used accordingly?
But this is the dumbest thing ever. It is better to take a closer look at the relational dependencies of any database, overtake xml-records and xml-records on the fly.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question