Archive for June, 2008

Delivery process of a Data Warehouse

The most important aspect of the delivery process is that the requirements are never static. Business requirements will constantly change during the life of the data warehouse, so it is imperative that the process supports this, and allows these changes to be reflected within the system. This issue can appear to be a very complex […]

The Ad Hoc Query Tool in a Data Warehouse

The next step in the process is where we configure an ad hoc query tool to operate against the data warehouse. These end-user access tools are capable of automatically generating the database query that answers any question posed by the user. The users will typically pose questions in terms that they are familiar with (for […]

Data Warehouse Delivery Sequence

For a successful Data Warehouse Delivery Sequence, a backload of atleast two years worth of sales history from archive tape is necessary. This would allow the business user to analyze seasonal sales trends year on year. However, the data volumes could be such that the existing relatively small data warehouse becomes a much larger one. […]