Kinetica in Motion
Using Window Functions in SQL
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 …
Read MoreHow to Build Real-Time Location Intelligence Apps
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, …
Read MoreUnlock Opportunities with Continuously Updated Materialized Views
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 …
Read MoreDealing with Extreme Cardinality Joins
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 …
Read MoreDo you need a streaming database?
Streaming databases are close cousins to time-series databases (think TimescaleDB) or log databases (think Splunk). All are designed to track a series of events and enable queries that can search and produce statistical profiles of blocks of time …
Read MoreWhat to look for in a database for spatio-temporal analysis?
As sensor data, log data and streaming data continues to grow, we are seeing a significant increase in demand for tools that can do spatial and time-series analytics. The cost of sensors and devices capable of broadcasting their longitude …
Read MoreDrinking from the “Data Fire Hose”
A data firehose, or a data stream, is a continuous, high-volume flow of data that is produced by a data source. Common data firehoses include social media feeds, financial market data, and transponder data. High volume data streams are found …
Read MoreKinetica 7.1.7 updates 🚀
Highlights Kinetica Workbench web interface for developing and collaborating with interactive SQL workbooks JDBC ingress and egress Import and export data to/from other data sources and enterprise applications Reveal filter slice allows additional map layers to be used for filtering …
Read MoreGet the most from a Distributed Analytics Database
Kinetica is one of the fastest distributed analytics databases in the world. Its vectorized compute engine can perform complex analytical tasks at scale in real-time. But speed and performance are useless if you don’t get the basics of a …
Read MoreOptimizing Longer Routes for Electric Vehicles needing Charging Stations
Electric vehicles (EVs) have increased ten-fold over the last two years. And it is estimated that the market share of EVs will increase to more than 50 percent of the passenger car market in the US by 2030. But one …
Read More