Dynamic DW the latest spin from IBM

Yesterday I read (RED) a WHITE paper by IBM on Dynamic Data Warehousing (see "New White Paper" at http://www-306.ibm.com/software/data/db2bi/data-warehousing/) that was sent to us. It’s basically a marketecture document disguised as IBM’s view of the future of DW

OLTP and OLAP, a tale of two cities.

It was the best of times, it was the worst of times… I’ve been working in OLAP systems (OnLine Analytical Processing – for Jim) for about 9 years now and have conciously avoided OLTP (OnLine Transaction Processing – for Jim).  The main reason for this bein

Six Critical Components to Enterprise Data Warehouse Governance

At the Teradata User Group meeting in Toronto I attended a great session lead by Betty Knight of Teradata.  Before I jump in I had one great observation on this presentation – it was good and mixed tech and bus together nicely.  So here are my observations: As in previ

CoffeeCAST – #42 – Teradata User Group and Other Musings

Welcome to the 42nd CoffeeCAST with Stephen Hayward of Project X Ltd.  I took a few minutes of space at a Starbucks along with Graham Boundy to chat about last weeks Teradata User Group meeting and a few other musings along the way. This was an impromptu meeting without any agenda, bu

Communication, Understanding and Testing

Testing is often the ugly step sister of IT.  So it is often marginalized and sometimes forgotten. Lately I have seen the opposite effect and that scares me as much as the other.  One of the indicators is in communicating what testing is required.  For me this is the dr

Return to Fundementals

When we are dealing with a complex subject like data warehousing and most complex IT areas, I think that returning to the fundamentals of the discipline is really helpful.  One often gets mired down in small details and forget about the principle of good design.  A good desi

CoffeeCAST – #40 – Capacity Planning

Welcome to the 40th CoffeeCAST with Stephen Hayward of Project X Ltd.  Graham and I grabbed a quiet spot in the office with some fresh Starbucks (coffee for me and tea for him) to talk about Capacity planning. Graham kicks off by discussing Mission statements which funnily enough gave

Who Is The Customer

I was reminded this week about the value of what we do in Information Technology. The Value to the Customer. In the world of data warehousing this is often confusing.  Is it the IT project that our data supports, the marketing or operational group that leverages our IT system or

CoffeeCAST – #38 – Readiness and Master Data Management

Welcome to the 38th CoffeeCAST with Stephen Hayward of Project X Ltd.  We are on the road this week, having jumped to Ottawa and Montreal on a three city tour.  It is cold and sunny and having some fun. Today I would like to Charles to the CoffeeCAST.  We are sitting here late at the

CoffeeCAST – #37 – Ipedo and the Virtualization of Data

Welcome to the 37th CoffeeCAST (and the first of 2007) with Stephen Hayward of Project X Ltd.  It is great to be back.  I have been off living the delivery dream stepping over to the dark side (delivery) for a couple of months.  But I am back and with a vengence. Today I would like to