In today’s world of data and application informatics, application ranging from large business intensive to small desktop stuff needs a database. The database used, either can be in the form of a single binary or text file (which just stores the info) to a sophisticated DBMS (with most advanced features). Thus acting as a lifeline for applications, a suitable and best choice of database can be critical.
The worst DBA’s nightmare is the choice of the right DBMS for a particular application. So one wonders – what are the areas one should consider before making the choice. Well based on some findings and research, here are some things to be looked up in DBMS:
- Performance
- Data Security
- Replication capabilities
- Recovery mechanism
So let’s drill down in some of the popular DBMS in market. We will use Oracle, Sql Server 2008 and MySql for our comparison. (more…)