Rittman Mead - Delivered Intelligence

Neil Raden, who’s article on
Model-Driven Approaches
For BI Projects I linked to last year, dropped me a line to tell me about
some new real-time ETL articles he’d written:

"Mark,
I’ve written some articles and white papers about real-time data
warehousing:

http://ww.hiredbrains.com/knowout.html
…but I think the really interesting part of it is not data warehousing,
per se, but abstraction and real-time analytics. Abstraction [...]

A number of clients I’ve worked with recently have been looking to implement OracleBI Discoverer 10.1.2 for OLAP as their general ad-hoc query tool. Whether running against relational OLAP data or data in analytic workspace, Discoverer for OLAP comes with a slick new interface, an OLAP-aware query builder and works against a logical dimensional model [...]

A number of clients I’ve worked with recently have been looking to implement
OracleBI Discoverer 10.1.2 for OLAP as their general ad-hoc query tool. Whether
running against relational OLAP data or data in analytic workspace, Discoverer
for OLAP comes with a slick new interface, an OLAP-aware query builder and works
against a logical dimensional model that mirrors the way [...]

Oracle Rebrands Middleware As Fusion :
"Oracle is slapping a new "Fusion" moniker on its array of middleware and
development tools. "Oracle Fusion Middleware" to be formally announced Monday,
will be the umbrella brand for some 32 products including Oracle’s J2EE server,
portal, data integration, application development, business intelligence,
identity management, and collaboration offerings, said Rick Schultz, vice
president of product [...]

So, you have got those MV in place and now need to keep them up to date, well there are three options: do-it-yourself, Complete refresh and ‘Fast‘ refresh. To me, fast is not the right name, as under the covers all of the rows affected by data change are updated, this can be quick or [...]