| Abstract: |
Several events in recent years have changed the requirements for retaining data from operational databases to long periods of time. Required retention periods have ballooned to many years, and in some cases, to many decades. This coupled with the rapid rise in data volumes and the importance of providing archived data on demand many years after it is created, has surfaced the need for companies to build a solid practice for archiving and managing business data from their online operational databases. The presentation covers the basics of an archiving methodology and a number of topics that require special consideration in building a database archiving practice. Topics covered are application independence, metadata independence, data authenticity, change management, storage management, and access control. |
| Outline: |
- Agenda - Difference between DBA and Data Mgmt - DBA Functions vs. DM Functions - Emerging Data Management Drivers - DM Drivers Impact(s) on DM Functions - Archiving Data - Data Archive vs. Database Archive - Long-Term Database Archiving - Data Retention Stages - Data Retention for eDiscovery: Legal Reqmts - Choices for Data Retention - Why Database Archiving is the Best Choice - Steps in Database Archiving - Database Archival Issues - Comprehensive Reqmts for Database Archiving --Policy based archiving: logical selection --Keep data for very long periods of time --Store very large amounts of data in archive --Maintain Archives for ever changing operational systems --Independent from Applications/DBMS/Systems --Independent from Operational Metadata --Protect authenticity of data --Access data when needed; as needed --Discard data after retention period -Summary |
| Experience Level: |
Intermediate |
| Presentation Category: |
Data Management |
| Platform: |
Cross Platform |
| Objective1: |
Discuss the business and regulatory issues driving data retention needs |
| Objective2: |
Understand the difference between DBA and DM and archiving's place within each |
| Objective3: |
Understand the deficiencies in current methods and attempts at preserving data for long durations |
| Objective4: |
Discover all of the requirements for achieving a viable and use-able data archive |
| Objective5: |
Understand the needs for not just creating the archive in the first place, but for being able to provide on-going access to data in the archive |
| Event Code: |
E01 |
| Date: |
Monday, November 5, 2007 |
| Time: |
11:15 AM - 12:15 PM |