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.
ReplyDeleteI've always struggled with managing multiple deadlines, so I eventually turned to Native Assignment Help just to survive the workload. I didn t expect it to make such a huge difference, but it honestly did. They helped me get my workload under control and, for the first time, actually understand what each assignment was asking for. Later, when my coursework started getting tougher, I needed help with quality management case study questions and answers, especially understanding how to interpret real business operations, evaluate quality systems, apply management principles to scenarios, and explain solutions clearly, and it honestly became a complete lifesaver. Instead of feeling overwhelmed by criteria, units, and endless task requirements, I finally had someone guiding me through everything in a way that actually made sense.
ReplyDelete