Data-Archival

Understanding Data Archival

What is Archival?

Archival is a process of moving out the data which is currently not active to a location only meant for record keeping. In other words, the data that would no longer be affected or will affect any transaction will be moved. Archival can be the Physical Separation of data (moving the data from the current location/device to a new/different location/device) or Logical Separation of data (logically grouping the data and moving within the same area).

Logical Separation is done by creating another table/record whose structure is a copy of the existing record and moving the nonactive data to the new record within the same database.

 

Why Archival?

To improve application performance and better response time of application online pages, reports, and batch processes
To reduce hardware and storage costs
To simplify tuning and maintaining large databases
To help PeopleSoft application developers with response time
To assist database managers/administrators
To be used for Audit, compliance, and information governance specialists
To reduce the transaction data growth at the exponential rate
To retain detailed information for a longer time
Statutory & Legislative requirements to hold historical data

 

Why Historical Data is required?

  • Long-term data retention requirements
  • Past Payroll data
  • Previous fiscal year books of account
  • Customer problems/issue logs
  • Providing a better response to workers/customer
  • History Timesheets / Payslip
  • CRM Cases
  • Closed/Billed historical Invoices

 

Regulatory Compliance

  • UK/India statutory and legislative requirements
  • Internal/External Audit

 

Archival approach/Our Experience

Upon receiving the requirement from the client, we made a list of modules that the user has implemented. We have made an analysis of the data and the tables that were involved with these modules. We divided our approach into 5 different steps.

5-step-on-our-data-archival-approach

 

PeopleSoft Data Archival Manager

After analysis of industry-leading archival products for PeopleSoft, DAM is the tool we selected to perform the archival activity at one of our leading staffing clients. A pictorial representation of archival data movement is given below,

 

Value Addition

Our value addition to the PeopleSoft Data Archival Manager includes,

  • Inbuilt Database Maintenance activity on archive tables.
  • Table locking to preserve structure on archive tables.
  • Approach to handle non-structured tables.
  • A unique approach to handling partitioned object archival

Data-Archival -Value-Addition

 

Data Archival duration:

Data Archival project varies based on the type of archival (Physical/Logical), Tool used. Our recommendation for PeopleSoft application archival is PeopleSoft Data Archival Manager. It just works with minor tweaking.

For more details, feel free to contact us

Data Archival Solutions

Archive your business data with our higher-security archiving solution.

Read More