Sunday, February 11th, 2007 by Peter Scott
The other day I was asked about the approach I took to refreshing materialized views. To be honest I use my own techniques – others do similar things.
In a data warehouse summary table very little actually changes; there is perhaps a small window were new data is added, but even allowing for late arriving data [...]
Thursday, February 8th, 2007 by Mark Rittman
I’ve been spending all my spare time recently on the book I’m working on, and so deliberately stayed away from the new Oracle BI Suite Enterprise Edition so that I didn’t get distracted. I’ve got a couple of days free now, and as the new versions of all these bits of software – BI Enterprise [...]
Wednesday, February 7th, 2007 by Peter Scott
Materialized views (mviews) have been part of Oracle for along time, before Oracle 8 they went under the name snapshots and indeed some of the current dictionary tables refer to the old name. Common uses of mviews are to replicate data and to summarise data. It’s this second use I’ll write about here.
Firstly a [...]
Monday, February 5th, 2007 by Peter Scott
Most data warehouses used for reporting and built on conventional database technology such as SQL Server, Oracle and DB2 use some form of summarisation to boost query performance. In principle we doing once in the batch load and refresh process what would need to be done for each query at run time if that [...]
Thursday, February 1st, 2007 by Mark Rittman
Well, this is something I’ve thought about for a while now and now I can mention officially: from March 1st 2007, I’ll be setting up my own company and working as an Independent Consultant, specializing in Oracle Business Intelligence & Data Warehousing solutions. My objective going forward is to provide expert-level consultancy, training, mentoring and [...]
