Discussions on logiclabs
Start a New Discussion
-
-
I noticed there weren't too many properties in the soccer commons, so I had a go at creating my own schema in the football assocation base. I've emulated most of the types from the soccer commons; but my big addition is soccer match - which has properties for players, goal scorers, substitutions and bookings etc.. as an example I've filled in the FA Cup Final 1999
I'd appreciate any comments on the schema, I've tried to pick up previous comments gathered from the soccer base discussion; but I'm open to any ideas for improvements... (particularly competitions/leagues/seasons)
-
Congratulations, you are now an admin of the Soccer Commons :)
-
Thanks skud.
As much as I'd like to go crazy with my new powers and move everything to the commons, I'll hold back as I'd like some critical review of the types I mashed together in the association football base earlier today.
-
Well, since you asked... :) Bear in mind that I know exactly zilch about association football, other than which three English teams contain swear words in their names (which is what you learn when Billy Bragg is your main entree into the sport).
I notice that there is no direct relationship between players and teams (only via squad or match), and that in the case of Manchester United, you've co-typed it as both a squad and a team, which seems confusing based on the type descriptions.
Should soccer field include sports arena?
For goals, I think the disambiguator "team" is ambiguous -- at a glance it's not clear whether that's the player's team or the team the goal is credited to.
A soccer league does not seem to contain any teams.
Why is a soccer league also a soccer competition?
Soccer competition's property "seasons" expects "Event" rather than Soccer Soccer competion season.
Speaking of soccer competition season, the "matches" property should probably be reciprocated on the Match type.
But overall this is a very impressive schema!
-
Maybe add attendance to the soccer match type?
If possible, it'd be great if these types could inherit properly from the existing sports events/sports league championship events ..
i.e. a soccer match (is a) sports event (is an) event .. a soccer championship event (is a) sports league championship event (is a sports event) (is an) event ..and so on ..
I'd mainly like this to reduce data duplication across types, and to enable querying across sub-types i.e. give me all the sports events held at Wembley in 2008 (although I suppose this is possible at the moment, but there is some duplication of data required i.e. location, date/time etc)
Just to add:
The "sports league championship" type naming is probably misleading but the schema does fairly accurately describe all football cup events (Essentially the FA cup is a league championship for the FA associated teams, and the 1999 FA Cup Final was for the 2008-2009 FA Cup Season)
The biggest difference for football I can see is in the multi-format competitions (although these are similar to american sports which the sports event types seem to have been created for) where you start with a league format and then a set of play off matches to arrive at a single winner i.e. world cup, euros, champions league
-
>I notice that there is no direct relationship between players and teams (only via squad or match)
I've added a time-mediated property soccer player tenure.
>and that in the case of Manchester United, you've co-typed it as both a squad and a team, which seems confusing based on the type descriptions.
Now fixed, I've split the squad from the team.
>Should soccer field include sports arena?
now typed with sports facility.
>For goals, I think the disambiguator "team" is ambiguous
now called "point awarded to"
>A soccer league does not seem to contain any teams.
I've created soccer league participation which is time-mediated using seasons instead of dates.
>Why is a soccer league also a soccer competition?
This was where I was having issues. I'm trying to get my head around the Sports commons and also get some abstract inheritance in. I was trying to make league competitions different from cup competitions, and possibly different from multi-format competitions - yet all have a common inheritance from soccer competition.
>Soccer competition's property "seasons" expects "Event" rather than Soccer Soccer competion season.
fixed this.
>Speaking of soccer competition season, the "matches" property should probably be reciprocated on the Match type.
now reciprocated.
>If possible, it'd be great if these types could inherit properly from the existing sports events/sports league championship events ..
absolutely, my problem is that I'm not too familiar with the sports commons. But if you could point out which types to include, I'll update the schema. I've done soccer match now.
I've also added a schema for player transfers and loans.
All my types are still in association football, and I'd appreciate any further comments on the types. If we feel some of the types/properties are OK I will start replicating them in the soccer commons. (with the plan to eventually move everything over and delete association football).
-
I'm planning to move the schema from association football over the next few days.
If anyone has further comments or improvements to the schema, please let me know.
-
Job done! The schema is now up and running in the soccer commons.
Hopefully I got everything from football association across (I purposefully left out squads and competition season types as I think they're a bit flaky), but let me know if there's something wrong.
Ideas for the next feature are welcome :)
-