Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Aug 2002
    Thanked 0 Times in 0 Posts

    Creating a Database with XML

    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?

  2. #2
    Join Date
    May 2002
    Hayward, CA
    Thanked 24 Times in 22 Posts
    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.
    "The first step to confirming there is a bug in someone else's work is confirming there are no bugs in your own."
    June 30, 2001
    author, Verbosio prototype XML Editor
    author, JavaScript Developer's Dictionary

  3. #3
    Regular Coder
    Join Date
    Jun 2002
    Newcastle, England
    Thanked 0 Times in 0 Posts

    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.



Posting Permissions

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