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)
}