Why Has Data Mining Struggled So Much?

Uli Bethke Business Intelligence, data mining, Data Warehouse, Oracle

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 are 1. We have been waiting a long time for it to become available in a usable way 2. Data mining ...

ODI snippets: Purge Log and shrink space

Uli Bethke Oracle, Oracle Data Integrator (ODI)

We all know that we should purge the ODI log on a regular basis. if we log everything or if we run near real time batches. You can either purge the log manually from the Operator module or you can use the ODIPurgeLog tool. As per Metalink 424663.1 the following tables contain information concerning Session runtime executions

When you ...

Comparative Window Functions: Proposed Extensions to Analytic Functions

Uli Bethke analytic functions, Oracle, SQL for Analysis

I promise that this will be the last post on analytic functions this month; but I came across this proposal to extend analytic functions with a comparative window function on Tom Kyte's blog yesterday (also make sure to review the actual paper). Basically this new type of analytic function would allow you to compare the current row in a window ...

SQL quiz revisited: ROW_NUMBER, LAST_VALUE, FIRST_VALUE and the SQL knights value problem.

Uli Bethke analytic functions, Oracle, SQL for Analysis

Thank you all for your entries to the recent quiz. The guys from Packt should be shortly sending out the e-books to the winners. Today I will walk you through some of the possible solutions and also briefly touch upon performance of these. Last week's contest was based on a classic SQL problem. Anthony Molinaro, the author of the SQL ...

SQL Quiz: Win two e-books (Essbase & BPEL)

Uli Bethke Books, Oracle, SQL for Analysis

We'll do something completely different today and have a quiz. And you can even win something. Thanks to the guys at Packt Publishing I have two e-books to giveaway. Oracle Essbase 9 Implementation Guide and Business Process Execution Language for Web Services When you visit their website make sure to have a look at their free section. They are always ...