Creating and transforming Linked Data – Linked Data for Professional Education https://ld4pe.dublincore.org Learning resources tagged by competency Thu, 19 Nov 2020 14:45:03 +0000 en-US hourly 1 https://wordpress.org/?v=4.9.16 Open Refine 101 https://ld4pe.dublincore.org/learning_resource/open-refine-101/ Fri, 25 Aug 2017 08:34:44 +0000 https://ld4pe.dublincore.org/learning_resource/open-refine-101/ This free online course explains that while data cleaning, preparation and enrichment take up an enormous amount of time, and is nevertheless a crucial stage in the data science methodology. However, data transformation tools haven’t fully caught up with the popularity of data analysis. Learn why domain experts need powerful yet easy-to-use interfaces to explore new data sets, normalize them and process them via innovative services often available via an API only. The instructor demonstrates the strengths of OpenRefine, which are that it offers a self-service agile and iterative interface for data discovery and preparation, as well as an easy-to-learn scripting language.

URL: https://cognitiveclass.ai/courses/introduction-to-openrefine/
Keywords: Google Refine, General Refine Expression Language (GREL), Data enrichment, Data cleansing
Author: Magdinier, Martin
Publisher: Cognitive Class
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P7H
Educational use: instruction
Educational audience: teacher-educationSpecialist
Interactivity type: mixed

]]> Tarql: SPARQL for Tables https://ld4pe.dublincore.org/learning_resource/tarql-sparql-for-tables/ Fri, 18 Aug 2017 08:22:56 +0000 https://ld4pe.dublincore.org/learning_resource/tarql-sparql-for-tables/ 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 https://ld4pe.dublincore.org/learning_resource/generating-rdf-from-tabular-data-on-the-web/ Fri, 18 Aug 2017 08:22:56 +0000 https://ld4pe.dublincore.org/learning_resource/generating-rdf-from-tabular-data-on-the-web/ 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

]]> URI design for RDF conversion of CSV-based data https://ld4pe.dublincore.org/learning_resource/uri-design-for-rdf-conversion-of-csv-based-data/ Fri, 18 Aug 2017 08:22:56 +0000 https://ld4pe.dublincore.org/learning_resource/uri-design-for-rdf-conversion-of-csv-based-data/ 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

]]> Level Up: Online CSV to RDF Converter (Beta) https://ld4pe.dublincore.org/learning_resource/level-up-online-csv-to-rdf-converter-beta/ Fri, 18 Aug 2017 08:22:56 +0000 https://ld4pe.dublincore.org/learning_resource/level-up-online-csv-to-rdf-converter-beta/ 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 https://ld4pe.dublincore.org/learning_resource/using-the-convert-csv-to-rdf-ingest-tool/ Fri, 18 Aug 2017 08:22:56 +0000 https://ld4pe.dublincore.org/learning_resource/using-the-convert-csv-to-rdf-ingest-tool/ 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 https://ld4pe.dublincore.org/learning_resource/desiderata-for-an-authoritative-representation-of-mesh-in-rdf/ Tue, 08 Aug 2017 08:07:57 +0000 https://ld4pe.dublincore.org/learning_resource/desiderata-for-an-authoritative-representation-of-mesh-in-rdf/ 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 https://ld4pe.dublincore.org/learning_resource/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 https://ld4pe.dublincore.org/learning_resource/transforming-the-medical-subject-headings-into-linked-data-a-new-article-in-the-journal-of-library-metadata/ 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 https://ld4pe.dublincore.org/learning_resource/converting-relational-data-into-rdf-format/ Tue, 08 Aug 2017 08:07:57 +0000 https://ld4pe.dublincore.org/learning_resource/converting-relational-data-into-rdf-format/ 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

]]> <sameAs>: interlinking the Web of Data https://ld4pe.dublincore.org/learning_resource/interlinking-the-web-of-data/ Fri, 21 Jul 2017 07:20:23 +0000 https://ld4pe.dublincore.org/learning_resource/interlinking-the-web-of-data/ The Web of Data has many equivalent URIs. This service helps you to find co-references between different data sets. The main store includes referents from DBpedia, VIAF, the British Library, and other authoritative sources. There are also links to many smaller sameAs stores that are being populated and used by projects and people. The latter are entirely independent from the main sameAs store, although some of the data may also be reflected in the main sameAs store..

URL: http://sameas.org/
Keywords: Web Ontology Language (OWL), HTTP URIs
Author: Glasser, Hugh
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P15M
Educational use: instruction
Educational audience: student
Interactivity type: active

]]>