Rittman Mead - Delivered Intelligence

My last post looked at some aspects of performance tuning that would make traditional DBAs blanche with horror, not once did I mention indexing, partitioning, PCTFREE or parallel. This was not because I don’t consider them important, but more that the simple test of “am I doing the right thing” is often overlooked. To appease [...]

My second presentation at this year’s RMOUG Training Days was on tuning “realtime data warehouses”; as usual, this paper is now on the Rittman Mead Articles page.  Perhaps more accurately my talk was more about my tuning philosophy rather than a cookbook of tuning “rules” to give optimal performance. I don’t think there is a [...]

You guessed it… more on transactional schemas. For a quick recap, here are the posts to date: Using OBIEE against Transactional Schemas Part 1: Introduction Using OBIEE against Transactional Schemas Part 2: Aliases Using OBIEE against Transactional Schemas Part 3: Simple Dimensions and Facts Combining Entities In the last post on Simple Dimensions and Facts, [...]

We briefly interrupt the transactional schemas series for this important message: the PIVOT clause of SELECT is only for aggregates! When Oracle added the PIVOT and UNPIVOT operators in Database 11g, at first, I was hopeful. It certainly scratched an itch that had been around in the Oracle DW space (and especially… the ETL arena) [...]

It seems like a different life when I posted the introduction to reporting against transactional schemas. Since that time, we’ve had some exciting new customers come aboard, which has required a lot of my time (and which I have been glad to provide). We’ve also had Kscope 12, where I was a member of the [...]