Why Has Data Mining Struggled So Much?

Uli Bethke November 20, 2009

Bill Inmon has recently posted an article on “Why has Data Mining struggled so much?” The article discusses 7 diferent reasons why data mining has struggled, as it has been around for a very long time. The main points are1. We have been waiting a long time for it to become available in a usable ...

Read More

Data Warehousing Books: Design and architecture

Uli Bethke October 31, 2009

In another post I have covered data warehousing books in the world of Oracle. We’ve also had a look at data warehousing and business intelligence books for project management and business analysis. Today we will look at data warehousing and business intelligence books that look at the technical design and architecture of a data warehouse solution. Must ...

Read More

TIME dimension script Oracle

Uli Bethke October 30, 2009

SELECT n AS time_id, TO_CHAR(to_date(n,'SSSSS'),'HH24') AS hour, TO_CHAR(to_date(n,'SSSSS'),'MI') AS minute, TO_CHAR(to_date(n,'SSSSS'),'SS') AS second FROM ( SELECT level-1 n FROM DUAL CONNECT BY LEVEL <= 86400 ) 123456789101112 SELECT   n AS time_id,   TO_CHAR(to_date(n,'SSSSS'),'HH24') AS hour,   TO_CHAR(to_date(n,'SSSSS'),'MI') AS minute,   TO_CHAR(to_date(n,'SSSSS'),'SS') AS secondFROM (   SELECT      level-1 n   FROM      DUAL   CONNECT BY LEVEL <= 86400)

Read More

Data warehousing for free! Terabyte sized data warehouse and business intelligence without license costs

Uli Bethke October 26, 2009

Greenplum This is no joke. Greenplum on 19 October announced a free single node edition of its analytical database. For those of you who haven’t heard about Greenplum, they are a provider of an MPP database software that runs on commodity hardware (unlike some its competitors such as Teradata, Netezza, or recently Oracle with Exadata). ...

Read More
1 8 9 10