DW Wisdom (3) – departmental business

Tuesday, June 27th, 2006 by Peter Scott

The first two parts of this discussion covered the physical aspects of conventional DW wisdom. Today I will cover some of the business drivers for data warehouses. When people found that their transactional systems were unsuited for BI reporting (perhaps because of the performance impact of running BI on a transactional system, or the transactional [...]

Starting Preparations for Oracle Open World 2006

Tuesday, June 27th, 2006 by Mark Rittman

Tim Hall mentioned the other day that our complementary Oracle Open World full conference passes came through, courtesy of the Oracle ACE program, which was rather nice. As both Tim and I are paying for ourselves to go over, we’re trying to keep to a reasonable budget and therefore we’re staying in the King George [...]

Checking out the Hackers’ Diet

Saturday, June 24th, 2006 by Mark Rittman

I’m back now from Washington, and the journey back wasn’t nearly so bad as when I came back from Nashville, or at least the jet-lag isn’t, anyway. The fact that my flight left Washington at 8.00am, and got in to Heathrow around 8.30pm, meant that by the time I got home I went straight to [...]

DW Wisdom (2) – more of the physical

Friday, June 23rd, 2006 by Peter Scott

Keep all the OLTP tables separate from the DW systems: In the olden days, the database ran on a single machine with one or (probably) more processors and direct connection to the disk. Enterprise storage and server clustering has moved things on a lot since then but there are still some good reasons not to [...]

Days 3,4 and 5 of ODTUG Kaleidoscope

Friday, June 23rd, 2006 by Mark Rittman

Time to catch up on the second half of the week at ODTUG Kaleidoscope. Tuesday was the one day that I wasn’t due to present, but due to my rather over-enthusiastic volunteering I was still down to be an ODTUG Ambassador for three presentations. This basically involved giving out the handouts and evaluation forms when [...]

Website Design & Build: tymedia.co.uk