Agent Relations - Revision history

VladimirAlexiev at 14:18, 19 March 2016

2016-03-19T14:18:43Z

VladimirAlexiev: Created page with "Let's analyze all dbo:Agent relations in EN dbpedia, and see if any rationalization is warranted. = Finding Relations = The first task is to find all agent relations == Sch..."

2016-03-19T14:17:54Z

Created page with "Let's analyze all dbo:Agent relations in EN dbpedia, and see if any rationalization is warranted. = Finding Relations = The first task is to find all agent relations == Sch..."

New page

Let's analyze all dbo:Agent relations in EN dbpedia, and see if any rationalization is warranted.

= Finding Relations =

The first task is to find all agent relations

== Schema Exploration ==
I started doing this by querying the schema:
<pre>
select ?d ?p ?r {
?p rdfs:domain ?d; rdfs:range ?r.
?d rdfs:subClassOf dbo:Agent.
?r rdfs:subClassOf dbo:Agent.
}
</pre>
This returns a nice listing of domain-property-range:
{|
|d
|p
|r
|-
|dbo:Person
|dbo:school
|dbo:EducationalInstitution
|-
|dbo:Artist
|dbo:mentor
|dbo:Artist
|-
|dbo:SoccerPlayer
|dbo:trainerClub
|dbo:SportsTeam
|}
However, it is incomplete: only 35 relations (at another query time 49), but there are a lot more.

== Data Exploration ==
So then I turned to iterative data exploration: starting from the above list, getting a few sample triples, then adding to the list.
<pre>
select * {
?s a dbo:Agent.
?s ?p ?o.
?o a dbo:Agent.
filter (?p not in (
# Already discovered relations
))} limit 10
</pre>

== dbo vs dbp ==
In the list of relations you'll see many raw props dbp: that duplicate the corresponding mapped property dbo:.

Aren't they redundant, since each dbp: is supposed to be present as dbo:?
Yes, it is supposed to be mapped, but not all are. Let's check:
<pre>
select * {
?s a dbo:Agent.
?s dbp:manager ?o.
?o a dbo:Agent.
filter not exists {?s dbo:manager ?o}}
</pre>

