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