@prefix map: <file:/E:/code/d2r-server-0.4/d2r-mapping.n3#> .
@prefix db: <> .
@prefix vocab: <vocab/> .
@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
@prefix d2rq: <http://www.wiwiss.fu-berlin.de/suhl/bizer/D2RQ/0.1#> .
@prefix dc: <http://purl.org/dc/elements/1.1/> .
@prefix bsbm: <http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/> .
@prefix bsbm-inst: <http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/> .
@prefix foaf: <http://xmlns.com/foaf/0.1/> .
@prefix rev: <http://purl.org/stuff/rev#> .

map:database a d2rq:Database;
	d2rq:jdbcDriver "com.mysql.jdbc.Driver";
	d2rq:jdbcDSN "jdbc:mysql://localhost/benchmark";
	d2rq:username "DATABASEUSER";
	d2rq:password "PASSWORD";
	.

# Table offer #########################################################################
map:offer a d2rq:ClassMap;
	d2rq:dataStorage map:database;
	d2rq:uriPattern "http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromVendor@@offer.publisher@@/Offer@@offer.nr@@";
	d2rq:class bsbm:Offer;
	.
map:offer_product a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:offer;
	d2rq:property bsbm:product;
	d2rq:refersToClassMap map:product;
  d2rq:join "product.nr = offer.product";
	.
map:offer_vendor a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:offer;
	d2rq:property bsbm:vendor;
	d2rq:refersToClassMap map:vendor;
  d2rq:join "vendor.nr = offer.vendor";
	.
map:offer_price a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:offer;
	d2rq:property bsbm:price;
	d2rq:column "offer.price";
	d2rq:datatype bsbm:USD;
	.
map:offer_validFrom a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:offer;
	d2rq:property bsbm:validFrom;
	d2rq:column "offer.validFrom";
	d2rq:datatype xsd:dateTime;
	.
map:offer_validTo a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:offer;
	d2rq:property bsbm:validTo;
	d2rq:column "offer.validTo";
	d2rq:datatype xsd:dateTime;
	.
map:offer_deliveryDays a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:offer;
	d2rq:property bsbm:deliveryDays;
	d2rq:column "offer.deliveryDays";
	d2rq:datatype xsd:integer;
	.
map:offer_offerWebpage a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:offer;
	d2rq:property bsbm:offerWebpage;
	d2rq:uriColumn "offer.offerWebpage";
	.
map:offer_publisher a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:offer;
	d2rq:property dc:publisher;
	d2rq:refersToClassMap map:vendor;
  d2rq:join "vendor.nr = offer.vendor";
	.
map:offer_publishDate a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:offer;
	d2rq:property dc:date;
	d2rq:column "offer.publishDate";
	d2rq:datatype xsd:date;
	.

# Table person #########################################################################
map:person a d2rq:ClassMap;
	d2rq:dataStorage map:database;
	d2rq:uriPattern "http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromRatingSite@@person.publisher@@/Reviewer@@person.nr@@";
	d2rq:class foaf:Person;
	.
map:person_name a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:person;
	d2rq:property foaf:name;
	d2rq:column "person.name";
	.
map:person_mbox_sha1sum a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:person;
	d2rq:property foaf:mbox_sha1sum;
	d2rq:column "person.mbox_sha1sum";
	.
map:person_country a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:person;
	d2rq:property bsbm:country;
	d2rq:uriPattern "http://downlode.org/rdf/iso-3166/countries#@@person.country@@";
	.
map:person_publisher a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:person;
	d2rq:property dc:publisher;
	d2rq:uriPattern "http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromRatingSite@@person.publisher@@/RatingSite@@person.publisher@@";
	.
map:person_publishDate a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:person;
	d2rq:property dc:date;
	d2rq:column "person.publishDate";
	d2rq:datatype xsd:date;
	.

# Table producer #########################################################################
map:producer a d2rq:ClassMap;
	d2rq:dataStorage map:database;
	d2rq:uriPattern "http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromProducer@@producer.nr@@/Producer@@producer.nr@@";
	d2rq:class bsbm:Producer;
	.
map:producer_label a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:producer;
	d2rq:property rdfs:label;
	d2rq:column "producer.label";
	.
map:producer_comment a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:producer;
	d2rq:property rdfs:comment;
	d2rq:column "producer.comment";
	.
map:producer_homepage a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:producer;
	d2rq:property foaf:homepage;
	d2rq:uriColumn "producer.homepage";
	.
map:producer_country a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:producer;
	d2rq:property bsbm:country;
	d2rq:uriPattern "http://downlode.org/rdf/iso-3166/countries#@@producer.country@@";
	.
map:producer_publisher a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:producer;
	d2rq:property dc:publisher;
	d2rq:uriPattern "http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromProducer@@producer.nr@@/Producer@@producer.nr@@";
	.
map:producer_publishDate a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:producer;
	d2rq:property dc:date;
	d2rq:column "producer.publishDate";
	d2rq:datatype xsd:date;
	.

