Hi-Definition Transformation Problems > Data Quality and Standardization

> Archive Old and Unnescessary Data

Your E-Business Suite database is overgrown with a large amount of obsolete data.

Profile

A cable company that has been in business over 25 years noticed that the amount of data it has accumulated over the years is causing its systems to perform poorly, costing the company valuable time as well as capital in the form of dollars spent in energy costs required to keep the datacenters running. After a thorough analysis, management discovered that approximately 45% of the data in the database is obsolete and not required for operations, most of it relating to past customers who were no longer receiving services from the company or who had moved out of the area. The company needed a way to purge the data from the database without destroying any existing relationships and corrupting the database.

Solution

The cable company used eprentise Data Archive software to separate out the data related to customers who were no longer active. All financial transactions and equipment history were purged, while the remaining data was fully functional and 100% consistent, complete, and correct. Costs of running the datacenters was reduced by 20%, and the archived data is able to be brought back into E-Business Suite at any time in the future.