zazuko / xrm-r2rml-workflow

All you need to convert relational databases (RDB) to RDF in a declarative & fully automated way.

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 the expressive-rdf-mapping 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.

xrm-r2rml-workflow's Issues

Support for other RDBMS?

Will it be possible to run on databases other than MySQL?

Specifically, I would like to use MS SQL

Test/update for XRM 1.1

Should be tested with XRM 1.1 & Gitpod when ready

• Update Ontop
• Update scripts & documentation where needed
• Check if everything works as expected