A comparison of Python and q for data analysis
21 Aug 2018
Guest blogger Ferenc Bodon illustrates using Python, SQL and kdb+ for data analytics in this blog. He takes an example that goes just one step beyond the simplest use cases by performing some aggregation based on multiple columns. Anybody who analyzes data tables will bump into this type of problem, probably on the third day.
Research in kdb+/q: AQuery
29 Sep 2016
Dr. Dennis Shasha, of the Courant Institute of Mathematical Sciences at NYU, and José Pablo Cambronero, a PhD student at MIT, recently presented the results of their research on AQuery and q/kdb+ at the latest Kx Community NYC Meetup. AQuery is a simple extension to SQL that makes joins, moving averages, correlations, and other such
Reprise of SQL article by Joe Celko and Arthur Whitney
8 Jul 2015
We are surprised and pleased by the resurgence of interest on social media this week in an article written by Joe Celko and Arthur Whitney in 2002.
kdb+ query scaling
21 Apr 2014
kdb+ is a powerful tool for extracting information from increasingly large amounts of timeseries data and Ian examines some of the key steps which can be taken to ensure optimal efficiency of queries being run against large kdb+ databases.
How a 20-line program to solve sudokus came about
1 Apr 2014
I wrote a 20-line program in K to solve all sudokus. Later, I sent it to Arthur Whitney and he came back with an 80-character program.
kdb qSQL vs standard SQL queries
30 Mar 2014
kdb is really fast at typical financial time-series queries.