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

BACKUP OF THE DATA

Partitions should be used for the behavioral information. This is usually, by far, the largest part of the data warehouse and is the most problematic to back up because of its sheer size. By placing the behavioral information into partitions based on dates, we can switch old partitions into a read-only mode. This means that no further data is expected to be placed into the partition and, therefore, once it is backed up, no further backups will be needed. Figure 7.10 shows the gathering of data into daily partitions.

Figure 7.10. Daily partitions.

Figure 7.10 shows a typical take-on of behavioral information into the warehouse ...

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