Maximize Oracle E-Business Suite Performance by Archiving Historical Data

1
Maximize Oracle E-Business Suite Performance by
Archiving Historical Data
David K. Glomski Sr. Consultant
2
Agenda

• Who are we?
• Addressing the Problem
• Product Overview

3
Corporate Summary

• Founded in 1989
• Over 2000 customers in 30 Countries
• Committed to providing enterprise database
  archiving and test data management solutions
• Reputation of high quality and reliable products
• Partners with industry leading database and
  storage solution providers
• .
• Recognized by Gartner, Giga, and Meta as database
  archiving market leader

4
Database Growth Impacts IT Budgets
databases will grow 30x during the next decade,
or roughly 40 annually. Source Meta Group 2001
40 CAGR may be a conservative estimate! With
growth rates exceeding 125, organizations face
two basic options continue to grow the
infrastructure or develop processes to separate
dormant data from active data. Source Meta
Group 2003
5
Related Symptoms

• Application users complain their system is slow
  to
• Perform online account inquiries and financial
  period closeouts
• Enter transactions and process payments
• Post batches and generate reports
• Process weekly/monthly/quarterly depreciation
  runs
• Increasing operating costs
• Higher hardware and software license and support
  costs
• Longer development and test cycles
• Labor intensive time and effort for system
  administrative tasks
• Extended maintenance times for managing backup,
  recovery and cloning processes
• Additional headcount required to adequately
  manage a larger environment

6
Traditional Approaches

• Add More Capacity
• Bottom line impact
• Uncontrolled continuous cost
• Institute rigorous database tuning
• Does not directly address data growth
• Reaches point of diminishing returns
• Delete Data (i.e. Purge)
• Legal and retention issues
• Data may be needed for data warehousing
• In-House Development
• Complex undertaking
• Application specific
• Support / upgrade / maintenance / opportunity cost

7
Data will continue to Grow
Oracle Applications 5 Years (GB) 6 Years (GB) 7 Years (GB)
Entire Database 400 600 900
Financials Modules 260 390 585
Accounts Payable 120 180 270
General Ledger 80 120 180
Accounts Receivable 60 90 135
Other Modules 140 210 315
8
Active Archive is the Solution
Archive Restore

• Reduce amount of data in the application database
• Remove obsolete or infrequently used data
• Maintain business context of archived data
• Archive relational subsets vs. entire files
• Enable easy user access to archived information
• View, research and restore as needed.
• Support Data Storage Management Strategies

9
Supports ILM Archiving Strategy
Information Lifecycle Management
Current Data 1 years
Active Historical 2-3 years
On-line Archive 4-7 years
Off-line Archive 8 years
Non DBMS Retention Platform ATA File
Server Centera
Off-line Retention Platform CD Tape Optical
ProductionDatabase
Archive Reporting Database
Archive
Archive File Management
() Adjust timeframes to meet retention time
requirements
10
Archiving Value Proposition

• Increased response time
• Shorten batch cycles
• Increased productivity
• Maintain SLAs

Improved Performance
Easy Access to Data

• Transparent end-user access

• Defer or eliminate expensive upgrades
• Store data on most cost-effective medium
• Reduce costs of DR by recovering
  mission-critical data first and rarely used data
  later
• Reduced maintenance costs

Reduced Costs
11
Princeton Softech Provides the Tools
Active Archive Solutions
Relational Tools
Pre-Production (Test, Dev, Training, )
Production
ClarifyCRM
PeopleSoft
Oracle Apps
RelationalTools
Archive for DB2
Archive for Servers
Relationship Engine
Legacy
Oracle
SQL Server
Sybase
Informix
DB2 UDB
DB2
12
Archive for Servers Oracle Applications Edition

• Support for Oracle Applications versions 11.0
  11i
• Financials Solution
• Assets
• General Ledger
• Payables
• Receivables
• Supply Chain Solution
• Purchasing
• Order Management
• Payables
• Manufacturing
• Inventory
• Work in Process
• Transparent access to data via standard Oracle
  Apps interface
• framework designed to support standard purge
  archive as well as customizations

13
Provides Transparent Access

• Seamless access to BOTH archived and production
  data via Oracle Applications
• Leverages Responsibility to access data using
  standard Oracle Forms Reports
• Steps to view archived data
• Login
• Select Responsibility
• Access archived data production data or BOTH

14
Archiving Oracle Financials Data
Archiving Historical Data
Active Archive Database

General Ledger
GL Balances, Journals AP Payments,
Invoices, Vendors AR Receipts, Invoices FA
Depreciation, Adjustments
Payables
Production Database
Receivables
Assets
Locate, Browse, Query, Report . . .
Data Access
15
Easy to Archive

• User-friendly administration and archiving
  interface (web-based)
• Steps to archive data
• Login
• Select module to archive
• Supply archiving criteria
• Run archive process

16
Workbench Verification Report

• System Verification Diagnostics
• Comprehensive top to bottom configuration
  analysis/validation
• Archive Process Diagnostics
• performs application validation prior to
  archiving data
• Verifies and matches table structures in the
  active archive database
• Oracle Patch and Upgrade Checking
• Detects mismatches
• Provides upgrade procedures

17
Oracle ApplicationsPatch and Upgrade Support

1. Views, Forms, Reports and Synonyms

1. Minor Table Structure Modifications

1. Changes to the Purge Programs

1. Data Model Changes

18
Workbench Archive Database Report
19
Archive Database Report Details
20
Archive the Archive
21
Transparent Access Demo
If you are interested in seeing a Web Demo of our
product and Transparent access to Production and
Archive data via standard Oracle Applications
Contact Sales at [phone] Or visit our
website www.princetonsoftech.com
22
Questions?