O'Reilly logo

Designing a Data Warehouse: Supporting Customer Relationship Management by Chris Todman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

ARCHIVAL

The partition approach to the storage of behavioral data makes archival very straightforward. However many days of history we wish to store, we can just drop the partitions when they reach the required age. So if the behavioral data table should contain 120 days of data, we can simply drop day (-120), as part of our daily warehouse management process, and store it permanently in the archive in case we ever have to retrieve it. Then we have to create the new partition for today's data.

We don't usually want to archive our circumstances data. In terms of storage it represents a fairly small percentage of the total disk space and is not, therefore, much of an overhead. The biggest change to customer circumstances is usually address changes. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required