Real-Time GPU-Accelerated Data Analytics of 250 million Flight Data Records of 737 Max grounding

Key Takeaways

this demo is highlighting a couple different things omnisci so omnisize a gpu enabled database so it's an sql database that runs entirely in gpu memory that allows it to be incredibly fast and allow you to do queries and filters into really large data sets much faster than you could do on a cpu-based system and so omnisi builds the back end to this demo so all of the data is loaded into omnisci as well as this front end the immerse dashboard and the immersed dashboard lets you visualize your data and then build all of these sort of sub views through charts the data we're looking at here is flight telemetry from adsb sensors so planes emit their trajectories where they are who made them their call signs like all this information so that planes don't run into each other and essentially we've got 500 million flights loaded up into this example and from here i can start filtering and asking questions of the data and so one kind of interesting use case to look at is the grounding of the 737 max we can start poking at this now all of these sub cards here these views are all based on the map so as i move the map around this is changing it's reflecting my view of the world this is all happening in real time really quickly on the gpu and so if i want to start saying okay show me all of the boeing flights in the world over this time period i can just start to query here so now i've got about 162 million flights showing up here and then you can see that southwest airlines they're a big customer of boeing so we can filter down even more and look at all of the southwest flights they're obviously mostly in the u.s biggest deal here is when you have hundreds of millions of records and you need to get insight out of that quickly you don't have time to wait hours for a query to come and then that question can change all the time depending on what your situation is you want to be able to query this data quickly and get answers back and the gpu enabled database is what lets you do that