Creating RDF data – Linked Data for Professional Education

URI design for RDF conversion of CSV-based data

Fri, 18 Aug 2017 08:22:56 +0000

The sharing of comma-separated files is very common, and a common set of problems arise upon the receipt and processing of data within this format. The RDF vocabulary described in this document provides interpretation instructions to a tool that converts tabular based data into RDF appropriate for linked data publishing. Links to a page which describes a Java-based tool that follows the interpretation vocabulary described here and provides a set of shell script tools to facilitate automatic conversion.

URL: https://data-gov.tw.rpi.edu/wiki/URI_design_for_RDF_conversion_of_CSV-based_data
Keywords: CSV (Comma Separated Values), HTTP URIs, VoID (Vocabulary of Interlinked Datasets)
Author: Williams, Gregory Todd
Publisher: Tetherless World Constellation
Date created: 2011-01-21 05:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P45M

Tarql: SPARQL for Tables

Fri, 18 Aug 2017 08:22:56 +0000

Tarql is a command-line tool for converting CSV files to RDF using SPARQL 1.1 syntax. In short, a CSV file’s contents are input into a SPARQL query as a table of bindings. This allows manipulation of CSV data using the full power of SPARQL 1.1 syntax, and in particular the generation of RDF using CONSTRUCT queries. Includes design patterns and examples. Discusses how to deal with variations in header rows, delimiters, quotes and character encoding encountered in CSV/TSV files.

URL: http://tarql.github.io/
Keywords: CSV (Comma Separated Values), SPARQL CONSTRUCT, SPARQL OFFSET, Apache Jena, Java (programming language)
Author: Cyganiak, Richard
Date created: 2017-06-22 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P45M

Generating RDF from Tabular Data on the Web

Fri, 18 Aug 2017 08:22:56 +0000

This document defines the procedures and rules to be applied when converting tabular data into RDF. Tabular data may be complemented with metadata annotations that describe its structure, the meaning of its content and how it may form part of a collection of interrelated tabular data. This document specifies the effect of this metadata on the resulting RDF. This is a draft document and may be updated, replaced or obsoleted by other documents at any time. It is inappropriate to cite this document as other than work in progress.

URL: http://w3c.github.io/csvw/csv2rdf/
Keywords: CSV (Comma Separated Values)
Author: Kellogg, Gregg
Publisher: W3C
Date created: 2017-06-07 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P20M
Interactivity type: expositive

Level Up: Online CSV to RDF Converter (Beta)

Fri, 18 Aug 2017 08:22:56 +0000

This online converter for CSV files was created for the many people out there who are big supporters of "Open Data" but are uncomfortable with getting that data into a format that can be used for Linked Data (regardless of whether it was open or not). Whilst many are happy with saving tabular data as CSV files, a surprising amount are still fairly mystified by saving that same data in RDF format. For more information about "Why RDF?", "What's Linked Open Data?" and similar questions – please have a read of the FAQ; this page concentrates on how to use the converter options to tweak the RDF output. The final step is to simply download a zip file of the converted CSV. The zip file includes the data in three formats – RDF, Turtle (.ttl) and N-Triples (.nt).

URL: http://levelup.networkedplanet.com/instructions
Keywords: CSV (Comma Separated Values)
Publisher: NetwrokedPlanet
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P15M
Educational use: professionalDevelopment
Interactivity type: active

Using the Convert CSV to RDF ingest tool

Fri, 18 Aug 2017 08:22:56 +0000

This guide will walk through the use of the Convert CSV to RDF tool, a semi-automated method of converting comma separated or tab separated text files into RDF that can be displayed in VIVO. These files should include one row of data per record (e.g., a person or publication) and represent the fields or properties associated with each record in separate columns within the row, much as the values appear in a spreadsheet. The most common pattern of loading CSV files involves one CSV file per type of data to be loaded. Note, the current ingest tools involve working through a number of steps from original source data files to the appearance of new data in VIVO. The process requires some understanding of semantic web data modeling and some training.

URL: https://wiki.duraspace.org/display/VIVODOC19x/Using+the+Convert+CSV+to+RDF+ingest+tool
Keywords: CSV (Comma Separated Values), VIVO Ontology for Researcher Discovery, SPARQL
Author: Gross, Benjamin
Publisher: Duraspace
Date created: 2017-03-16 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P30M
Educational use: instruction
Educational audience: teacher-educationSpecialist
Interactivity type: mixed

