ProvenanceContextEntity

From Knoesis wiki
Revision as of 20:07, 6 February 2010 by Satyasahoo (Talk | contribs) (→‎Result Set)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Provenance Context Entity (PaCE) Resource Page

The Provenance Context Entity (PaCE) is a new approach for provenance tracking in RDF datasets using the notion of provenance context to create provenance-aware RDF triples without the use of RDF reification or blank nodes.

This is a resource page for PaCE featuring the queries used in evaluating the PaCE approach.

SPARQL Query Set

The following queries were used in the evaluations.

Queries for M_PaCE Dataset

Query 1: All statements for a given PMID (e.g., 17209178)

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT ?st_s_inst ?st_p_inst ?st_o_inst
FROM <http://mor.nlm.nih.gov/bkr_instances_context1>

WHERE {

 ?st_s_inst ?st_p_inst ?st_o_inst .

?st_s_inst provenir:derives_from bkr:PUBMED_17209178-INST .

}

Query 2: All sources for a given statement (Lipoproteins AFFECTS Inflammatory cell)

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT ?source_inst
FROM <http://mor.nlm.nih.gov/bkr_instances_context1>

WHERE {

?st_s_inst ?st_p_inst ?st_o_inst .
?st_s_inst rdf:type meta:C0023820 .
?st_p_inst rdfs:subPropertyOf sn:AFFECTS .
?st_o_inst rdf:type meta:C0440752 .

?st_s_inst provenir:derives_from ?source_inst .

}

Query 3: Frequency by source for 1 statement (Thalidomide treats disease)

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT ?source_name count(?source_name)
FROM <http://mor.nlm.nih.gov/bkr_instances_context1>
FROM <http://mor.nlm.nih.gov/bkr_schema>

WHERE {
graph <http://mor.nlm.nih.gov/bkr_instances_context1> {

?st_s_inst ?st_p_inst ?st_o_inst .
?st_s_inst rdf:type meta:C0039736 .
?st_p_inst rdfs:subPropertyOf ?st_p_cl .
?st_s_inst provenir:derives_from ?source_inst .

?source_inst rdf:type ?source_cl .

} .

graph <http://mor.nlm.nih.gov/bkr_schema> {

?source_cl rdfs:label ?source_name .
?st_p_cl rdfs:subPropertyOf ?st_p_cl_top .

?st_p_cl_top rdfs:label 'treats' .
} .

}

Query 4: Count the number of journal articles published between two dates (e.g., 2000-01-01 and 2000-12-31) for a given triple (e.g. Thalidomide treats multiple_myeloma)

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT count(*)
FROM <http://mor.nlm.nih.gov/bkr_instances_context1>
FROM <http://mor.nlm.nih.gov/bkr_metadata>

WHERE {
graph <http://mor.nlm.nih.gov/bkr_instances_context1> {

?st_s_inst ?st_p_inst ?st_o_inst .
?st_s_inst rdf:type meta:C0039736 .
?st_p_inst rdfs:subPropertyOf sn:TREATS .
?st_o_inst rdf:type meta:C0026764 .
?st_s_inst provenir:derives_from ?source_inst .

?source_inst rdf:type ?source_cl .

} .

graph <http://mor.nlm.nih.gov/bkr_metadata> {

?source_inst dc:date ?source_date .

FILTER(?source_date >= xsd:date("2000-01-01") && ?source_date < xsd:date("2000-12-31"))
}

}

Query 5: Time profile the number of journal articles published over 10 years that mention the therapeutic use of the drug Thalidomide

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT ?year count(*)
FROM <http://mor.nlm.nih.gov/bkr_instances_context1>
FROM <http://mor.nlm.nih.gov/bkr_schema>
FROM <http://mor.nlm.nih.gov/bkr_metadata>

where {
{

select (bif:year(?source_date)) as ?year

WHERE {
graph <http://mor.nlm.nih.gov/bkr_instances_context1> {

?st_s_inst ?st_p_inst ?st_o_inst .
?st_s_inst rdf:type meta:C0039736 .
?st_p_inst rdfs:subPropertyOf sn:TREATS .
?st_o_inst rdf:type meta:C0026764 .
?st_s_inst provenir:derives_from ?source_inst .

?source_inst rdf:type ?source_cl .

} .

graph <http://mor.nlm.nih.gov/bkr_metadata> {
 ?source_inst dc:date ?source_date .
}
}
}

} order by ?year

Queries for I_PaCE Dataset

