OEG’s Data Integration Group RDB2RDF

WorkdistributedunderthelicenseCreativeCommonsAttribution-Noncommercial-Share Alike 3.0

Boris Villazón-Terrazas Facultad de Informática, Universidad Politécnica de Madrid

Campus de Montegancedo sn, 28660 Boadilla del Monte, Madrid http://www.oeg-upm.net

bvillazon@fi.upm.es Phone: 34.91.3366605, Fax: 34.91.3524819

Slides available at: http://www.slideshare.net/boricles/

Acknowledgements: W3C RDB2RDF group members, Freddy Priyatna, and Jean Paul Calbimonte.

ToC

•  Motivation •  Direct Mapping •  R2RML •  Morph / ODEMapster

2

A Survey of Current Approaches for Mapping of Relational Databases to RDF

3

A Survey of Current Approaches for Mapping of Relational Databases to RDF, Satya S. Sahoo, Wolfgang Halb, Sebastian Hellmann, Kingsley Idehen, Ted Thibodeau Jr, Sören Auer, Juan Sequeda, Ahmed Ezzat, 2009. (See http://www.w3.org/2005/Incubator/rdb2rdf/RDB2RDF_SurveyReport.pdf.)

•  A majority of dynamic Web content is backed by relational databases (RDB), and so are many enterprise systems.

•  W3C RDB2RDF Working Group •  R2RML: RDB to RDF Mapping Language - http://www.w3.org/2001/sw/rdb2rdf/r2rml/ •  Direct Mapping - http://www.w3.org/TR/rdb-direct-mapping/ •  R2RML and Direct Mapping Test Cases - http://www.w3.org/2001/sw/rdb2rdf/test-cases/ •  RDB2RDF Implementation Report - http://www.w3.org/2001/sw/rdb2rdf/implementation-

report/

RDB2RDF

4

transformation description

transformation engine

Access the RDF data in different ways

•  The consumer of the RDF Graph (virtual or materialized)

5

Use Cases and Requirements for Mapping Relational Databases to RDF http://www.w3.org/2001/sw/rdb2rdf/use-cases/

Direct Mapping

•  The direct mapping defines an RDF Graph representation of the data in an RDB. The direct mapping takes as input an RDB (data and schema), and generates an RDF graph that is called the direct graph.

6

Direct Mapping - example

7

R2RML

•  A language for expressing customized mappings from RDB to RDF datasets.

•  R2RML mappings are themselves expressed as RDF graphs and written down in Turtle syntax.

8

R2RML - Overview

9

R2RML - Overview

10

R2RML - example I - input

11

R2RML - example I - mapping

12

R2RML – example I - output

13

R2RML – example II - input

14

R2RML - example II - mapping

15

R2RML – example II - output

16

R2RML - example III - input

17

R2RML - example III - mapping

18

19

R2RML - example III - output

20

R2RML - example IV - input

21

R2RML - example IV - mapping

22

23

R2RML - example IV - output

24

Morph / ODEMapster - database

25

mapping

26

27

Upload to an RDF store - Fuseki

28

29

•  http://code.google.com/p/oeg-obdi/

•  https://github.com/jpcik/morph

•  https://github.com/boricles/morph

• 

30

RDB2RDF Implementation Report. Boris Villazón-Terrazas, Michael Hausenblas. http://www.w3.org/2001/sw/rdb2rdf/implementation-report/

OEG’s Data Integration Group RDB2RDF

WorkdistributedunderthelicenseCreativeCommonsAttribution-Noncommercial-Share Alike 3.0

Boris Villazón-Terrazas Facultad de Informática, Universidad Politécnica de Madrid

Campus de Montegancedo sn, 28660 Boadilla del Monte, Madrid http://www.oeg-upm.net

bvillazon@fi.upm.es Phone: 34.91.3366605, Fax: 34.91.3524819

Slides available at: http://www.slideshare.net/boricles/

Acknowledgements: W3C RDB2RDF group members, Freddy Priyatna, and Jean Paul Calbimonte.