DW Design (2) – staging data

Thursday, June 29th, 2006 by Peter Scott

As mentioned yesterday, the staging area of the data warehouse has three functional uses:

It is the initial target for data loads from source systems
It validates the incoming data for integrity
It is the data source for information to be published the ‘user visible” layers of the data warehouse

Optionally, it may also be where the logic to […]

Creating an Oracle BI Suite Enterprise Edition Demo

Thursday, June 29th, 2006 by Mark Rittman

I’m off to do a presales visit to Ireland tomorrow, and the bit of technology I’ll be demonstrating is the new Oracle BI Suite Enterprise Edition. I had to put a demo together to show the customer, and therefore I was able to spend a few hours this afternoon working with Oracle BI Answers and […]

Creating an Oracle BI Suite Enterprise Edition Demo

Thursday, June 29th, 2006 by Mark Rittman

I’m off to do a presales visit to Ireland tomorrow, and the bit of technology
I’ll be demonstrating is the new Oracle
BI Suite Enterprise Edition. I had to put a demo together to show the
customer, and therefore I was able to spend a few hours this afternoon working
with Oracle
BI Answers and Dashboards. As with my other […]

DW Design (part 1)

Wednesday, June 28th, 2006 by Peter Scott

“Which comes first, the physical or logical design for an Oracle data warehouse?” has always been a question that I have struggled to come up with a convincing answer. To my thinking they both develop simultaneously. True, when designing a data warehouse there will be a set of design criteria that define the bounds of […]

DW Wisdom (4)

Tuesday, June 27th, 2006 by Peter Scott

The final part of this small series on data warehouse wisdom looks at the enterprise strands. Enterprise DW moves away from the tactical departmental “point solutions” and into something that fits with strategic aspirations of the enterprise. On the face of it having a single solution across the enterprise as distinct advantages:

there is a single, […]

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 system […]

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 Hotel, just off
of Union Square. […]

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 bed and woke […]

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 run […]

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 people came into the […]