Show me the MONEY

1. Strategies for Managing Data Growth & Data Cost in Enterprise ApplicationsPaul Garstang – IBMAndrew Crouch – Aviva UK

2. Show me the MONEY • Cost comparison of DB2 on IBM Enterprise Servers v Sun on Oracle • Reducing Cost of Production / Test / Dev Data Footprint through Optim • Aviva – Example customer implementation and results driven • Andrew Crouch

3. The benefits of the IBM solution • Database license optimisation • Avoid database license over deployment • The industry’s most powerful database servers • At least 40% cheaper than Oracle • 50% - 65% faster than Oracle • 25% - 80% less hardware • 50%+ storage savings over Oracle • Automated database management • Virtualisation flexibility and headroom

4. IBM Enterprise Servers The Most Powerful Processors in the World • Enables 30:1 consolidation of Sun servers • Dramatic Reduction in Processor cores and DB licenses required

5. Save up to 90% cost of energy Save up to 90% cost of floor space Save up to 90% on per core SW costs Solaris to IBM Consolidation Example 30 Sun Fire V890 systems Two IBM Enterprise Database Servers withAdvanced Virtualization • 480 processor cores • $5,625 annual space costs @ $62.50 sq ft • $116,132 annual energycosts @ $0.092 / kWhr • 32 processor cores • $375 annual space costs @ $62.50 sq ft • $13,549 annual energycosts @ $0.092 / kWhr

6. Customer Case for Oracle License Consolidation For EVERY processor core deployed, this customer paid £46,013 http://oraclestore.oracle.com/OA_HTML/ibeCZzpHome.jsp?minisite=10061&respid=1298373&grp=STORE&language=US

7. Intel server utilisation is typically significantly lower than 50%. IBM can deliver 80%+ Utilisation With Intel an entire blade must be licensed - £360K in this example per blade Oracle do not support VMWare or even their own Oracle VM hypervisor. Oracle’s own partitioning document states that:“soft partitioning is not permitted as a means to determine or limit the number of software licenses required for any given server” The Virtualisation AdvantageA like for like DB2 Enterprise Edition vs Oracle Enterprise Edition Comparison

8. Massive consolidation opportunity

9. Lightning Fast for Transactions “Before we made a final decision we benchmarked some of the key database management systems. That includes Oracle, SQL Server and DB2. We ended up choosing DB2 for several reasons. One was reliability, second was performance and perhaps the most important factor was ease of use” – Bashir Khan, Director of Data Management and Business Intelligence, Dow Jones Top TPC-C Performance By Data Server Vendor • 50% Faster than Oracle • 5X Faster than SQL Server • Lower server costs for transactional systems

10. IBM Optim™ Solutions • Optim Data Growth Solution (Archiving) • Improve performance • Control data growth, save storage • Support retention compliance • Enable application retirement • Streamline upgrades • Optim Test Data Management Solution • Create targeted, right sized test environments • Improve application quality • Speed iterative testing processes • Optim Data Privacy Solution • Mask confidential data • Comply with privacy policies

11. Industry average £150/GB per year Current Application Costs Spiral

12. Information has a ‘lifecycle’ Data ≠ Information Over time, the value of data decreases  “less informative” Your application data is currently depreciating in value Yet the costs of maintaining this data in your application database stays constant – if not increasing Depreciating value of Data over time (ILM): Information Lifecycle Management: • Managing data in a way so that its informative value is consistent with the overall cost of maintaining that data

13. Archives HistoricalData ReferenceData ReportingData Optim Universal Access to Application Data Application Application XML ODBC / JDBC Report Writer Enterprise Challenge: Data GrowthOptim™ Data Growth Solution: Archiving Production Archive Historical Retrieved Retrieve Current • Complete Business Object provides historical reference snapshot of business activity • Storage device independence enables ILM • Immutable file format enables data retention compliance

14. 3 Archive Restore Extract, Store and RestoreStore in Any Environment Current Data 1-2 years Active Historical 3-4 years Online Archive 5-6 years Offline Archive 7+ years Offline Retention Platform CD Tape Optical ProductionDatabase Non DBMS Retention Platform ATA File Server EMC Centera IBM RS550 HDS Archive ReportingDatabase Archive Definitions Compressed Archives Compressed Archives Compressed Archives

15. Current Data Archives Archives Application Universal Access to Application Data Application XML ODBC / JDBC Report Writer Enterprise Challenge: Application UpgradesOptim Streamlines Application Upgrades Older Version Upgraded Version ApplicationData Upgrade Project Archive Archive Application

16. Sun-settedApplications JDE/Siebel/etc. IBM Optim: Legacy System retirement / consolidation Inactive Data Inactive Data Inactive Data Current Application Data Current Application Data Current Application Data Load ReplacementApplication Load SAP Replacement Application Data

17. Sun-settedApplications JDE/Siebel/etc. Optim Legacy Data Reference Data XML ODBC / JDBC Mashup Report Writer IBM Optim: Legacy System retirement / consolidation Consolidated low cost Archive repository Inactive Data Inactive Data Archive Inactive Data Consolidated Archive Universal Access to Data

18. Questions & Answers