From ImageWeb

{{#ifeq:D2R Server|||| colspan="2" style="text-align: center; background: #CAF7B7"|}}

{{#ifeq:sites.wiwiss.fu-berlin.de/suhl/bizer/d2r-server/||||style="vertical-align: top;" |Link

{{#ifeq:Active||||style="vertical-align: top;" |Status {{#ifeq:False||||style="vertical-align: top;" |JISCTool {{#ifeq:Semantic Web, Relational database||||style="vertical-align: top;" |Focus {{#ifeq:||||style="vertical-align: top;" |Publishes {{#ifeq:||||style="vertical-align: top;" |Uses {{#ifeq:||||style="vertical-align: top;" |RelatedTo {{#ifeq:||||style="vertical-align: top;" |Partner {{#ifeq:||||style="vertical-align: top;" |Contact

DefiningImageAccess/Tool/D2RServer
Link:=http://sites.wiwiss.fu-berlin.de/suhl/bizer/d2r-server/}}
Status:=Active}}
JISCTool:=False}}
Focus:=Semantic Web, Relational database}}
[[Publishes::{{{Publishes}}}]]}}
[[Uses::{{{Uses}}}]]}}
[[RelatedTo::{{{RelatedTo}}}]]}}
[[Partner::{{{Partner}}}]]}}
[[Contact::{{{Contact}}}]]}}

D2R Server

Publishing Relational Databases on the Semantic Web

• http://sites.wiwiss.fu-berlin.de/suhl/bizer/d2r-server/
• http://sites.wiwiss.fu-berlin.de/suhl/bizer/D2RQ/spec/

D2R Server is a tool for publishing relational databases on the Semantic Web. It enables RDF and HTML browsers to navigate the content of the database, and allows applications to query the database using the SPARQL query language.

Set up D2R for BDGP Gene Expression Database

• Download the source data archive from BDGP ftp://ftp.fruitfly.org/pub/exgomysqldump/archive/current/
• Import data into mysql database using the command:

mysql -u root databasename < dump.sql -p

• Install D2R http://sites.wiwiss.fu-berlin.de/suhl/bizer/d2r-server/#quickstart
• To initialise the mapping:

./generate-mapping -o mapping-exgo-short.n3 -d com.mysql.jdbc.Driver -u root -p pwd jdbc:mysql://localhost:3306/bdgp

• Set up D2R running behind Tomcat: http://sites.wiwiss.fu-berlin.de/suhl/bizer/d2r-server/#container