Knows methods such as Direct Mapping of Relational Data to RDF (2012) for transforming data from the relational model (keys, values, rows, columns, tables) into RDF graphs. – Linked Data for Professional Education

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

Answering SPARQL Queries over Databases under OWL 2 QL Entailment Regime

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

This video presents an extension of the ontology-based data access platform Ontop that supports answering SPARQL queries under the OWL 2 QL direct semantics entailment regime for data instances stored in relational databases. On the theoretical side, we show how any input SPARQL query, OWL 2 QL ontology and R2RML mappings can be rewritten to an equivalent SQL query solely over the data. On the practical side, we present initial experimental results demonstrating that by applying Ontop technologies the system produces scalable SQL queries.

URL: http://videolectures.net/iswc2014_kontchakov_sparql_queries/
Keywords: Ontop, Entailment Regimes, Ontology-Based Data Access (ODBA), Query rewriting, RDBMS, Relational model
Author: Kontchakov, Roman
Date created: 2014-12-19 05:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P20M

Direct Mapping of Relational Data to RDF

Fri, 15 Jan 2016 13:27:05 +0000

The need to share data with collaborators motivates custodians and users of relational databases (RDB) to expose relational data on the Web of Data. This document defines a direct mapping from relational data to RDF. This definition provides extension points for refinements within and outside of this document.

URL: http://www.w3.org/TR/rdb-direct-mapping/
Keywords: Mapping, R2RML, Relational Model, SQL, RDBMS
Author: Arenas, Marcelo
Publisher: W3C
Date created: 2012-09-27 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P30M
Interactivity type: expositive

R2RML: RDB to RDF Mapping Language

Fri, 15 Jan 2016 13:27:04 +0000

This document describes R2RML, a language for expressing customized mappings from relational databases to RDF datasets. Such mappings provide the ability to view existing relational data in the RDF data model, expressed in a structure and target vocabulary of the mapping authors choice. R2RML mappings are themselves RDF graphs and written down in Turtle syntax. R2RML enables different types of mapping implementations.

URL: http://www.w3.org/TR/r2rml/
Keywords: Mapping, RDBMS, R2RML, Relational Model, Turtle, SQL
Author: Das, Souripriya
Publisher: W3C
Date created: 2012-09-27 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P30M

Multi-Agent and Semantic Web Systems: RDF Data Structures

Abi Evans — Fri, 13 Nov 2015 06:00:10 +0000

This slide presentation of lecture material was used as part of a course given at The University of Edinburgh School of Informatics. This lecture reviews the concepts of resources and HTTP URIs, then discusses literals and datatypes. Discusses "Instance-of" in RDF, the use of blank nodes, and mapping from the relational model to RDF.

URL: http://www.inf.ed.ac.uk/teaching/courses/masws/lectures-14/6-full.pdf
Keywords: RDF, HTTP URIs, Blank node, Relational model, R2RML
Author: McNeill, Fiona
Date created: 2013-01-31 05:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P25M
Educational use: instruction
Educational audience: teacher-educationSpecialist
Interactivity type: expositive

Publishing Relational Databases as Linked Data

Abi Evans — Wed, 21 Oct 2015 20:15:07 +0000

These slides appear to have been used for a course in Database Management Systems at the University of Toronto, but contain material which the creator attributes to other authors. Part 1 outlines a six-step process for "Publishing Linked Data on the Web". Part 2, "How to Publish Relational Databases as Linked Data", covers the following subjects: Mapping relational databases to RDF; following Linked Data Principles and guidelines; mapping and publication tools; the D2R Server.

URL: http://www.cs.toronto.edu/~oktie/slides/publishing-relational-databases-as-linked-data.pdf
Keywords: RBD2RDF, HTTP URIs, Query rewriting, Link discovery
Author: Heath, Tom
Publisher: Herman, Ivan
Date created: 2011-03-01 05:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P30M
Educational use: instruction
Educational audience: professional
Interactivity type: expositive

Recognizing, Naming and Exploring Structure in RDF Data

Abi Evans — Sat, 10 Oct 2015 12:05:44 +0000

This master's thesis seeks to apply research into RDBMS – which has led to mature techniques for storing and querying data – to the problem of improving how RDF data can be handled efficiently without missing any of the additional insights for which the RDF data model allows. The authors have come up with an unusual approach in which RDF data is transformed into the relational data model. Inherently unstructured RDF data is structured by means of semantic information, and relationships between these structures are extracted with the names for structures, their attributes, and relationships automatically generated. Subsequently, using the relational schema thus created, RDF data is physically stored in efficient data structures. Afterwards, it can be queried with an SQL-based interface.

URL: http://homepages.cwi.nl/~boncz/msc/2014-Passing.pdf
Keywords: RDBMS, URI shortening, Characteristic sets, MonetDB/RDF
Author: Passing, Linnea
Date created: 2014-05-22 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P2H
Educational use: instruction
Educational audience: student
Interactivity type: expositive

Model Driven Engineering for Publishing Data on the Semantic Web

Abi Evans — Sat, 10 Oct 2015 12:05:44 +0000

Publishing local data on the Semantic Web requires that one provide a shareable semantic data representation of that data. This paper presents a complete Model Driven Engineering (MDE) approach that allows for importing data sources into an RDF repository. First, the object domain model is mapped to an ontology and to a persistence model through annotation performed by a domain expert. Then, all other processes are automated and data transformations are generated from the mappings via model-weaving techniques.

URL: http://ceur-ws.org/Vol-395/paper03.pdf
Keywords: RDBMS, Web Ontology Language (OWL), Model Driven Engineering (MDE), Object Relational Mapping (ORM)
Author: Hillairet, Guillaume
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P30M
Educational use: instruction
Educational audience: student
Interactivity type: expositive