TorQ-Air is an application built on the TorQ framework that allows us to capture data through the Lufthansa developer API and perform both real-time and historical analytics on flight data. The solution includes a front-end built on Kx-dashboards, showing a number of real-time and historical stats. Download and installation instructions can be found on the TorQ-Air github repo. Founded in …
TorQ in 2020
2020 was a strange year for most of us. We’ve used it as an excuse to put a lot of work into extending TorQ- here’s a brief recap of some highlights. The first large contribution in 2020 was to provide the option of integrating Datadog into TorQ. Datadog is an extremely useful application monitoring service capable of tracking anything from …
TorQ Segmented Tickerplant
Our most recent project here at AquaQ Analytics has been an extension of the TorQ production framework. In particular, a new segmented tickerplant process (STP) has been incorporated into TorQ which will provide greater flexibility to the user whilst also preserving the functionality of the original tickerplant process. This blog post will revisit the role of the tickerplant in TorQ, show the new features that a segmented tickerplant provides and highlight the advantages …
TorQ-Crypto Released
Today we are excited to release our new TorQ-Crypto package! For those of you that have used TorQ, you will most likely be familiar with the TorQ Finance Starter Pack. TorQ-Crypto behaves in a similar manner to the starter pack and provides an example of how an application can be built and deployed on top of the TorQ framework. The …
TorQ DQS
We are delighted to announce the release of the Data Quality System to TorQ, our kdb+ framework. The system allows developers to easily set up customizable checks on the quality of data within their database system. Motivation TorQ already has monitoring tools provided, but previously they were mainly used to monitor the health of individual processes. Checks would be performed …
kdb+ IoT Database Structure
When implementing a kdb+ database the partitioning structure is a key decision point. kdb+ provides four in-built ways to partition database tables: by year, month, date or integer. Only one partitioning scheme may be used. The best option is usually based on two factors: how data arrives how it is accessed The partitioning scheme should facilitate easy addition of data …
The Road So Far (TorQ RM 2018)
With 2018 well and truly underway, our development team has set off on a journey along the 2018 TorQ Roadmap. We previously posted a compilation of requested features and desired improvements for our TorQ framework, which has provided us with a range of mini-projects to take on. We are keen on receiving prioritisation requests, if a feature on the roadmap …
As You Bike It: Mapping Belfast Bike Usage
We recently noted the ability to use our TorQ package to collect data on our local Belfast Bikes transport network. So how does our cycle network look after collecting for a while? We recorded data on the status of each station in the network for 6 months, and we can now use this data to observe how the population of …
TorQ 2018 Roadmap
Below is our current TorQ roadmap for 2018. We welcome any additional suggestions, or prioritisation requests. Data Manipulation Library The point here is to produce a set of utilities useful for analysing and manipulating datasets. The target audience is new kdb+ developers or business users. Visualisation products (e.g. Panopticon) are probably good target applications as it is useful to pivot, …