Tranforming CQ in SPARQL

[TizianaPasciuto]

Tiziana's new tests use riot CTP_Ontology_core.ttl Instances\CTP_Ontology_core_Instance* >TestSparql\20240508\CTPcatWhole_20240513.n3 and sparql.bat --data=TestSparql\20240508\CTPcatWhole_20240513.n3 --query=TestSparql\20240508\CQs\CQX.sparql To print results & errors: sparql.bat --data=TestSparql\20240508\CTPcatWhole_20240513.n3 --query=TestSparql\20240508\CQs\CQX.sparql >rescqX.txt 2>rescqXerr.txt

• [x] CQ1 - Inserted filter by language (Optional).
• [x] CQ2 - Inserted filter by language (Optional - results in "rescq2bis.txt").
• [x] CQ3
• [x] CQ4 - Inserted filter by language (Optional - resultis in "rescq4bis.txt").
• [x] CQ5
• [x] CQ6
• [x] CQ7
• [x] CQ8
• [x] CQ9
• [x] CQ10
• [x] CQ11 - Modified instance "transitions" to test the query, because there were no cases where the funder was in common between two instances. Cfr. "CTPcatWhole_20240513_CQ11.n3"
• [x] CQ12
• [x] CQ13
• [x] CQ14
• [x] CQ15
• [x] CQ16
• [x] CQ17
• [x] CQ18
• [x] CQ19
• [x] CQ20
• [x] CQ21
• [x] CQ22
• [x] CQ23
• [x] CQ24
• [x] CQ25

[TizianaPasciuto]

Points to discuss and questions to answer

• 19

• 20

• 21

[TizianaPasciuto]

All the CQs have been materialized, so this activity is over. It will be verified at the next meeting and specific issues related to this point will be discussed.

[TizianaPasciuto]

As a result of the activity of checking the Competency Questions formulated, it was found necessary to reopen the issue to resolve some criticalities. Therefore, the list of CQs is brought back, and labeled with the entities to be referred to, and the modified CQs will be checked as the work progresses.

Use riot CTP_Ontology_core.ttl Instances\CTP_Ontology_core_Instance* >TestSparql\20240508\CTPcatWhole_20240513.n3 and sparql.bat --data=TestSparql\20240508\CTPcatWhole_20240513.n3 --query=TestSparql\20240508\CQs\CQX.sparql To print results & errors: sparql.bat --data=TestSparql\20240508\CTPcatWhole_20240513.n3 --query=TestSparql\20240508\CQs\CQX.sparql >rescqX.txt 2>rescqXerr.txt

• [x] CQ1 - Definition of Thematic Path ---> [set so that all languages in which the definition is provided come out, using BIND(LANG)]
• [x] CQ2 - ?Theme ---> [set so that all languages in which the ThematicPathTitle is provided come out, using BIND(LANG) and FILTER(REGEX)]
• [x] CQ3 - ?PlaceName ?Role (Holder) ---> [Inserted filter for role, having it filter by "holder (custodians)" with URI from Getty Institute]
• [x] CQ4 - ?TemporalEntity (Historical period) ---> [set so that all languages in which the ThematicPathTitle is provided come out, using BIND(LANG) and FILTER(REGEX)]
• [x] CQ5 - ?AgentName ?Role (Creator) ---> [As "creators" should be considered not only "creators" as such, but also "authors" and "senders". Matching URIs, taken from the Getty Institute, were included to search for roles] For this reason, a filter has been included for these three role categories]
• [x] CQ6 - ?TemporalEntity ?AgentName ?Role (Creator) [Fusion of CQ5 & CQ7] ---> [query modified, now it points to the start date and end date of the period, overriding the century written as a string] + [As "creators" should be considered not only "creators" as such, but also "authors" and "senders". Matching URIs, taken from the Getty Institute, were included to search for roles]
• [x] CQ7 - ?TemporalEntity ---> [query modified, now it points to the start date and end date of the period, overriding the century written as a string]
• [x] CQ8 - ?AgentName --->[In this case, the relation points directly to the agent that inspires the thematic path (ctp:isInspiredByAgent), without having to go through the ctp:relationToAgent and then having to assign a role to an agent]
• [x] CQ9 - ?PathCount ---> [I can indicate the number of paths in which the resource is included, but I cannot indicate the title of the paths]
• [x] CQ10 - ?AgentName ?Role (Creator) ---> [Inserted filter for role, having it filter by "creator" with URI from Getty Institute]
• [x] CQ11 - ?AgentName ?Role (Funder) ---> [Inserted filter for role, having it filter by "funder" with URI from Getty Institute]
• [x] CQ12 - ?CulturalResourceType
• [x] CQ13 - ?Subject ---> [set so that all languages in which the SubjectLabel is provided come out, using BIND(LANG) and FILTER(LANGMATCHES)]
• [x] CQ14 - ?PlaceName
• [x] CQ15 - ?Values ---> [set so that all languages in which the ThematicPathTitle is provided come out, using BIND(LANG) and FILTER(LANGMATCHES)]
• [x] CQ16 - ?OrderedListSlot ---> [To have a correct order, you must enter the title of the thematic path, otherwise the individual cultural resource positions in the different thematic paths will come out]
• [x] CQ17 - ?CulturalEvent ?TemporalEntity ---> [set so that all languages in which the ThematicPathTitle is provided come out, using BIND(LANG) and FILTER(REGEX)]
• [x] CQ18 - ?ThematicPath ?SubThematicPath
• [x] CQ19 - ?LinkToResource = URL ThematicPath
• [x] CQ20 - ?LinkToResource = URL CulturalResource
• [x] CQ21 - ?CulturalResource ?ThematicPath
• [x] CQ22 - ?Product ?Link ---> [set so that all languages in which the definition is provided come out, using BIND(LANG)]
• [x] CQ23 - ?SecondaryIdentifier ---> [Identifies the secondary identifier that has been established by the agent storing the object]
• [x] CQ24 - ?PrimaryIdentifier ---> [Since the URI of the resource would go here, I would edit the CQ, because I don't think it needs to indicate the catalog. I would therefore modify it like this: "What is the unique identifier of the cultural resource X? / Qual è l'identificatore univoco della risorsa culturale X?"]
• [x] CQ25 - ?CreationDate ---> [Taking into account the critical issues indicated in #25 - not solved]

[TizianaPasciuto]

All the CQs have been materialized, so this activity is over. It will be verified at the next meeting and specific issues related to this point will be discussed.

[TizianaPasciuto]

@riccardoAlbertoni: evaluate the CQs, 9 through 27.