Applimation is the leading provider of Application Lifecycle Management solutions

1. Applications Archiving • Applimation is the leading provider of Application Lifecycle Management solutions Thursday November 20th, 2008 Diane Hallahan Account Manager Paul Capobianco Sales Engineer

2. Agenda • Overview of Applimation • Application Archiving • Types of Archiving – Performance, Compliance, Retirement • Database Subsetting • Intelligent Data Masking • Informia Archive – Components and details • Informia Subset – Components and details • Informia Secure – Components and details CONFIDENTIAL

3. Applimation – Broad Application Coverage SLIDE: 3 CONFIDENTIAL • A leader in enterprise data management software • Focus on business applications • Unified, integratedproduct suite

4. Applimation: Informia Solutions Improve Production Database Performance Maintain Complete Application Integrity Comply with Data Retention Regulations Enable Accessibility to Archived Data SLIDE: 4 CONFIDENTIAL

5. Applimation: Informia Solutions Test & Development Optimization Automate the Creation of Smaller Database Copies Update Copies with Current, Relevant Production Data Reduce Storage Space Requirements SLIDE: 5 CONFIDENTIAL

6. Applimation: Informia Solutions Protect Sensitive Application Data Enable Safe Data Sharing Reduce Risk of Data Breaches Enhance Test-Data Quality SLIDE: 6 CONFIDENTIAL

7. Applimation: Informia Solutions Enable Regulator Compliance Ensure Data Accessibility Reduce Infrastructure and Licensing Costs SLIDE: 7 CONFIDENTIAL

8. Applimation: Informia Solutions Automate Divestiture Process Preserve History and Integrity of Data Speed Reduced Risk SLIDE: 8 CONFIDENTIAL

9. Premier Customers

10. Performance Improvement

12. Compliance

13. Archive Before Upgrading

14. Return on Investment

15. Archiving – A Repeatable Process

16. Scalability 5+ TB 3.5 TB 3 TB 900 GB 600 GB 300GB

17. Multi-stage Archiving for ILM Enterprise Disk ModularDisk SATA Disk Tape Library Tape Archived Data Current Data High Data Accessibility Low $50 - $70/GB $20 - $35/GB $5 - $15/GB $2 - $4/GB $1 - $2/GB SATA  - Serial Advanced Technology Attachment

18. Systemic problems caused by data growth IF YOU DO NOT MANAGE GROWTH Application Performance Degradation Decreased Application Availability Increased Time for Backups/Restores Upgrades continue to take Longer Copies of Production take Longer Production Size become unwieldy for testing and development Hardware Costs Continue Bigger CPU / More Disk / More Memory Power and Cooling Costs Continue Analysts expect U.S. companies will spend twice as much on power and cooling by 2009 as they did to acquire their IT devices (SearchStorage.com)

19. Data Management – Traditional Options Purchase additional hardware DBAs tune application standard code Rebuild Indexes / Update Stats Vendor provided Purge routines if available THE PROBLEM: - constantly spending on hardware - tuning only does so much - purging doesn’t archive

20. Model ERD

21. Applimation Informia Archive Informia Archive SLIDE: 21 CONFIDENTIAL

22. Informia Archive Product Objective Better performing production database Objective Relocating inactive data Method Primary Challenge Complex transactional chaining Solution Informia Archive SLIDE: 22 CONFIDENTIAL

23. What is archiving? SLIDE: 23 • Archiving is an application-aware method of relocating enterprise data out of a production database. • What Archiving is NOT: (and was not repurposed from) • Backup • Disaster recovery • Mirroring • Reporting instance • Data warehouse • ETL CONFIDENTIAL

24. PROD Dev 1 Dev 2 Dev 3 Dev 4 Dev x Business Reasons to Manage Growth • Many copies of production • Project teams require many testing and development environments • How Much Disk does that Total? • Increased Overhead • Copies of Production take Longer • Production Size become unwieldy for testing and development • Hardware Costs Continue • Bigger CPU / More Disk / More Memory

25. PROD DEV 1 DEV 2 DEV 3 DEV 4 DEV x Inactive Data Business Reasons to Manage Growth • Many copies of production • Project teams require many testing and development environments • How Much Disk does that Total? • Increased Overhead • Copies of Production take Longer • Production Size become unwieldy for testing and development • Hardware Costs Continue • Bigger CPU / More Disk / More Memory

26. Informia Today – Broad Application and Database Support Applimation Informia DB2UDB SQLServer DB2z/OS Data onDemand Sybase MySQL Oracle Archive Data Subset Secure Business Applications Oracle e-Business Suite Custom/3rd Party SAP PeopleSoft Siebel Databases

27. Informia Archive Accelerators - Oracle E-Business

28. Informia Archive Accelerators – PeopleSoft Enterprise

29. Informia Archive Accelerators – Siebel

30. Two Important Accelerator Components • Entity Definition • Logical unit to archive • Database and application level relationships • Policy scoping criteria SLIDE: 30 • Business Rules • Transaction chaining • Within an entity • To other applications • Testing of Fields, Flags& Codes CONFIDENTIAL

31. Database Archiving – What to Call it • Database Archiving • a.k.a. Active Archiving • a.k.a. Data Movement • a.k.a. Data Relocation • Done online • Separates ‘active’ data from ‘seldom’ accessed data

