@prefix d2rq: <http://www.wiwiss.fu-berlin.de/suhl/bizer/D2RQ/0.1#> .
@prefix dbpedia-owl: <http://dbpedia.org/ontology/> .
@prefix map: <file:///d2r/example.ttl#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
@prefix foaf: <http://xmlns.com/foaf/0.1/> .  

map:Database1 a d2rq:Database;
    d2rq:jdbcDSN "jdbc:mysql://localhost/imdb";
    d2rq:jdbcDriver "com.mysql.jdbc.Driver";
    d2rq:username "user";
    d2rq:password "password";
    .
# -----------------------------------------------
# CREATE TABLE Movies(MovieID int, Title text, Year int);
map:Movie a d2rq:ClassMap;
    d2rq:dataStorage map:Database1.
    d2rq:class dbpedia-owl:Film;
    d2rq:uriPattern "http://mymoviedomain/movie/@@Movies.MovieID@@";
    .
map:movieTitle a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Movie;
    d2rq:property dbpedia-owl:title;
    d2rq:column "Movies.Title";
    d2rq:lang "en";
    d2rq:datatype xsd:string;
    .
map:movieCreationYear a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Movie;
    d2rq:property dbpedia-owl:creationYear;
    d2rq:column "Movies.Year"; 
    d2rq:datatype xsd:gYear;
    .
# -----------------------------------------------
# CREATE TABLE Actors(ActorID int, FullName text);
map:Actor a d2rq:ClassMap;
    d2rq:dataStorage map:Database1.
    d2rq:class dbpedia-owl:Person;
    d2rq:uriPattern "http://mymoviedomain/actor/@@Actors.ActorID@@";
    .
map:actorName a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Actor;
    d2rq:property foaf:name;
    d2rq:column "Actor.FullName";
    d2rq:datatype xsd:string;
    .
# -----------------------------------------------
# CREATE TABLE MoviesActors(MovieID int, ActorID);
map:movieActor a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:Movie;
	d2rq:property dbpedia-owl:starring;
      d2rq:refersToClassMap map:Actor;
	d2rq:join "Movies.MovieID = MoviesActors.MovieID";
	d2rq:join "MoviesActors.ActorID = Actors.ActorID";
	.