Rittman Mead - Delivered Intelligence

Browsing the UKOUG website I see that the deadline for paper abstracts for the November conference is 1st May. As I had thoughts of pitching up with a DW presentation of some sort I better get my thinking cap on. I have a few ideas which I might run past people here in the UK. [...]

One of the Oracle 9.2 data warehouses my team manages uses nested materialized views for the aggregation strategy. Nesting of aggregates can reduce the workload on the batch as ‘expensive’ roll-ups only need happen once. The downside to nesting is that in order to make query re-write work for the higher-level nested tables we must [...]

I worked for a client the other week that asked me to come up with some tips and best practices for Oracle Warehouse Builder. Without giving the game away (otherwise you’d never pay to hire me) here’s ten tips for working with Oracle Warehouse Builder 10g. Don’t skimp on the design and analysis phase. Just [...]

I said the other week, when I wrote the first two articles about 5.6 Enterprise, that’d I’d come back in a few days to report on how straightforward it was to put together more complicated reports. I’ve been delayed since then by putting together the OTN article on XML Publisher but it’s given me a [...]

I said the other week, when I wrote the first two articles about XML Publisher 5.6 Enterprise, that’d I’d come back in a few days to report on how straightforward it was to put together more complicated reports. I’ve been delayed since then by putting together the OTN article on XML Publisher but it’s given [...]