Tag Archives: deleting data
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.
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.