Off To Ireland, The OLAP Survey and Dual Core PCs

Saturday, June 18th, 2005 by Mark Rittman

I’m off to Ireland tomorrow to work with one of our public sector clients. They’re putting in a data warehouse and I’m helping out with the initial requirements definition and data model. It’s nice once in a while to do some "business analysis"-type work, nice to step away from coding and debugging and think instead [...]

“AskMark” – Or, The Bonkers Questions I Sometime Get Sent Through

Friday, June 17th, 2005 by Mark Rittman

Duncan Mills’ recently posted about the questions he sometimes receives from readers, and it got me thinking about the type of questions I often get sent through to me. Like Duncan, I put my email address on the front page of my blog (in case someone wants to write to me and offer me a [...]

Surrogate keys

Wednesday, June 15th, 2005 by Peter Scott

June 17 – I was not too happy about the way this post was written – I will be revising parts of this – I will use italics to highlight changes. I must admit my view on surrogate keys in a data warehouse is far from the orthodox. For me a surrogate key on a [...]

Is A Dimensional Model Suitable For All Types Of Reporting (Even Operational)?

Wednesday, June 15th, 2005 by Mark Rittman

Next week I’m off to see a client in Ireland, who’s using us to help put together the design for their data warehouse. They’re looking to use tools such as Business Objects, Discoverer and so forth, there’s a certain element of OLAP-style decision support reporting required, but the vast bulk of the reporting they’re going [...]

A Frustrating Couple of Days

Wednesday, June 15th, 2005 by Mark Rittman

If you read Tom Kyte’s blog the other day you’d have seen the entry where he asks you to guess where he’s currently staying, using a photo taken out of his hotel bedroom window. Well in the same spirit, here’s one out of the office window where I’ve been working the last few days – [...]

Website Design & Build: tymedia.co.uk