Comparing Window Function Features by Database Vendors

We will round off the series on window functions with comparison of what database vendors offer. There are various mutations of window functions and every vendor supports a different subset…
Jiří Mauritz September 15, 2017

Big Data News – MapR’s Deep Dive into Apache Drill and Gartner’s Big Data Predictions for 2020

30% of all Enterprises will use intermediaries for big data by 2017 Another week has passed and our big data community has been busy around the world. Some interesting movements in…
Uli Bethke September 4, 2015

Guest Post: Can Database Developers do Data Mining ?

I was recently invited by Sandro Saitta, who runs the Data Mining Research blog (, to write a guest blog post for him. The topic for this guest post was…
Uli Bethke May 11, 2011

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

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…
Uli Bethke November 15, 2009

TIME dimension script Oracle

Uli Bethke October 30, 2009

Date dimension script with Oracle SQL

The script below will create a date dimension in just one SQL statement. We don't use performance-killer nonsense such as cursors, functions etc. We just pick a start date and…
Uli Bethke February 24, 2009