Adam Gartenberg's Blog

Business Analytics and Optimization, IBM and Social Marketing

Interesting results from DB2 BLU vs SAP HANA data mart sizing


Paul Zikopoulos recently shared on Twitter some results from a sizing done on a 10 TeraByte data mart, comparing IBM DB2 BLU on Power Systems with SAP HANA.

To summarize some of the primary differences the team found in this particular instance:

  • HANA requires 4x more RAM
  • HANA requires 10x more required disk
  • HANA requires 10x more CPU cores
  • With HANA , the client would have to buy new hardware and not reuse the hardware they have
  • HANA would require Intel Westmere processors, not Intel Sandy Bridge processors
  • HANA must backup to disks and can't back up to Tivoli Storage Manager, Netbackup or Legato
  • HANA isn't able to offer controls to restrict DBAs without a business need from reading data

You can see more over on the @BigData_paulz Twitter feed.

Image:Interesting results from DB2 BLU vs SAP HANA data mart sizing
Image:Interesting results from DB2 BLU vs SAP HANA data mart sizing