Ibm Db2 vs Oracle
For this week 's paper I have chosen to do a comparison between IBM 's DB2 database management system (DBMS) product and Oracle. Realistically, making such a comparison is akin to discussing religion with friends. Each person will have their own biases based on their own experiences. Looking for an unbiased opinion is much like looking for the Holy Grail, every bit as speculative and subjective with the results jaundiced by the outlook of the reporter (Lim, 2002).
A decision between DB2 and Oracle should be based on what resources are available for use at the site. Is there specific hardware or software already onsite that can or will be used in the installation, if so this will have a major impact on the decision making process. Does the staff have an existing knowledge base that favors one or the other DBMS and is there a team that has unallocated time to dedicate to this project or will another project be put on hold to allow them to make this project their focus until completion. Finally, have the costs of ongoing maintenance for fixed and soft assets been considered? All of the above will impact the decision making processes prior to purchasing one of the DBMS 's. These factors aside, either DBMS will run as fast as the other provided that the environment has been optimized for it (Lim, 2002).
A side by side analysis of the hardware and software requirements for both DBMS 's shows some remarkable similarities as well as some differences. Similarities in baseline processors across the various hardware platforms but different amounts of disk space and both applications desiring as much memory as possible to improve performance (Chigrik, 2003).
For DB2 v8.1 when installed into a windows environment you will need a minimum of a Pentium or Pentium compatible processor, at least 256mb of ram, and between 100 and 350mb of hard disk space depending on whether the installation is compact, custom, or typical. Depending of the file format of the disk drives additional
A decision between DB2 and Oracle should be based on what resources are available for use at the site. Is there specific hardware or software already onsite that can or will be used in the installation, if so this will have a major impact on the decision making process. Does the staff have an existing knowledge base that favors one or the other DBMS and is there a team that has unallocated time to dedicate to this project or will another project be put on hold to allow them to make this project their focus until completion. Finally, have the costs of ongoing maintenance for fixed and soft assets been considered? All of the above will impact the decision making processes prior to purchasing one of the DBMS 's. These factors aside, either DBMS will run as fast as the other provided that the environment has been optimized for it (Lim, 2002).
A side by side analysis of the hardware and software requirements for both DBMS 's shows some remarkable similarities as well as some differences. Similarities in baseline processors across the various hardware platforms but different amounts of disk space and both applications desiring as much memory as possible to improve performance (Chigrik, 2003).
For DB2 v8.1 when installed into a windows environment you will need a minimum of a Pentium or Pentium compatible processor, at least 256mb of ram, and between 100 and 350mb of hard disk space depending on whether the installation is compact, custom, or typical. Depending of the file format of the disk drives additional
References: Chigrik, A. (2003). Oracle 9i Database vs DB2 v8.1. Retrieved May 11, 2005, from MSSQL City Web site: http://www.mssqlcity.com/Articles/Compare/oracle_vs_db2.htm#part_3. Lim, C. (2002). Oracle vs DB2 vs Teradata. Retrieved May. 11, 2005, from Experts.About.com Web site: http://experts.about.com/q/1041/2465849.htm. Transaction Processing Performance Council, (2005). Retrieved May. 11, 2005, from Top Ten TPC-C by Performance Version 5 Results Web site: http://www.tpc.org/tpcc/results/tpcc_perf_results.asp.