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 [...]

Oracle Data Warehouse Global Leaders Webcast

Friday, March 18th, 2011 by Stewart Bryson

I’m honored to be delivering a webcast for the Oracle Data Warehouse Global Leaders Program on Tuesday, March 22 at Noon EST. This is an elite program for key global data warehousing customers and is managed by the Oracle data warehousing product management team. It also provides a rich opportunity to network with peers, and these webcasts are one of [...]

Transcend Part 2: Dimensions

Wednesday, December 15th, 2010 by Stewart Bryson

In the last post, I described the concept of a “Mapping” entity in Transcend as a bundling of pre- and post-mapping processes that can be executed with a single call. The “Dimension” entity is very similar. In fact, in strict programming terms (for those of you who are interested… the rest I’ll bore for just [...]

Website Design & Build: tymedia.co.uk