Who Moved My Data?
Application Archiving for Business Agility

Application Archiving No Comments »

There’s an apocryphal story I heard about a CIO who asked his DBA to surreptitiously archive one month’s data from his ERP each week, starting with the oldest data stretching back five years. The DBA archived to the point where the oldest historical data was being accessed by any functional user. As expected, the DBA archived three years’ data and the functional users never noticed. The question then is why did he have to move the data in a covert manner?

Business owners – the true owners of the data – are usually the most reluctant when they hear the word “archive”. They think data will be moved offline and access will be lost – never mind the fact that they rarely, if ever, access it at all! Perhaps the solitary word “archive” is a misnomer. Some prefix it and call it “active archiving” – meaning the data would still remain active – while others refer to it as “near-line archiving” – where data would be moved to near-line storage and still be accessed online. And there are some who avoid the word “archive” altogether and call it “data relocation”.

Whatever one may call it – once archived, moved or relocated – business users – and not just CIOs and DBAs – see immediate benefits in terms of application performance improvements. One such customer, a BaaN user on Informix Database, ran into serious issues whenever the application hit the table limit size. The system would be down for several days seriously impacting manufacturing schedules. With Solix EDMS, which supports BaaN Archiving, the customer now moves closed historical data to a separate database, resulting in:

  • Improved application performance and stability – which in turn, helped to maintain their manufacturing schedules
  • Reduced future hardware costs through space reclamation after DB size reduction
  • Reduced downtime associated with frequent database maintenance
  • Reduced backup and restore downtime.

A non-believer may say a swallow does not make a summer. Customers like Forbes Marshall and TRACO, in engineered-to-order manufacturing, deployed Solix EDMS for Oracle E-Business Suite archiving to trim their DB size in Bill of Material and Order Management systems on their production servers and experienced immediate benefits in the shop floor through better application performance. These examples prove the point that Archiving helps to avoid a hit on the company’s top line revenue figures.

Archiving is a pain killer for an organization, not a vitamin providing a short term panacea. If the CIO is the custodian of company data, let him Archive it. Archiving achieves business agility with a high ROI and should be a top priority project in a recession-hit economy.


© Solix Technologies, Inc.
Entries RSS