# Table product #########################################################################
map:product a d2rq:ClassMap;
	d2rq:dataStorage map:database;
	d2rq:uriPattern "http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromProducer@@product.producer@@/Product@@product.nr@@";
	d2rq:class bsbm:Product;
	.
map:product_feature a d2rq:PropertyBridge;
  d2rq:belongsToClassMap map:product;
  d2rq:property bsbm:productFeature;
  d2rq:uriPattern "http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature@@productfeatureproduct.productfeature@@";
  d2rq:join "product.nr = productfeatureproduct.product";
  .
map:product_type a d2rq:PropertyBridge;
  d2rq:belongsToClassMap map:product;
  d2rq:property rdf:type;
  d2rq:uriPattern "http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductType@@producttypeproduct.producttype@@";
  d2rq:join "product.nr = producttypeproduct.product";
  .
map:product_label a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:product;
	d2rq:property rdfs:label;
	d2rq:column "product.label";
	.
map:product_comment a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:product;
	d2rq:property rdfs:comment;
	d2rq:column "product.comment";
	.
map:product_producer a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:product;
	d2rq:property bsbm:producer;
	d2rq:refersToClassMap map:producer;
  d2rq:join "producer.nr = product.producer";
  .
map:product_propertyNum1 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:product;
	d2rq:property bsbm:productPropertyNumeric1;
	d2rq:column "product.propertyNum1";
	d2rq:datatype xsd:int;
	.
map:product_propertyNum2 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:product;
	d2rq:property bsbm:productPropertyNumeric2;
	d2rq:column "product.propertyNum2";
	d2rq:datatype xsd:int;
	.
map:product_propertyNum3 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:product;
	d2rq:property bsbm:productPropertyNumeric3;
	d2rq:column "product.propertyNum3";
	d2rq:datatype xsd:int;
	.
map:product_propertyNum4 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:product;
	d2rq:property bsbm:productPropertyNumeric4;
	d2rq:column "product.propertyNum4";
	d2rq:datatype xsd:int;
	.
map:product_propertyNum5 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:product;
	d2rq:property bsbm:productPropertyNumeric5;
	d2rq:column "product.propertyNum5";
	d2rq:datatype xsd:int;
	.
map:product_propertyNum6 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:product;
	d2rq:property bsbm:productPropertyNumeric6;
	d2rq:column "product.propertyNum6";
	d2rq:datatype xsd:int;
	.
map:product_propertyTex1 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:product;
	d2rq:property bsbm:productPropertyTextual1;
	d2rq:column "product.propertyTex1";
	.
map:product_propertyTex2 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:product;
	d2rq:property bsbm:productPropertyTextual2;
	d2rq:column "product.propertyTex2";
	.
map:product_propertyTex3 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:product;
	d2rq:property bsbm:productPropertyTextual3;
	d2rq:column "product.propertyTex3";
	.
map:product_propertyTex4 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:product;
	d2rq:property bsbm:productPropertyTextual4;
	d2rq:column "product.propertyTex4";
	.
map:product_propertyTex5 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:product;
	d2rq:property bsbm:productPropertyTextual5;
	d2rq:column "product.propertyTex5";
	.
map:product_propertyTex6 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:product;
	d2rq:property bsbm:productPropertyTextual6;
	d2rq:column "product.propertyTex6";
	.
map:product_publisher a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:product;
	d2rq:property dc:publisher;
	d2rq:refersToClassMap map:producer;
  d2rq:join "producer.nr = product.producer";
	.
map:product_publishDate a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:product;
	d2rq:property dc:date;
	d2rq:column "product.publishDate";
	d2rq:datatype xsd:date;
	.

# Table productfeature #########################################################################
map:productfeature a d2rq:ClassMap;
	d2rq:dataStorage map:database;
	d2rq:uriPattern "http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductFeature@@productfeature.nr@@";
	d2rq:class bsbm:ProductFeature;
	.
map:productfeature_label a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:productfeature;
	d2rq:property rdfs:label;
	d2rq:column "productfeature.label";
	.
map:productfeature_comment a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:productfeature;
	d2rq:property rdfs:comment;
	d2rq:column "productfeature.comment";
	.
map:productfeature_publisher a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:productfeature;
	d2rq:property dc:publisher;
	d2rq:uriPattern "http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/StandardizationInstitution@@productfeature.publisher@@";
	.
map:productfeature_publishDate a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:productfeature;
	d2rq:property dc:date;
	d2rq:column "productfeature.publishDate";
	d2rq:datatype xsd:date;
	.

# Table producttype #########################################################################
map:producttype a d2rq:ClassMap;
	d2rq:dataStorage map:database;
	d2rq:uriPattern "http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/ProductType@@producttype.nr@@";
	d2rq:class bsbm:ProductType;
	.
map:producttype__label a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:producttype;
	d2rq:property rdfs:label;
	d2rq:column "producttype.label";
	.
map:producttype_comment a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:producttype;
	d2rq:property rdfs:comment;
	d2rq:column "producttype.comment";
	.
map:producttype_parent a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:producttype;
	d2rq:property rdfs:subClassOf;
	d2rq:refersToClassMap map:producttype;
  d2rq:join "producttype.parent = pt.nr";
  d2rq:alias "producttype AS pt";
	.
