Rittman Mead - Delivered Intelligence

One of the topics I have wanted to research, but have never managed to find time to, is a performance comparison of Oracle OLAP technology and the SQL grouping extensions such as GROUP BY ROLLUP, GROUP BY CUBE and GROUP BY GROUPING SETS. I suppose for that mater I should also include conventional aggregate materialized […]

Today was Day Two of the Miracle DBF up at Edinburgh Castle, and for those of us that got a reasonably early night it was a Nine O’Clock start with Mogens Norgaard on “You Probably Need RAC”. Following on from Mogens was Dan Fink with “No Mogens…” and James Morle with “Brewing Benchmarks”.

After lunch was […]

I’m currently sitting in a pub just down from Edinburgh Castle, in a break between the morning and afternoon sessions. Just across the table from me is Doug Burns, and behind is Thomas Presslie and Carel-Jan Engel, who are working on the Miracle musical for tonight’s gala dinner. We’ve slipped out for a cheeky one […]

A little while back I took part in a partitioning survey. You may have seen it mentioned on Ton Kyte’s blog. It is certainly good to be asked these things - but I expect that the organiser of the survey already had an inkling of my views anyway.
Still, I actually like a lot about Oracle’s […]

Back in January I wrote about a bug we found in the query optimiser that caused some of our complex temporary table star_transformation query candidates to crash the plan evaluation phase of optimisation with an ORA 604 error.
Well, the effort of filing the test case was worthwhile - the guys and gals at Oracle have […]

Yesterday I mentioned a query that would not eliminate unused partitions and resulted in a somewhat large nested loop join plan that would take hours to return. A kind of “find all the rows that match predicate B and then filter the result set on a range of 7 days (out of 800)” type of […]

Constraints do just that; when enforced they constrain data such that rules are obeyed. But even when not enforced the existence of an Oracle RELY constraint does something really useful, it tells the CBO, and especially the query rewrite engine, that certain facts about the data can be presumed to be true. Of course, if […]

Jonathan Lewis posts a nice example (with a subsequent comment from Jeremy expanding it to work well with RAC) of an use of the analytic LEAD function.
Which reminds me of a gotcha with LAG or LEAD with sparse data. Sparse data is commonly found in business intelligence databases at low levels of aggregation. Suppose we […]

Tom Kyte posts an interesting paper and invites comment. It is not an easy read, and really needs a reasonable understanding of analytic functions, but persevere if you can.
To my mind the best place to find patterns is as close to the data as possible. I know that some vendors have developed “real time analytics” […]

A somewhat slow week blogwise; loads of events that are not blog worthy, or just unusable for confidentiality reasons. Some may be written about later, but others will be locked away for ever.
At long last one of my customers is going to upgrade the Oracle version of there multi-terabyte DW. When I designed it I […]