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 Physical Separation of data (moving the data from 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 non active data to the new record
within the same database.
- To improve application performance – 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 on response time
- To assist database managers/administrators
- To be used for Audit, compliance and information governance specialists
- To reduce the transaction data growing at the exponential rate
- To retain the detailed information for a longer time
- Statutory & Legislative requirements to hold historical data
Long term data retention requirements
- Past Payroll data
- Previous fiscal year books of account
- Customer problems/issue logs
- Providing better response to worker/customer
- History Timesheets / Payslip
- CRM Cases
- Closed/Billed historical Invoices
- UK/India statutory and legislative requirements
- Internal/External Audit
On receiving the requirement from the client we have 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.
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 client. Pictorial representation of archival data movement is given below,
Value Addition:
Our value addition to the PeopleSoft Data Archival Manger includes,
- Inbuilt Database Maintenance activity on archive tables.
- Table locking to preserve structure on archive tables.
- Approach to handle non structured tables.
- Unique approach to handle partitioned object archival
Data Archival duration:
Data Archival project varies based on the type of the archival (Physical/Logical), Tool used. Our recommendation for PeopleSoft application archival is PeopleSoft Data Archival Manager. It just works with minor tweeking.
For more details, feel free to contact us
For more details, feel free to contact us
hmmmm
ReplyDeleteWhen archiving data for writing services, it's crucial to maintain accuracy and integrity. I have read essay writing services reviews which ensure that all review data is securely stored and backed up to prevent loss. They produced quality content and evolving data storage technologies and compliance requirements.
ReplyDelete