Hi all, I'm getting into the meat of my application, namely transitional calculations between statistical tables. As a brief overview:
37 categorical statistics tables (independent data from one another) but each belongs to an inheritance_template.rb model with self.abstract_class = true so that methods can be shared and code is DRY. Now my main ratings table will need to pull information from all 37 tables, and calculate variance between that data using standard deviation and other advanced mathematics. So, as an example of a motion diagram: Ratings controller --> queries Table #1 of 37 pulling all records --> standard deviation and offset for variance is calculated --> new results are formed ----> (should these results be placed somewhere or stored in arrays?) --> new results are further calculated and rating point modifiers are assigned ----> rating point modifiers should be stored in a table ------> table should be accessible by ratings for further use Ratings controller --> queries Table #2 of 37 pulling all records etc. etc. Now, at first glance the data being pulled is actually going to happen one day each week so it's probably better to "task" it using a rake task. Or, do you disagree and if so, why? I could simply store the method in the inheritance_template model and let the rake task call that method and perform the calculations. However, I need to have the results of those calculations saved somewhere so that my ratings table can be created from those values. So, I need some advice on how to proceed with this diagram and what you would suggest about normalizing the data? I've already created this entire platform in PHP but PHP is not rails. Many thanks in advance. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---