Query 1: All statements for a given PMID (e.g., 17209178)

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT ?st_s_inst ?st_p_inst ?st_o_inst
FROM <http://mor.nlm.nih.gov/bkr_instances_context2>

WHERE {

 ?st_s_inst ?st_p_inst ?st_o_inst .
?st_s_inst provenir:derives_from bkr:PUBMED_17209178-INST .

?st_p_inst provenir:derives_from bkr:PUBMED_17209178-INST .

}

Query 2: All sources for a given statement (Lipoproteins AFFECTS Inflammatory cell)

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT ?source_inst
FROM <http://mor.nlm.nih.gov/bkr_instances_context2>

WHERE {

?st_s_inst ?st_p_inst ?st_o_inst .
 ?st_s_inst rdf:type meta:C0023820 .
?st_p_inst rdfs:subPropertyOf sn:AFFECTS .
?st_o_inst rdf:type meta:C0440752 .
?st_s_inst provenir:derives_from ?source_inst .

?st_p_inst provenir:derives_from ?source_inst .

}

Query 3: Frequency by source for 1 statement (Thalidomide treats disease)

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT ?source_name count(?source_name)
FROM <http://mor.nlm.nih.gov/bkr_instances_context2>
FROM <http://mor.nlm.nih.gov/bkr_schema>

WHERE {
graph <http://mor.nlm.nih.gov/bkr_instances_context2> {

?st_s_inst ?st_p_inst ?st_o_inst .
?st_s_inst rdf:type meta:C0039736 .
?st_p_inst rdfs:subPropertyOf ?st_p_cl .
?st_s_inst provenir:derives_from ?source_inst .
 ?st_p_inst provenir:derives_from ?source_inst .

?source_inst rdf:type ?source_cl .

} .

graph <http://mor.nlm.nih.gov/bkr_schema> {

?source_cl rdfs:label ?source_name .
?st_p_cl rdfs:subPropertyOf ?st_p_cl_top .

?st_p_cl_top rdfs:label 'treats' .
} .

}

Query 4: Count the number of journal articles published between two dates (e.g., 2000-01-01 and 2000-12-31) for a given triple (e.g. Thalidomide treats multiple_myeloma)

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT count(*)
FROM <http://mor.nlm.nih.gov/bkr_instances_context2>
FROM <http://mor.nlm.nih.gov/bkr_metadata>

WHERE {
graph <http://mor.nlm.nih.gov/bkr_instances_context2> {

?st_s_inst ?st_p_inst ?st_o_inst .
?st_s_inst rdf:type meta:C0039736 .
?st_p_inst rdfs:subPropertyOf sn:TREATS .
?st_o_inst rdf:type meta:C0026764 .
?st_s_inst provenir:derives_from ?source_inst .
 ?st_p_inst provenir:derives_from ?source_inst .

?source_inst rdf:type ?source_cl .

} .

graph <http://mor.nlm.nih.gov/bkr_metadata> {

?source_inst dc:date ?source_date .

FILTER(?source_date >= xsd:date("2000-01-01") && ?source_date < xsd:date("2000-12-31"))
}

}

Query 5: Time profile the number of journal articles published over 10 years that mention the therapeutic use of the drug Thalidomide

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT ?year count(*)
FROM <http://mor.nlm.nih.gov/bkr_instances_context2>
FROM <http://mor.nlm.nih.gov/bkr_schema>
FROM <http://mor.nlm.nih.gov/bkr_metadata>

where {
{

select (bif:year(?source_date)) as ?year

WHERE {
graph <http://mor.nlm.nih.gov/bkr_instances_context2> {

?st_s_inst ?st_p_inst ?st_o_inst .
?st_s_inst rdf:type meta:C0039736 .
?st_p_inst rdfs:subPropertyOf sn:TREATS .
?st_o_inst rdf:type meta:C0026764 .
?st_s_inst provenir:derives_from ?source_inst .
 ?st_p_inst provenir:derives_from ?source_inst .

?source_inst rdf:type ?source_cl .

} .

graph <http://mor.nlm.nih.gov/bkr_metadata> {
 ?source_inst dc:date ?source_date .
}
}
}

} order by ?year

Queries for E_PaCE Dataset

Query 1: All statements for a given PMID (e.g., 17209178)

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT ?st_s_inst ?st_p_inst ?st_o_inst
FROM <http://mor.nlm.nih.gov/bkr_instances_context3>

