Second Desktop Conference 2006 Presentation

And relax...

Just finished the second of my two Desktop Conference 2006 presentations, this time on Oracle OLAP Best Practices. There were more technical problems as the start again, just as I was about to start I was asked to move to a different conference ID (i.e. virtual "room") and only about half of the attendees on the old room managed to move across to the new one. We didn't get to start until about 20 minutes past the official start time, which meant I had to leave out the last 20 minutes or so of my talk. A bit of a shame but if you were listening in, you can download the powerpoint slides and paper and read what you missed.

It was interesting delivering the paper actually. I've delivered it once internally within the company, and now once externally, and I'm due to present it again at the Collaborate'06 event in Nashville. Next time around, I'll probably cut out about half of the "best practices" and focus more on sparsity handling, dimension ordering, memory management and partitioning, as they're the factors that have by far the biggest impact on cube performance. When I do the presentation next time, I'll go into more detail on scenarios where, for example, time is the least or the most varying dimension, the actual impact that compression can have on cube size and rollup time, and what effect logical and physical partitioning has. Sort of less, more focussed and with examples.

If you sat through the presentation and you've got feedback, or comments on the best practices put forward, drop me a line or add a comment.