IBM DB2 vs Oracle Essay -- essays research papers

For this weeks paper I have chosen to do a simile between IBMs DB2 database management system (database management system) product and vaticinator. Realistically, making very much(prenominal) a comparison is akin to discussing religion with friends. Each person depart have their own biases based on their own puzzles. Looking for an apathetic opinion is much like looking for the Holy Grail, every good turn as speculative and hacekjective with the results jaundiced by the outlook of the reporter (Lim, 2002).A finality between DB2 and Oracle should be based on what resources are available for use at the commit. Is in that location specific computer ironware or software program already onsite that can or depart be used in the installation, if so this will have a major impact on the decision making process. Does the staff have an lively 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 anoth er project be put on hold to support them to make this project their focus until completion. Finally, have the costs of ongoing guardianship for fixed and soft assets been considered? All of the above will impact the decision making processes prior to purchasing one of the DBMSs. These factors aside, either DBMS will run as fast as the other provided that the purlieu has been optimized for it (Lim, 2002).A side by side analysis of the hardware and software requirements for both DBMSs shows some remarkable similarities as swell as some differences. Similarities in baseline processors across the various hardware platforms but different amounts of disk distance and both applications desiring as much holding as possible to improve performance (Chigrik, 2003).For DB2 v8.1 when installed into a windows surround you will need a nominal of a Pentium or Pentium harmonious processor, at least 256mb of ram, and between 100 and 350mb of hard disk spot depending on whether the installat ion is compact, custom, or typical. Depending of the file format of the disk drives excess space may be needed by DB2 because of cluster sizes (Chigrik, 2003).Oracle 9i on the other hand requires a minimum of 128b of ram in a windows environment, although 256mb is recommended. Oracle also requires a minimum of 200mb of virtual memory for file swap space. In terms of processors, Oracle specifies a minimum of a Pentium 166 or higher. Oracle also needs 140mb of disk space on the system drive an... ... block great poweres. IBM DB2 has higher limits in well-nigh of the common database features except most columns in an index key, longest index key, max char() size, max table row length, longest SQL statement, and recursive sub queries (Chigrik, 2003).In the end there is no clear cut winner, as stated previously, a lot of the outcome is determined by the experience of the developer of the database and the administrator of the database. Both DBMSs can be used to build horse barn and eff icient transaction processing systems, with the level of experience of the personnel workings with the system having a greater impact on performance, than the vendor furnish the DBMS (Chigrik, 2003).ReferencesChigrik, A. (2003). Oracle 9i Database vs DB2 v8.1. Retrieved May 11, 2005, from MSSQL City Web site http//www.mssqlcity.com/Articles/ differentiate/oracle_vs_db2.htmpart_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 go along Ten TPC-C by Performance Version 5 Results Web site http//www.tpc.org/tpcc/results/tpcc_perf_results.asp.