Conor O'Mahony's Database Diary

Your source of IBM database software news (DB2, Informix, Hadoop, & more)

Archive for June 2011

“Seek the Geek” Video from Triton Consulting

with one comment


Written by Conor O'Mahony

June 16, 2011 at 7:00 pm

Posted in DB2 for LUW, Video

Got Oracle Database Skills? Get DB2 Skills at No Charge…

leave a comment »

IBM has a couple of great ways for people with Oracle Database skills to easily add DB2 skills to their resumes. These are available at no charge, allowing you to add skills to your resume and become more attractive to potential employers.

  • The IBM DB2 Workshop for Oracle Professionals is a 2-day classroom-based workshop. This workshop helps people who are already familiar with Oracle Database to learn DB2. That’s correct… high-quality classroom-based training at no charge! Attendees even get to take the DB2 9 Family Fundamentals Certification Exam at no charge. We currently have workshops scheduled in Brazil, Canada, Cyprus, France, Germany, Greece, Hong Kong, Indonesia, Korea, Malaysia, Philippines, Romania, Singapore, Spain, Switzerland, Thailand, Turkey, and the United States. If your location is not listed on the workshop Web page, please check back soon as IBM frequently updates the list of classes.
  • IBM developerWorks is a tremendous resource. It was awarded the Forrester Groundswell Award with Josh Bernoff claiming that developerWorks “is perhaps the largest and most effective customer community we’ve seen.” Well, developerWorks has a new DB2 Fundamentals for Oracle Professionals: Introduction to DB2 learning path. These learning paths are a step-by-step set of articles that help build your proficiency. There are additional learning paths available if you master the introductory one.

Written by Conor O'Mahony

June 14, 2011 at 9:55 am

A Closer Examination of Oracle’s “Database Performance” Advertisement

with 20 comments

Last week, I was in Dallas speaking at an event. In the morning, as I left my hotel room, I picked up the Wall Street Journal which was outside my door. I was surprised to see that Oracle are re-running an old advertisement:

Oracle Advertisement - Database Performance

Why was I surprised? Because this advertisement is based on an industry benchmark that shows that Oracle uses 9 times the number of CPU cores to achieve only 3 times the performance of the IBM result. To put it another way, if you look at the per-core throughput, the IBM system is 3 times faster than the Oracle system. Oracle highlight the overall throughput of the system, but if you do some investigating you will see that the Oracle system in question uses 1,728 CPU cores, whereas the IBM system in question uses only 192 CPU cores. Considering that you typically pay for software based upon the number of CPU cores, I know which system I’d prefer to be buying software for 🙂

By the way, if you want to see how big these benchmark systems are, check out this blog post… TPC-C Result in Real World Terms: Big Macs and Walmart. Of course, while the benchmark systems themselves are—for the most part—disconnected from today’s real world situations, that is not to say that they are not useful. They are. They serve a very useful purpose in stress testing the different vendor’s products. And they also demonstrate how efficiently those systems scale out.

This is why I’m surprised that Oracle is persisting with advertising this benchmark result. For fun, let’s create a graph that doesn’t show the overall throughput of the systems. Let’s instead create a graph that shows the throughput per CPU core for these benchmark systems. Some people might consider this to be a good measure of efficiency for the systems. As you can see, when you look at this measure of efficiency, it paints a very different picture (of course, the higher the number, the better).

tpmC per CPU core for leading TPC-C benchmark results

Results on Transaction Processing Performance Council Web site at Results as of 06/08/11.
Oracle SPARC SuperCluster (108 chips, 1728 cores, 13824 threads); 30,249,688 tpmC; $1.01/tpmC; available 6/1/11.
IBM Power 780 cluster (24 chips, 192 cores, 768 threads); 10,366,254 tpmC; $1.38/tpmC; available 10/13/10.
HP Integrity Superdome (64 chips, 128 cores, 256 threads); 4,092,799 tpmC; $2.93/tpmC; available 08/06/07.

Written by Conor O'Mahony

June 8, 2011 at 4:13 pm

%d bloggers like this: