Haha yeah there's so much to it, I always find I end up spending a lot more time than I plan on the database side of things and it takes me a few iterations to get it the way I want. The main thing is to get something reasonable that will work, start capturing the data, and then when you think of a better way to do it later you can migrate your old data into that. I think your plan sounds pretty good!TLindeth wrote: ↑Sun Mar 14, 2021 4:20 pm
Thanks Harry - this is an interesting concept (I've certainly underestimated this database design lark... ). So in essence I could create a fact table which has something along the lines of:
Date
Time
RaceID
RunnerID
CourseID
RaceTypeID
etc.. etc..
With this central fact table then providing a link to other tables of greater detail.. i.e. a table for the pre-off data (structured as you mentioned), names of runners, distances, courses etc..
Have I got that right? I'm sure I'll eventually get my head around this - you'll have to excuse my noddy questions until then but thanks for your help!
Database Structure for Horse Racing
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
Bloody google. I've just spend the last 5mins 'walking' down Mulgrave Rd re-living my old commute. I wasn't in the posh end down near Purley, I was up near the flyover (in The Waldrons), it was only estate agents that called it South Croydon really.
harry wrote: ↑Sun Mar 14, 2021 5:09 pmHaha yeah there's so much to it, I always find I end up spending a lot more time than I plan on the database side of things and it takes me a few iterations to get it the way I want. The main thing is to get something reasonable that will work, start capturing the data, and then when you think of a better way to do it later you can migrate your old data into that. I think your plan sounds pretty good!TLindeth wrote: ↑Sun Mar 14, 2021 4:20 pm
Thanks Harry - this is an interesting concept (I've certainly underestimated this database design lark... ). So in essence I could create a fact table which has something along the lines of:
Date
Time
RaceID
RunnerID
CourseID
RaceTypeID
etc.. etc..
With this central fact table then providing a link to other tables of greater detail.. i.e. a table for the pre-off data (structured as you mentioned), names of runners, distances, courses etc..
Have I got that right? I'm sure I'll eventually get my head around this - you'll have to excuse my noddy questions until then but thanks for your help!
Thanks Harry - now I just need to put the plan into action, maybe that will my help my understanding of how this truly works...
Haha - Sutton has changed a fair bit since your commuting days. There are significant developments around the station now, it actually looks pretty impressive. Shame the high street hasn't really received the same attention. The same could be said for Croydon too!ShaunWhite wrote: ↑Sun Mar 14, 2021 5:39 pmBloody google. I've just spend the last 5mins 'walking' down Mulgrave Rd re-living my old commute. I wasn't in the posh end down near Purley, I was up near the flyover (in The Waldrons), it was only estate agents that called it South Croydon really.