Now that the Wine Club has decided to build a data warehouse, it must further decide:

  1. Where is it to be placed?

  2. What technology should be used?

  3. How will it be populated?

These are problems experienced by most organizations when they attempt to build a data warehouse. As we have said, the business applications have been designed using technology and methodologies that were appropriate when they were developed. At the time, no consideration was given to decision support. The applications were designed to satisfy the business operational requirements.

The Wine Club must draw its warehouse data from three very different software environments:

  1. Indexed sequential

  2. RDBMS

  3. Third-party package

Also, these applications reside on two ...

Get Designing a Data Warehouse: Supporting Customer Relationship Management now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.