O'Reilly Open Source Convention
Books Safari Bookshelf Conferences O'Reilly Network

Arrow Home
Arrow Registration
Arrow Speakers
Arrow Keynotes
Arrow Tutorials
Arrow Sessions
Arrow At-a-Glance
Arrow Wiki
Arrow BOFs
Arrow Events
Arrow Exhibitors
Arrow Sponsors
Arrow Hotel/Travel
Arrow Venue Map
Arrow See & Do
Arrow Tips for
Arrow Press
Arrow Mail List



SOLD OUT FlightStats MySQL Demo and Tutorial
Jeremy Cole, MySQL Geek, Proven Scaling LLC

Track: MySQL
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.

    O'Reilly Home | Privacy Policy

    © 2004, O'Reilly Media, Inc.