Docstoc

ERPA Archive Process - ERP Analysts_ Inc

Document Sample
ERPA Archive Process - ERP Analysts_ Inc Powered By Docstoc
					         ERPA Archive
An ERPA Archive Tool for PeopleSoft Databases
                 Version 1.0

            A Product by


     ERP Analysts, Inc.
      http://www.erpanalysts.com

            2005 ERP Analysts
                              Introduction

In ERP Applications, Databases are growing exponentially and becoming
more complex for maintenance. Considering high volume of data and
customer-facing in PeopleSoft applications, it is very important for the
customers to maintain their applications to respond very quickly. For every
production database application, multiple copies exist for Development,
Testing and Training databases. While refreshing these databases with
production copy, the seldom-accessed data also copied to the respective
environments. In reality, we do not require seldom-accessed data to these
environments. This led the customers to think about moving seldom-
accessed data to off-line storage devices.

As industry ERP leaders, we understand PeopleSoft customers better than
anyone and we are developing custom PeopleSoft Archival tool, which has
the superior qualities than existing Archives products. And moreover, this is
a product from PeopleSoft experts.
                       Two-Fold Approach

We followed two-fold approach for our Archive process.

1. Archive : Archive the data which qualifies pre-defined Archive rules and
   move it to online storage devices called as History Database

2. Retire : We recommend our customers do not purge the data. Just retire
   it. Based on legalities, identify the data and move from online to offline
   low cost storage devices.
                             Flexibility

Our Tools comes with standards business rules which determines the
data to be archived. And we also know most ERP applications are not
just vanilla implementations. By considering this, our tool provide
flexibility towards

 • Defining custom Archive business rules

 • Defining custom tables for Archiving

 • Defining custom indexes

 • Differential Setup Data Archiving

 • Defining Flexible Inter module constraint rules
                       Module Constraints
   ERP implementation is not just one modules. If one module Transactions
   are dependent on other modules Transactions, our tools’ preset rules
   ensures all inter modules constraints are satisfied.

   Ex: Purchase order will not be Archived until it satisfies Voucher Archive
   criteria
                        ARCHIVE ENGINE

                                                     Voucher
                       C                 E   A       (VCHR1)
                       U                 R   R
                       S                 P
                       T                 A
                                             C
                       O                     H
                       M                     I
                       A                 A   V
                       R                 R   E
Purchase Order         C                 C
                       H                 H   R
    (PO1)              I                 I   U
                       V                 V
                       E                 E
                                             L
                                             E
                        R                    S       If Inter module constraints satisfied
                        U                P
                        L                R   F
                        E                O   O
                        S                C   R                         YES
                                         E
                                         S
                                         S
                                             AP
                                                    PO1 ARCHIVED
                                       After Archive
   After Archive tools moves the data from current active database, there is
   a need to resize / shrink / Re-organize current production database. Our
   tools does this automatically after every Archive process.

   This process       ensures          performance     improvement            on      Production
   database.

Before Archive         After Archive                      After Archive and Re-size




 Active Data
                 Active Data                         Active Data


Seldom Used                                                                 Seldom Used
    Data          Un used                                                       Data
                                  Seldom Used
                 Disk Space           Data
                                Core Process
  Before ARCHIVE                         After ARCHIVE

Production Database                    Production Database   History Database
                      ARCHIVE ENGINE
                                                              History Year 3
                       C          E     Current Year
     Current Year
                       U          R                           History Year 4
                                        History Year 1
    History Year 1     S          P                           History Year 5
                       T          A     History Year 2
    History Year 2     O                                      History Year 6
                       M                 Setup Data
    History Year 3
                                  A                           History Year 7
    History Year 4     A          R                           History Year 8
                       R          C
    History Year 5     C          H                           History Year 9
    History Year 6     H          I
                       I          V                          History Year 10
    History Year 7     V          E                            Setup Data
                       E
    History Year 8

    History Year 9     R          P
                       U          R
    History Year 10    L          O
                       E          C
      Setup Data       S          E
                                  S
                                  S
                    Product Features

• Transactional Growth Analysis

• Module Wise Transactional Growth Forecasting

• User Friendly Reports

• Seamless Integration to Archive Database and Production Databases

• Decreases time to make clones for test, development and disaster
  recovery

• Friendly Interface for Implementing Custom Archive Business Rules

• Conditional Transactional Data Recovery Interface
                          Advantages
• Reduce Total Cost of Ownership

• All Processes Automated

• Substantial Improvement of Application Performance

• Stable Infrastructure Maintenance (Hardware).

• Easy maintenance of environments( Dev, Testing and Production)

• Fully retire inactive transactions to offline storage devices

• User Friendly Conditional Purging of Archived data

• Greater improvement in backup and recovery timings

• Application Data maintenance with minimal learning curve / training
 Contact Details




ERP Analysts, Inc.
425 Metro Place North Ste# 510,
Dublin, OH, 43017, USA
Email: info@erpanalysts.com
http://www.erpanalysts.com
Thank You!

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:4/2/2013
language:English
pages:11