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 Can Database Developers do Data Mining ? The original post is available at – Can Database Developers do Data Mining – Here is the main ...
Read MoreIntroduction 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 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 MoreOne 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 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 MoreBook 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 Amazon.co.uk Get it from Amazon.com Generally I found the book useful and I got some ideas that I will apply in one of my next ...
Read More