Hello and welcome to our community! Is this your first visit?
Register
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
    Posts
    2
    Thanks
    0
    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
    Moderator
    Join Date
    May 2002
    Location
    Hayward, CA
    Posts
    1,461
    Thanks
    1
    Thanked 23 Times in 21 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
    https://alexvincent.us/blog

  • #3
    Regular Coder
    Join Date
    Jun 2002
    Location
    Newcastle, England
    Posts
    178
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Alex,

    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.

    patrick


  •  

    Posting Permissions

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