DSS AWARE APPLICATIONS

Another big problem we face in data warehousing is the whole extraction, transformation, and load (ETL) issue. Having to take data from lots of different places, pass it through some nontrivial (VIM) processing, and load into the warehouse comprises the major part of our development effort.

Historically, the applications from which the data has had to be extracted are entirely blind to the requirements of decision support. The relative success of data warehousing, or at least the success of the idea of data warehousing, should have convinced the application designers of the value of decision support, and they should be beginning to understand the link between the data that resides in their applications and the information ...

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.