{"id":30946,"date":"2023-12-16T06:31:24","date_gmt":"2023-12-16T06:31:24","guid":{"rendered":"http:\/\/kovaion-new1.local\/all-you-need-to-know-about-data-archival-kovaion\/"},"modified":"2026-01-06T13:48:37","modified_gmt":"2026-01-06T13:48:37","slug":"all-you-need-to-know-about-data-archival-kovaion","status":"publish","type":"post","link":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/all-you-need-to-know-about-data-archival-kovaion\/","title":{"rendered":"All you Need to Know About Data Archival | Kovaion"},"content":{"rendered":"<h2><\/h2>\n<h2><strong>What is Archival?<\/strong><\/h2>\n<p>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).<\/p>\n<p>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.<\/p>\n<p>&nbsp;<\/p>\n<h2><strong>Why Archival?<\/strong><\/h2>\n<p>To improve application performance and better response time of application online pages, reports, and batch processes<br \/>\nTo reduce hardware and storage costs<br \/>\nTo simplify tuning and maintaining large databases<br \/>\nTo help PeopleSoft application developers with response time<br \/>\nTo assist database managers\/administrators<br \/>\nTo be used for Audit, compliance, and information governance specialists<br \/>\nTo reduce the transaction data growth at the exponential rate<br \/>\nTo retain detailed information for a longer time<br \/>\nStatutory &amp; Legislative requirements to hold historical data<\/p>\n<p>&nbsp;<\/p>\n<h2>Why Historical Data is required?<\/h2>\n<ul>\n<li>Long-term data retention requirements<\/li>\n<li>Past Payroll data<\/li>\n<li>Previous fiscal year books of account<\/li>\n<li>Customer problems\/issue logs<\/li>\n<li>Providing a better response to workers\/customer<\/li>\n<li>History Timesheets \/ Payslip<\/li>\n<li>CRM Cases<\/li>\n<li>Closed\/Billed historical Invoices<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><strong>Regulatory Compliance<\/strong><\/h2>\n<ul>\n<li>UK\/India statutory and legislative requirements<\/li>\n<li>Internal\/External Audit<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><strong>Archival approach\/Our Experience<\/strong><\/h2>\n<p>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.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1694\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Untitled-300x176.png\" alt=\"5-step-on-our-data-archival-approach \" width=\"684\" height=\"401\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2><strong>PeopleSoft Data Archival Manager<\/strong><\/h2>\n<p>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,<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1693\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Untitled-1-300x211.png\" alt=\"\" width=\"601\" height=\"423\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2><strong>Value Addition<\/strong><\/h2>\n<p>Our value addition to the PeopleSoft Data Archival Manager includes,<\/p>\n<ul>\n<li>Inbuilt Database Maintenance activity on archive tables.<\/li>\n<li>Table locking to preserve structure on archive tables.<\/li>\n<li>Approach to handle non-structured tables.<\/li>\n<li>A unique approach to handling partitioned object archival<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1692\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Picture2-300x196.png\" alt=\"Data-Archival -Value-Addition\" width=\"641\" height=\"419\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2><strong>Data Archival duration:<\/strong><\/h2>\n<p>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.<\/p>\n<p>For more details, feel free to <strong><a href=\"info@kovaion.com\">contact us<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":21124,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[24],"tags":[],"class_list":["post-30946","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-analytics"],"acf":[],"_links":{"self":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/30946","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/comments?post=30946"}],"version-history":[{"count":1,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/30946\/revisions"}],"predecessor-version":[{"id":30947,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/30946\/revisions\/30947"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media\/21124"}],"wp:attachment":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media?parent=30946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/categories?post=30946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/tags?post=30946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}