Rittman Mead - Delivered Intelligence

I’m working over in Ireland at the moment, and staying over in Dublin for the weekend, hence the lack of updates to the website this week. In the meantime, if you’re coming to the UKOUG BIRT SIG meeting in London next week we’ve managed to sell out again, and this time we’re in a bigger [...]

A little while back I posted a piece on how I got into databases in general and data warehouses in particular. One reader asked if I could reveal how to start out in data warehousing. Rather than posting a direct reply to the question, I thought that I would write it as a new post [...]

One of our customers uses Oracle materialized views and query rewrite as the key component of their summarisation strategy. The front-end query tool is Business Objects (or rather its web version) The great thing about rewrite is that the BO universe designer only needed to include the base level summaries (for stock, sales etc) and [...]

Rang the user who created last week’s query from hell… he still needed to find that mystery transaction. It turns out the police were investigating a credit card fraud and knew the amount but no other details (strange they did not know the date (even to the nearest month would help) or store, but hey). [...]

One of the things I do on the DWHs I manage is to periodically review the nature of queries being run so that we can come up with performance improvement plans. When a data warehouse is put in the designer (me) guesses the aggregates and indexes that will be needed to give the required performance, [...]