search

kinow / kinoshita.eti.br

kinow website
https://kinoshita.eti.br
Other
4 stars 2 forks source link

Move movies to Jena backed database #154

Closed kinow closed 2 years ago

kinow commented 4 years ago

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