Recent Articles

All Data Marketplace Flexter FlowHigh JSON Snowflake XML
Data Warehouse,

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,

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
Best Practice,

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…
Uli Bethke May 11, 2011
analytic functions,

Comparative Window Functions: Proposed Extensions to Analytic Functions

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…
Uli Bethke November 16, 2009
analytic functions,

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
Books,

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

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