Template for Mapping from MySQL to RDF Triples using XRM

Push

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

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.