[Data-modeling] the pitch... baseball managers

[Dan Milbrath]

Interesting pattern I've run across for sports teams -- worth a look at an example with baseball. If this works, I might go ahead and extend it to other sports team types as well.

I want to make it very simple to get at who the current manager is, so I added a simple property (current manager) that links between team and manager. I also wanted to support a richer model for the entire coaching staff, including historical staff, so I added a compound value type relationship with a property called 'coaching staff'. This leads to a bit of redundancy, but it seems OK to me.

Have a look here:
http://sandbox.freebase.com/view/en/joe_torre
http://sandbox.freebase.com/tools/schema/baseball/baseball_manager
http://sandbox.freebase.com/tools/schema/baseball/baseball_coach_tenure

Comments? Suggestions? 
Note: this data will likely go away in the next day or so on Sandbox, but if it looks alright to those who review it today -- I'll post the same model on freebase.