EssentialNET at vTechUG Cardiff - July 16th 2020 - Cohosted with Vertica

vTechUG Cardiff is the South Wales virtual community event for IT Ops, Infrastructure, Cloud, DevOps & CyberSecurity Professionals. TechUG is completely independent and guided by a group of local committee members who help create a great community experience.

EssentialNET and Vertica are sponsors of the event and will also be presenting.

Presentation Synopsis

Tracking aircraft with a Raspberry PI, Kafka and Vertica

Using a small number of Raspberry PI “radars” in Geneva, Moscow, New York and Pennard (where?), collecting ~100m messages per day from aircraft, we stream the data into a Vertica database via Apache Kafka. With 50bn historic records, and live data streaming in 10 second micro batches, we have prepared a number of Tableau dashboards to demonstrate having a live conversation with the Vertica database. In this we are using some of the hundreds of in-database analytic, data preparation and machine learning Vertica SQL functions. The dashboards include; the latest positions of aircraft, flight tracks, gap filling & interpolation and sessionisation – to name but a few.

This short presentation will provide a high-level overview of the project from aircraft to dashboard and introduce the Vertica Analytic Database at a very high level.

To register for the event, please follow this link to TechUG’s site:

vTechUG Cardiff Virtual Community Event

One Response to EssentialNET at vTechUG Cardiff – July 16th 2020 – Cohosted with Vertica

Leave a Reply

Your email address will not be published. Required fields are marked *