Guest Post: Can Database Developers do Data Mining ?

Uli Bethke Best Practice, Business Intelligence, data mining, Data Warehouse, DW Design, ETL, Irish BI SIG, Oracle, SQL for Analysis, Training

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 body of the post Over ...

Introduction to star schemas and dimensional modeling concepts.

Uli Bethke Data Warehousing Books, Dimensional Modeling, DW Design

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 of dimensional models by a ...

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

Uli Bethke DW Design, ETL, Oracle

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 SQL statement. As a result ...

Book Review: Inmon - DW 2.0. The Architecture for the next Generation of Data Warehousing

Uli Bethke DW Design

Get it from Amazon.co.uk Get it from Amazon.com First of all, this book is not written with the DW novice in mind. Some of the chapters require a thorough understanding of DW theory and concepts. Generally I found the book useful and I got some ideas that I will apply in one of my next projects. The biggest weakness of ...