You could certainly model this with MySQL, but for more optimized results, other database systems could be better. You might look at Vertica. Read up on data wa

You could certainly model this with MySQL, but for more optimized results, other database systems could be better. You might look at Vertica. Read up on data warehousing, if you haven't already, and see what applies to what you're trying to do.