Transcript Princeton Softech Archive for Servers Oracle

Maximize Oracle E-Business
Suite Performance
by Archiving Historical Data
David K. Glomski
Sr. Consultant
 PrincetonSoftech 2004
Agenda
 Who are we?
 Addressing the Problem
 Product Overview
 PrincetonSoftech 2004
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
 PrincetonSoftech 2004
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
2001 2002
 PrincetonSoftech 2004
2003 2004 2005
2006 2007 2008 2009
Current Data
Historical Data
2010 2011
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
 PrincetonSoftech 2004
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
 PrincetonSoftech 2004
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
140
210
315
Other Modules
 PrincetonSoftech 2004
Active Archive is the Solution
Archive
Files
Production
Database
Archive
Database
Archive
&
Restore
Archive Files
Data Access (locate, browse, query, report)
 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
 PrincetonSoftech 2004
Supports ILM Archiving Strategy
Information Lifecycle Management
Current
Data
Active
Historical
On-line
Archive
Off-line
Archive
1+ years
2-3 years
4-7 years
8+ years
Non DBMS
Retention Platform
Off-line
Retention Platform
ATA File Server
Centera
CD
Tape
Optical
Production
Database
Archive
Archive
Reporting
Database
Archive File Management
(*) Adjust timeframes to meet retention time requirements
 PrincetonSoftech 2004
Archiving Value Proposition
Improved
Performance:
 Increased response time
 Shorten batch cycles
 Increased productivity
 Maintain SLA’s
Easy Access
to Data:
 Transparent end-user access
Reduced
Costs:
 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
 PrincetonSoftech 2004
Princeton Softech Provides the Tools
Active Archive Solutions
Relational Tools
Production
Pre-Production
(Test, Dev, Training, …)
PeopleSoft ClarifyCRM
Relational
Tools
Archive
for Servers
Oracle
Apps
Archive for
DB2
Relationship Engine
Oracle
 PrincetonSoftech 2004
SQL
Server
Sybase
Informix
DB2
UDB
DB2
Legacy
Archive for Servers Oracle
Support for Oracle Applications
Applications Edition
versions 11.0 & 11i


Financials Solution:
–
–
–
–

Supply Chain Solution:
–
–
–

Purchasing
Order Management
Payables
Manufacturing
–
–
 PrincetonSoftech 2004
Assets
General Ledger
Payables
Receivables
Inventory
Work in Process

Transparent access to data via
standard Oracle Apps interface

framework designed to support
standard purge archive as well as
customizations
Archiving Oracle Financials Data
Archiving Historical Data
Active Archive
Database
Production
Database
GL – Balances, Journals …
AP – Payments, Invoices, Vendors…
AR – Receipts, Invoices …
FA – Depreciation, Adjustments
General Ledger
Payables
Receivables
Assets
Locate, Browse, Query, Report . . .
Data Access
 PrincetonSoftech 2004
Easy to Archive
User-friendly administration and
archiving interface (web-based)
Steps to archive data:
–
–
–
–
Runs process to archive
historical production data
Historical Production Data
Production
Data
 PrincetonSoftech 2004
Archived
Data
Login
Select module to archive
Supply archiving criteria
Run archive process
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
–
–
 PrincetonSoftech 2004
Detects mismatches
Provides upgrade procedures
Oracle Applications
Patch and Upgrade Support
1. Views, Forms, Reports
and Synonyms
4. Changes to the
Purge Programs
3. Data Model Changes
 PrincetonSoftech 2004
2. Minor Table
Structure
Modifications
Workbench Archive Database Report
 PrincetonSoftech 2004
Archive Database Report Details
 PrincetonSoftech 2004
Archive the Archive
 PrincetonSoftech 2004
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 (800) 457-7060
Or visit our website:
www.princetonsoftech.com
 PrincetonSoftech 2004
Questions?
 PrincetonSoftech 2004