Template for Mapping from MySQL to RDF Triples using XRM

Use this repo as template to set up a project-specific mapping project.

This repository is structured as a full example showing how Zazuko Expressive RDF Mapper (XRM) can be used together with Ontop to generate triples out of a MySQL database. See our product page and the documentation for editing instructions.

For this example, we will use a basic example database from the R2RML W3C Recommendation.

Using the Expressive RDF Mapper Eclipse plugin or the VS Code extension, the project will automatically write the mapping to ./src-gen.

Prerequisites

• Docker
• docker-compose
• GNU Make

Repository Structure

• Makefile

  • $ make install_ontop to install Ontop.
  • $ make convert to 'apply' the r2rml mapping generated by the expressive-rdf-mapping to the MySQL database, resulting in ontop-scripts/triples.nt N-Triples file.
  • $ make pipeline to run the pipeline that creates IRI slugs for the location resources, resulting in ontop-scripts/triples-slug.nt N-Triples file.

• mapping/

  R2RML mappings used to convert the MySQL database content into triples. The R2RML mappings are generated using the expressive-rdf-mapper.

• ontop-scripts/

  Scripts used to create triples from the MySQL database, using the R2RML mappings.