10

I want to generate RDF data from tabular data, in particular: CSV, TSV, spreadsheets (either Excel or OpenOffice) and, eventually, tables in RDBMS.

I am aware of the "RDB to RDF Mapping Language" (R2RML) (http://www.w3.org/TR/r2rml/) current draft.

I use Apache Jena for processing, storing and querying RDF data and/or reading CSV or TSV files. I use Apache POI for reading Microsoft Excel spreadsheets and I am planning to use Apache ODF Toolkit for reading OpenOffice spreadsheets.

Is there a Java open source (preferably ASL) implementation of R2RML I can use?

Jens Piegsa
  • 7,399
  • 5
  • 58
  • 106
castagna
  • 1,349
  • 10
  • 12

3 Answers3

6

D2RQ is the underling implementation behind the popular D2R Server. Open source (Apache) and written in Java, so I guess it's exactly what you need.

wikier
  • 2,517
  • 2
  • 26
  • 39
  • Does D2RQ implement R2RML? I can't seem to find anything that says that it does, and while D2RQ's mapping language and R2RML are similar, they aren't the same, I believe. – Joshua Taylor Oct 14 '14 at 19:05
  • 1
    @JoshuaTaylor It appears that R2RML support (modulo a possible bug or two in the test suite) is supported in the development branch, as of 2012. See [Implement R2RML #84](https://github.com/d2rq/d2rq/issues/84) D2RQ's GitHub issue tracker. – Joshua Taylor Oct 14 '14 at 19:07
3

Before your actual question, you introduced another related problem regarding spreadsheets transformation into RDF. For that I'd recommend you to take a look to Google Refine (now: OpenRefine) and its RDF extension. Maybe this screencast regarding how it's used in LMF would help you.

Jens Piegsa
  • 7,399
  • 5
  • 58
  • 106
wikier
  • 2,517
  • 2
  • 26
  • 39
3

Here you can find a list of current R2RML implementations. Maybe the Clojure one might be interesting for you ;)

zazi
  • 686
  • 1
  • 7
  • 19