Uses CONSTRUCT to extract and transform results into a single RDF graph specified by a graph template. – Linked Data for Professional Education

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

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

SPARQL and Linked Data Homework Exercises

Sat, 21 Jan 2017 06:46:40 +0000

This document contains several "written" and "electronic" homework questions originally from the course "Semantic Web Topics" at LeHigh University. They include: Write a series of SPARQL queries using a provided schema; Write a SPARQL construct query that generates all triples inferred by a specific RDFS entailment rule; Write a SPARQL construct query to generate
owl:sameAs statements between domains which share specified property; Describe the pros and cons of generating links in the manner specified in the previous question; Using Jena, create a class that can read in all the files in a specified directory and create a Web page that lists a series of publications organized by topic – reading all of the files into a single model and only using SPARQL to retrieve information from the model.

URL: http://www.cse.lehigh.edu/~heflin/courses/sw-2013/hw2.pdf
Keywords: SPARQL, RDF Schema, Entailment regime, Apache Jena, Java
Author: Heflin, Jeff
Date created: 2013-02-01 05:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P4H
Educational use: assessment
Educational audience: teacher-educationSpecialist
Interactivity type: active

Pulling SKOS "prefLabel" and "altLabel" Values Out of DBpedia

Tue, 10 Jan 2017 06:45:33 +0000

In this blog post, the author proposes that DBpedia may be the best source of reusable URIs when one is seeking to describe entities in Linked Open Data. He shares a script for a SPARQL query that selects preferred and alternative labels for a group of DBpedia entries at once. Taking this a step further and adding a few SKOS properties to the mix, a single query can pull data from DBpedia to populate a SKOS-based thesaurus with preferred and alternative labels.

URL: http://www.snee.com/bobdc.blog/2011/02/pulling-skos-preflabel-and-alt.html
Keywords: DBpedia, Simple Knowledge Organization System (SKOS), SPARQL, Controlled vocabulary
Author: DuCharme, Bob
Date created: 2011-02-22 05:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P10M

SPARQL: Using DESCRIBE and CONSTRUCT Tutorial and Quiz

Thu, 24 Nov 2016 05:51:17 +0000

This slide tutorial focuses on using DESCRIBE and CONSTRUCT in SPARQL queries, but also includes other basic operators. Several examples are provided which include the RDF data being queried, the SPARQL query itself, and the result table. This is followed by quiz questions which ask the user to query DBpedia's SPARQL endpoint. The answers to the question (in the form of completed SPARQL queries) are included.

URL: http://skkudatalab.weebly.com/sparql-describe.html
Keywords: DBpedia, SPARQL
Author: Oh, Sam
Publisher: Sungkyunkwan University (SKKU)
Date created: 2016-11-22 05:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P20M
Educational use: instruction
Educational audience: professional
Interactivity type: expositive

Rich Export SPARQL Queries

Tue, 01 Nov 2016 05:40:07 +0000

The VIVO "rich export" functionality was developed by Stella Mitchell to provide a means of executing one or more pre-defined queries via a URL within the VIVO application in order to receive the results in a form consumable by another application. VIVO's rich export queries are organized by typical sections of a curriculum vitae or CV. They may be useful to supplement the examples of SPARQL queries in the SPARQL Resources section of this wiki (see "Based on URL").

URL: https://wiki.duraspace.org/display/VTDA/Rich+export+SPARQL+queries
Keywords: Apache Jena, VIVO, SPARQL
Author: Conlon, Mike
Publisher: Duraspace
Date created: 2016-08-16 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng

MarkLogic: SPARQL and XQuery together

Tue, 19 Jan 2016 14:59:48 +0000

This exercise covers the use of SPARQL and XQuery together in a few different ways. This involves running a series of queries on the BBC news documents and related triples loaded into the database in a previous exercise. This is just one of several tutorials in a sequence, and they should be done in order to gain the most benefit.

URL: http://developer.marklogic.com/learn/semantics-exercises/sparql-and-xquery
Keywords: XQuery, SPARQL, Triple, XML, JSON
Publisher: MarkLogic
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P20M

SPARQL in 11 minutes

Sat, 16 Jan 2016 13:43:29 +0000

This video serves as an introduction to the W3C query language for RDF, SPARQL. Before explaining SPARQL queries themselves, a brief discussion of Linked Data principles (RDF, Triples, HTTP URIs, Ontologies) is given. Sample data and queries used in video are available at http://learningsparql.com/misc/sparqlIn11Minutes.zip .

URL: https://www.youtube.com/watch?v=FvGndkpa4K0
Keywords: SPARQL, HTTP URIs, Triple
Author: DuCharme, Bob
Publisher: O’Reilly
Date created: 2015-05-03 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P15M

Linked Data Patterns

Sat, 16 Jan 2016 13:43:28 +0000

This resource is a pattern catalogue for modelling, publishing, and consuming Linked Data which adopts a tried and tested means of communicating knowledge and experience in software development: the design pattern. The intent is to create a ready reference that will be useful for both the beginner and the experienced practitioner alike. It is also intended to grow and mature in line with the practitioner community. NOTE: This is a book-length resource and covers a wide range of different areas from the design of Web-scale identifiers to application development patterns.

URL: http://patterns.dataincubator.org/book/index.html
Keywords: Reification, Graph annotation, Autodiscovery, Named query, Binding
Author: Dodds, Leigh
Date created: 2012-05-31 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P3H

Module 2: Querying Linked Data

Abi Evans — Sat, 07 Nov 2015 02:03:58 +0000

This module looks in detail at SPARQL and introduces approaches for querying and updating semantic data. It covers the SPARQL algebra, the SPARQL protocol, and provides examples for reasoning over Linked Data. The module uses examples from the music domain, which can be directly tried out and ran over the MusicBrainz dataset. This includes gaining some familiarity with the RDFS and OWL languages, which allow developers to formulate generic and conceptual knowledge that can be exploited by automatic reasoning services in order to enhance the power of querying. Note: Will need to also create entries for this modules component parts.

URL: http://www.euclid-project.eu/modules/course2
Keywords: Web Ontology Language (OWL), RDF Schema, SPARQL, Query, Linked Data
Publisher: EUCLID Project
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P3H
Educational use: instruction
Educational audience: student
Interactivity type: mixed