08-13-2002, 01:39 AM
I am new to XML and most books I have read use examples where a database is created using XML. Is this practical in the real world? Why would someone create a XML database rather than say a mysql database and access it with php? What about an Oracle database?
08-13-2002, 03:29 AM
The concept of an XML database, as far as I know, is largely theoretical. And it's not entirely clearly defined, either.
*deep breath, this is going to take a minute*
XML DB's imply storing data in a tree-based format. MySQL is not itself entirely compatible with this format, as it is a table-based db.
That being said, the main interpretation of an XML db is as a table-based database with scripts to store XML documents.
I myself have tinkered with the concept of reorganizing a tree-based document structure into a table of nodes. You'd be surprised to see what I came up with.
I do believe I've seen references to XML databases which are not based on tables, probably at SourceForge.
As I see it, an object-oriented database (like ZOPE) would be much more compatible for storing XML nodes, as a tree-based format and an object-oriented data format are very closely related indeed.
Note this is all opinion, and not an expert one at that. You may have to do some research.
08-14-2002, 03:23 PM
Like yourself I have wondered a lot about this. Isn't there also a question about access speed? I believe a native XML database can (in theory) be accessed more quickly via the web than a mySQL/PHP or similar combination.