Friday, November 30, 2007

MySql and BI

The business of business intelligence stands in the data so choosing the right data storage system for your team can be of high importance.
I am a fan of MySql for 2 simple reasons:
-it is free
-you have more programmers that use MySql than any other db system

No, i am not touching in here the hard core minor differences between Oracle and MySql, the differences in speed etc. Those differences are overall minor because all db systems start to become more and more professional.
The main differences are indeed the costs differences. A paid solution will allways cost you more than when you buy it. The programmers costs more, the training costs, the maintenances costs more etc. Overall big bucks spent. To say so in MySql you can do it all for free.
Another difference is the personel. Right now MySql is very very popular being the startup db system used for writing simple web applications (it is the only one available because you don't spend big bucks for a small firm site). Thus you have a large market opened full of programmers that know MySql. For the other db programmers, those are hard to find, cost a lot, will become easily absolute and most of all, all the time need paid training.
Another nice thing about MySql is that the community is very rich. If you have a problem you can solve it easily by going on the web. Most of the time somebody encountered the same problem you have, fixed it and publicated the solution;)

No comments: