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

CRM APPLICATIONS

As informational applications are developed, the main source of data will be the data pool. The application will draw data from the pool, either to support queries directly or to store within the application's own database, perhaps in the form of aggregates. In addition, the application will, most likely, use its own data. This might be internal metadata or externally provided agency data such as geographic or demographic information.

The applications will have their own processing cycles, completely independent from those of the data pool. This includes processes for:

  1. Data capture

  2. Application-specific transformations

  3. Loading

  4. End-user access

  5. Backup

This separation of the data pool from the applications means that new applications ...

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