Choosing the best DBMS
A frequent question that’s often rised from some DBMS user is probably “How to choose the best DBMS to use over the many numbers of DBMS that’s been released?” TCO- Total Cost of Ownership can be a great guideline to help answering the question. Comparing the TCO’s among DBMSs will help deciding the best DBMS suitable for users. In his research, Curt A. Monash (2008) mentioned that there are number of things that are included in the Total Cost of Ownership to acquire a DBMS : the license fee , maintenance fee ,administrative cost, hardware cost, and system downtimed training cost
To make things clearier here are TCO’s comparison of two popular proprietary DBMSs, Oracle and Microsoft SQL.
For the licensing fee, a comment were echoed in a post by Khan (2011) stating that SQL has a cheaper licensing cost than Oracle which requires additional licensing costs for its complex array of options and add-ins needed to develop, deploy, and manage most large scale applications. In addition to databases licenses, customers automatically purchase maintenance and support as a percentage of the price, usually 20 to 25 percent. So, since Oracle tend to have significantly higher license costs than Microsoft, maintenance costs are most likely to be higher as well. Regarding the hardware cost, Alexander Chigrik (2010) made a brief comparison on the hardware requirement and it seems that there’s no significant difference between the two DBMS, but Oracle products can run on any platform whether it is Linux, Windows, UNIX or Solaris. But to run SQL Server, customers have to buy at least Windows Server licenses plus CALs or processor licenses in addition to the Database, so it should still put in consideration. To be able to operate and maintain DBMS efficiently, of course customers will need training. Alexander (2000) explained that as part of their Microsoft Certified Systems Engineer program, Microsoft held Database Implementation, Database...
References: Alexander,Limi, Alan Runyan, 2000, viewed on 21 March 2011, <http://www.fsf.org/philosophy/free-sw.html>
Chigrik, Alexander 2010, SQL Server 2000 vs Oracle 9i, viewed 21 March 2011, < http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm#part_2_1>
Khan, Sanam 2011, ‘Sanam Khan - Dynamics AX Blog,’ Discontinuation of Oracle database support in Microsoft Dynamics AX 2012, 25 January 2011, viewed 21 March 2011,< http://sk-dax.blogspot.com/2011_01_01_archive.html>
Monash, Curt A. 2008. The Explosion in DBMS Choice: Database Options In A Cost-Conscious World. Monash Research : Monash Information Services Bulletin, p.3-4, viewed 24 March 2011, <http://www.monash.com/uploads/explosion-database-choice.pdf>.
Pisello, Tom 2006, ‘The Total Cost of Administration Champ: Microsoft SQL Server 2005 or Oracle Database 10g?’, , viewed 21 March 2011, http://www.computerworld.com/s/article/9002689/The_Total_Cost_of_Administration_Champ_Microsoft_SQL_Server_
Verma, Vinit 2010, The Database Battle - Oracle Vs Microsoft, viewed 21 March 2011,
Please join StudyMode to read the full document