IBM DB2 vs Oracle Essay

IBM DB2 vs Oracle Essay

Length: 1185 words (3.4 double-spaced pages)

Rating: Strong Essays

Open Document

Essay Preview

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 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...


... middle of paper ...


... block indexes. IBM DB2 has higher limits in most 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 stable and efficient transaction processing systems, with the level of experience of the personnel working with the system having a greater impact on performance, than the vendor supplying the DBMS (Chigrik, 2003).

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.

Need Writing Help?

Get feedback on grammar, clarity, concision and logic instantly.

Check your paper »

Database Comparison of SQL Server 2000, Access, MySQL, DB2, and Oracle Essay

- Introduction This paper will compare and contrast five different database management systems on six criteria. The database management systems (DBMS) that will be discussed are SQL Server 2000, Access, MySQL, DB2, and Oracle. The criteria that will be compared are the systems’ functionality, the requirements that must be met to run the DBMS, the expansion capabilities – if it is able to expand to handle more data over time, the types of companies that typically use each one, the normal usage of the DBMS, and the costs associated with implementing the DBMS....   [tags: essays research papers]

Strong Essays
1088 words (3.1 pages)

Financial Analysis of Oracle Corp Essay

- Financial Analysis of Oracle Corp INTRODUCTION Background and History Oracle Corporation is a technology company that supplies software for the use of information management. They develop, manufacture, market and distribute computer software that helps other corporations manage their data so they can better grow and prosper. In 1977, Larry Ellison, Bob Miner, and Ed Oates founded System Development Laboratories. After being inspired by a research paper written in 1970 by an IBM researcher titled “A Relational Model of Data for Large Shared Data Banks” they decided to build a new type of database called a relational database system....   [tags: essays papers]

Strong Essays
2599 words (7.4 pages)

Essay about Oracle

- Oracle- Database Management System Data management is an extraordinarily old craft. Aristotle's scheme of interlocking classifications of knowledge in his work Physica is a data-management effort. In the early 1800s the Jacquard loom used holes punched in paper cards to represent instructions for controlling the action of a loom. These cards became the basis for Herman Hollerith’s card-sorting device, used for the 1890 U.S. census http://80-gme.grolier.com.ezproxy.apollolibrary.com. Many database programs were designed around the physical cards: the maximum information that could be encoded on a punch card became the length of a standard record....   [tags: essays research papers]

Strong Essays
2005 words (5.7 pages)

Job Roles And Responsibilities At Ibm Cloud And Cloudera Big Data Architect : Business Analytics & Strategy

- Executive Summary The aim of this report is identifying job roles and responsibilities, and answering the questions to demonstrate the finding in data curation and management. An employment services website and other article are used in this research. The results indicate that the role, tasks and responsibilities of the Data curation and management related job roles are depended on the nature of the position within the organisational structure and supporting infrastructure. Content Executive Summary 1 Introduction 1 Job role analysis 1 Research question answer 3 Q1 Nature of the roles 3 Q2 Positions fit within the organisational structure 3 Q3 Position descriptions level...   [tags: Data management, Data warehouse, Data mining]

Strong Essays
1927 words (5.5 pages)

Ibm : Efficient At Managing The Diversity Of Its Workforce Essay

- bringing technology to people when and where it is needed requires that IBM be efficient at managing the diversity of its workforce (DuBrin, 2010). Alternate Courses of Action Investment expanded in other emerging markets. In December 2007, IBM announced plans to invest $1.6 billion in developing countries in Asia, the Middle East, and Latin America. In 2007, over 50 countries in the IBM family, including Poland, South Africa, and Mexico, grew more than10%. IBM had operated in Egypt continuously since 1954, it was another growth target....   [tags: Corporation, Globalization, IBM, Management]

Strong Essays
1320 words (3.8 pages)

Brief History Of Ibm 's Business Operation Essay

- Brief History of IBM IBM was first incorporated in New York under the name Computing-Tabulating-Recoding Company in 1911. Although the company’s history can be track back as early as 1890, which was when the U.S. were receiving waves of immigrants. This is when the punch card Tabulating machine was created to calculate census data. After joining forces with International Time Recording Company and Computing Scale Company of America, this created a company that manufactured and sold commercial scales and industrial time recorder, tabulators and punch cards....   [tags: IBM, Strategic management, Strategy, Marketing]

Strong Essays
1461 words (4.2 pages)

Oracle : For All Of Your Vendor Needs Essay

- Oracle: For All of Your Vendor Needs The Oracle Corporation is an American multinational computer technology corporation headquartered in Redwood City, California, United States. Oracle specializes in developing and selling computer hardware systems and enterprise software products – particularly its own brands of database management systems. As of 2011, the company is the second only to Microsoft in terms of revenue. The company also builds tools for database development and systems of middle-tier software, enterprise resource planning (ERP) software, customer relationship management (CRM) software and supply chain management (SCM) software....   [tags: Oracle Corporation, Supply chain management]

Strong Essays
1227 words (3.5 pages)

Essay about Written Case Analysis – IBM

- Written Case Analysis – IBM Salient Case Facts at a Glance: John Akers became the CEO of IBM in 1985. By this time, IBM had registered a drop in earnings for the first time. This trend continued, creating various other problems till John Akers was forced to resign in 1993. IBM was perceived as a ruthless giant with tremendous growth. Naturally, it was singled out for criticism by the entire industry and the government. IBM also attracted anti-trust legislation as a result. IBM lost out once the Personal Computer industry began to boom....   [tags: IBM Business Analysis Strategy Management]

Free Essays
764 words (2.2 pages)

Essay about Oracle Implementations

- Oracle Implementations Introduction .........................................................................................................................3 Project Manager Role........................................................................................................3 Client Project Manager....................................................................................................3 Consulting Project Manager ...........................................................................................3 Scope, Objectives and Approach..................................................................................4 Scope.....................................................   [tags: Oracle Implementation Project Management Essays]

Strong Essays
4787 words (13.7 pages)

Essay about Lou Gerstner's IBM

- Lou Gerstner's IBM 1. What struggles does Lou Gerstner face in his plan to make IBM network-centric. Consider internal and external impediments. In order to make Lou Gerstner’s plan effective he had to make many changes with in the IBM company. Gerstner set up a team with Jerry York and Richard Thoman along board. Some changes that were made with in IBM were, a cut back on employment, reduced expenses, and a stronger customer service. Gerstner and his new team based their plans on computer networks and the products needed to help IBM reach their future goals for the company....   [tags: Lou Gerstner IBM]

Free Essays
402 words (1.1 pages)