Monday, May 30th, 2005 by Mark Rittman
Well that’s it for the rest of the week for me. I’m off up to Manchester for
Jonathan Lewis’ "Optimising
Oracle, Performance By Design" seminar for the next three days, and as no
doubt I’ll be back in the hotel each evening trying out some of Jonathan’s ideas
on the laptop I’m definitely leaving the blog alone for the […]
Monday, May 30th, 2005 by Mark Rittman
Another one of our clients is looking to put some hardware in place for a new
data warehousing project. The two hardware options are:
Buy a single, large Unix server (probably a HP box running HP-UX) with 8
CPUs
Buy two or more commodity "Lintel" boxes, with 2 or 4 processors,
running Red Hat Advanced Server, and use RAC to […]
Sunday, May 29th, 2005 by Mark Rittman
One of the most powerful features of the multidimensional engine behind analytic workspaces is the ability to create formulas. Formulas, or “calculated measures” as they’re referred to in AWM10g, are measures that are derived from other measures. Using AWM, you can create simple formulas that reference other measures in a cube, […]
Sunday, May 29th, 2005 by Mark Rittman
One of the most powerful features of the multidimensional engine behind
analytic workspaces is the ability to create formulas. Formulas, or "calculated
measures" as they’re referred to in AWM10g, are measures that are derived from
other measures. Using AWM, you can create simple formulas that reference other
measures in a cube, allowing you for example to create a "margin" […]
Sunday, May 29th, 2005 by Mark Rittman
"Scott Berkun, Smart People, Bad Ideas" : "Scott Berkun, former Microsoftie,
just got
slashdotted with an essay about
"Why smart people defend
bad ideas". It’s a very interesting essay. I’m not crazy about his examples,
but his portrayal of the bad-idea-defender is dead on: "Until they come face
to face with someone who is tenacious enough to dissect their logic, […]
Saturday, May 28th, 2005 by Peter Scott
In a data warehouse there are typically two ‘chunks’ of data – the public stuff (such as reference or dimensional data, raw fact data, and the aggregated fact data.) The other chunk is the ‘backroom’ layer that is used to build the public side of the warehouse.
For me, the backroom deals with ETL - applying […]
Saturday, May 28th, 2005 by Mark Rittman
One of the customers I work with is looking to us for advice on how to set
their data warehousing database up. They’re looking to use the Enterprise
Edition of the latest Oracle version (10.1.0.4) and are planning on using Oracle
Warehouse Builder 10g as the ETL tool. Each environment (dev, test, prod) will
have two database instances, one […]
Saturday, May 28th, 2005 by Mark Rittman
I’ve
been meaning to post a plug for this one for a while.
"Oracle 10g Data Warehousing" by Susan Hillson, Shilpa Lawande, Pete Smith
and Lilian Hobbs came out a while ago and is the update to the 9iR2 Data
Warehousing book that I talked about on my Books page. Although the 9iR2 book
was good, I thought it was […]
Saturday, May 28th, 2005 by Mark Rittman
Another new batch of Oracle blogs:
Jeff Hunter (not to be confused with Jeffrey Hunter),
Robert Vollman, Frank van Bortel and
Peter K.
Niall’s site has also
just gone through a bit of a redesign (and spurred on by Tom’s comments it’s
updated a bit more frequently now :-)) and if you’ve not seen them before, make
sure you check out […]
Thursday, May 26th, 2005 by Mark Rittman
It’s been a pretty hectic couple of weeks recently, with trips over to
Ireland, down to Swindon and a couple of times up to London to work with clients
and do a couple of presentations. I’ve had a lot of "dead time" where I couldn’t
really do any Oracle work or update the blog, but it’s been a […]
