Comparing Window Function Features by Database Vendors

Jiří Mauritz September 15, 2017

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 or feature. Some also add extra window functions or features beyond standard ANSI SQL. One of the most powerful features is user-defined aggregate functions (UDAF), ...

Read More

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

Uli Bethke September 4, 2015

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 our industry has arisen with Doug Laney on Forbes making three predictions on the advancement of big data to 2020, including the rise of 3rd ...

Read More

Guest Post: Can Database Developers do Data Mining ?

Uli Bethke May 11, 2011

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 Can Database Developers do Data Mining ? The original post is available at – Can Database Developers do Data Mining – Here is the main ...

Read More

Comparative Window Functions: Proposed Extensions to Analytic Functions

Uli Bethke November 16, 2009

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 ...

Read More
1 2 3