Docstoc

Slide 1 - MI-OAUG

Document Sample
Slide 1 - MI-OAUG Powered By Docstoc
					   Michigan OAUG
Creating smaller and faster
   test & dev databases
          12/10/02
    Why Use Downsizer?

    n Excessive  storage requirements for dev &
      test databases?

    n Too  much time spent maintaining dev and
      test databases?

    n Poor   system performance?



2
    Relational Database Complexity

                                     Oracle Applications 11i
                                     contains roughly 7,500
                                     tables with an equally
                                     astonishing number of
                                     rule driven
                                     interrelationships.


                                     Oracle Applications
                                     10.7 contains
                                     approximately 2,400
                                     tables governed by
                                     roughly 180,000
                                     separate rules.




3
    Execute Db Downsizer

           Source                    Test
                                     Source        Reduce Data for
                                    Source
                                    DATA              downsized
                                                        modules
                                                  Reclaim Table
           DATA           Copy       DATA
                                      DATA           Space

                                  Unused Table
                                  Table Space
                                     Space
        Unused Table
                                   Unused Table
           Space
                                       Space
                       Test           Dev 1          Dev 1

                       DATA           DATA          DATA

                    Table Space    Table Space    Table Space


4
     Flexible Parameters



3 yrs.



2 yr.



1 yr.

         GL Balances   GL Detail    Inventory     AP Invoices
                                   Transactions

 5
    Example of a Driving Class


       Accounts Receivable        Accounts Payable
       (ex: AR Invoice)           (ex: AP Invoice)
       – Credit Memos             – Credit Memos
       – Chargebacks              – Payments
       – Debit Memos              – Checks
       – Commitments              – All related PO data
       – All related OE/OM data




6
    Db Downsizer Classes


     Primary transaction and related data objects (classes)

         - GL Balances            - Purchase Orders
         - GL Batches             - Sales Orders
         - AP Invoices            - Inventory Item Transactions
         - AP Batches             - WIP Transactions
         - AR Invoices            - WIP Operations
         - AR Batches
         - AR Receipts




7
    Db Downsizer Process


    Begin Db         Perform       Analyze        Create
    Downsizer        Instance       Data          Rules
                    Validation



                                   Analyze
                                    Data
                                   Report                       Pre-
     Required                                      Pre-      Diagnostic
                                               Diagnostics     Report
      Optional
                                    Post-
                                  Diagnostic
                                    Report




     End Db       Reclaim           Post-      Downsize
    Downsizer    Tablespace      Diagnostics     Data




8
    Db Downsizer Rules




9
 Resize Tablespace After Downsizing




10
 Customer Case Study




                                                                          Run time
                                                                           9 hrs
     Requirements:                          THE RULES (Kept)
     • 15 months of transaction history     „ GL: GL Balances > 01-FEB-2002
     • Maintained 8 months for GL, AP, PO   „ GL: GL Batches > 01-FEB-2002
                                            „ AP: AP Batches > 01-FEB-2002
                                            „ AP: AP Invoices > 01-FEB-2002
                                            „ PO: PO Headers > 01-FEB-2002



11
     Competitive Analysis

     § Complete solution (doesn’t require Quest’s
       LiveReorg)
     § Multiple modules downsized simultaneously –
       results in optimal data integrity
     § Very fast implementation – less than one day
     § 4.5 Release on Mar 3rd
        § Command line execution of combined downsize
          process and space reclamation
        § Automated notification of job status



12
     Product Roadmap - Release Schedule

     Application                    Date
     n Order Management 11i (ONT)   Q4-02 (12/16/02)
     n Project Accounting           Q1-03 (3/03/03)
     n Fixed Assets                 Q1-03 (3/03/03)
     n HR/Payroll                   Q2-03 (4/28/03)
     n Cost                         Q2-03 (4/28/03)
     n Grants                       Q3-03
     n MRP                          Q2-03
     n Shipping                     Q4-03
     n Quality                      Q4-03
     n Cash Management              Q4-03


13
   Michigan OAUG
Creating smaller and faster
   test & dev databases
          12/10/02
 Our Focus

     To provide a suite of Application Management tools to
     enable our Oracle Applications customers to:


          Enable effective change management

          Improve operating performance

          Control enterprise growth

          Reduce total cost of ownership




15
 Our Products

                   Automate, Optimize and Manage
                       using our unique suite of
                    Application Management tools:

                n Setup Reporter
                     Ø Manage, control configurations

                n Xpress Archiver
                     Ø Archive and purge

                n Db Downsizer
                     Ø Create smaller test environments

                n FlexChanger
                     Ø Change chart of accounts structure

                n DataCleanser
                     Ø Identify and resolve duplicate information


16
17
                             Setup Reporter

                               DownSizer


                            XpressArchiver
                                               Applimation Platform




                              FlexChanger

                             DataCleanser
     Applimation Platform



                            New Applications
 Oracle Certification



                             Certified for use with all modules of Oracle Applications
         1998               2000 –10.7, 11.03              2001 - 11i Certified

     Oracle Partner   Certified by Oracle Cooperative   Oracle Partner Technical Services
     Program Member   Applications Initiative (CAI)     (PTS) organization approved the
     since 1998       Program, April 2000               integration of Crystallize Products
                                                        through the Oracle E-Business
                                                        Suite Integration (EBSI) program,
                                                        July 2001




18
 Our Customers




19
 Key Payback to our Clients


                                     Im
                       &   t            p
                    st men           Or rove
                 Te p y          Ap ac d
                     lo        pe plic le
                  ve ienc        rfo at
                De ffic             rm ion
                  e                    an
                                          ce




                                      Ch ith za
           st st e




                                     cu
             co duc




                                        w mi
                                        an out tion
             or of




                                         st
                  e




                                           ge
               Re


               ag




                                            o
                          Version
                          Control
                          assures
                        continuous
                         business
                         operation


20
 Applimation’s Credentials

 n   The “GO TO” Company for Applications
     Management tools
      ØFamily of 5 Application Management software
       products + growing
      ØLower the cost of Oracle ownership
 n Architecture based on comprehensive,
  proprietary Metadata
 n 75+ Oracle Customers
 n Deep Oracle expertise on-staff
 n World class support

21

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:1
posted:7/22/2013
language:English
pages:21