It’s a mater of integrity

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

Getting To The Bottom Of NOLOGGING, NOARCHIVELOG and Standby Databases

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

“Oracle 10g Data Warehousing”

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

Another Batch Of New Oracle Blogs

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

On Books, End-User Presentations and ASBOs

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

Website Design & Build: tymedia.co.uk