mixed – Linked Data for Professional Education

0 to 60 on SPARQL Queries in 50 Minutes

Sun, 06 May 2018 02:22:48 +0000

This webinar provides an introduction to SPARQL, a query language for RDF. Users will gain hands on experience crafting queries, starting simply, but evolving in complexity. These queries will focus on coinage data in the SPARQL endpoint hosted by http://nomisma.org with numismatic concepts defined in a SKOS-based thesaurus and physical specimens from three major museum collections (American Numismatic Society, British Museum, and Münzkabinett of the Staatliche Museen zu Berlin) linked to these concepts. Results generated from these queries in the form of CSV may be imported directly into Google Fusion Tables for immediate visualization in the form of charts and maps. Links to all resources necessary to practice the queries covered are available online and referenced from the webinar presentation.

The webinar uses the following SPARQL constructs: SELECT, WHERE, LIMIT, ORDER BY (ASC), FILTER, DISTINCT, regex(), count(), lang(), langMatches().

Access to all SPARQL queries used in the webinar are available at http://numishare.blogspot.com/2015_05_01_archive.

URL: https://www.asist.org/events/webinars/dcmi-webinar-from-0-to-60-on-sparql-queries-in-50-minutes/
Keywords: visualization (map geolocations), Google Fusion Tables, visualization (statistics), geographic queries, UNION, OPTIONAL, sorting, filtering, SPARQL syntax
Author: Ethan Gruber
Publisher: DCMI
Date created: 2014-01-01 07:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P1H00M
Educational use: instruction
Educational audience: student
Interactivity type: mixed

Open Refine 101

Fri, 25 Aug 2017 08:34:44 +0000

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

Swagger, the API Economy, REST, Linked Data, and a Semantic Web

Sat, 19 Aug 2017 08:28:00 +0000

In this blog post, the author presents the following situation analysis: The network commonly referred to as the World Wide Web (“Web”) is built upon the powerful duality delivered by a HTTP URI (“Hyperlink”). Hypermedia (Webby Content) is Document Content that includes hyperlinks, which may or may not include explicit controls for Hyperlink lookup (or dereference). Notations for creating RDF document content e.g., (RDF-Turtle or JSON-LD) don’t include explicit Hyperlink-lookup controls. This has led to a false dichotomy has arisen across the communities of so-called “Web Developers” (who prefer explicit Hyperlink-lookup controls) and don’t necessarily see the need for HTTP URI opacity. The author argues that "the notion of a Semantic Web of Linked Data and REST-ful interactions using APIs aren’t in anyway mutually exclusive". He presents an example (with screenshots) showing how a single instance of OpenLink Smart Data Bot (OSDB), combined with the use of several other tools, provides a REST-ful interaction point for engaging a variety of Actions extracted from a variety of APIs documented using Swagger and/or RDF documents.

URL: https://medium.com/openlink-software-blog/swagger-the-api-economy-rest-linked-data-and-a-semantic-web-9d6839dae65a
Keywords: REST (Representational State Transfer), Web APIs, OpenLink Smart Data Bot (OSDB), DBpedia, Virtuoso, CURL
Author: Idehen, Kingsley Uyi
Publisher: OpenLink Software
Date created: 2017-06-24 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P45M
Educational use: instruction
Educational audience: student
Interactivity type: mixed

Eurostat Linked Data

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

his is a Linked Data version of the Eurostat data with the goal to provide 5 star Linked Open Data on the European level, in a contextually rich and up-to-date manner, useful for ETL-style business analysis or data warehousing purposes with benefits including but not limited to: It allows for a straight-forward comparison of statistical indicators across EU countries; Through providing context for statistics it facilitates the interpretation process; Enables one to re-use observations in a fine-grained way. A SPARQL endpoint allows the user to query the entire metadata, including DSDs and dictionaries. Contains SPARQL queries kindly provided by Søren Roug from the European Environment Agency (EEA).

URL: http://eurostat.linked-statistics.org/
Keywords: Extract, Transform, Load (ETL), 5-Star Linked Open Data, SPARQL endpoint, Dataset, RDF
Author: Roug, Søren
Publisher: DERI
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P1H
Educational use: professionalDevelopment
Educational audience: professional
Interactivity type: mixed

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

