Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

Re: XML for databases?!?! Is it just me or is the rest of the world nutz?

by Starky (Chaplain)
on May 24, 2002 at 18:09 UTC ( #169169=note: print w/replies, xml ) Need Help??

in reply to XML for databases?!?! Is it just me or is the rest of the world nutz?

Should you use XML or not?

The answer to this question, as is the answer to so many technical questions, is, "It depends."

The main advantages I've found to XML in practice are:

  • There are a bevy of tools available to parse, manipulate, and validate XML data. This is part of its appeal as a standard data format. Other standards would have this advantage if folks rallied behind them as they have XML, but they haven't so they don't. You don't need to do much work to parse, search, or validate an XML document. If you are trading data between applications / environments / languages, this can be _hugely_ advantageous. Its strength by simply being a widely adopted standard can't be underestimated.
  • It represents heirarchical data very well. If your data is not heirarchical, then you really need to think twice before jumping on the XML bandwagon.
  • The format is (rather easily) human-readable. I realize this is not the most important aspect of the specification, but it can be very nice in practice.

There you have it. To me, it's not much more complicated than that. If your data only needs treatment by in-house developers who understand the schema and know a few things about SQL, then it's far more trouble than it's worth. If the data is heirarchical and needs to be represented in HTML and other kinds of documents in a variety of ways or if diverse tools need to exchange data, then it is a very nice tool.

Those are the business / technical considerations.

The personal considerations for me have been that, like SQL, XML is something that I know I will use time and time again in a variety of situations. So when I had an opportunity to learn to use it, I jumped on it. So while you may or may not decide that it fits your business needs, your human capital will be that much more valuable if you become comfortable with it out sooner rather than later.

Hope this helps :-)

  • Comment on Re: XML for databases?!?! Is it just me or is the rest of the world nutz?

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://169169]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (11)
As of 2018-06-22 16:03 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (124 votes). Check out past polls.