Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

comment on

( [id://3333]=superdoc: print w/replies, xml ) Need Help??

XML and databases includes at least 2 different aspects:

  • XML as an exchange format for data, which might come from a DB or not. You just use it as a neutral, standard format, that takes care of annoying things like character encodings. CVS is great if the data source is "close" to the recipient: if they belong to the same organization, if they changes are synchronized, if the quality of the data can be checked and if the recipient can refuse to accept it if it is bad. Otherwise it is much easier to work with XML: the fields are tagged, which means that you can tell easily if one is missing, it is generally easier to deal with changes in the format (don't process extra tags, default non-existing ones) and to work with data coming from different sources (add a simple layer to normalize the data to a single DTD/Schema). You can do this with CVS but generally XML tools make it easier for the programer. Hence "XML for DB: use it as an exchange format". In buzzword-speak I guess this is described as: "XML is very well suited to loosely coupled applications".
  • then there are some emerging XML Data Base systems (Berkeley DB XML, XML DB, see Ron Bourret's site for more products). These are used to store XML documents natively. The problem with XML documents is that their model is a tree, which does not fit nicely in relational tables: either you define a schema for a specific DTD, and it becomes difficult to change it, and you loose one of the great benefits of XML, or you design a generic schema, but then, unless you built a whole layer on top of the RDBMS, in fact developing a dedicated XML DB, performances are real bad, your queries need too many joints to be fast. XML DBs are either built on top of OODBMS (Object Store was used a lot for SGML DBs) or on top of RDBMS, but offer a tree model of the data. This can be very convenient for things like technical documentation or even product data (complex products are usually designed in a top-down way, which leads naturally to a tree model, relational databases are used because they are stable and work well, but a lot of CAD manufacturers are moving towards OO systems to store design data). Hence DBs for XML: "Store XML data in an XML DB".

Does this answers your question?


In reply to Re: XML for databases?!?! Is it just me or is the rest of the world nutz? by mirod
in thread XML for databases?!?! Is it just me or is the rest of the world nutz? by S_Shrum

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":



  • Are you posting in the right place? Check out Where do I post X? to know for sure.
  • Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
    <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
  • Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
  • Want more info? How to link or How to display code and escape characters are good places to start.
Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others goofing around in the Monastery: (4)
As of 2024-04-25 22:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found