Training:Semantic Technologies in Practice PhD course in Linköping 2012/XD collaborative OE/G1

From Odp

Revision as of 13:20, 25 September 2012 (view source) KarlHammar (Talk | contribs) (→SPARQL Tests) ← Previous diff		Current revision (13:26, 25 September 2012) (view source) KarlHammar (Talk | contribs) (→SPARQL Tests)
(2 intermediate revisions not shown.)
Line 94:		Line 94:
	?seminar Seminars:seminarIncludesPaper ?paper .		?seminar Seminars:seminarIncludesPaper ?paper .
	?paper rdfs:label ?paperTitle		?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
	}		}

---

Current revision

Contents 1 Story: Medical Degrees 1.1 Competency Questions 1.2 Contextual Statements 1.3 Reasoning Requirements 1.4 OWL Module 1.5 SPARQL Tests 1.5.1 CQ 1 1.5.2 CQ 2 1.5.3 CQ 3 2 Story: Seminars 2.1 Competency Questions 2.2 Contextual Statements 2.3 Reasoning Requirements 2.4 OWL Module 2.5 SPARQL Tests 2.5.1 CQ 1 2.5.2 CQ 2 2.5.3 CQ 3 2.5.4 CQ 4

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
}