Rittman Mead - Delivered Intelligence

If you have been reading my current series on data warehouse design you will have read (or perhaps soon will, as there is also a new piece in preparation!) that a good technique in the batch process is to disable bitmap indexes during an insert and then rebuild them after the insert is complete. Inspecting [...]

One of the new features in Oracle Warehouse Builder 10gR2 is the Data Object Editor. The Data Object editor, like the Data Profiler, is a Warehouse Builder “module” that launches when you edit a database object, and works for both relational and OLAP objects. As this feature is going to be new to most users [...]

One of the new features in Oracle Warehouse Builder 10gR2 is the Data Object Editor. The Data Object editor, like the Data Profiler, is a Warehouse Builder "module" that launches when you edit a database object, and works for both relational and OLAP objects. As this feature is going to be new to most users [...]

I suppose that if we had unlimited computing power and the ability to read our entire fact table in a single, instant, read then there would be no need to summarise. But in the real world this is not the case. Summaries are used to speed queries by pre-calculating aggregations (often, but not invariably, summations); [...]

I’m just working through the Data Modelling part of my upcoming seminar, and I’m at the point where I’m thinking about logical and physical modelling within Warehouse Builder 10.2. Warehouse builder seems to mix up the concepts of logical and physical modeling, and therefore I thought it worthwhile to work through what I’m thinking, and [...]