Rollups with an arbitrary tree hierarchy

15 Mar 2015 | , ,
Share on:

Steve Wirts, an expert kdb+ developer at OpenFin, recently presented his latest innovation to OpenFin’s Hypergrid/Q project at a Google Developer Group Meetup. It’s a version that allows you to do rollups with an arbitrary tree hierarchy. You can read a little more about it if you scroll down here.

Since then, Steve has a continued to work on Hypergrid/Q:

The latest example is a million row grid with 20 columns, rollups using sum/max/min/first/avg, and sub second updates. It has 2 q servers, 1 for computation and 1 for caching the results so Hypergrid is never blocked.

Screenshot of the app

Also, it now has a dnd interface for selecting the hierarchy/hidden/visible columns.

dnd interface screenshot

SUGGESTED ARTICLES

Kx Product Insights: Inter-Trading Alert

5 Dec 2018 | , , ,

by Aidan O’Neill Kx has a broad list of products and solutions built on the time-series database platform kdb+ that capitalize on its high-performance capabilities when analyzing very large datasets. Kx for Surveillance is a robust platform widely used by financial institutions for monitoring trades for regulatory compliance. The Surveillance platform instantly detects known trading […]

Kx extends relationship with NASA Frontier Development Lab and the SETI Institute

The Exploration of Space Weather at NASA FDL with kdb+

4 Dec 2018 | , , , ,

Our society is dependent on GNSS services for navigation in everyday life, so it is critically important to know when signal disruptions might occur. Physical models have struggled to predict astronomic scintillation events. One method for making predictions is to use machine learning (ML) techniques. This article describes how kdb+ and embedPy were used in the ML application.

kdb+ on Google Cloud

Running kdb+ on Google Cloud (GCP)

8 Nov 2018 | , ,

By Himanshu Gupta Our guest blogger, Himanshu Gupta, is an expert kdb+ programmer who frequently writes about kdb+/q, as well as other technologies on his blog, enlist q, where this post originally appeared. In this latest article Himanshu gives a tutorial on using kdb+ on the Google Cloud. Check out enlist q, and subscribe while you […]