Use Firestore for its scalable and flexible document-based database. Use collections to aggregate race data by season and event.

Use Cloud Spanner for its scalability and ability to version schemas with zero downtime. Split race data using season as a primary key.

Use BigQuery for its scalability and ability to add columns to a schema. Partition race data based on season.

Use Cloud SQL for its ability to automatically manage storage increases and compatibility with MySQL. Use separate database instances for each season.