Freebase
Start typing to get some suggestions
  • Explore
  • Use
  • Build
  • Developers

        Discussions on logiclabs

        logiclabs » Discuss

        Start a New Discussion

        Discussion will be posted in:

        • logiclabs

        Think this discussion also relates to something else? Cross-post it by adding a new discussion area:

        • General Support,
        • Developer Support
        1.  

          Improved(?) soccer schema

          also posted to
          • Soccer,
          • jeff,
          • joakim
          8 posts, latest post: sprocketonline, Jul 9, 2009
          Link to discussion
          1. sprocketonline Top Contributor Freebase Experts
            Jun 29, 2009
            sprocketonline says:

            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)

            1. skud Metaweb Staff
              Jun 29, 2009
              skud says:

              Congratulations, you are now an admin of the Soccer Commons :)

            2. sprocketonline Top Contributor Freebase Experts
              Jun 29, 2009
              sprocketonline says:

              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.

            3. typelibrarian
              Jun 29, 2009
              typelibrarian says:

              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!

            4. logiclabs
              Jun 30, 2009
              logiclabs says:

              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

            5. sprocketonline Top Contributor Freebase Experts
              Jun 30, 2009
              sprocketonline says:

              >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).

                   

            6. sprocketonline Top Contributor Freebase Experts
              Jul 7, 2009
              sprocketonline says:

              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.

            7. sprocketonline Top Contributor Freebase Experts
              Jul 9, 2009
              sprocketonline says:

              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 :)

          Discussion is posted in:

          • close Soccer
          • close jeff
          • close logiclabs
          • close joakim

          Think this discussion also relates to something else? Cross-post it by adding a new discussion area:

          • General Support,
          • Developer Support

        Search Discussions

        Related Discussions

        • Soccer
        • jeff
        • joakim
        ©2009  Metaweb
        • Page History
        • RDF
        • Feedback
        • Attribution Policy
        • Terms of Service
        • About Us
        • Jobs
        • Freebase Blog
        Freebase contains information on:
        • Arts & Entertainment
        • Products & Services
        • Science & Technology
        • Society
        • Special Interests
        • Sports
        • Time & Space
        Dev Tools
        Refresh cache | Query Editor | Normal view | Explore | Explore2 | Admin view | View transaction log | Suggest transaction log | Client transaction log | hide (F8) | debug-level
        TID(s):
        Controller: 0.353s
        Template: 0.086s
        Cost: br=8.0, cc=0.424, ch=0.0, cm=0.0, cm+h=0.0, cr=0.0, cs=6.0, cw=3.0, dr=4738.0, dt=0.66, dw=0.0, gqr=0.0, in=2870.0, ir=53.0, iw=0.0, lh=0.0, lm=1.0, lr=1.0, mcs=0.004, mcu=0.08, minflt=104.0, mr=3.0, nivcsw=48, nreqs=10.0, nvcsw=28.0, pf=0.0, pr=0.0, stime=0.02, te=0.081, tf=0.209, tg=0.201, tm=0.294, tr=0.029, ts=0.0, tu=0.028, utime=0.404, va=11873.0