Time & Space Analytics
at Speed, at Scale
For Advanced Time-Series and Geospatial Analytics
Spatio-temporal data requires new capabilities to join, analyze, and visualize in order to extract value.
Time-Series & Spatial Functions
Spatial Funtions »
Server Side Visualizations
Window Functions »
Low Latency Spatio-temporal Joins
How do you combine data from multiple tables when the timestamps don't exactly match?
Kinetica's ASOF joins make it easy to set an interval within which to combine data on values that are close to each other. This makes it easier to understand what's happening even when there aren't exact matches on timestamps from the two tables. You can use inexact joins for location, to connect tables where objects are within a specified distance of another.
Geo joins enable you to fuse two or more datasets based on spatial matching conditions. Most sensors and IoT devices record location as a set of longitude and latitude pairs. Modern sensor analysis often requires this point based location stream to be enriched with datasets that might represent information using other types of spatial geometries like polygons and lines. Geo joins make this easy to do.
In-Database Functions for Time-Series & Spatial Analysis
Time Series Functions
Kinetica supports windowing which allows you to apply aggregate and ranking functions over a period of time, and keep the picture updated as data evolves.
Work with timestamps and dates with ease. Kinetica includes base date/time functions along with tools for more complex date-time conversions.
Kinetica natively works with points and shapes as WKT. Tracks can be generated from sequential data to represent paths objects take as they move.
Over 130 OGC high-performance geospatial functions are available with SQL or using the REST API. Functions include tools to filter, compare or aggregate data by area, by track, or custom shape. Kinetica's network graph functionality enables you to model location data as graphs, and then solve routing and other questions with a selection of in-built graph solvers
See Spatial Funtions and Kinetica Graph
One of the core challenges with displaying spatial information is moving data from the database layer to the visualization layer. Serializing and moving millions to billions of objects from one technology to another takes time.
Kinetica is able to solve this bottleneck by generating geospatial tiles directly on the server through a Web Mapping Service (WMS). WMS tiles can be used as overlays on top of a map with applications such as ESRI and Mapbox, Leaflet and others.
ESRI & Kinetica »
Web Mapping Service »
Billions of Points...
Display unlimited points on a map with interactice query. While noisy, this provides a unique means to explore volumes of data that is not possible when generated by the front-end alone.
Heatmaps take the noise out of large datasets to show patterns and nodes of maximum usage. Hatmaps generated in-database are another efficient.
Isolines represent curves of equal cost, with cost often referring to the time or distance from a starting point. Isochrones work with Kinetica's Graph functionality to visualize distances.
A class break rendering enables you to take data from one or more tables and apply styling on a per-class basis.
Leverage graphs for optimal routes or for network planning
Kinetica's graph API enables you to model spatial data as graphs. Then solve difficult questions using SQL queries, or with in-built graph solvers. Outputs from solvers can be piped directly to maps.
Connect to your choice of tools
Kinetica plays well with a wide variety of BI and GIS tools. Or you can work with data through Kinetica Workbench and Kinetica Reveal.
BI & Observability Tools
With Kinetica's implementation of the Postgres Wireline protocol, popular observability and BI tools including Grafana, Prometheus, Datadog, Lookr and others can monitor and integrate directly with Kinetica.Posgtres Wireline »
Data in Kinetica can be made available to ArcGIS Insights through ArcGIS JDBC connector and through the ArcGIS Python API, and visualizations passed back through WMS tiles. This enables ArcGIS to be used with streaming location data at scale.ESRI Integration »
Kinetica's native extension for Tableau allows for geospatial processing to be done in-database with visulizations delivered back to Tableau through the WMS endpoint.
Tableau Connector »
Kinetica Reveal - Native BI Framework
Kinetica comes with Reveal — a web-based BI framework that makes it quick and easy to start exploring geospatial data. Reveal also connects with Kinetica's geospatial pipeline for advanced mapping and interactive location-based analytics.
Kinetica Workbench is a sophisticated, yet intuitive interface, to interactively explore data, organize and store SQL workbooks, import and export data streams, and for general database administration.