Download Mogens Norgard’s Oracle Scene Articles

Sunday, October 16th, 2005 by Mark Rittman

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

Download Mogens N?rd’s Oracle Scene Articles

Sunday, October 16th, 2005 by Mark Rittman

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

SAND, Sybase IQ and Column-Based Databases

Sunday, October 16th, 2005 by Mark Rittman

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

String Parsing, Table Functions and OWB10gR1

Friday, October 14th, 2005 by Mark Rittman

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

Partitioning revisited

Wednesday, October 12th, 2005 by Peter Scott

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

Oracle OLAP 10gR2 Incremental Load Improvements : The Mystery Solved

Wednesday, October 12th, 2005 by Mark Rittman

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

Bits and Bobs and the Hotsos Symposium

Sunday, October 9th, 2005 by Mark Rittman

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

We know where you live

Thursday, October 6th, 2005 by Peter Scott

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

Materialized view usage

Wednesday, October 5th, 2005 by Peter Scott

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