Guest Post: Can Database Developers do Data Mining ?

Uli Bethke May 11, 2011

I was recently invited by Sandro Saitta, who runs the Data Mining Research blog (http://www.dataminingblog.com/), to write a guest blog post for him. The topic for this guest post was Can Database Developers do Data Mining ? The original post is available at – Can Database Developers do Data Mining – Here is the main ...

Read More

Introduction to star schemas and dimensional modeling concepts.

Uli Bethke October 16, 2010

I recently came across two excellent papers that give an introduction to star schemas and dimensional modeling. The two papers have a unique anlgle in that they apply a rule based approach to transform transactional ER models to dimensional models. In the words of the authors: “An ER model can be transformed into a set ...

Read More

One pass SCD2 load: How to load a Slowly Changing Dimension Type 2 with one SQL Merge statement in Oracle

Uli Bethke February 1, 2009

The other day I came across a useful new feature in the Merge statement for SQL Server 2008. This new feature outputs merged rows for further processing, something which up until now (Oracle 11.1.0.7) is not possible in Oracle. This extra functionality can be used to load a Slowly Changing Dimension Type 2 in one ...

Read More