The Query Optimizer Tool (QOT) is used by instructors and students to assist in the teaching and understanding, respectively, of the way that modern (as of 2008) DBMS tools translate SQL statements into query trees and, furthermore, estimate the cost of those query trees to produce an optimized execution plan.

This program will be written in Ruby on top of an Apache2 server with the necessary packages. We intend to make a useful, easily accessible tool that can be used in a classroom setting.