Arrived in Las Vegas

Monday, April 16th, 2007 by Mark Rittman

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

Saturday, April 14th, 2007 by Peter Scott

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

Bootstrapping an Oracle Consultancy

Friday, April 13th, 2007 by Mark Rittman

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

Lag, lead and sparse data

Tuesday, April 10th, 2007 by Peter Scott

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

Collaborate’07 Schedule

Sunday, April 8th, 2007 by Mark Rittman

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

Website Design & Build: tymedia.co.uk