This returns many pairs, eg dbr:Chelsea_F.C. and dbr:Jos%C3%A9_Mourinho. Let's check Wikipedia:
* https://en.wikipedia.org/w/index.php?title=Chelsea_F.C.&action=edit
<pre>
{{Infobox football club
| chairman = [[Bruce Buck]]
| owner = [[Roman Abramovich]]
| manager = [[Guus Hiddink]]
| mgrtitle = Interim manager
</pre>
(I guess Mourinho was replaced recently, and you can also see the difference between chairman, manager and owner).
So let's check the mapping:
* http://mappings.dbpedia.org/index.php?title=Mapping_en:Infobox_football_club&action=edit
All seems to be in order, so let's do an extraction sample:
* http://mappings.dbpedia.org/server/extraction/en/extract?title=Chelsea_F.C.&format=turtle-triples
<http://en.dbpedia.org/resource/Guus_Hiddink> is in there: looks like the mapping works.
Not sure why dbo:manager is missing then.

(Note: there is strange tabular data, see [https://github.com/dbpedia/mappings-tracker/issues/77 mappings-tracker#77]

== CareerStation ==
dbo:CareerStation is an unusual sort of Agent: it's an intermediate node with details of the position, eg:

dbo:Person dbo:careerStation dbo:CareerStation dbo:team dbo:SportsTeam.

= List of Agent Relations =

== Org->Person: Leader ==

- dbo:manager, dbp:manager, dbo:chairman, dbp:chairman, dbo:president, dbp:president, dbo:ceo, dbo:chairperson, dbo:head, dbo:leader, dbp:leader, dbp:currentPresident, dbo:secretaryGeneral, dbo:superintendent,
- dbo:trustee,
- Academic: dbo:rector, dbp:rector, dbo:chancellor, dbp:chancellor, dbo:provost, dbp:provost, dbo:headteacher, dbo:actingHeadteacher, dbo:executiveHeadteacher, dbo:custodian, dbp:headOfSchool, dbo:dean, <http://dbpedia.org/property/president&Dean>,
- Military: dbo:fourthCommander, dbp:currentCommander, dbo:officerInCharge,
- Sports: dbp:chief1Name, dbo:trainer, dbo:trainerClub, dbo:managerClub, dbo:formerCoach, dbo:coachedTeam,
- Religion: dbo:chaplain,

== Org->Person: Founder, Owner ==
- dbo:foundedBy, dbo:founder, dbp:founder
- dbo:owner, dbp:owner

== Org->Person: Other ==
- Sports: dbo:club, dbp:club, dbo:team, dbp:team, dbo:clubsRecordGoalscorer
- dbo:nobelLaureates, dbo:notableCommander, dbo:notableStudent, dbo:choreographer, dbo:formerChoreographer, dbo:dubber,

== Person->Org ==
- dbo:employer,
- Politics: dbo:party, dbp:party, dbo:federation,
- Sports: dbp:clubs, dbp:youthclubs, dbp:currentclub,
- Academic: dbo:affiliation, dbp:affiliation, dbp:affiliations, dbp:academicAffiliation, dbo:almaMater, dbp:almaMater, dbo:alumni, dbp:alumni, dbo:school, dbo:university, dbo:student, dbo:training, dbo:education,

== Org->Org ==
- Part: dbo:subsidiary, dbo:childOrganisation, dbp:branch, dbo:militaryBranch, dbo:commandStructure, dbo:parentOrganisation,
- Sports: dbo:league, dbp:league, dbo:athletics, dbp:athletics, dbp:conference,
- Academic: dbo:accreditation, dbp:accreditation, dbp:mainFeederSchoolFor,
- Politics: dbo:mergedIntoParty, dbo:house, dbp:house, dbp:houses, dbo:politicalPartyOfLeader,
- Religion: dbo:denomination, dbp:denomination, dbo:religion, dbp:religion,
- Various: dbo:distributingCompany, dbo:distributingLabel, dbp:oversight,

== Person->Person: Familial ==
- dbo:parent, dbp:parents, dbo:sibling, dbo:spouse, schema:spouse, dbo:relative, dbo:relation, dbo:partner, dbo:currentPartner, dbo:formerPartner, dbo:friend,

== Family->Person ==
- dbo:primogenitor, dbo:familyMember, dbo:lastFamilyMember, dbo:headOfFamily,

== Person->Person: Professional ==
- dbo:influenced, dbp:influenced, dbo:influencedBy, dbo:colleague, dbo:academicAdvisor, dbp:doctoralAdvisor, dbo:doctoralAdvisor, dbo:student, dbo:doctoralStudent, dbo:mentor,
- dbo:copilote, dbo:collaboration, dbo:seiyu, dbo:coemperor, dbo:usurper, dbo:cousurper,

== Succession ==
- dbp:before, dbp:after, dbp:predecessor, dbp:predecessor, dbo:successor, dbp:successor,

== Various ==
- dbo:beatifiedBy, dbo:canonizedBy,
- dbo:opponent, dbo:detractor, dbo:rival, dbp:rival, dbp:rivals, dbp:sisterSchool, dbo:performer, dbo:associatedAct, dbp:mascot

== Non-Relations ==
These are derived relations, or occur between Agents only coincidentally (eg when an Agent is also considered a Location)

=== Location ===
- schema:containedIn, gn:parentFeature, gn:parentCountry,
- dbo:locatedInArea, dbo:location, dbo:county, dbo:province, dbo:district, dbp:district, dbo:settlement, dbo:city, dbo:country, dbp:country,

=== Generic/wrong ===
- owl:sameAs, rdfs:seeAlso, owl:differentFrom,
- dbp:teamname, dbp:nickname, dbp:title, dbp:name, dbp:free, dbo:type,

=== Derived ===
- wd:P118, wd:P286, wd:P112, wd:P131, wd:P17, wd:P184, wd:P69, wd:P102, wd:P26, wd:P31, wd:P54, wd:P140,
- dul:coparticipatesWith, dul:sameSettingAs, dul:hasLocation, dul:isClassifiedBy, dul:isSettingFor, dul:hasSetting, dul:isExpressedBy, dul:isPartOf, dul:hasPart, dul:isMemberOf,

← Older revision		Revision as of 15:18, 19 March 2016
Line 87:		Line 87:
	== Org->Person: Leader ==		== Org->Person: Leader ==

	- dbo:manager, dbp:manager, dbo:chairman, dbp:chairman, dbo:president, dbp:president, dbo:ceo, dbo:chairperson, dbo:head, dbo:leader, dbp:leader, dbp:currentPresident, dbo:secretaryGeneral, dbo:superintendent,		* dbo:manager, dbp:manager, dbo:chairman, dbp:chairman, dbo:president, dbp:president, dbo:ceo, dbo:chairperson, dbo:head, dbo:leader, dbp:leader, dbp:currentPresident, dbo:secretaryGeneral, dbo:superintendent,
	- dbo:trustee,		* dbo:trustee,
	- Academic: dbo:rector, dbp:rector, dbo:chancellor, dbp:chancellor, dbo:provost, dbp:provost, dbo:headteacher, dbo:actingHeadteacher, dbo:executiveHeadteacher, dbo:custodian, dbp:headOfSchool, dbo:dean, <http://dbpedia.org/property/president&Dean>,		* Academic: dbo:rector, dbp:rector, dbo:chancellor, dbp:chancellor, dbo:provost, dbp:provost, dbo:headteacher, dbo:actingHeadteacher, dbo:executiveHeadteacher, dbo:custodian, dbp:headOfSchool, dbo:dean, <http://dbpedia.org/property/president&Dean>,
	- Military: dbo:fourthCommander, dbp:currentCommander, dbo:officerInCharge,		* Military: dbo:fourthCommander, dbp:currentCommander, dbo:officerInCharge,
	- Sports: dbp:chief1Name, dbo:trainer, dbo:trainerClub, dbo:managerClub, dbo:formerCoach, dbo:coachedTeam,		* Sports: dbp:chief1Name, dbo:trainer, dbo:trainerClub, dbo:managerClub, dbo:formerCoach, dbo:coachedTeam,
	- Religion: dbo:chaplain,		* Religion: dbo:chaplain,

	== Org->Person: Founder, Owner ==		== Org->Person: Founder, Owner ==
	- dbo:foundedBy, dbo:founder, dbp:founder		* dbo:foundedBy, dbo:founder, dbp:founder
	- dbo:owner, dbp:owner		* dbo:owner, dbp:owner

	== Org->Person: Other ==		== Org->Person: Other ==
	- Sports: dbo:club, dbp:club, dbo:team, dbp:team, dbo:clubsRecordGoalscorer		* Sports: dbo:club, dbp:club, dbo:team, dbp:team, dbo:clubsRecordGoalscorer
	- dbo:nobelLaureates, dbo:notableCommander, dbo:notableStudent, dbo:choreographer, dbo:formerChoreographer, dbo:dubber,		* dbo:nobelLaureates, dbo:notableCommander, dbo:notableStudent, dbo:choreographer, dbo:formerChoreographer, dbo:dubber,

	== Person->Org ==		== Person->Org ==
	- dbo:employer,		* dbo:employer,
	- Politics: dbo:party, dbp:party, dbo:federation,		* Politics: dbo:party, dbp:party, dbo:federation,
	- Sports: dbp:clubs, dbp:youthclubs, dbp:currentclub,		* Sports: dbp:clubs, dbp:youthclubs, dbp:currentclub,
	- Academic: dbo:affiliation, dbp:affiliation, dbp:affiliations, dbp:academicAffiliation, dbo:almaMater, dbp:almaMater, dbo:alumni, dbp:alumni, dbo:school, dbo:university, dbo:student, dbo:training, dbo:education,		* Academic: dbo:affiliation, dbp:affiliation, dbp:affiliations, dbp:academicAffiliation, dbo:almaMater, dbp:almaMater, dbo:alumni, dbp:alumni, dbo:school, dbo:university, dbo:student, dbo:training, dbo:education,

	== Org->Org ==		== Org->Org ==
	- Part: dbo:subsidiary, dbo:childOrganisation, dbp:branch, dbo:militaryBranch, dbo:commandStructure, dbo:parentOrganisation,		* Part: dbo:subsidiary, dbo:childOrganisation, dbp:branch, dbo:militaryBranch, dbo:commandStructure, dbo:parentOrganisation,
	- Sports: dbo:league, dbp:league, dbo:athletics, dbp:athletics, dbp:conference,		* Sports: dbo:league, dbp:league, dbo:athletics, dbp:athletics, dbp:conference,
	- Academic: dbo:accreditation, dbp:accreditation, dbp:mainFeederSchoolFor,		* Academic: dbo:accreditation, dbp:accreditation, dbp:mainFeederSchoolFor,
	- Politics: dbo:mergedIntoParty, dbo:house, dbp:house, dbp:houses, dbo:politicalPartyOfLeader,		* Politics: dbo:mergedIntoParty, dbo:house, dbp:house, dbp:houses, dbo:politicalPartyOfLeader,
	- Religion: dbo:denomination, dbp:denomination, dbo:religion, dbp:religion,		* Religion: dbo:denomination, dbp:denomination, dbo:religion, dbp:religion,
	- Various: dbo:distributingCompany, dbo:distributingLabel, dbp:oversight,		* Various: dbo:distributingCompany, dbo:distributingLabel, dbp:oversight,

	== Person->Person: Familial ==		== Person->Person: Familial ==
	- dbo:parent, dbp:parents, dbo:sibling, dbo:spouse, schema:spouse, dbo:relative, dbo:relation, dbo:partner, dbo:currentPartner, dbo:formerPartner, dbo:friend,		* dbo:parent, dbp:parents, dbo:sibling, dbo:spouse, schema:spouse, dbo:relative, dbo:relation, dbo:partner, dbo:currentPartner, dbo:formerPartner, dbo:friend,

	== Family->Person ==		== Family->Person ==
	- dbo:primogenitor, dbo:familyMember, dbo:lastFamilyMember, dbo:headOfFamily,		* dbo:primogenitor, dbo:familyMember, dbo:lastFamilyMember, dbo:headOfFamily,

	== Person->Person: Professional ==		== Person->Person: Professional ==
	- dbo:influenced, dbp:influenced, dbo:influencedBy, dbo:colleague, dbo:academicAdvisor, dbp:doctoralAdvisor, dbo:doctoralAdvisor, dbo:student, dbo:doctoralStudent, dbo:mentor,		* dbo:influenced, dbp:influenced, dbo:influencedBy, dbo:colleague, dbo:academicAdvisor, dbp:doctoralAdvisor, dbo:doctoralAdvisor, dbo:student, dbo:doctoralStudent, dbo:mentor,
	- dbo:copilote, dbo:collaboration, dbo:seiyu, dbo:coemperor, dbo:usurper, dbo:cousurper,		* dbo:copilote, dbo:collaboration, dbo:seiyu, dbo:coemperor, dbo:usurper, dbo:cousurper,

	== Succession ==		== Succession ==
	- dbp:before, dbp:after, dbp:predecessor, dbp:predecessor, dbo:successor, dbp:successor,		* dbp:before, dbp:after, dbp:predecessor, dbp:predecessor, dbo:successor, dbp:successor,

	== Various ==		== Various ==
	- dbo:beatifiedBy, dbo:canonizedBy,		* dbo:beatifiedBy, dbo:canonizedBy,
	- dbo:opponent, dbo:detractor, dbo:rival, dbp:rival, dbp:rivals, dbp:sisterSchool, dbo:performer, dbo:associatedAct, dbp:mascot		* dbo:opponent, dbo:detractor, dbo:rival, dbp:rival, dbp:rivals, dbp:sisterSchool, dbo:performer, dbo:associatedAct, dbp:mascot

	== Non-Relations ==		== Non-Relations ==
Line 137:		Line 137:

	=== Location ===		=== Location ===
	- schema:containedIn, gn:parentFeature, gn:parentCountry,		* schema:containedIn, gn:parentFeature, gn:parentCountry,
	- dbo:locatedInArea, dbo:location, dbo:county, dbo:province, dbo:district, dbp:district, dbo:settlement, dbo:city, dbo:country, dbp:country,		* dbo:locatedInArea, dbo:location, dbo:county, dbo:province, dbo:district, dbp:district, dbo:settlement, dbo:city, dbo:country, dbp:country,

	=== Generic/wrong ===		=== Generic/wrong ===
	- owl:sameAs, rdfs:seeAlso, owl:differentFrom,		* owl:sameAs, rdfs:seeAlso, owl:differentFrom,
	- dbp:teamname, dbp:nickname, dbp:title, dbp:name, dbp:free, dbo:type,		* dbp:teamname, dbp:nickname, dbp:title, dbp:name, dbp:free, dbo:type,

	=== Derived ===		=== Derived ===
	- wd:P118, wd:P286, wd:P112, wd:P131, wd:P17, wd:P184, wd:P69, wd:P102, wd:P26, wd:P31, wd:P54, wd:P140,		* wd:P118, wd:P286, wd:P112, wd:P131, wd:P17, wd:P184, wd:P69, wd:P102, wd:P26, wd:P31, wd:P54, wd:P140,
	- dul:coparticipatesWith, dul:sameSettingAs, dul:hasLocation, dul:isClassifiedBy, dul:isSettingFor, dul:hasSetting, dul:isExpressedBy, dul:isPartOf, dul:hasPart, dul:isMemberOf,		* dul:coparticipatesWith, dul:sameSettingAs, dul:hasLocation, dul:isClassifiedBy, dul:isSettingFor, dul:hasSetting, dul:isExpressedBy, dul:isPartOf, dul:hasPart, dul:isMemberOf,