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