WHERE {

 ?st_s_inst ?st_p_inst ?st_o_inst .
?st_s_inst provenir:derives_from bkr:PUBMED_17209178-INST .  ?st_p_inst provenir:derives_from bkr:PUBMED_17209178-INST .

?st_o_inst provenir:derives_from bkr:PUBMED_17209178-INST .

}

Query 2: All sources for a given statement (Lipoproteins AFFECTS Inflammatory cell)

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT ?source_inst
FROM <http://mor.nlm.nih.gov/bkr_instances_context3>

WHERE {

?st_s_inst ?st_p_inst ?st_o_inst .
?st_s_inst rdf:type meta:C0023820 .
?st_p_inst rdfs:subPropertyOf sn:AFFECTS .
?st_o_inst rdf:type meta:C0440752 .
?st_s_inst provenir:derives_from ?source_inst .
 ?st_p_inst provenir:derives_from ?source_inst .

?st_o_inst provenir:derives_from ?source_inst .

}

Query 3: Frequency by source for 1 statement (Thalidomide treats disease)

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT ?source_name count(?source_name)
FROM <http://mor.nlm.nih.gov/bkr_instances_context3>
FROM <http://mor.nlm.nih.gov/bkr_schema>

WHERE {
graph <http://mor.nlm.nih.gov/bkr_instances_context3> {

?st_s_inst ?st_p_inst ?st_o_inst .
?st_s_inst rdf:type meta:C0039736 .
?st_p_inst rdfs:subPropertyOf ?st_p_cl .
?st_s_inst provenir:derives_from ?source_inst .
 ?st_p_inst provenir:derives_from ?source_inst .
?st_o_inst provenir:derives_from ?source_inst .

?source_inst rdf:type ?source_cl .

} .

graph <http://mor.nlm.nih.gov/bkr_schema> {

?source_cl rdfs:label ?source_name .
?st_p_cl rdfs:subPropertyOf ?st_p_cl_top .

?st_p_cl_top rdfs:label 'treats' .
} .

}

Query 4: Count the number of journal articles published between two dates (e.g., 2000-01-01 and 2000-12-31) for a given triple (e.g. Thalidomide treats multiple_myeloma)

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT count(*)
FROM <http://mor.nlm.nih.gov/bkr_instances_context3>
FROM <http://mor.nlm.nih.gov/bkr_metadata>

WHERE {
graph <http://mor.nlm.nih.gov/bkr_instances_context3> {

?st_s_inst ?st_p_inst ?st_o_inst .
?st_s_inst rdf:type meta:C0039736 .
?st_p_inst rdfs:subPropertyOf sn:TREATS .
?st_o_inst rdf:type meta:C0026764 .
?st_s_inst provenir:derives_from ?source_inst .
 ?st_p_inst provenir:derives_from ?source_inst .
?st_o_inst provenir:derives_from ?source_inst .

?source_inst rdf:type ?source_cl .

} .

graph <http://mor.nlm.nih.gov/bkr_metadata> {

?source_inst dc:date ?source_date .

FILTER(?source_date >= xsd:date("2000-01-01") && ?source_date < xsd:date("2000-12-31"))
}

}

Query 5: Time profile the number of journal articles published over 10 years that mention the therapeutic use of the drug Thalidomide

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT ?year count(*)
FROM <http://mor.nlm.nih.gov/bkr_instances_context3>
FROM <http://mor.nlm.nih.gov/bkr_schema>
FROM <http://mor.nlm.nih.gov/bkr_metadata>

where {
{

select (bif:year(?source_date)) as ?year

WHERE {
graph <http://mor.nlm.nih.gov/bkr_instances_context3> {

?st_s_inst ?st_p_inst ?st_o_inst .
?st_s_inst rdf:type meta:C0039736 .
?st_p_inst rdfs:subPropertyOf sn:TREATS .
?st_o_inst rdf:type meta:C0026764 .
?st_s_inst provenir:derives_from ?source_inst .
 ?st_p_inst provenir:derives_from ?source_inst .
 ?st_o_inst provenir:derives_from ?source_inst .

?source_inst rdf:type ?source_cl .

} .

graph <http://mor.nlm.nih.gov/bkr_metadata> {
 ?source_inst dc:date ?source_date .
}
}
}

} order by ?year

Queries for Reification (R) Dataset

Query 1: All statements for a given PMID (e.g., 17209178)

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT ?st_s_inst ?st_p_inst ?st_o_inst
FROM <http://mor.nlm.nih.gov/bkr_instances_reification>

WHERE {

 ?bn rdf:subject ?st_s_inst .
 ?bn rdf:predicate ?st_p_inst .
 ?bn rdf:object ?st_o_inst .

?bn provenir:derives_from bkr:PUBMED_17209178-INST .

}

