Rittman Mead - Delivered Intelligence

No mater what data warehouse designers do, data warehouses are manifestly slower than transactional systems or at least they seem so to users. Queries that can be quickly expressed in words such “How many bottles of ketchup did I sell in Seattle last week?” or “Which oil stocks moved more 15 points today?” can involve [...]

There is a saying that you can’t have too much of a good thing. I have my doubts; you can have too much chocolate, cream, beer, sun, or whatever. Perhaps a surfeit of something is a bad thing and as ‘no longer good’ the saying still holds true. In data warehouses, having too many summaries [...]

A while back it was quite feasible to draw circles around discrete databases in an organisation’s IT structure and say ‘this is the data warehouse, here is the billing system and that is the blinkity-boo system. But now those circles are pretty defuse. It is harder to differentiate between where document storage diverges from data [...]

Justin Kestelyn writes about Electronic Content Management and IBM buy Filenet – amazing how the world synchronises

In this example I’ll be looking at how Oracle BI Suite Enterprise Edition can be used to access data in Analytic Workspaces. Analytic Workspaces are potentially a more efficient way to store and summarize data used for reporting, as they can take up less disk space, return results faster and handle ad-hoc queries more effectively [...]