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. Salesforce Archiving
  9. SAP Application Retirement
  10. Creating Retirement Archive Projects
  11. Retention Management
  12. External Attachments
  13. Data Archive Restore
  14. Data Discovery Portal
  15. Data Visualization
  16. Oracle E-Business Suite Retirement Reports
  17. JD Edwards Enterprise Retirement Reports
  18. Oracle PeopleSoft Applications Retirement Reports
  19. Smart Partitioning
  20. Smart Partitioning Data Classifications
  21. Smart Partitioning Segmentation Policies
  22. Smart Partitioning Access Policies
  23. Language Settings
  24. Data Vault Datatype Conversion
  25. Special Characters in Data Vault
  26. SAP Application Retirement Supported HR Clusters
  27. 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!