1 / 53

Applimation is the leading provider of Application Lifecycle Management solutions

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

Download Presentation

Applimation is the leading provider of Application Lifecycle Management solutions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

  11. Compliance

  12. Archive Before Upgrading

  13. Return on Investment

  14. Archiving – A Repeatable Process

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

  16. 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

  17. 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)

  18. 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

  19. Model ERD

  20. Applimation Informia Archive Informia Archive SLIDE: 21 CONFIDENTIAL

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

  22. 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

  23. 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

  24. 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

  25. 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

  26. Informia Archive Accelerators - Oracle E-Business

  27. Informia Archive Accelerators – PeopleSoft Enterprise

  28. Informia Archive Accelerators – Siebel

  29. 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

  30. 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

  31. 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

  32. 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

  33. 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

  34. 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

  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 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

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

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

  38. Actual Candidate Summary Report Actual Example

  39. 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

  40. 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)

  41. 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

  42. 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

  43. 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

  44. 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

  45. Seamless Data Access for End-Users

  46. Custom Applications

  47. 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

More Related