In a recent study conducted by the Edison Group, shows how Oracle Database extends the lead over IBM DB2 9.5 for database manageability. In the whitepaper, Edison reveals how Oracle Database saves 40% in time for day-to-day administrative functions and 43% in database management costs over IBM DB2 9.5.
89 Fifth Avenue, 7th Floor New York, NY 10003 www.TheE dison.com 212.367 .7400
Comparative Management
Costs Study
Oracle Database 11g vs. ŽIBM DB2 Enterprise 9.5 Printed in the United States of America. Copyright ? 2008 Edison Group, Inc. New York. Edison Group offers no warranty either expressed or implied on the information contained herein and shall be held harmless for errors resulting from its use. All products are trademarks of their respective owners. First Publication: January 2009 Produced by: Steve Mintz, Senior Analyst, Craig Norris, Editor; Barry Cohen, Senior Analyst, Editor-in-Chief
Table of Contents Executive Summary ..................................................................................................................... 1
About This Report ....................................................................................................................... 3
Who Should Read This Report ............................................................................................. 3
Methodology Overview......................................................................................................... 3
Contents of this Report .......................................................................................................... 4
Rationale Behind this Comparison .......................................................................................... 6
The Methodology Defined ......................................................................................................... 7
Workload Weighting .............................................................................................................. 7
The Study ................................................................................................................................. 7
Tasks ......................................................................................................................................... 7
Workload Weighting ............................................................................................................ 10
Test Administration Workload ........................................................................................... 11
Test Results ................................................................................................................................. 13
Comparative Management Cost Savings .......................................................................... 13
Workload Category Results Synopsis ............................................................................... 14
Install DB/Software/Out-of-the-Box Setup (Results Synopsis) ...................................... 14
Day-to-Day Database Administration (Results Synopsis) .............................................. 16
Backup and Recovery (Results Synopsis) ......................................................................... 19
Performance Tuning (Results Synopsis) ........................................................................... 23
Conclusion ................................................................................................................................... 27
Appendix I - Test Platform Details ......................................................................................... 28
Appendix II - What's New? ...................................................................................................... 29
Appendix III - Architectural & Terminology Discrepancies Requiring Clarification . 35
Appendix IV - Detailed Test Results ..................................................................................... 36
Appendix V - Complexity Calculation Formula .................................................................. 38 Table of Contents - continued
Appendix VI - Detailed Task Descriptions .......................................................................... 40
Installation and Simple "Out-of-Box" Setup .................................................................... 40 ? Task 1: Install database and management software, create starter database .......... [download for more]