Stallion statistics database
Design and build and addition to an online service to generate reports from millions of rows of data.
the-racehorse.com Stallion Statistics Database includes tabular and graphical information on thousands of stallions of data in millions of rows.
It is based on a custom database built on race results, sales results and stallion nomination fees.
The source data is imported, validated, standardised and inter-connected to show a stallion's performance over time.
Approach
Paola designed and developed the Stallion Stats as a new Drupal module. Frank wrote all the code to clean the imported data to use in the reports.
All the graphs were implemented in standard HTML using stretched 1-pixel graphics and require no special browser versions to view.
Sire Record
Paola later built a tool to extract data from the database in a format that could be imported into Harbury's Sire Record publication.