Update, Awards and Articles

Wednesday, November 30th, 2005 by Mark Rittman

Time for a quick update.
If you read my posting a couple of weeks ago, you’ll have seen that I’ve been
working away on a few articles recently, hence the lack of updates. It’s all a
bit embarrasing actually as the Oracle Magazine ACE of the Year 2005 article was
recently published, and I also just got an email […]

Modelling from JDeveloper

Monday, November 21st, 2005 by Peter Scott

In a few idle moments I downloaded the CWD4ALL extension to JDeveloper – I guess it is the developer in me that wants to give modelling tools a trial and as the vendor web page mentioned words and phrases such as OLAP, multi-dimensional modelling and Oracle Analytical Workspaces. I thought I would give it a […]

More design

Monday, November 14th, 2005 by Peter Scott

The other day I had a rant about poor (in my opinion) DW design, and in particular not using the database features to the best advantage (or at all). Sometimes, though, people use the wrong features.
Database links can be a marvellous feature when used the right way (it can move data efficiently between databases, for […]

What I’m Working On

Sunday, November 13th, 2005 by Mark Rittman

If you’re a regular reader of this blog you’ll probably have noticed that the
frequency of postings has gone down a little over the last few months, part of
this is due to our second child coming along, but it’s also because I’ve been
working on some more in-depth articles that should surface over the next few
months. If […]

Oracle OLAP Tips and Oracle BI 10g Product Demos

Saturday, November 12th, 2005 by Mark Rittman

I’ve been over in Ireland for the last week, and in the evenings working on a new article for OTN on data profiling using OWB “Paris”, so I’ve not had a chance to update the blog since the UKOUG conference. In the meantime though, here’s a couple of Oracle OLAP tips that […]

Oracle OLAP Tips and Oracle BI 10g Product Demos

Saturday, November 12th, 2005 by Mark Rittman

I’ve been over in Ireland for the last week, and in the evenings working on a
new article for OTN on data profiling using OWB "Paris", so I’ve not had a
chance to update the blog since the UKOUG conference. In the meantime though,
here’s a couple of Oracle OLAP tips that I picked up during the week.
The […]

Odds and Ends

Saturday, November 12th, 2005 by Mark Rittman

A few bookmarked articles that I’ve been meaning to clear out for a while.

A nice article from Lucas Jellema on
using
DBMS_FREQUENT_ITEMSET for PL/SQL data mining
Intelligent Enterprise with a

sneak peek to Cognos 8, which features (like Discoverer Drake)
integrated relational and OLAP reporting.
"Ever download a framework and feel overwhelmed? Maybe there is a way
around that." asks Michael Feathers […]

Design matters

Monday, November 7th, 2005 by Peter Scott

One of our customers has asked us to review the performance of one of their legacy data warehouses. The daily data load takes far too long. There seems to be a lot we can suggest here to improve things - for a start, we need move to an incremental load and not the complete reload […]

UKOUG Conference 2005 : Day 3

Wednesday, November 2nd, 2005 by Mark Rittman

Back from the UKOUG Conference now, just thought I’d jot some final thoughts
down on the four days. Unlike Open World, I’ve actually had a job to do over the
past three days so I’ve not had much of chance to post anything except photos,
but here’s my thoughts on what I saw.
Unlike Open World, the UKOUG isn’t […]

UKOUG Conference 2005 : Day 2

Tuesday, November 1st, 2005 by Mark Rittman

Today was the day for Tom Kyte’s keynote and from
reading his blog
just before the presentation, I had an inkling that a few of us last night were
in for a bit of a ribbing. Little did I know …

See also
here,
here,
here and
here. It
turns out that Tom’s keynote was due to be about the new Express edition of
Oracle […]