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.
SQL and the Problem with Time Series
1 Jul 2002
SQL isn’t keeping pace with the demand to quickly analyze large amounts of data by Joe Celko and Arthur Whitney (July 1, 2002) • Inside Market Data Vol 17 No 39 • July 1, 2002 (New York – London) “Time is what keeps everything from happening all at once.” —George Carlin In the real world,