Its been a couple of weeks since my last post, and I’ve been experimenting more with graph databases. One of the more common graph database examples explores the relationship between air traffic carriers, and their routes. The nodes are the various cities that carriers fly between, routes are the edges connecting the nodes, and the number of carriers or the flights per day servicing those routes can be a value for the edge.
I uploaded the raw data to a SQL Server to create tables – a set of Graph database tables and a set of normal tables. Working with an assumption that a carrier who had a route out of city has a corresponding route into a city, I created queries to narrow down the returned data to only routes from Cleveland-Hopkins International and Detroit Wayne County airports. (As an aside, population for the Cleveland Metro area is about 2.0 million people, and for Detroit 4.3 million which looks to play into the results.