Saturday, May 21st, 2005 by Mark Rittman
I’m working over in Ireland at the moment, and staying over in Dublin for the weekend, hence the lack of updates to the website this week. In the meantime, if you’re coming to the UKOUG BIRT SIG meeting in London next week we’ve managed to sell out again, and this time we’re in a bigger […]
Thursday, May 19th, 2005 by Peter Scott
A little while back I posted a piece on how I got into databases in general and data warehouses in particular. One reader asked if I could reveal how to start out in data warehousing. Rather than posting a direct reply to the question, I thought that I would write it as a new post […]
Thursday, May 19th, 2005 by Peter Scott
One of our customers uses Oracle materialized views and query rewrite as the key component of their summarisation strategy. The front-end query tool is Business Objects (or rather its web version) The great thing about rewrite is that the BO universe designer only needed to include the base level summaries (for stock, sales etc) and […]
Tuesday, May 17th, 2005 by Peter Scott
Rang the user who created last week’s query from hell… he still needed to find that mystery transaction. It turns out the police were investigating a credit card fraud and knew the amount but no other details (strange they did not know the date (even to the nearest month would help) or store, but hey).
So […]
Saturday, May 14th, 2005 by Peter Scott
One of the things I do on the DWHs I manage is to periodically review the nature of queries being run so that we can come up with performance improvement plans. When a data warehouse is put in the designer (me) guesses the aggregates and indexes that will be needed to give the required performance, […]
Saturday, May 14th, 2005 by Peter Scott
Working for an IT services company I tend to get quite a bit of variety in the work that passes my way. Although (for me) it is always data warehouses, the works ranges from completely new systems, through data warehouse migrations, enhancements, to steady-state maintenance and performance tuning. This week my team started work on […]
Saturday, May 14th, 2005 by Mark Rittman
Michael Armstrong-Smith, author of the
forthcoming Oracle
Discoverer 10g book and a regular
OTN Discoverer
Forum contributor, recently posted the
slides and
white paper from his IOUG Live! 2005 session on the
learndiscoverer.com
website. One interesting concept that Michael has come up with for these presentations is that of a
"Discoverer Library".
Michael explained how this worked in a
recent OTN Discoverer Forum posting :
"The […]
Friday, May 13th, 2005 by Mark Rittman
Oracle works quietly with Mozilla : "Oracle and the Mozilla Foundation
are keeping a joint venture under wraps, leading to speculation that the
database giant may by planning to release an open-source product.
The Mozilla Foundation revealed in February at the Free and Open Source
Developers’ European Meeting (FOSDEM) that the database giant had hired three
people to work on […]
Friday, May 13th, 2005 by Mark Rittman
The customer is not
always right : "First, though, I’m posting the longest comic I’ve ever
drawn - practically a graphic novel by my own standards - illustrating why the
customer is not always right. This is an old adage which I think goes back to a
time when it was your job to let the customer dictate terms […]
Friday, May 13th, 2005 by Mark Rittman
"I have a question about drilling from an OracleBI Discoverer for OLAP
10.1.2 worksheet to a Discoverer Plus Relational worksheet. When you pass
values from an OLAP worksheet you pass either the dimension name or the
dimension value to the associated parameter in the relational worksheet.
Obviously, in OLAP this dimension is treated as an object, and we have […]
