Thursday, April 21st, 2005 by Peter Scott
In a recent blog reply Oracle Sponge Blog Squarepants (sorry David) mentioned not having much success with query rewrite on Materialized Views. Rashly I said I would blog something. These notes relate specifically to Oracle 9.2 in Data Warehouses. You will find changes with Oracle 10
MV creation: there are two ways to create an MV, […]
Monday, April 18th, 2005 by Mark Rittman
Supercharging Star Transformations : "A star transformation is a
methodology used to join tables to greatly improve performance of queries on
dimensional data warehouse schemas. Prior to star transformations, the primary
join methods available were nested loops, merge, and hash joins. Like many
other of the more complex Oracle RDBMS features, star transformations much be
properly configured and tuned to […]
Monday, April 18th, 2005 by Mark Rittman
Tom Kyte, who’ll you’ll probably know through the
AskTom site and the
"Effective Oracle by Design" book, has
started a blog.
Tom’s site is another one of those hosted on
blogger.com that you might not be aware of as the site feed isn’t syndicated on
orablogs.com - I think this is because blogger.com uses
ATOM and orablogs currently only
aggregates RSS […]
Friday, April 15th, 2005 by Peter Scott
One of the medium sized DWH I run is to have all the aggregate summaries rebuilt in few weeks time. The customer is replacing the old mainframe with a new ERP system, and at the same time restructuring their reporting structures and hence asked that we change all of the existing product codes to the […]
Saturday, April 9th, 2005 by Mark Rittman
Alan Alda’s Interviewing Tips for Uncovering Business Requirements :
"Alan Alda is still widely known as "Hawkeye" Pierce from the hit television
series "M*A*S*H" but he’s also the long-time host of the PBS series "Scientific
American Frontiers," in which he interviews research scientists. Discussing his
11-year hosting stint on National Public Radio recently, Alda described his
approach for eliciting […]
Saturday, April 9th, 2005 by Mark Rittman
Tom Kyte :
"In Search of the Truth - Or Correlation Is Not The Same As
Causation"
"… I have two guiding principles with regards to Oracle. One is that every day,
each and every day, I learn something new about Oracle I did not know the day
before. Each and every day. Maybe that is more of a fact […]
Tuesday, April 5th, 2005 by Mark Rittman
Larry’s war: Oracle vs. SAP :
"Ellison’s attack on SAP goes far deeper than
words, as Oracle’s recent acquisitions show. First, Oracle launched a full
assault on joint rival PeopleSoft, which ended in a
$10 billion hostile takeover of the company and one of the largest mergers
ever in the software industry. Oracle quickly followed that up by
arm wrestling SAP […]
Tuesday, April 5th, 2005 by Mark Rittman
It’s been busy, busy, busy around here over the last week with preparations
taking place for our
Oracle Business Intelligence & Reporting Seminar over in Dublin. In the
meantime, if like me
you followed the debate on Don Burleson’s forum on
whether single user
scripts can "prove" Oracle performance you’ll want to read Jonathan Lewis’
subsequent article, "Can
we have a sensible debate?".
