Rittman Mead - Delivered Intelligence

If you’re a UKOUG member you should get a copy of Oracle Scene every few months. The bit I always turn to first when the magazine arrives is Mogens N rgaard’s column at the back, which usually has something to rub Oracle up the wrong way such as Oracle […]

If you’re a UKOUG member you should get a copy of Oracle Scene every few
months. The bit I always turn to first when the magazine arrives is Mogens
N rgaard’s column at the back, which usually has something to rub Oracle up the
wrong way such as
Oracle
being a legacy technology, his
colleague’s
view on Oracle Application Server […]

Several months ago a reader contacted me about about a new data warehousing
technology he’d come across:

"Mark,
I have been reading a quite enthralling document (sounds nerdy I know),
about how to actually achieve ROI on Data Warehousing.
The article is

http://www.it-director.com/research.php?productid=748.
Its done by Bloor, and to be honest is really pitching you to use SAP. I’m
not going to go […]

I worked with a client recently who needed to parse a comma-delimited string
as part of an OWB mapping. The mapping contained a source table, which we’ll
call STAFF_TEAMS

SQL> create table staff_teams (
2 staff_id number,
3 team_members varchar2(255));

Table created.

which contained a field, TEAM_MEMBERS, which contained a comma-delimited list
of team members who reported […]

In a previous post I asserted that range partitioning on date was commonly used in data warehouses. Date partitioning can simplify the 'retiring' of old data, make the fact load more efficient and improve the performance of user queries (after all, most users will include some form of date predicate in their queries). One point […]

Right, I’ve been meaning to post this to the blog for a couple of weeks now
but I keep getting sidetracked. If you followed the debate around my
Incremental Load
Improvements in Oracle OLAP 10gR2 posting a couple of months ago you’ll be
interested in a follow-up Scott Powell did on the OTN OLAP Forum.
Basically neither of us […]

After the flurry of articles around Open World, it’s been pretty quiet around
here for the past two weeks. Usually a lack of postings on the blog equates to
very busy at work, and now I’m back I’ve been working away from home and trying
to do some prep for the UKOUG Conference
during the evenings. If you’re a […]

No, not a threat from a bunch of gangsters, but a reminder about a, perhaps, under used Oracle feature in data warehousing
A little while back Mark Rittman reminded me of a piece he wrote on GIS enabling a data warehouse. People may think “Spatial, extra feature, extra license, extra cost”. But this may not […]

For one of my DW customers we adopted a materialized view-based aggregation strategy. Only the base level summaries are exposed to the query tool and the Oracle database uses query rewrite to select the ‘best fit’ aggregation. This was the customers first use of query rewrite, their previous DW had all of the summary tables […]