comment on

Using an XML database (or using a storage/retrival mechanism that understands XML) is really useful if the domain of the data you need to handle is ill-defined.

For example I just read an interesting article on FpML - a specification for data exchange for Over The Counter financial instruments between banks (swaps, FRAs, etc).

The problem here is that because these instruments aren't traded on an exchange the instruments aren't standardized, and have different behavior and characteristics depending on who the participants in the deal are.

With an XML-based system you can store the information regarding these instruments without having to re-define your database every other day because some smart trader has found a new way of doing a particular trade...

This doesn't solve all the problems of course - you still have to interpret the data correctly to perform appropriate accounting/trade reporting/confirmation/etc., but it at least enables the database to store the information without recoding it.

Michael

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

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.


Your skill will accomplish what the force of many cannot
	PerlMonks