Tag Archives: deleting data

Archiving And Purging

The main goals of any Application ILM project are to reduce cost, improve application performance while maintaining compliance.  To meet these goals, data has to be moved from a production database to either an online, accessible archive or purged completely from the system.  In either case, data is deleted from production.  Deleting data can have a significant impact on the production system’s performance if not executed carefully.  However, once the data is gone – the benefits have a ripple effect.  Production tables are smaller and more manageable.  Recovery times and maintenance windows can be reduced.  The cost of managing a smaller production database is reduced proportionally with the amount of data removed.

(more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Application ILM, Application Retirement, Business Impact / Benefits, Business/IT Collaboration, Data Governance, Database Archiving, Governance, Risk and Compliance, Operational Efficiency | Tagged , , , , , , , , , , | Leave a comment

Keeping Too Much Data? Delete It!

One aspect of an Information Lifecycle Management (ILM) project that often gets overlooked is deleting data. Once information has reached the end of its usefulness, delete it. It is the single-most cost effective task you can execute on an ILM project. If you don’t have the data, you don’t have to store it, manage it, or worry about it getting into the wrong hands. Delete it.

(more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Application ILM, Business/IT Collaboration, Data Governance, Data Warehousing, Database Archiving, Operational Efficiency | Tagged , , , , , , , , , , | Leave a comment