A recent study conducted by the Edison Group titled "Comparative Management Costs Study - Oracle Database 11g vs. IBM DB2 Enterprise 9.5" quantifies how Oracle widens the manageability lead against IBM. Points made in the 78-page report:
- Organizations can save 43% annually in database management costs using Oracle Database over IBM DB2.
- DBAs can perform typical administrative functions 40% faster using Oracle Database 11g compared with IBM DB2 Enterprise 9.5.
- Oracle Database 11g requires 49% fewer steps for the same set of standard RDBMS tasks than IBM DB2 Enterprise 9.5.
- Benefiting from increased DBA productivity due to lower complexity and higher efficiency, businesses could save up to $35,155 per year per DBA by using Oracle Database 11g over IBM DB2 Enterprise 9.5.
The Edison Group identifies two main areas of discrepancy between the two products:
- 1.)
Performance Diagnostics and Tuning: DBAs spend a considerable amount of time in this area, and the Oracle Database 11g demonstrated a significant 88 percent savings in time and 93 percent fewer steps. Oracle’s Automatic Database Diagnostic Monitor (ADDM) and Automatic SQL Tuning features were mainly responsible for this advantage.
- 2). Day-to-Day Administration: Oracle Database 11g provided 47 percent time savings and 37 percent lower complexity over IBM DB2 Enterprise 9.5. The analysts cited DB2’s lack of an easy-to-use tool for auto-configuring of thresholds for proactive system monitoring as the main contributor to this difference.
The actual study measures (in quantitative and qualitative terms), the relative manageability of Oracle Database 11g and IBM DB2 Enterprise 9.5, and projects the expected savings in management cost over the course of a year due to the administrative efficiency of one product over the other.
Common database management tasks were performed in Oracle Database 11g and IBM DB2 Enterprise 9.5 and compared for their ease of use. For both products, their native management tools were used in the study as follows:
- For Oracle Database 11g: Oracle Enterprise Manager Database Control, supplemented with the Diagnostic and Tuning Management Packs
- For IBM DB2 Enterprise 9.5: Control Center, Command Center, and Health Monitor / Health Center, supplemented with the DB2 Optimization and Recovery Expert Features
This report is intended for corporate decision makers, technical end users, such as DBA's/system administrators, and independent software vendors (ISVs). It also should hold the interest of small and medium businesses with critical database requirements but with limited IT resources to manage them.
More Information
"Comparative Management Costs Study - Oracle Database 11g vs. IBM DB2 Enterprise 9.5" - Edison Group report
Oracle Database
[...read more...]