Table of Contents

Search

  1. Preface
  2. Introduction
  3. Accessing Data Archive
  4. Working with Data Archive
  5. Scheduling Jobs
  6. Viewing the Dashboard
  7. Creating Data Archive Projects
  8. SAP Application Retirement
  9. Creating Retirement Archive Projects
  10. Retention Management
  11. External Attachments
  12. Data Archive Restore
  13. Data Discovery Portal
  14. Data Visualization
  15. Oracle E-Business Suite Retirement Reports
  16. JD Edwards Enterprise Retirement Reports
  17. Oracle PeopleSoft Applications Retirement Reports
  18. Smart Partitioning
  19. Smart Partitioning Data Classifications
  20. Smart Partitioning Segmentation Policies
  21. Smart Partitioning Access Policies
  22. Language Settings
  23. Data Vault Datatype Conversion
  24. Special Characters in Data Vault
  25. SAP Application Retirement Supported HR Clusters
  26. Glossary

Smart Partitioning Example

Smart Partitioning Example

Your organization needs to increase the response time of an financial application used by different types of business users in your organization.
To increase application response time, you want to divide the transactions in a high-volume general ledger application module so that application users can query specific segments. You decide to create segments based on calendar year. In the Enterprise Data Manager you create a time dimension that you configure as a date range. Then you create a general ledger segmentation group that contains related general ledger tables. In the Data Archive user interface you create a data classification and configure the dimension slices to create segments for all general ledger transactions by year, from 2010 through the current year, 2013.
When you run the segmentation policy, the ILM Engine divides each table across the general ledger segmentation group based on the dimension slices you defined. The ILM Engine creates four segments, one for each year of general ledger transactions from 2010-2012, plus a default segment. The default segment contains transactions from the current year, 2013, plus transactions that do not meet business rule requirements for the other segments. As users enter new transactions in the general ledger, the application inserts the transactions in the default segment where they remain until you move them to another segment or create a new default segment.
After you create segments, you create and apply access policies to the segmentation group. The default access policy you apply allows all users and programs access to one year of application data. You create another access policy for business analysts who need access to all four years of application data. The access policy you create for the business analysts overrides the default policy.

0 COMMENTS

We’d like to hear from you!