Training:Semantic Technologies in Practice PhD course in Link�ping 2012/XD collaborative OE/G1 Revision as of 13:26, 25 September 2012 by KarlHammar (Talk | contribs) (→‎SPARQL Tests) (diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Story: Medical Degrees

Competency Questions

1. When was a person awarded a certain medical degree?
2. What medical degree does a certain person hold?
3. Which medical degrees have a certain person studied for?

Contextual Statements

• A degree is awarded on a single date.
• A nursing educational program awards a single degree upon completion.
• Each degree is awarded by completion of only one educational program.
• An educational program is attended for a certain time period, and can end in either achieving a degree, or dropping out.
• Persons can attend more than one educational program, either simultaneously or in sequence.

Reasoning Requirements

• Currently attending a program is implied by having a starting attendance date to the program being earlier than today, and having either no ending date, or a date in the future.

OWL Module

• Medical Degrees ontology fragment
• Medical Degrees test data (to be used with SPARQL queries below)

SPARQL Tests

CQ 1

SELECT ?date
WHERE {
	?person MedicalDegrees:personName "Pasquale Di Gennaro" .
	?attendance MedicalDegrees:attendanceOfPerson ?person .
	?attendance MedicalDegrees:attendanceToEducationalProgram ?program .
	?program rdfs:label "Nursing Assistant Program" .
	?attendance MedicalDegrees:attendanceStatus "DEGREE_AWARDED" .
	?attendance MedicalDegrees:attendanceDuringTime ?timeinterval .
	?timeinterval timeinterval:hasIntervalEndDate ?date
}

CQ 2

SELECT ?degreeName
WHERE {
	?person MedicalDegrees:personName "Pasquale Di Gennaro" .
	?attendance MedicalDegrees:attendanceOfPerson ?person .
	?attendance MedicalDegrees:attendanceToEducationalProgram ?program .
	?attendance MedicalDegrees:attendanceStatus "DEGREE_AWARDED" .
	?program MedicalDegrees:programAwardsDegree ?degree .
	?degree rdfs:label ?degreeName
}

CQ 3

SELECT ?degreeName
WHERE {
	?person MedicalDegrees:personName "Pasquale Di Gennaro" .
	?attendance MedicalDegrees:attendanceOfPerson ?person .
	?attendance MedicalDegrees:attendanceToEducationalProgram ?program .
	?program MedicalDegrees:programAwardsDegree ?degree .
	?degree rdfs:label ?degreeName
}

Story: Seminars

Competency Questions

• Which papers were presented at a certain seminar?
• Where is a certain hospital located?
• When and where was a certain seminar held?
• At which hospitals was a certain paper presented?

Contextual Statements

• At least three papers are presented at each seminar.
• Each seminar takes place during one day (though not necessarily the whole day), at one hospital.

Reasoning Requirements

There are no applicable reasoning requirements for this story.

OWL Module

• Seminars ontology fragment
• Seminars test data (to be used with SPARQL queries below)

SPARQL Tests

CQ 1

SELECT ?paperTitle
WHERE {
	?seminar rdfs:label "Cancer Seminar in Nocera Inferiore" .
	?seminar Seminars:seminarIncludesPaper ?paper .
	?paper rdfs:label ?paperTitle
}

CQ 2

SELECT ?locationName
WHERE {
	?hospital rdfs:label "Ospedale Riunito delle Tre Valli" .
	?hospital place:hasLocation ?location .
	?location rdfs:label ?locationName
}

CQ 3

SELECT ?seminarDate ?seminarSTime ?seminarETime ?seminarPlace
WHERE {
	?seminar rdfs:label "Cancer Seminar in Nocera Inferiore" .
	?seminar Seminars:seminarDate ?seminarDate .
	?seminar Seminars:seminarEndTime ?seminarETime .
	?seminar Seminars:seminarStartTime ?seminarSTime .
	?seminar Seminars:eventHeldAt ?hospital .
	?hospital rdfs:label ?seminarPlace
}

CQ 4

SELECT ?hospitalName
WHERE {
	?paper rdfs:label "A 5 year-program for improving cancer care - experiences and future directions" .
	?paper Seminars:paperPresentedAtSeminar ?seminar .
	?seminar Seminars:eventHeldAt ?hospital .
	?hospital rdfs:label ?hospitalName
}