Rittman Mead - Delivered Intelligence

Well over in the UK it’s around 5pm on New Year’s Eve, and as we went out last night rather than tonight (babysitters) I’ve got an hour or so spare to look back at what happened in the world of Oracle BI this year, and speculate a bit on what’s in store for us in […]

The final installment on the ingredients for successful BI is about data quality. For some strange reason, if users do not trust the quality of data in a BI system the system will fall into disrepute and be seen as a failure. Now I said “strange reason” and in truth there is a degree of […]

Let’s be honest here, the BI world is changing; it is no longer the exclusive domain of an elite group of data analysts (the sort of people where being an extrovert is to look at someone else’s shoes whilst talking). BI is now (or should be) part of every worker’s daily life; from the CxO […]

So what is timeliness? Again this a purposely vague term. I suppose that “knowing something when you need to know it” is timely; and the sooner you know something the more options you have to react to the information. But in reality this depends on the nature of the information - looking at last month’s […]

Now that is a good interview question - the simplicity of the question hides a vast richness of answers; it can differentiate between the “been there, done it” and the “read a book”; it can tease out the roundedness of a candidate - are they reporting tool biased or database centric. It can also separate […]

Well, the turkey’s stuffed, the pies are minced and the presents are wrapped. Today was my last day in the office, and apart from a day over the Christmas break when I’ll be going in just to get a bit of peace and quiet, that’s it for me now until the New Year.
It’s been an […]

It’s that time of year again when I start to think about the appraisals for the team I look after. If any of you have completed appraisal forms in the past, you’ll know that one of the sections is usually along the lines of “What do you see as your objectives for the next twelve […]

I mentioned the other day that a new version of AWM was now available following the release of the 10.2.0.3 patch for Oracle Database 10g. One of the new features that this latest version of AWM comes with is the Sparsity Advisor.
I covered the PL/SQL Sparsity Advisor earlier in the year, but at the time […]

… our use of an index organized table in our ETL process and I promised to jot a quick note on it. So here goes.
There are various combinations of database functionality that I do not like mixing in a data warehouse. For instance I impose rigorous RI checking in the staging layer of my typical […]

The Oracle Sponge makes a timely comment on statistics on partition keys. Having the right (and not just some!) statistics on a data warehouse table is often the factor that tips the balance between an efficient query and one that causes abject misery in attempts to find what is wrong and how to tune things […]