Tuesday, October 22, 2013

We're building a database of US flight on-time performance

As part of the classwork in the University of Texas at Austin Business Analytics program, we're doing basic database design. Simple relational databases are something I'm already familiar with, so I teamed up with another experienced colleague of mine to do something a little more interesting.

The US Department of Transportation maintains a dataset of every US flight's on-time performance going back to 1987. We're building a database to hold this information, with the idea of doing some analysis later on. And once we've implemented a traditional relational database, we're going to do the whole thing again as a graph database, using Neo4j, and then compare its functionality to the relational database. Should be interesting.

We made a beautifully nerdy video of our relational database design. Watch and comment!





No comments:

Post a Comment