Rittman Mead - Delivered Intelligence

In this final posting in the series, I’ll look at how Oracle Warehouse
Builder 10.2 can be used to perform Partition Exchange Loading into a target
table.
Partition Exchange Loading (PEL) s a data warehousing technique that is
useful when you are loading data into a large, partitioned table. By swapping
the table that contains the data to be loaded […]

In addition to the conventional
Select D1,D2,SUM(M1) from base group by D1,D2
type of summary Oracle offers two other approaches: Oracle OLAP cubes and the various extensions to GROUP BY. Oracle OLAP has it roots in the Oracle Express technology - that is the the stand alone OLAP database and not any more recent additions to […]

In one of last week’s postings I looked at how relational data objects are defined using Oracle Warehouse Builder 10gR2. In this posting, I’ll look at how OLAP objects are defined and populated.
To define OLAP objects, you don’t need to have installed and licensed the OLAP Option to the Enterprise Edition of the database. Without […]

In one of last week’s postings I looked at how relational data objects are
defined using Oracle Warehouse Builder 10gR2. In this posting, I’ll look at how
OLAP objects are defined and populated.
To define OLAP objects, you don’t need to have installed and licensed the
OLAP Option to the Enterprise Edition of the database. Without this option
installed, […]

Summary tables are often very suitable candidates for partitioning. They are usually date organised and as we generally receive data for a limited range of dates we are able to apply the changes to a subset of partitions of a table. In particular we can get away from the use of merge or delete/insert type […]

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 the […]

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 of Warehouse Builder 10gR2, […]

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 […]