José Cambronero & Dennis Shasha present q/kdb+ research

Research in kdb+/q: AQuery

29 Sep 2016 | , , ,
Share on:

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 operations, fast on terabyte-scale data. AQuery unifies the declarative syntax of SQL 92 with the addition of an ASSUMING ORDER clause, moving aggregates, flatten etc to achieve the semantics of kdb+. The system includes an optimizer. AQuery compiles to q.

There are two aspects of this project that Dennis and José presented: (i) AQuery, the language and the optimizer; and (ii) using q/kdb+ as the execution engine for new languages. They provided a series of helpful dos and don’ts.

Check out the video on the Kx Systems’ Youtube channel [here].

SUGGESTED ARTICLES

Kx Partner Companies Recognized for Excellence and Innovation

26 Jan 2018 | , , , , , , , ,

Over the last few months a number of startups using Kx technology have been recognized for excellence and innovation in their industries, including BrainWaveBank, 3DEO and RxDataScience (RxDS).
RxDS, is at the forefront of new types of interactive data science software applications for the pharmaceutical and healthcare industries. It uses Kx technology to power the Big Data analytics engine in its apps. Silicon Review noted RxDS’ rapid growth in revenue and customer acquisition in naming RxDS as one of the 30 Fastest Growing Private Companies to Watch.