Tag Archives: Database Archiving
Oracle has been relatively quiet of late about Oracle Fusion Applications availability. But as the first applications are scheduled to rollout this year (2010), it might be a good time to revisit your upgrade to Fusion Applications plans. Is data archiving part a of it? If it isn’t, it should be.
One of the key deliverables for an ILM project that my team is wrapping up is a metadata repository of all the database tables we have applied an ILM solution to. In this repository, we list the database, schema and table name; what Record Series the data belong to; the corresponding retention period and criteria; business owner; and source information. Not only will this repository be used to archive and purge data on a regular, operational basis, but it will also be used by Records Management to track Records Retention compliance.
What do you get when you combine Information Lifecycle Management (ILM), Master Data Management (MDM), Enterprise Content Management (ECM), and Storage Area Networks (SAN)? A compelling Data Management solution on a single purchase order that finally closes the gap on databases. EMC announced this last week at EMC World 2010 that they will start reselling Informatica’s Data Archive and Master Data Management products as part of the EMC Select program. Why does this taste good to data management practitioners? Because EMC customers have been in need for a single solution to manage, retain and archive ALL data, not just email and files.
Has your application portfolio changed over the past 10 years? Have you migrated to newer systems and infrastructure to make your company more competitive? Has your organization gone through mergers or acquisitions where you ‘inherited’ additional applications? Over time, even though these applications may not be used to support current business processes, they are kept on life support simply for occasional access requirements or maybe to meet retention compliance.
In a recent blog from Informatica’s Data Archive Product Manager, Claudia Chandra, she discusses the need for and the business value of retiring legacy applications. This is another excellent topic on how to keep what you need and delete everything else. Purge what is not needed and reduce cost. From a legal discussion perspective, The Sedona Conference has invested in a Working Group Series Publication on the very same topic. The working group on Electronic Document Retention and Production (WG1) shares their insight in the paper “The Sedona Conference® Commentary on Inactive Information Sources: Guidance Principles for Identifying, Classifying, Retaining and Destroying Orphaned, Legacy and Dormant ESI”.
Enterprise Content Management (ECM) solutions have typically focused on managing electronic documents and unstructured content. What about structured data that is ‘locked up’ and traditionally retained indefinitely in your application databases? Can your existing ECM system help manage this content as well? Many people consider database content to be a completely different animal and not a good fit for storing in ECM repositories. However, with the increasing costs of electronic discovery (eDiscovery) during litigation, consider leveraging your ECM investment for managing the long-term retention of structured data.
Structured data archiving has proven to be a great way to trim production databases and get tremendous cost savings by aligning the lifecycle of the data with the underlying infrastructure. ECM adds value to this process by adding functionality in the area of content indexing, search and retention management. (more…)
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.
Over the last few blogs, we have stepped through a project to implement Information Lifecycle Management (ILM) on corporate databases. First, we evaluated the target databases, then we determined the Business Objects and assigned retention periods to the data – including both Legal and Operational requirements. Now that we are ready to start applying the retention policies and deleting data, it is a good idea to set up an archive database as an intermediate repository for business objects classified as legal records.
A key benefit of implementing an Application Information Lifecycle Management (ILM) project is to reduce the amount of structured data in the data center. Application ILM is a combination of a strategy and process that assesses information based on its business value and aligns the technology it resides on. This process assures that the data center does not over allocate IT resources if the business doesn’t need it. And likewise, if the business can provide detailed requirements for what it needs for its data, the IT department has a better idea of its technology forecasting needs. Application ILM is a capacity planner’s friend.
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.