Mega Power Member
More - What can I use my Organiser for?
« on: Dec 1st, 2018, 12:58pm »
This is another of my 'What can I use my Organiser for?' threads.
For those looking at OPL and database management.
Last time it was a 616 UK birds species ODB.
This time I've got consent from Adrian Massey - http://adrianmassey.no-ip.org/web1/index.php - to post some of his horse racing data. The RaceODB.Zip contains an 128k OPK with three ODB files on it. Jockeys.ODB 418 Records, Trainers.ODB 536 records, Horse.ODB 1028 race favourite records Jan to November 2018. So anyone interested in horse racing and looking to practice working with multiple related databases has plenty to go at. If you need you can break open the OPK in Jaaps OPK File Editor.
If for example you were considering the 14:05 at Newcastle (today) the 1st December 2018 and wanted to consider the favourite Buveur D'Air ridden by B.Geraghty and trained by N Henderson. You could cross reference the databases to find..
Buveur D'Air was the winning favourite at Sansown on 3rd Feb, with Jockey B.Geraghty placed 142 times from 386 races was trained by Nicky Henderson who has been placed 224 times from 464 runners.
I'll let you know later how it went on.
Anyway again sincerely and in good faith
Samples from databases (the 1st record contains the field names)
Jockey Name - Rides - Wins - Places - Adrian Massey Rating
A E LYNCH 623 36 145 99
A P HESKIN 234 30 70 75
AARON JONES 184 10 34 83
ADAM KIRBY 781 121 290 88
Trainer Name - Runners - Wins - Places - Adrian Massey Rating
A J MARTIN 247 8 45 97
A OLIVER 95 14 30 135
A P O'BRIEN 501 70 166 135
ADAM WEST 148 9 24 99
Date - Race - Favourite Horse - Position - Starting Price
01-Jan-18 1:55 Fakenham ARTIFICE SIVOLA 1/6. 5-2.
01-Jan-18 2:35 Cheltenham RED RISING 2/8. 11-4.
01-Jan-18 2:50 Musselburgh CASTLETOWN 3/9. 4-1.
01-Jan-18 3:05 Fakenham NORSE LIGHT 2/2. 1-2.