Desiderata for an authoritative Representation of MeSH in RDF

Tue, 08 Aug 2017 08:07:57 +0000

Although the Semantic Web provides a framework for the integration of resources on the web, datasets are not always made available in RDF by their producers and the Semantic Web community has had to convert some of these datasets to RDF in order for these datasets to participate in the LOD cloud. As a result, the LOD cloud sometimes contains outdated, partial and even inaccurate RDF datasets. The authors of this article review the LOD landscape for one of these resources, MeSH, and analyze the characteristics of six existing representations in order to identify desirable features for an authoritative version, for which they have created a prototype. They then illustrate the suitability of this prototype on three common use cases. NLM released an authoritative representation of MeSH in RDF (beta version) in the Fall of 2014.

URL: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4419968/
Keywords: Medical Subject Headings (MeSH), Linked Open Data (LOD) Cloud, Linked Open Data (LOD), Semantic Web, eXtensible Markup Language (XML)
Author: Bodenreider, Olivier
Publisher: American Medical Informatics Association (AMIA)
Date created: 2014-11-14 05:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P20M

Transforming the Medical Subject Headings into Linked Data: a new article in the Journal of Library Metadata

Tue, 08 Aug 2017 08:07:57 +0000

This article reviews the pilot project to convert the Medical Subject Headings (MeSH) from XML to Linked Data/RDF. The article examines the collaborative process, the technical and organizational issues tackled, and the future of Linked Data at the National Library of Medicine.

URL: http://aims.fao.org/activity/blog/transforming-medical-subject-headings-linked-data-new-article-journal-library-metadata
Keywords: Medical Subject Headings (MeSH), Semantic Web, LAMs (Libraries, Archives, and Museums)
Publisher: AIMS (Agricultural Information Management Standards)
Date created: 2016-02-11 05:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P10M
Educational audience: teacher-educationSpecialist
Interactivity type: expositive

Converting Relational Data Into RDF Format

Tue, 08 Aug 2017 08:07:57 +0000

This tutorial shows two different methods of converting or materializing relational data into RDF graph data format: the D2RQ based method and the SQL based method. The D2RQ based method provides customizable mapping files that allow users to specify the generation of URIs, enabling the reuse of URIs across different columns, tables, schemas, or even databases. URI reuse here means using the same URI to represent the same resource. The SQL-based approach, as provided in this tutorial, does not handle escapes, character encoding, new lines, tabs, and other special characters.

URL: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r1/prod/datamgmt/relational_into_rdf/relational_data_into_rdf_format_otn.htm
Keywords: D2RQ Mapping Language, SQL (Structured Query Language), N-Triples, N3
Publisher: Oracle
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P1H
Educational use: instruction
Educational audience: professional
Interactivity type: active

An Introduction to Semantic Web and Linked Data

Tue, 18 Oct 2016 05:39:02 +0000

This W3C tutorial was presented at WWW2014. It is a massive, 200+ slide presentation that provides at least an overview (and often a good amount of detail) of nearly every aspect of Linked Data, from the basic to the not-so-basic.

URL: http://www.slideshare.net/fabien_gandon/semantic-web-and-linked-data
Keywords: Semantic Web, Triple, HTTP URIs, SPARQL, Web Ontology Language (OWL), RDF Schema, Rule Interchange Format (RIF), PROV-O (Provenance Ontology)
Author: Gandon, Fabien
Date created: 2014-04-08 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P1H30M
Educational use: professionalDevelopment
Educational audience: professional
Interactivity type: expositive

Metadata Standards Crosswalk

Tue, 18 Oct 2016 05:39:01 +0000

The crosswalk presented here is only a partial list of the elements for each of many metadata standards, focusing on the areas of overlap. This crosswalk is for planning purposes only; it is an intellectual mapping. To create a technical mapping, programmers and developers should use this crosswalk for general guidance, but please refer to the original standards.

URL: http://www.getty.edu/research/publications/electronic_publications/intrometadata/crosswalks.html
Keywords: Metadata, Standards, Mapping, Dublin Core
Publisher: The J. Paul Getty Trust
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P30M
Educational use: instruction
Educational audience: professional
Interactivity type: expositive