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