ARCHIVAL

only for RuBoard - do not distribute or recompile

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. If 10 percent of your customers change their address each year and you have five million customers, that's half a million new records, assuming you've implemented true retrospection for customers' addresses. That's a drop in the ocean compared to the number of behavioral records being managed.

only for RuBoard - do not distribute or recompile


Designing a Data Warehouse . Supporting Customer Relationship Management
Designing A Data Warehouse: Supporting Customer Relationship Management
ISBN: 0130897124
EAN: 2147483647
Year: 2000
Pages: 96
Authors: Chris Todman

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net