BUILDING A DATA WAREHOUSE

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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial