Oracle Warehouse Builder and Data Integrator

Sunday, October 30th, 2011 by Peter Scott

Sometimes, when I am working with customers on data warehousing projects I am asked questions about Oracle Warehouse Builder and its future. I know no more on this than what I read in Oracle’s reposted a statement of direction from May 2011 and recent internet postings elsewhere which states that OWB 11gR2 will be the [...]

Real-time BI: EDW with a Real-time Component

Wednesday, July 6th, 2011 by Stewart Bryson

I apologize for the long delay in getting this last portion of the Real-time discussion in place. Since I wrote the first two installments, we’ve had the BI Forum (US and UK versions), plus a flurry of activity around Rittman Mead in the US, followed up by KScope11. But a promise is a promise, and [...]

Real-time BI: Federated OLTP/EDW Reporting

Monday, May 16th, 2011 by Stewart Bryson

The typical approach in Federated OLTP/EDW reporting environments is to use a BI tool such as OBIEE to do horizontal federation. This means combining data from multiple sources at the same grain in a single logical table. One note of clarification: my use of the word “federated” might be a misnomer, and I apologize in [...]

Real-time BI: An Introduction

Monday, May 9th, 2011 by Stewart Bryson

Discussing real-time data warehousing is difficult because the meaning of real-time is dependent on context. A CIO of an organization that has weekly batch refresh processes might view an up-to-the-day dashboard as real-time, while another organization that already has daily refresh cycles might be looking for something closer to up-to-the-hour. In truth, an interval will [...]

The One Mapping Paradigm

Friday, April 1st, 2011 by Jon Mead

Here at Rittman Mead we have been working on some new methodology and design patterns for ETL. We have long realised that the bottleneck in  Business Intelligence and Data Warehousing projects is ETL, so we have been prototyping new techniques to approaching this and trialling them at client’s sites. Taking a step back and looking [...]

Website Design & Build: tymedia.co.uk