Query 2: All sources for a given statement (Lipoproteins AFFECTS Inflammatory cell)

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT ?source_inst
FROM <http://mor.nlm.nih.gov/bkr_instances_reification>

WHERE {

?bn rdf:subject ?st_s_inst .
?bn rdf:predicate ?st_p_inst .
?bn rdf:object ?st_o_inst .
?st_s_inst rdf:type meta:C0023820 .
?st_p_inst rdfs:subPropertyOf sn:AFFECTS .
?st_o_inst rdf:type meta:C0440752 .

?bn provenir:derives_from ?source_inst .

}

Query 3: Frequency by source for 1 statement (Thalidomide treats disease)

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT ?source_name count(?source_name)
FROM <http://mor.nlm.nih.gov/bkr_instances_reification>
FROM <http://mor.nlm.nih.gov/bkr_schema>

WHERE {
graph <http://mor.nlm.nih.gov/bkr_instances_reification> {

?bn rdf:subject ?st_s_inst .
?bn rdf:predicate ?st_p_inst .
?bn rdf:object ?st_o_inst .
?st_s_inst rdf:type meta:C0039736 .
?st_p_inst rdfs:subPropertyOf ?st_p_cl .
?st_s_inst provenir:derives_from ?source_inst .

?source_inst rdf:type ?source_cl .

} .

graph <http://mor.nlm.nih.gov/bkr_schema> {

?source_cl rdfs:label ?source_name .
?st_p_cl rdfs:subPropertyOf ?st_p_cl_top .

?st_p_cl_top rdfs:label 'treats' .
} .

}

Query 4: Count the number of journal articles published between two dates (e.g., 2000-01-01 and 2000-12-31) for a given triple (e.g. Thalidomide treats multiple_myeloma)

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT count(*)
FROM <http://mor.nlm.nih.gov/bkr_instances_reification>
FROM <http://mor.nlm.nih.gov/bkr_metadata>

WHERE {
graph <http://mor.nlm.nih.gov/bkr_instances_reification> {

?bn rdf:subject ?st_s_inst .
?bn rdf:predicate ?st_p_inst .
?bn rdf:object ?st_o_inst .
?st_s_inst rdf:type meta:C0039736 .
?st_p_inst rdfs:subPropertyOf sn:TREATS .
?st_o_inst rdf:type meta:C0026764 .
?st_s_inst provenir:derives_from ?source_inst .

?source_inst rdf:type ?source_cl .

} .

graph <http://mor.nlm.nih.gov/bkr_metadata> {

?source_inst dc:date ?source_date .

FILTER(?source_date >= xsd:date("2000-01-01") && ?source_date < xsd:date("2000-12-31"))
}

}

Query 5: Time profile the number of journal articles published over 10 years that mention the therapeutic use of the drug Thalidomide

PREFIX bkr: <http://mor.nlm.nih.gov/bkr/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX provenir: <http://knoesis.wright.edu/provenir/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX umls: <http://mor.nlm.nih.gov/umls/>
PREFIX meta: <http://mor.nlm.nih.gov/umls/META_>
PREFIX sn: <http://mor.nlm.nih.gov/umls/SEMNET_>
SELECT ?year count(*)
FROM <http://mor.nlm.nih.gov/bkr_instances_reification>
FROM <http://mor.nlm.nih.gov/bkr_schema>
FROM <http://mor.nlm.nih.gov/bkr_metadata>

where {
{

select (bif:year(?source_date)) as ?year

WHERE {
graph <http://mor.nlm.nih.gov/bkr_instances_reification> {

?bn rdf:subject ?st_s_inst .
 ?bn rdf:predicate ?st_p_inst .
 ?bn rdf:object ?st_o_inst .
?st_s_inst rdf:type meta:C0039736 .
?st_p_inst rdfs:subPropertyOf sn:TREATS .
?st_o_inst rdf:type meta:C0026764 .
?st_s_inst provenir:derives_from ?source_inst .

?source_inst rdf:type ?source_cl .

} .

graph <http://mor.nlm.nih.gov/bkr_metadata> {
 ?source_inst dc:date ?source_date .
}
}
}

} order by ?year

Result Set

The Evaluation results for the two phase evaluation of the PaCE approach versus the RDF reification approach can be downloaded here (in .zip format).

Retrieved from "https://wiki.aiisc.ai/index.php?title=ProvenanceContextEntity&oldid=1711"