How to measure the success of Data Archiving (Part 3)

J.F. Shea, Inc. Case Study

Project background:

• In 2006, to prepare for upgrading to E1, J.F. Shea embarked on a project to consolidate all JDE environments into 1 instance and create data consistency going forward.
• J.F. Shea had been looking for an end-to-end archiving solution to tackle all JD Edwards data, including Homebuilder data

Next steps:

• Find a flexible product that's straightforward to use
• Ensure users can easily access archive data
• Choose a solution that can handle Homebuilder data

Results of the archiving project:

• Users experienced a 30% improvement in system performance from archiving the Homebuilder data
• A 90% reduction in the quantity of data in the Community Master was recorded
• A total of 60 million records from a possible 52 tables were archived

Homebuilder data archived with Purge-it!

Pacific Steel & Recycling Case Study

Project background:

• Problems maintaining some indexes due to amount of data in some key tables
• Preparing for a JDE upgrade
• In a hosted environment, the company felt they were paying for premium storage and replication of data they weren't using

Results of the archiving project:

• 17 years of data was archived and the archive was purged
• Data integrity issues were highlighted.
  The flagged data was worked on separately to avoid delaying the project
• 95% of EDI data was purged
• 94% of Manual backups were purged
• 72% of Messaging data was archived
• 51% of Inventory data was archived
• 46% of data was archived using the Custom Module
• 42% of Purchasing data was archived
• 39% of data was archived from the Master Table
• 29% of Accounts payable data was archived