Tag Archive for 'timeseries database'

Pipe-lining Time Series Calculations for Cache Efficiency

I always like to investigate new technology and this week I found a nice automatic technique for improved cache use that I had previously seen some people manually write. Consider a database query with three steps (three SQL SELECTs), some databases may pass results of each step to temporary tables in main memory. When the […]

Kdb qSQL vs standard SQL queries

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 Kdbs column-oriented architecture). Another reason is that qSQL is extremely expressive and well suited for time-series […]