Recent Articles

All Data Marketplace Flexter FlowHigh JSON Snowflake XML
Best Practice,

Guest Post: Can Database Developers do Data Mining ?

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…
Uli Bethke May 11, 2011
Data Warehousing Books,

Introduction to star schemas and dimensional modeling concepts.

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…
Uli Bethke October 16, 2010
DW Design,

One pass SCD2 load: How to load a Slowly Changing Dimension Type 2 with one SQL Merge statement in 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…
Uli Bethke February 1, 2009
DW Design,

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

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. Get it from…
Uli Bethke August 9, 2008