The Oracle Sponge

Oracle Data Warehouse Design and Architecture

Under the Wire

Posted by David Aldridge on 2007-01-09

I just slipped my white paper for the 2007 Rocky Mountain Oracle User Group Training Days in yesterday, which was coincidentally the deadline for getting them included on the CD that attendees will be receiving. Lovely.

The title is Linux 2.6 I/O Schedulers For Oracle Data Warehousing, so it will be an esoteric little 30 minutes of talk about head movement, elevators, and a cheap (free) way to get 60% better read performance. Certainly not mainstream stuff but anyone looking for an economical test and/or development platform would be doing well to consider Linux nowadays even if you do insist on some monstrous HPUX RISC +SAN architecture for your production machine. When your sub-$10,000 machine outperforms your “real” hardware at disk bandwidth then you have something of interest to talk about over the water cooler at least.

Looking through the list of presenters there are a fair few that I know/bumped into at Hotsos 2006 or have corresponded with since – discretion and amnesia prevent me from recalling to whom I owe drinks, but if you say I do then I’ll probably believe you.

Unfortunately socialising will be curtailed by the 70 mile drive home every evening down I25. In the event of yet another flippin’ snow storm, and they do seem to be popular this year, I’d better make sure I have a bag packed all the same.

8 Responses to “Under the Wire”

  1. Allan Nelson Says:

    will the paper be available to non-members of that user group? I’m in Houston, which would make my drive longer than yours :-)

    Allan

  2. shrekdba Says:

    hhey, i got mine in a whole day early…. hmmmm… must mean i forgot something.;-)

  3. David Aldridge Says:

    I think it will be, yes. In any case unless there’s some reason why I’m not allowed to I’ll be making the WP, and maybe the associated slides if they add value, available through the blog anyway.

    Good job Bill, and yes it does mean that you forgot something.

  4. Alex Gorbachev Says:

    Well, at least, you have some snow whereas we can’t even go skiing here is Ottawa. What a surprise in my first winter here!

  5. David Aldridge Says:

    Heh, technically what we have here has been one to five inches of solid ice on the minor roads for the past couple of weeks. A bit of honest here-today-gone-tomorrow snow would be luxury!

    It looks like we’re set for another weekend of stir-crazy kids too — forecasted high temperatures of 10F/-12C, lows of 2F/-17C. I’m thinking that I’ll be barbecueing my defiance to the gods one evening.

  6. Noons Says:

    David, please make that available on the blog at some future stage: very interested in it. Not too long ago I had to undertake similar tweaking of the elevators and would love to compare with your findings.
    Better yet: any chance of you sending me an email when it becomes available? I might be offline from the blogsphere for a while in the near future.

  7. gandolf989 Says:

    Did you discover a silver bullet for better disk access???

  8. David Aldridge Says:

    Well you might say that it’s a silver bullet for a very particular type of disk access on a very particular platform. I don’t think that really counts — it’s more of a silver needle.

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>