Chapter 10. Designing for Archive Independence

Independence is the single most important objective to achieve in a long-term database archive. The archive must be independent from the operational environment unless you are willing to maintain the operational environment in its entirety forever.

Dependencies run as deep as relatively minor changes to data structures where some data is created under one definition and other data created under a newer definition. The dependency comes down to a “version” of the application. Archive units of data may also be tied to versions of operating systems or hardware.

When you have data retention requirements of many years, the number of separate configurations of the application and operational environments ...

Get Database Archiving now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.