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 runs all targets:

  • $ make sql to start the MySQL database with the example-database.sql data.
  • $ make convert to 'apply' the r2rml mapping generated by XRM to the MySQL database, resulting in ontop-scripts/triples.nt N-Triples file.

• database/

  MySQL database related files and config.

• 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.