Rittman Mead - Delivered Intelligence

I’m over in Las Vegas now for the Collaborate’07 event, a joint user-group conference by the IOUG, OAUG and Quest. The event’s being held at the Mandalay Bay hotel, one of the “mega-casino hotels” on the Las Vegas strip, and I’m staying up on the 31st floor. In the end, the journey wasn’t too bad [...]

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

I’ve not been blogging much recently because I’ve been working flat out on something that’s turned out equally as interesting – bootstrapping a consulting business with an old colleague of mine, Jon Mead. When I used to bump in to people such as Mogens Norgaard and Jonathan Lewis at user group events, one of the [...]

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

It’s only a week to go now until Collaborate’07 in Las Vegas, so I was thinking it’s about time I sorted my agenda out. Here’s what I’m planning to attend over the main four days: Monday 8:15 AM-9:00 AM : 30 Years of Database Innovation, Ken Jacobs, Open 10 9:15 AM-10:15 AM : Oracle Identity [...]