Can I apply a private handicap to all the historic records

Question

Hi. I am considering purchashing the database and learning SQL and would like to apply my own ratings to races ( a class calculation) & horses ( my own handicappining method plus a good run / ok run / poor run flag). My thoughts are to apply this to all records in the database andsave the data back tothe database to allow for researching etc . Is this feasable ?

Thanks

Answer 1

Yes this is possible, You wont want to add anything to the main 4 tables in the database as it will effect the automatic daily updates, but its quite feasible to create other tables to hold the data you require and then join them to the main tables with the unique raceid and or runnerid when runnind SQLs

Comments

It's all completely do-able - I run a daily script to do exactly the sort of thing you describe for newly downloaded historic records. But Nick's right - don't alter the 4 main data tables as updating will fail. Use separate tables using the race_id and runner_id variables as join keys.