Rittman Mead - Delivered Intelligence

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

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

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

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

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