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.