kdb qSQL vs standard SQL queries

30 Mar 2014 | , ,
Share on:


Often at the start of one of our training courses I’m asked why banks use the kdb Database for their tick data.

One well known reason is that kdb is really fast at typical financial time-series queries (due to kdb’s column-oriented architecture). Another reason is that qSQL is extremely expressive and well suited for time-series queries.

To demonstrate this I’d like to look at three example queries, comparing qSQL to standard SQL.


By Ryan Hamilton


Kdb+ Transitive Comparisons

6 Jun 2018 | ,

By Hugh Hyndman, Director, Industrial IoT Solutions. A direct comparison of the performance of kdb+ against InfluxData and, by transitivity, against Cassandra, ElasticSearch, MongoDB, and OpenTSDB

Kx provides rapid access to unstructured data

Insights into kdb+ 3.6

5 Jun 2018 | , ,

At Kx25, the international kdb+ user group conference held on May 18th, we released kdb+ version 3.6. With this release, we are opening up new possibilities for kdb+ application developers.
It provides a lot of new capabilities and streamlines previously complex processes so that programmers will be able to take a simpler approach to writing systems compared to what they did in the past.