Chapter 11. Modeling Archive Data

The database archive stores data coming from structured databases. It only makes sense that it would be a structured database itself. This means that the archive for any specific application is logically a database and must be architected just as the source database was originally architected. There will be differences between the model of data in the source system and the model of data in the archive. These differences may be minor or significant.

The data archivist must model two data structures and relate them to each other. One is of the data in the source operational database that are impacted by the application's archiving activity. The other is the structure that the archived data will take in the archive ...

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.