dbpedia-importer

A project written in clojure to import a bunch of .ttl files from dbpedia into neo4j at once, using neo4J Batch REST api.

Usage

• lein deps
• Start neo4J
• Open http://host:7474

Create neo4j Label index:

CREATE INDEX ON :resource(resource)

Import One file:

lein run http://localhost:7474 /Users/BLA/Data/mappingbased_properties_en_uris_ca.ttl

Import List of files (Recommended):

lein run http://localhost:7474/db/data/  /Users/whoRock/Data/dbpedia_de/dewiki-20140320-labels.ttl /Users/whoRock/Data/dbpedia_de/dewiki-20140320-skos-categories.ttl /Users/whoRock/Data/dbpedia_de/dewiki-20140320-article-categories.ttl /Users/whoRock/Data/dbpedia_de/dewiki-20140320-category-labels.ttl

###Cypher to Try

MATCH (n:resource) WHERE n.resource = "<http://de.dbpedia.org/resource/Dortmund>"

MATCH
  (a:resource {resource:"<http://de.dbpedia.org/resource/Dortmund>"})-[:`<http://purl.org/dc/terms/subject>`]->(ca),
  (b:resource {resource:"<http://de.dbpedia.org/resource/Borussia_Dortmund>"})-[:`<http://purl.org/dc/terms/subject>`]->(cb),
  p=(ca)-[:`<http://www.w3.org/2004/02/skos/core#broader>` *..3]->(g),
  q=(cb)-[:`<http://www.w3.org/2004/02/skos/core#broader>` *..3]->(g)
WITH p,q,g,a,b,ca,cb,
  shortestPath((ca)-->(g)) AS sp,
  shortestPath((cb)-->(g)) AS sq
RETURN sp,sq,g,a,b LIMIT 10;

MATCH
  (a:resource {resource:"<http://de.dbpedia.org/resource/Dortmund>"})-[r:`<http://purl.org/dc/terms/subject>`]->(ca)
RETURN a, r, ca LIMIT 10

MATCH 
  (n:resource)-[r:`<http://purl.org/dc/terms/subject>`]->(ca)
WHERE n.resource = "<http://de.dbpedia.org/resource/Dortmund>" 
RETURN n,r,ca LIMIT 1

Thanks to

* http://losangelesindustries.tumblr.com/post/41701508265/loading-dbpedia-into-neo4j-with-clojure
* https://gist.github.com/nlacasse/4630592

License

Copyright © 2014 sojoner

Distributed under the Eclipse Public License either version 1.0 or any later version.