StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>You could also try a native XML database, such as <a href="http://exist.sourceforge.net/" rel="nofollow noreferrer">eXist</a>, which would fit ok for your needs of XML storing and retrieving.</p> <p><strong>Update</strong>: Another solution could be using XML capabilities of your DBMS. Just almost any modern DBMS support XML types, so the best approach should go this way (using XML-types for columns where you would store data).</p> <p><strong>Update 2</strong>: If what you need is just to store structured information (you import from CSV and store it in a single XML file, if I am not wrong), why not using a plain old RDMBS? I find no advantage in storing data in a XML file that can grow without control. What happens when you want to retrieve back some data (summarized or not) from that file? The bigger it becomes the more time and computer resources will it take to have the job done. If you use SAX you would need to proccess the entire file, so accessing data at the end of the file would take more time than to access the start of it. Using DOM would be just worse, because the bigger the file it becomes, the more memory you need to process it.</p> <p>On the other hand if I understood you wrong and what you need is to keep many XML files, and every XML file makes sense by itself as a piece of information (you must deliver XML files or pieces of an XML file as result) I would go the native XML database way, since it is the most natural way of storing and accessing this data.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload