Skip to content

Conversational Query with ChatGPT and Kinetica — A How-to Guide

By Hari Subhash | May 3, 2023

Kinetica is a high-speed analytical database for big data. Its integration with ChatGPT allows you to have a sophisticated analytical conversation with your data in English no matter the scale. This post will show you how to set up and use this integration. Step 1: Launch Kinetica  Kinetica offers a “free forever” managed version with…

Using Window Functions in SQL

By Hari Subhash | April 20, 2023

Window functions allow us to perform calculations on a subset of rows in a table, rather than the entire table. A window function performs a calculation across a set of rows that are related to the current row, based on a specified window of observations. They are used to calculate running totals, ranks, percentiles and…

How to Build Real-Time Location Intelligence Apps

By Hari Subhash | March 3, 2023

Real-time location intelligence is the the art of gathering, analyzing and acting on location-based data as events unfold. It’s valuable for a range of applications such as fleet management, smart cities, detecting threats in our airspace, smart agriculture, proximity marketing, telco network optimization, supply chain management and more. Over the past few years, building real-time…

Unlock Opportunities with Continuously Updated Materialized Views

By Hari Subhash | January 4, 2023

Materialized views are a feature available with many databases to store the results of a frequently executed query so that the same view can be accessed repeatedly without forcing the database to re-execute the query each time. This allows for faster access to the data, as the results of the query do not need to…

Dealing with Extreme Cardinality Joins

By Chad Meley | December 21, 2022

High cardinality data can be more difficult to efficiently analyze because many unique elements increase the computational cost for analysis, and make it more challenging to identify useful insights from the data. Cardinality refers to the number of unique elements in a set. For instance, low cardinality data sets include the names of a few…

In the press

Join us at these upcoming events