Medical Subject Headings (MeSH) RDF Linked Data (beta)

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

This links to the home page of beta version of the Medical Subject Headings (MeSH) data in RDF (Resource Description Framework). The National Library of Medicine (NLM) is seeking stakeholder input and feedback as part of a broader effort to evaluate the creation of an NLM Linked Data Service. This includes refining MeSH RDF and contributing use cases for future services. Includes links to documentation, a SPARQL endpoint query interface, and a download of the MeSH RDF data.

URL: https://id.nlm.nih.gov/mesh/
Keywords: Medical Subject Headings (MeSH), RDF, dataset
Publisher: National Library of Medicine (NLM)
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P5M
Educational use: professionalDevelopment
Interactivity type: mixed

SPARQL Package for R: Movie Star Graph Visualization Tutorial

Sun, 06 Aug 2017 07:58:04 +0000

The SPARQL Package allows you to directly import results of SPARQL SELECT queries into the statistical environment of R as a data frame, allowing one to directly perform statistical analysis on datasets on the web. This tutorial shows how to do a visual analysis with the Gephi graph visualization tool, and basic social network analysis with R of the data in the DBpedia repository about Hollywood movies. It makes use of the SPARQL Package for R and the igraph library.

URL: http://linkedscience.org/tools/sparql-package-for-r/sparql-package-for-r-gephi-movie-star-graph-visualization-tutorial/
Keywords: R (programming language), Linked Open Data (LOD), Statistical analysis, Data visualization, Gephi
Author: van Hage, Willem Robert
Publisher: COMBINE project
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P90M
Educational use: instruction
Educational audience: student
Interactivity type: mixed

Using the SPARQL Package in R to Handle Spatial Linked Data: Part II

Sun, 06 Aug 2017 07:58:04 +0000

Continuing where Part I left off, this tutorial shows how to access Spatial and Temporal Data about the complex environmental system of the Brazilian Amazon Rainforest, including deforestation statistics, and a variety of socio-economic variables. It shows how store this data in a meaningful way and how to plot and handle it within R.

URL: http://linkedscience.org/tools/sparql-package-for-r/tutorial-part-ii-calculating-deforestation-per-state/
Keywords: R (programming language), Linked Open Data (LOD), Statistical analysis, Data visualization
Author: Gräler, Benedikt
Publisher: COMBINE project
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P30M
Educational use: instruction
Educational audience: student
Interactivity type: mixed

Using the SPARQL Package in R to Handle Spatial Linked Data: Part I

Sun, 06 Aug 2017 07:58:04 +0000

As a solution to bridge two communities, those of statistical computing and the Semantic Web, there is now the SPARQL Package for R, which enables one to retrieve data from Linked Data services for analysis. This tutorial shows
how to access Spatial and Temporal Data about the complex environmental system of the Brazilian Amazon Rainforest, including deforestation statistics, and a variety of socio-economic variables. It shows how store this data in a meaningful way and how to plot and handle it within R.

URL: http://linkedscience.org/tools/sparql-package-for-r/tutorial-on-sparql-package-for-r/
Keywords: R (programming language), Linked Open Data (LOD), Statistical analysis, Data visualization
Author: Gräler, Benedikt
Publisher: COMBINE project
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P30M
Educational use: instruction
Educational audience: student
Interactivity type: mixed

SPARQL Package for R: Linked Open Piracy Tutorial

Sun, 06 Aug 2017 07:58:04 +0000

This tutorial shows how to do a visual analysis and basic statistical analysis of the data in the Linked Open Piracy data set. It makes use of the SPARQL Package for R and the ggmap package. The SPARQL Package allows one to directly import results of SPARQL SELECT queries into the statistical environment of R as a data frame, allowing one to directly perform statistical analysis on datasets from the web.

URL: http://linkedscience.org/tools/sparql-package-for-r/linked-open-piracy-tutorial/
Keywords: R (programming language), Linked Open Data (LOD), Statistical analysis, Data visualization
Author: van Hage, Willem Robert
Publisher: COMBINE project
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P1H
Educational use: instruction
Educational audience: student
Interactivity type: mixed