kinow/kinoshita.eti.br

Move movies to Jena backed database

kinow opened this issue · 0 comments

kinow commented

Movielens exports the ratings list as CSV. That can be the initial data.

TARQL appears to be a good option for processing that CSV and ingesting into Jena. Ref: http://www.bobdc.com/blog/tarql/

An example query:

PREFIX ex:  <http://www.learningsparql.com/ns/example/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

CONSTRUCT {
	?m a ex:movie ;
	   ex:id ?movie_id ;
	   ex:title ?title ;
	   ex:rating ?rating . 
}
FROM <file:/home/kinow/Downloads/movielens-ratings.csv>
WHERE {
	# BIND (UUID() AS ?m)
	BIND (IRI(CONCAT("ex:", STR(?movie_id))) AS ?m)
}