32. Informia: An Enterprise Solution SHARED SERVICE CENTER ACQUIRED DIVISION Oracle Applications 11.5.10 Custom Billing Application Sybase HPUX 10 Years = 600 GB Oracle 10g Sun Solaris 10 7 Years = 1.4 TB CALL CENTER CORPORATE HQ SQL Server Windows 8 Years = 800 GB PeopleSoft HR 8.3 DB2 AIX 5 Years = 350 GB Siebel 7.8 SLIDE: 32 CONFIDENTIAL

33. Archive for Compliance – Long Term Retention With Online Archive DataDiscoveryPortal Archived Data Current Data ProductionDatabase SeamlessAccessLayer Online Archive Database Direct from Production – Archive Only DataDiscoveryPortal Current Data Current Data SLIDE: 33 CONFIDENTIAL

34. SQL Plus CUSTOM DBArtisan TOAD SIEBEL Oracle APPS PeopleSoft OEM DISCOVERER ENCAPSULATED XML ARCHIVES Seamless Access Layer Retired data Retire Inactive Data (Read Only) Inactive Data (Read Only) Inactive Data Meeting the Challenge – Online Archive • Always Accessible • No Developer Modifications Needed • No Customizations Required PRODUCTIONDATABASE ONLINE ARCHIVE DATABASE Active Data xml

35. Seamless Access Layer Multi-stage Archiving for Information Lifecycle Management (ILM) DataDiscovery Online ArchiveDatabase(2 – 7 years old) Current Data (less than 2 years old) Encapsulated XML Archive(over 7 years old) CONFIG. DATA 1 TRANSACTION 1 CONFIG. DATA 2 TRANSACTION 2 TRANSACTION 3 OPERATIONAL DATA 1 TRANSACTION 4 OPERATIONAL DATA 2 TRANSACTION 5 OPERATIONAL DATA 3 TRANSACTION 6 TRANSACTION 7 SLIDE: 35 CONFIDENTIAL

36. Seamless Access Layer Multi-stage Archiving for Information Lifecycle Management (ILM) DataDiscovery Online ArchiveDatabase(2 – 7 years old) Current Data (less than 2 years old) Encapsulated XML Archive(over 7 years old) CONFIG. DATA 1 CONFIG. DATA 1 TRANSACTION 4 TRANSACTION 1 CONFIG. DATA 2 CONFIG. DATA 2 TRANSACTION 6 TRANSACTION 2 TRANSACTION 7 TRANSACTION 3 OPERATIONAL DATA 1 OPERATIONAL DATA 1 TRANSACTION 5 OPERATIONAL DATA 2 OPERATIONAL DATA 2 OPERATIONAL DATA 3 SLIDE: 36 CONFIDENTIAL

37. Online Archive Process – Another Look AR Schema 500+ Tables Production History History Schema Only High Volume Transaction Tables

38. Business Rule Validation – Same Process for All Applications SLIDE: 38 CONFIDENTIAL

39. Actual Candidate Summary Report Actual Example

40. Online Archive Process – Detailed Biz Rule # 2 Biz Rule # n Biz Rule # 1 Archive Flag Transaction Table Txn ID Date Status 1 01-JAN-2001 Closed 01-JAN-2002 Closed 2 3 01-FEB-2003 Open 4 01-MAR-2003 Closed 5 01-OCT-2004 Open Production 2008 2007 Y Archive/History 2006 N N 2005 Y HistoryTables N APPLIMATION HOME 2004 2004 • Build Interim Tables and test against business rules • Move into Staging Area ONLY 2001 - 2004 transactions that pass business rules • Purge 2001 - 2004 transactions from Production • Merge 2001 - 2004 transactions to History location • Drop Staging Area 2003 2003 2002 2002 Staging Area 2001 2001 SLIDE: 40 CONFIDENTIAL

41. 30,000 tables 29,980 have 7 years of data 20have 2 years of data 20 tables 20 have 5 years of data History APPLIMATION HOME APPS Packages Tables ViewsProcs, Syns, Java, etc. HISTORY GL SYN VIEW SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN AP SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN VIEW SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN VIEW SYN PO SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN SYN INV About 200+ Schemas HISTORY_ONLY VIEW COMBINED VIEW Online Archive Architecture – Seamless Access – More Detail Production APPS_COMBINED APPS APPS SELECT column_names from GL.GL_BALANCES UNION ALL (SELECT column_names from GL_BALANCES@HISTORY_DBLINK)

42. The Challenge of Increasing Data Growth AFTER SOLUTION BEFORE SOLUTION Growing storage costs Diminishing performance Increasing maintenance & Compliance work Predictable manageable growth Improved, stable performance Reduced maintenance & compliance work SLIDE: 42 CONFIDENTIAL

44. Seamless Data Accessin Oracle Apps • Auto-generated • No user re-training • Access to • Current Only • Current + History • No modifications to code base • Support for any/all query tools

45. Seamless Access – Application Layer • Uses Responsibilities to enable access • No modifications to application code • No additional application server • No new user IDs • No user re-training

47. Seamless Data Access in PeopleSoft • Auto-generated • No user re-training • Access to • Current Only • Current + History • No modifications to code base • Support for any/all query tools

48. Seamless Data Access for End-Users

49. Custom Applications

50. Custom Seamless Data Access • Auto-generated • No user re-training • Access to • Current Only • Current + History • No modifications to code base • Support for any/all query tools