map:producttype_publisher a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:producttype;
	d2rq:property dc:publisher;
	d2rq:uriPattern "http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/StandardizationInstitution@@producttype.publisher@@";
	.
map:producttype_publishDate a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:producttype;
	d2rq:property dc:date;
	d2rq:column "producttype.publishDate";
	d2rq:datatype xsd:date;
	.

# Table review #########################################################################
map:review a d2rq:ClassMap;
	d2rq:dataStorage map:database;
	d2rq:uriPattern "http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromRatingSite@@review.publisher@@/Review@@review.nr@@";
	d2rq:class bsbm:Review;
	.
map:review_product a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:review;
	d2rq:property bsbm:reviewFor;
	d2rq:refersToClassMap map:product;
  d2rq:join "product.nr = review.product";
	.
map:review_person a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:review;
	d2rq:property rev:reviewer;
	d2rq:refersToClassMap map:person;
  d2rq:join "person.nr = review.person";
	.
map:review_reviewDate a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:review;
	d2rq:property bsbm:reviewDate;
	d2rq:column "review.reviewDate";
	d2rq:datatype xsd:dateTime;
	.
map:review_title a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:review;
	d2rq:property dc:title;
	d2rq:column "review.title";
	.
map:review_text1 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:review;
	d2rq:property rev:text;
	d2rq:column "review.text";
	d2rq:lang "en";
	d2rq:condition "review.language='en'";
	.
map:review_text2 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:review;
	d2rq:property rev:text;
	d2rq:column "review.text";
	d2rq:lang "ja";
	d2rq:condition "review.language='ja'";
	.
map:review_text3 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:review;
	d2rq:property rev:text;
	d2rq:column "review.text";
	d2rq:lang "zh";
	d2rq:condition "review.language='zh'";
	.
map:review_text4 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:review;
	d2rq:property rev:text;
	d2rq:column "review.text";
	d2rq:lang "de";
	d2rq:condition "review.language='de'";
	.
map:review_text5 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:review;
	d2rq:property rev:text;
	d2rq:column "review.text";
	d2rq:lang "fr";
	d2rq:condition "review.language='fr'";
	.
map:review_text6 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:review;
	d2rq:property rev:text;
	d2rq:column "review.text";
	d2rq:lang "es";
	d2rq:condition "review.language='es'";
	.
map:review_text7 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:review;
	d2rq:property rev:text;
	d2rq:column "review.text";
	d2rq:lang "ru";
	d2rq:condition "review.language='ru'";
	.
map:review_text8 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:review;
	d2rq:property rev:text;
	d2rq:column "review.text";
	d2rq:lang "ko";
	d2rq:condition "review.language='ko'";
	.
map:review_rating1 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:review;
	d2rq:property bsbm:rating1;
	d2rq:column "review.rating1";
	d2rq:datatype xsd:int;
	.
map:review_rating2 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:review;
	d2rq:property bsbm:rating2;
	d2rq:column "review.rating2";
	d2rq:datatype xsd:int;
	.
map:review_rating3 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:review;
	d2rq:property bsbm:rating3;
	d2rq:column "review.rating3";
	d2rq:datatype xsd:int;
	.
map:review_rating4 a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:review;
	d2rq:property bsbm:rating4;
	d2rq:column "review.rating4";
	d2rq:datatype xsd:int;
	.
map:review_publisher a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:review;
	d2rq:property dc:publisher;
	d2rq:uriPattern "http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromRatingSite@@review.publisher@@/RatingSite@@review.publisher@@";
	.
map:review_publishDate a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:review;
	d2rq:property dc:date;
	d2rq:column "review.publishDate";
	d2rq:datatype xsd:date;
	.

# Table vendor #########################################################################
map:vendor a d2rq:ClassMap;
	d2rq:dataStorage map:database;
	d2rq:uriPattern "http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromVendor@@vendor.nr@@/Vendor@@vendor.nr@@";
	d2rq:class bsbm:Vendor;
	.
map:vendor_label a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:vendor;
	d2rq:property rdfs:label;
	d2rq:column "vendor.label";
	.
map:vendor_comment a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:vendor;
	d2rq:property rdfs:comment;
	d2rq:column "vendor.comment";
	.
map:vendor_homepage a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:vendor;
	d2rq:property foaf:homepage;
	d2rq:uriColumn "vendor.homepage";
	.
map:vendor_country a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:vendor;
	d2rq:property bsbm:country;
	d2rq:uriPattern "http://downlode.org/rdf/iso-3166/countries#@@vendor.country@@";
	.
map:vendor_publisher a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:vendor;
	d2rq:property dc:publisher;
	d2rq:uriPattern "http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromVendor@@vendor.nr@@/Vendor@@vendor.nr@@";
	.
map:vendor_publishDate a d2rq:PropertyBridge;
	d2rq:belongsToClassMap map:vendor;
	d2rq:property dc:date;
	d2rq:column "vendor.publishDate";
	d2rq:datatype xsd:date;
	.