diff options
Diffstat (limited to 'rdf-documentation/dump-publication.md')
| -rw-r--r-- | rdf-documentation/dump-publication.md | 37 |
1 files changed, 20 insertions, 17 deletions
diff --git a/rdf-documentation/dump-publication.md b/rdf-documentation/dump-publication.md index 90a366c..708e47f 100644 --- a/rdf-documentation/dump-publication.md +++ b/rdf-documentation/dump-publication.md @@ -1,40 +1,44 @@ # Publications Metadata ## 'dump-publication' - ## Generated Triples: The following SQL query was executed: ```sql -SELECT IF(Publication.PubMed_ID IS NULL, '', CONVERT(Publication.PubMed_Id, INT)) AS pmid, Publication.Id, IFNULL(PubMed_ID, '') AS pubmedId, Publication.Title, Publication.Journal, Publication.Volume, Publication.Pages, Publication.Month, Publication.Year, Publication.Authors, CAST(CONVERT(BINARY CONVERT(Publication.Abstract USING latin1) USING utf8) AS VARCHAR(100)) AS Abstract FROM Publication +SELECT IF(Publication.PubMed_ID IS NULL, '', CONVERT(Publication.PubMed_Id, INT)) AS pmid, Publication.Id, IFNULL(PubMed_ID, '') AS pubmedId, Publication.Title, Publication.Journal, Publication.Volume, Publication.Pages, Publication.Month, IF(Publication.Year = 0, NULL, Publication.Year) AS Year, Publication.Authors, Publication.Abstract FROM Publication ``` The above query results to triples that have the form: ```text -pubmed:pmid -> rdf:type -> gn:publication -pubmed:pmid -> gn-term:pubMedId -> pubmed:pubmedId -pubmed:pmid -> gn-term:title -> Publication(Title) -pubmed:pmid -> gn-term:journal -> Publication(Journal) -pubmed:pmid -> gn-term:volume -> Publication(Volume) -pubmed:pmid -> gn-term:pages -> Publication(Pages) -pubmed:pmid -> gn-term:month -> Publication(Month) -pubmed:pmid -> gn-term:year -> Publication(Year) -pubmed:pmid -> gn:abstract -> Abstract -pubmed:pmid -> gn:author -> PublicationAuthors +pubmed:pmid -> rdf:type -> fabio:ResearchPaper +pubmed:pmid -> fabio:hasPubMedId -> pubmed:pubmedId +pubmed:pmid -> dct:title -> Publication(Title) +pubmed:pmid -> fabio:Journal -> Publication(Journal) +pubmed:pmid -> prism:volume -> Publication(Volume) +pubmed:pmid -> fabio:page -> Publication(Pages) +pubmed:pmid -> prism:publicationDate -> "Publication(Month)"^^xsd:gMonth +pubmed:pmid -> fabio:hasPublicationYear -> "Year"^^xsd:gYear +pubmed:pmid -> dct:abstract -> PublicationAbstract +pubmed:pmid -> dct:creator -> PublicationAuthors ``` Here's an example query: ```sparql -PREFIX gn-term: <http://genenetwork.org/terms/> +PREFIX gnt: <http://genenetwork.org/terms/> +PREFIX fabio: <http://purl.org/spar/fabio/> +PREFIX dct: <http://purl.org/dc/terms/> +PREFIX prism: <http://prismstandard.org/namespaces/basic/2.0/> PREFIX gn: <http://genenetwork.org/id/> +PREFIX gnc: <http://genenetwork.org/category/> PREFIX pubmed: <http://rdf.ncbi.nlm.nih.gov/pubmed/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> +PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> -SELECT ?s ?p ?o WHERE { - ?s rdf:type gn:publication . +SELECT * WHERE { + ?s rdf:type fabio:ResearchPaper . ?s ?p ?o . } ``` @@ -42,7 +46,6 @@ SELECT ?s ?p ?o WHERE { Expected Result: ```rdf -gn:unpublished_1 rdf:type gn:publication . -gn:unpublished_1 gn-term:year "0" . +gn:unpublished_1 rdf:type fabio:ResearchPaper . ``` |