Copyright© 2012 All rights reserved. Proactive Data Consulting, LLC.
Data Management is a necessary part of the lifecycle of every database. The data in every database has two key phases: Growth and Retirement. Data Management focuses on Purging & Archiving during the Growth phase and Sunset Archiving during the Retirement phase.
The Growth Phase is a very important time to plan the life of the data within a database. The amount of online data is critical to performance. Purging removes unnecessary data and Archiving moves data out of production to other accessible systems.
When a system is replaced, many companies keep the database running for many years because they do not want to lose access to the data. Sunset Archiving allows for the key data to be retained and remove the unwanted database from the datacenter floor.
Performance Archive is the process that takes data out of the production database
but keeps the data available to the production system. This method allows users
to still access the archived data while only keeping day-
Some of the data within a database needs to be permanently purged. This would include
API, backup and conversion data. Some of the purging is a one-
Many corporations have legacy systems that should have been retired years ago. Since the data in the system is still relevant to a very small number of people, the entire system still exists. The system is a maintenance problem and tough to support. A Sunset Archiving project is needed to move the relevant data to a maintainable system and build simple access tools to allow required users access to the new system. The data is compressed and the original system can finally be shutdown permanently.
Contact us if Data Management is needed for your company.