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 ...
Get Designing a Data Warehouse: Supporting Customer Relationship Management 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.
