Jeremy Cole, MySQL Geek, Proven Scaling LLC
Date: Monday, July 26
Time: 1:45pm - 5:15pm
Location: Salon B
Follow a fully working application from beginning to end and learn how to make sense of data available to you. We'll look at some data available from Government sources, and look at how to turn that into a meaningful application.
FlightStats is an application designed to monitor all aspects of the airline industry, and has been created as a demonstration application for MySQL, PHP, and Perl and their use together. It demonstrates a complex application, with over 50 million records, and is actually real data. The working data set is from the Bureau of Transportation Statistics, and the FAA, and contains data about every commercial flight in the United States since 1995.
Using the FlightStats application, we will look at:
How to get the data you need
How to load that data into MySQL
Common problems you might encounter
Building a complex application
Making everything work together
Turning "data" into "useful information"
When we're finished, you may take the application and full working data set home with you to try things out on your own. All software used is under the GPL, and all data is in the public domain.