Included manifest files
authorBoris Villazon-Terrazas <bvillazon@fi.upm.es>
Wed, 20 Jul 2011 19:25:08 +0100
changeset 11 fd20eac2d562
parent 10 270a11b2adc2
child 12 47c60b91708e
Included manifest files
D000-1table0rows/directGraph.nt
D000-1table0rows/directGraph.ttl
D000-1table0rows/manifest.ttl
D000-1table0rows/mapped.nq
D000-1table0rows/mapped.trig
D001-1table1row/directGraph.nt
D001-1table1row/directGraph.ttl
D001-1table1row/manifest.ttl
D001-1table1row/mappeda.nq
D001-1table1row/mappeda.trig
D001-1table1row/mappedb.nq
D001-1table1row/mappedb.trig
D002-1table2columns1row/directGraph.nt
D002-1table2columns1row/directGraph.ttl
D002-1table2columns1row/manifest.ttl
D002-1table2columns1row/mappeda.nq
D002-1table2columns1row/mappeda.trig
D002-1table2columns1row/mappedb.nq
D002-1table2columns1row/mappedb.trig
D003-1table3columns1row/directGraph.nt
D003-1table3columns1row/directGraph.ttl
D003-1table3columns1row/manifest.ttl
D003-1table3columns1row/mappeda.nq
D003-1table3columns1row/mappeda.trig
D003-1table3columns1row/mappedb.nq
D003-1table3columns1row/mappedb.trig
D003-1table3columns1row/mappedc.nq
D003-1table3columns1row/mappedc.trig
D003-1table3columns1row/mappedd.nq
D003-1table3columns1row/mappedd.trig
D004-1table2columnsprojection/directGraph.nt
D004-1table2columnsprojection/directGraph.ttl
D004-1table2columnsprojection/manifest.ttl
D004-1table2columnsprojection/mappeda.nq
D004-1table2columnsprojection/mappedb.nq
D004-1table2columnsprojection/r2rmla.ttl
D004-1table2columnsprojection/r2rmlb.ttl
D005-2duplicates0nulls/directGraph.nt
D005-2duplicates0nulls/directGraph.ttl
D005-2duplicates0nulls/manifest.ttl
D006-1table1primarykey1column1row/create.sql
D006-1table1primarykey1column1row/directGraph.nt
D006-1table1primarykey1column1row/manifest.ttl
D007-1table1primarykey2columns1row/create.sql
D007-1table1primarykey2columns1row/directGraph.nt
D007-1table1primarykey2columns1row/manifest.ttl
D008-1table1compositeprimarykey3columns1row/create.sql
D008-1table1compositeprimarykey3columns1row/directGraph.nt
D008-1table1compositeprimarykey3columns1row/manifest.ttl
D009-2tables1primarykey1foreingkey/directGraph.nt
D009-2tables1primarykey1foreingkey/directGraph.ttl
D009-2tables1primarykey1foreingkey/manifest.ttl
D009-2tables1primarykey1foreingkey/mapped.nq
D009-2tables1primarykey1foreingkey/r2rml.ttl
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D000-1table0rows/directGraph.nt	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,1 @@
+# empty graph
--- a/D000-1table0rows/directGraph.ttl	Wed Jul 20 19:12:51 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,1 +0,0 @@
-# empty graph
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D000-1table0rows/manifest.ttl	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,33 @@
+@prefix test: <http://www.w3.org/2006/03/test-description#> .
+@prefix dcterms: <http://purl.org/dc/elements/1.1/> .
+@prefix rdb2rdftest: <http://purl.org/NET/rdb2rdf-test#> .
+@base <http://mappingpedia.org/rdb2rdf/tc/> .
+
+<d000> a rdb2rdftest:DataBase;
+	dcterms:title "Empty table" ;
+	dcterms:identifier "D000-1table0rows" ;
+	rdb2rdftest:sqlScriptFile "create.sql";
+	rdb2rdftest:relatedTestCase <dg0000> ;
+	rdb2rdftest:relatedTestCase <tc0000> ;
+.
+
+<dg0000> a rdb2rdftest:DirectMapping;	
+	dcterms:title "Empty table"; 
+	dcterms:identifier "Direct Graph TC0000" ;
+	test:purpose "Tests if an empty table produces an empty RDF graph" ;
+	test:specificationReference "#rules_table_triples" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d000> ;
+	rdb2rdftest:output "directGraph.nt" ;
+.
+
+<tc0000> a rdb2rdftest:R2RML ;	
+	dcterms:title "Empty table" ; 
+	dcterms:identifier "R2RMLTC000" ;
+	test:purpose "Tests if an empty table produces an empty RDF graph" ;
+	test:specificationReference "#dfn-output-dataset" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d000> ;
+	rdb2rdftest:output "mapped.nq" ;
+	rdb2rdftest:mappingDocument "r2rml.ttl" ;
+.
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D000-1table0rows/mapped.nq	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,1 @@
+# empty database
--- a/D000-1table0rows/mapped.trig	Wed Jul 20 19:12:51 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,1 +0,0 @@
-# empty database
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D001-1table1row/directGraph.nt	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,2 @@
+_:a <Student#Name> "Venus".
+_:a a <Student> .
--- a/D001-1table1row/directGraph.ttl	Wed Jul 20 19:12:51 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,2 +0,0 @@
-_:a <Student#Name> "Venus".
-_:a a <Student> .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D001-1table1row/manifest.ttl	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,45 @@
+@prefix test: <http://www.w3.org/2006/03/test-description#> .
+@prefix dcterms: <http://purl.org/dc/elements/1.1/> .
+@prefix rdb2rdftest: <http://purl.org/NET/rdb2rdf-test#> .
+@base <http://mappingpedia.org/rdb2rdf/tc/> .
+
+<d001> a rdb2rdftest:DataBase;
+	dcterms:title "One table, one row" ;
+	dcterms:identifier "D001-1table1row" ;
+	rdb2rdftest:sqlScriptFile "create.sql";
+	rdb2rdftest:relatedTestCase <dg0001> ;
+	rdb2rdftest:relatedTestCase <tc0001a> ;
+	rdb2rdftest:relatedTestCase <tc0001b> ;
+.
+
+<dg0001> a rdb2rdftest:DirectMapping;	
+	dcterms:title "One table, one row"; 
+	dcterms:identifier "Direct Graph TC0001" ;
+	test:purpose "Tests: (1) one column mapping, no primary key; (2) generation of a \"BlankNode\" subject; (3) one column to one property" ;
+	test:specificationReference "#rules_table_triples" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d001> ;
+	rdb2rdftest:output "directGraph.nt" ;
+.
+
+<tc0001a> a rdb2rdftest:R2RML ;	
+	dcterms:title "One column mapping" ; 
+	dcterms:identifier "R2RMLTC0001a" ;
+	test:purpose "Tests: (1) one column mapping, no primary key; (2) subject URI generation by using one single column; (3) one column to one property" ;
+	test:specificationReference "#dfn-output-dataset" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d001> ;
+	rdb2rdftest:output "mappeda.nq" ;
+	rdb2rdftest:mappingDocument "r2rmla.ttl" ;
+.
+
+<tc0001b> a rdb2rdftest:R2RML ;	
+	dcterms:title "One column mapping" ; 
+	dcterms:identifier "R2RMLTC0001b" ;
+	test:purpose "Tests: (1) one column mapping, no primary key; (2) generation of a \"BlankNode\" subject; (3) one column to one property" ;
+	test:specificationReference "#dfn-output-dataset" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d001> ;
+	rdb2rdftest:output "mappedb.nq" ;
+	rdb2rdftest:mappingDocument "r2rmlb.ttl" ;
+.
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D001-1table1row/mappeda.nq	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,1 @@
+<http://example.com/Venus> <http://xmlns.com/foaf/0.1/name> "Venus" .
--- a/D001-1table1row/mappeda.trig	Wed Jul 20 19:12:51 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-@prefix foaf: <http://xmlns.com/foaf/0.1/> .
-@prefix ex: <http://example.com/> .
-
-ex:Venus foaf:name "Venus".
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D001-1table1row/mappedb.nq	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,1 @@
+_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7fff <http://xmlns.com/foaf/0.1/name> "Venus" .
--- a/D001-1table1row/mappedb.trig	Wed Jul 20 19:12:51 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-@prefix foaf: <http://xmlns.com/foaf/0.1/> .
-@prefix ex: <http://example.com/> .
-
-_:Venus foaf:name "Venus".
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D002-1table2columns1row/directGraph.nt	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,3 @@
+_:a a <Student> .
+_:a <Student#id> 10 .
+_:a <Student#name> "Venus" .
--- a/D002-1table2columns1row/directGraph.ttl	Wed Jul 20 19:12:51 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-_:a a <Student> .
-_:a <Student#id> 10 .
-_:a <Student#name> "Venus" .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D002-1table2columns1row/manifest.ttl	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,45 @@
+@prefix test: <http://www.w3.org/2006/03/test-description#> .
+@prefix dcterms: <http://purl.org/dc/elements/1.1/> .
+@prefix rdb2rdftest: <http://purl.org/NET/rdb2rdf-test#> .
+@base <http://mappingpedia.org/rdb2rdf/tc/> .
+
+<d002> a rdb2rdftest:DataBase;
+	dcterms:title "One table, two columns, one row" ;
+	dcterms:identifier "D002-1table2columns1row" ;
+	rdb2rdftest:sqlScriptFile "create.sql";
+	rdb2rdftest:relatedTestCase <dg0002> ;
+	rdb2rdftest:relatedTestCase <tc0002a> ;
+	rdb2rdftest:relatedTestCase <tc0002b> ;
+.
+
+<dg0002> a rdb2rdftest:DirectMapping ;	
+	dcterms:title "Two columns mapping" ; 
+	dcterms:identifier "Direct Graph TC0002" ;
+	test:purpose "Tests: (1) two columns mapping, no primary key; (2) generation of a \"BlankNode\" subject; (3) one column to one property" ;
+	test:specificationReference "#rules_table_triples" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d002> ;
+	rdb2rdftest:output "directGraph.n3" ;
+.
+
+<tc0002a> a rdb2rdftest:R2RML ;	
+	dcterms:title "Two columns mapping" ; 
+	dcterms:identifier "R2RMLTC0002a" ;
+	test:purpose "Tests: (1) two column mapping, no primary key; (2) subject URI generated by concatenation of two column values; (3) one column to one property" ;
+	test:specificationReference "#dfn-output-dataset" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d002> ;
+	rdb2rdftest:output "mappeda.nq" ;
+	rdb2rdftest:mappingDocument "r2rmla.ttl" ;
+.
+
+<tc0002b> a rdb2rdftest:R2RML ;	
+	dcterms:title "Two columns mapping" ; 
+	dcterms:identifier "R2RMLTC0002b" ;
+	test:purpose "Tests: (1) two column mapping, no primary key; (2) generation of a \"BlankNode\" subject; (3) one column to one property" ;
+	test:specificationReference "#dfn-output-dataset" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d002> ;
+	rdb2rdftest:output "mappedb.nq" ;
+	rdb2rdftest:mappingDocument "r2rmlb.ttl" ;
+.
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D002-1table2columns1row/mappeda.nq	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,3 @@
+<http://example.com/10Venus> <http://xmlns.com/foaf/0.1/name> "Venus" .
+<http://example.com/10Venus> <http://example.com/id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
+<http://example.com/10Venus> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
--- a/D002-1table2columns1row/mappeda.trig	Wed Jul 20 19:12:51 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,8 +0,0 @@
-@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
-@prefix foaf: <http://xmlns.com/foaf/0.1/> .
-@prefix ex: <http://example.com/> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-
-ex:10Venus rdf:type foaf:Person;
-           ex:id "10"^^xsd:integer;
-           foaf:name "Venus".
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D002-1table2columns1row/mappedb.nq	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,3 @@
+_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ffd <http://xmlns.com/foaf/0.1/name> "Venus" .
+_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ffd <http://example.com/id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
+_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ffd <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
--- a/D002-1table2columns1row/mappedb.trig	Wed Jul 20 19:12:51 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,8 +0,0 @@
-@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
-@prefix foaf: <http://xmlns.com/foaf/0.1/> .
-@prefix ex: <http://example.com/> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-
-_:Student10 rdf:type foaf:Person;
-            ex:id "10"^^xsd:integer;
-            foaf:name "Venus". 
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/directGraph.nt	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,4 @@
+_:a a <Student> .
+_:a <Student#ID> 10 .
+_:a <Student#FirstName> "Venus" .
+_:a <Student#LastName> "Williams" .
--- a/D003-1table3columns1row/directGraph.ttl	Wed Jul 20 19:12:51 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-_:a a <Student> .
-_:a <Student#ID> 10 .
-_:a <Student#FirstName> "Venus" .
-_:a <Student#LastName> "Williams" .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/manifest.ttl	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,69 @@
+@prefix test: <http://www.w3.org/2006/03/test-description#> .
+@prefix dcterms: <http://purl.org/dc/elements/1.1/> .
+@prefix rdb2rdftest: <http://purl.org/NET/rdb2rdf-test#> .
+@base <http://mappingpedia.org/rdb2rdf/tc/> .
+
+<d003> a rdb2rdftest:DataBase;
+	dcterms:title "One table, two columns, one row" ;
+	dcterms:identifier "D003-1table3columns1row" ;
+	rdb2rdftest:sqlScriptFile "create.sql";
+	rdb2rdftest:relatedTestCase <dg0003> ;
+	rdb2rdftest:relatedTestCase <tc0003a> ;
+	rdb2rdftest:relatedTestCase <tc0003b> ;
+	rdb2rdftest:relatedTestCase <tc0003c> ;
+	rdb2rdftest:relatedTestCase <tc0003d> ;
+.
+
+<dg0003> a rdb2rdftest:DirectMapping ;	
+	dcterms:title "Three column mapping"; 
+	dcterms:identifier "Direct Graph TC0003" ;
+	test:purpose "Tests: (1) three column mapping, no primary key; (2) Generation of a \"BlankNode\" subject; (3) One column to one property" ;
+	test:specificationReference "#rules_table_triples" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d003> ;
+	rdb2rdftest:output "directGraph.nt" ;
+.
+
+<tc0003a> a rdb2rdftest:R2RML ;	
+	dcterms:title "Two columns mapping" ; 
+	dcterms:identifier "R2RMLTC0003a" ;
+	test:purpose "Tests: (1)three column mapping, no primary key; (2) Subject URI generated by concatenation of three column values and a constant value; (3) One column to one property" ;
+	test:specificationReference "#dfn-output-dataset" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d003> ;
+	rdb2rdftest:output "mappeda.nq" ;
+	rdb2rdftest:mappingDocument "r2rmla.ttl" ;
+.
+
+<tc0003b> a rdb2rdftest:R2RML ;	
+	dcterms:title "Two column mapping, a concatenation operation" ; 
+	dcterms:identifier "R2RMLTC0003b" ;
+	test:purpose "Tests: (1) two column mapping, no primary key; (2) subject URI generated by concatenation of three column values and a constant value; (3) Two column to one property – concat operation" ;
+	test:specificationReference "#dfn-output-dataset" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d003> ;
+	rdb2rdftest:output "mappedb.nq" ;
+	rdb2rdftest:mappingDocument "r2rmlb.ttl" ;
+.
+
+<tc0003c> a rdb2rdftest:R2RML ;	
+	dcterms:title "Three column mapping" ; 
+	dcterms:identifier "R2RMLTC0003c" ;
+	test:purpose "Tests: (1) three column mapping, no primary key; (2) Generation of a \"BlankNode\" subject; (3) One column to one property" ;
+	test:specificationReference "#dfn-output-dataset" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d003> ;
+	rdb2rdftest:output "mappedc.nq" ;
+	rdb2rdftest:mappingDocument "r2rmlc.ttl" ;
+.
+
+<tc0003d> a rdb2rdftest:R2RML ;	
+	dcterms:title "Two column mapping, a concatenation operation" ; 
+	dcterms:identifier "R2RMLTC0003d" ;
+	test:purpose "Tests: (1) two column mapping, no primary key; (2) Generation of a \"BlankNode\" subject; (3) Two column to one property – concat operation" ;
+	test:specificationReference "#dfn-output-dataset" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d003> ;
+	rdb2rdftest:output "mappedd.nq" ;
+	rdb2rdftest:mappingDocument "r2rmld.ttl" ;
+.
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/mappeda.nq	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,4 @@
+<http://example.com/Student10VenusWilliams> <http://xmlns.com/foaf/0.1/lastName> "Williams" .
+<http://example.com/Student10VenusWilliams> <http://xmlns.com/foaf/0.1/firstName> "Venus" .
+<http://example.com/Student10VenusWilliams> <http://example.com/id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
+<http://example.com/Student10VenusWilliams> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
--- a/D003-1table3columns1row/mappeda.trig	Wed Jul 20 19:12:51 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,9 +0,0 @@
-@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
-@prefix foaf: <http://xmlns.com/foaf/0.1/> .
-@prefix ex: <http://example.com/> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-
-ex:Student10VenusWilliams rdf:type foaf:Person;
-                          ex:id "10"^^xsd:integer;
-                          foaf:firstName "Venus";
-                          foaf:lastName "Williams".
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/mappedb.nq	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,3 @@
+<http://example.com/Student10VenusWilliams> <http://xmlns.com/foaf/0.1/name> "Venus Williams" .
+<http://example.com/Student10VenusWilliams> <http://example.com/id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
+<http://example.com/Student10VenusWilliams> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
--- a/D003-1table3columns1row/mappedb.trig	Wed Jul 20 19:12:51 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,8 +0,0 @@
-@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
-@prefix foaf: <http://xmlns.com/foaf/0.1/> .
-@prefix ex: <http://example.com/> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-
-ex:Student10VenusWilliams rdf:type foaf:Person;
-                          ex:id "10"^^xsd:integer;
-                          foaf:name "Venus Williams". 
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/mappedc.nq	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,4 @@
+_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ffb <http://xmlns.com/foaf/0.1/lastName> "Williams" .
+_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ffb <http://xmlns.com/foaf/0.1/firstName> "Venus" .
+_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ffb <http://example.com/id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
+_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ffb <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
--- a/D003-1table3columns1row/mappedc.trig	Wed Jul 20 19:12:51 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,9 +0,0 @@
-@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
-@prefix foaf: <http://xmlns.com/foaf/0.1/> .
-@prefix ex: <http://example.com/> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-
-_:Student10VenusWilliams rdf:type foaf:Person;
-                         ex:id "10"^^xsd:integer;
-                         foaf:firstName "Venus";
-                         foaf:lastName "Williams". 
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/mappedd.nq	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,3 @@
+_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff9 <http://xmlns.com/foaf/0.1/name> "Venus Williams" .
+_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff9 <http://example.com/id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
+_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff9 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
--- a/D003-1table3columns1row/mappedd.trig	Wed Jul 20 19:12:51 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,8 +0,0 @@
-@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
-@prefix foaf: <http://xmlns.com/foaf/0.1/> .
-@prefix ex: <http://example.com/> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-
-_:Student10VenusWilliams rdf:type foaf:Person;
-                         ex:id "10"^^xsd:integer;
-                         foaf:name "Venus Williams". 
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D004-1table2columnsprojection/directGraph.nt	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,3 @@
+_:a a <Student_Sport> .
+_:a <Student_Sport#Student> "Venus" .
+_:a <Student_Sport#Sport> "Tennis" .
--- a/D004-1table2columnsprojection/directGraph.ttl	Wed Jul 20 19:12:51 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-_:a a <Student_Sport> .
-_:a <Student_Sport#Student> "Venus" .
-_:a <Student_Sport#Sport> "Tennis" .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D004-1table2columnsprojection/manifest.ttl	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,45 @@
+@prefix test: <http://www.w3.org/2006/03/test-description#> .
+@prefix dcterms: <http://purl.org/dc/elements/1.1/> .
+@prefix rdb2rdftest: <http://purl.org/NET/rdb2rdf-test#> .
+@base <http://mappingpedia.org/rdb2rdf/tc/> .
+
+<d004> a rdb2rdftest:DataBase;
+	dcterms:title "One table, two columns, projection" ;
+	dcterms:identifier "D004-1table2columnsprojection" ;
+	rdb2rdftest:sqlScriptFile "create.sql";
+	rdb2rdftest:relatedTestCase <dg0004> ;
+	rdb2rdftest:relatedTestCase <tc0004a> ;
+	rdb2rdftest:relatedTestCase <tc0004b> ;
+.
+
+<dg0004> a rdb2rdftest:DirectMapping ;	
+	dcterms:title "Three column mapping"; 
+	dcterms:identifier "Direct Graph TC0004" ;
+	test:purpose "Tests: (1) two column mapping, no primary key, (2) generation of a \"BlankNode\" subject; (3) one row table to two different resources" ;
+	test:specificationReference "#rules_table_triples" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d004> ;
+	rdb2rdftest:output "directGraph.nt" ;
+.
+
+<tc0004a> a rdb2rdftest:R2RML ;	
+	dcterms:title "Projection" ; 
+	dcterms:identifier "R2RMLTC0004a" ;
+	test:purpose "Tests: (1) two column mapping, no primary key, (2) subject URI generated by a column value; (3) one row table to two different resources" ;
+	test:specificationReference "#dfn-output-dataset" ;
+	test:reviewStatus test:unreviewed ;
+	rdb2rdftest:database <d004> ;
+	rdb2rdftest:output "mappeda.nq" ;
+	rdb2rdftest:mappingDocument "r2rmla.ttl" ;
+.
+
+<tc0004b> a rdb2rdftest:R2RML ;	
+	dcterms:title "Projection" ; 
+	dcterms:identifier "R2RMLTC0004b" ;
+	test:purpose "Tests: (1) two column mapping, no primary key, (2) generation of a \"BlankNode\" subject; (3) one row table to two different resources" ;
+	test:specificationReference "#dfn-output-dataset" ;
+	test:reviewStatus test:unreviewed ;
+	rdb2rdftest:database <d004> ;
+	rdb2rdftest:output "mappedb.nq" ;
+	rdb2rdftest:mappingDocument "r2rmlb.ttl" ;
+.
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D004-1table2columnsprojection/mappeda.nq	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,4 @@
+<http://example.com/Venus> <http://xmlns.com/foaf/0.1/name> "Venus" .
+<http://example.com/Venus> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/Student> .
+<http://example.com/Tennis> <http://xmlns.com/foaf/0.1/name> "Tennis" .
+<http://example.com/Tennis> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/Sport> .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D004-1table2columnsprojection/mappedb.nq	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,4 @@
+_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff6 <http://xmlns.com/foaf/0.1/name> "Tennis" .
+_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff6 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/Sport> .
+_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff7 <http://xmlns.com/foaf/0.1/name> "Venus" .
+_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff7 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/Student> .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D004-1table2columnsprojection/r2rmla.ttl	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,36 @@
+@prefix rr: <http://www.w3.org/ns/r2rml#> .
+@prefix foaf: <http://xmlns.com/foaf/0.1/> .
+@prefix ex: <http://example.com/> .
+@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
+@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
+
+<TriplesMap1>
+    a rr:TriplesMapClass;
+
+    rr:tableOwner "boricles";
+    rr:tableName "Student_Sport";
+
+    rr:subjectMap [ rr:template "http://example.com/{Student}";
+                    rr:class ex:Student ];
+	
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate foaf:name ]; 
+      rr:objectMap    [ rr:column "Student" ]
+    ]
+    .
+
+<TriplesMap2>
+    a rr:TriplesMapClass;
+
+    rr:tableOwner "boricles";
+    rr:tableName "Student_Sport";
+
+    rr:subjectMap [ rr:template "http://example.com/{Sport}";
+                    rr:class ex:Sport  ];
+	
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate foaf:name ]; 
+      rr:objectMap    [ rr:column "Sport" ]
+    ]
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D004-1table2columnsprojection/r2rmlb.ttl	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,41 @@
+@prefix rr: <http://www.w3.org/ns/r2rml#> .
+@prefix foaf: <http://xmlns.com/foaf/0.1/> .
+@prefix ex: <http://example.com/> .
+@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
+@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
+
+<TriplesMap1>
+    a rr:TriplesMapClass;
+
+      rr:SQLQuery """
+       Select ('Student' || Student) AS StudentId
+         from Student_Sport
+       """;
+
+    rr:subjectMap [ rr:column "StudentId"; rr:termtype "BlankNode";
+                    rr:class ex:Student ];
+	
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate foaf:name ]; 
+      rr:objectMap    [ rr:column "Student" ]
+    ]
+    .
+
+<TriplesMap2>
+    a rr:TriplesMapClass;
+
+      rr:SQLQuery """
+       Select ('Sport' || Sport) AS SportId
+         from Student_Sport
+       """;
+
+    rr:subjectMap [ rr:column "SportId"; rr:termtype "BlankNode";
+                    rr:class ex:Sport  ];
+	
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate foaf:name ]; 
+      rr:objectMap    [ rr:column "Sport" ]
+    ]
+	.
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D005-2duplicates0nulls/directGraph.nt	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,17 @@
+@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
+  
+  _:a a <IOUs> .
+  _:a <IOUs#fname> "Bob" .
+  _:a <IOUs#lname> "Smith" .
+  _:a <IOUs#amount> "30"^^xsd:float .
+  
+  _:b a <IOUs> .
+  _:b <IOUs#fname> "Sue" .
+  _:b <IOUs#lname> "Jones" .
+  _:b <IOUs#amount> "20"^^xsd:float .
+  
+  _:c a <IOUs> .
+  _:c <IOUs#fname> "Bob" .
+  _:c <IOUs#lname> "Smith" .
+  _:c <IOUs#amount> "30"^^xsd:float .
+
--- a/D005-2duplicates0nulls/directGraph.ttl	Wed Jul 20 19:12:51 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,17 +0,0 @@
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-  
-  _:a a <IOUs> .
-  _:a <IOUs#fname> "Bob" .
-  _:a <IOUs#lname> "Smith" .
-  _:a <IOUs#amount> "30"^^xsd:float .
-  
-  _:b a <IOUs> .
-  _:b <IOUs#fname> "Sue" .
-  _:b <IOUs#lname> "Jones" .
-  _:b <IOUs#amount> "20"^^xsd:float .
-  
-  _:c a <IOUs> .
-  _:c <IOUs#fname> "Bob" .
-  _:c <IOUs#lname> "Smith" .
-  _:c <IOUs#amount> "30"^^xsd:float .
-
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D005-2duplicates0nulls/manifest.ttl	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,21 @@
+@prefix test: <http://www.w3.org/2006/03/test-description#> .
+@prefix dcterms: <http://purl.org/dc/elements/1.1/> .
+@prefix rdb2rdftest: <http://purl.org/NET/rdb2rdf-test#> .
+@base <http://mappingpedia.org/rdb2rdf/tc/> .
+
+<d005> a rdb2rdftest:DataBase;
+	dcterms:title "Duplicate tuples, no primary key" ;
+	dcterms:identifier "D005-2duplicates0nulls" ;
+	rdb2rdftest:sqlScriptFile "create.sql";
+	rdb2rdftest:relatedTestCase <dg0005> ;
+.
+
+<dg0005> a rdb2rdftest:DirectMapping ;	
+	dcterms:title "Duplicate tuples, no primary key"; 
+	dcterms:identifier "Direct Graph TC0005" ;
+	test:purpose "Tests the generation of Blank Nodes for duplicate tuples" ;
+	test:specificationReference "#rules_table_triples" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d005> ;
+	rdb2rdftest:output "directGraph.nt" ;
+.
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D006-1table1primarykey1column1row/create.sql	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,4 @@
+CREATE TABLE Student (
+Name varchar(50) PRIMARY KEY
+);
+INSERT INTO Student (Name) VALUES ("Venus");
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D006-1table1primarykey1column1row/directGraph.nt	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,3 @@
+<Student/Name.Venus#_> <Student#Name> "Venus" .
+<Student/Name.Venus#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
+
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D006-1table1primarykey1column1row/manifest.ttl	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,21 @@
+@prefix test: <http://www.w3.org/2006/03/test-description#> .
+@prefix dcterms: <http://purl.org/dc/elements/1.1/> .
+@prefix rdb2rdftest: <http://purl.org/NET/rdb2rdf-test#> .
+@base <http://mappingpedia.org/rdb2rdf/tc/> .
+
+<d006> a rdb2rdftest:DataBase;
+	dcterms:title "One table, one column, one primary key" ;
+	dcterms:identifier "D006-1table1primarykey1column1row" ;
+	rdb2rdftest:sqlScriptFile "create.sql";
+	rdb2rdftest:relatedTestCase <dg0006> ;
+.
+
+<dg0006> a rdb2rdftest:DirectMapping ;	
+	dcterms:title "One table, one column, one primary key"; 
+	dcterms:identifier "Direct Graph TC0006" ;
+	test:purpose "Tests a table with a column that is a primary key" ;
+	test:specificationReference "#rules_table_triples" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d006> ;
+	rdb2rdftest:output "directGraph.nt" ;
+.
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D007-1table1primarykey2columns1row/create.sql	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,6 @@
+CREATE TABLE Student (
+ID integer,
+Name varchar(50),
+PRIMARY KEY (ID)
+);
+INSERT INTO Student (ID, Name) VALUES(10,"Venus");
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D007-1table1primarykey2columns1row/directGraph.nt	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,3 @@
+<Student/ID.10#_> <Student#ID> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
+<Student/ID.10#_> <Student#Name> "Venus" .
+<Student/ID.10#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D007-1table1primarykey2columns1row/manifest.ttl	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,21 @@
+@prefix test: <http://www.w3.org/2006/03/test-description#> .
+@prefix dcterms: <http://purl.org/dc/elements/1.1/> .
+@prefix rdb2rdftest: <http://purl.org/NET/rdb2rdf-test#> .
+@base <http://mappingpedia.org/rdb2rdf/tc/> .
+
+<d007> a rdb2rdftest:DataBase;
+	dcterms:title "One table, one column, one primary key" ;
+	dcterms:identifier "D007-1table1primarykey2columns1row" ;
+	rdb2rdftest:sqlScriptFile "create.sql";
+	rdb2rdftest:relatedTestCase <dg0007> ;
+.
+
+<dg0007> a rdb2rdftest:DirectMapping ;	
+	dcterms:title "A table with a primary key and 2 columns"; 
+	dcterms:identifier "Direct Graph TC0007" ;
+	test:purpose "Tests a table with a primary key and 2 columns" ;
+	test:specificationReference "#rules_table_triples" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d007> ;
+	rdb2rdftest:output "directGraph.nt" ;
+.
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D008-1table1compositeprimarykey3columns1row/create.sql	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,7 @@
+CREATE TABLE Student (
+ID integer,
+Name varchar(50),
+Sport varchar (50),
+PRIMARY KEY (ID,Name)
+);
+INSERT INTO Student (ID, Name,Sport) VALUES(10,"Venus Williams","Tennis");
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D008-1table1compositeprimarykey3columns1row/directGraph.nt	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,5 @@
+<Student/ID.10_Name.Venus+Williams#_> <Student#ID> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
+<Student/ID.10_Name.Venus+Williams#_> <Student#Name> "Venus Williams" .
+<Student/ID.10_Name.Venus+Williams#_> <Student#Sport> "Tennis" .
+<Student/ID.10_Name.Venus+Williams#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
+
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D008-1table1compositeprimarykey3columns1row/manifest.ttl	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,21 @@
+@prefix test: <http://www.w3.org/2006/03/test-description#> .
+@prefix dcterms: <http://purl.org/dc/elements/1.1/> .
+@prefix rdb2rdftest: <http://purl.org/NET/rdb2rdf-test#> .
+@base <http://mappingpedia.org/rdb2rdf/tc/> .
+
+<d008> a rdb2rdftest:DataBase;
+	dcterms:title "Composite primary key" ;
+	dcterms:identifier "D008-1table1compositeprimarykey3columns1row" ;
+	rdb2rdftest:sqlScriptFile "create.sql";
+	rdb2rdftest:relatedTestCase <dg0008> ;
+.
+
+<dg0008> a rdb2rdftest:DirectMapping ;	
+	dcterms:title "Composite primary key"; 
+	dcterms:identifier "Direct Graph TC0008" ;
+	test:purpose "Tests a table with a composite primary key" ;
+	test:specificationReference "#rules_table_triples" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d008> ;
+	rdb2rdftest:output "directGraph.nt" ;
+.
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D009-2tables1primarykey1foreingkey/directGraph.nt	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,13 @@
+<Student/ID.20#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
+<Student/ID.20#_> <Student#ID> "20"^^<http://www.w3.org/2001/XMLSchema#integer> .
+<Student/ID.20#_> <Student#Name> "Demi Moore" .
+
+<Student/ID.10#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
+<Student/ID.10#_> <Student#ID> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
+<Student/ID.10#_> <Student#Name> "Venus Williams" .
+<Student/ID.10#_> <Student#Sport> <Sport/ID.100#_> .
+
+<Sport/ID.100#_> <Sport#ID> "100"^^<http://www.w3.org/2001/XMLSchema#integer> .
+<Sport/ID.100#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Sport> .
+<Sport/ID.100#_> <Sport#Name> "Tennis" .
+
--- a/D009-2tables1primarykey1foreingkey/directGraph.ttl	Wed Jul 20 19:12:51 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,13 +0,0 @@
-<Student/ID.20#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
-<Student/ID.20#_> <Student#ID> "20"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<Student/ID.20#_> <Student#Name> "Demi Moore" .
-
-<Student/ID.10#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
-<Student/ID.10#_> <Student#ID> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<Student/ID.10#_> <Student#Name> "Venus Williams" .
-<Student/ID.10#_> <Student#Sport> <Sport/ID.100#_> .
-
-<Sport/ID.100#_> <Sport#ID> "100"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<Sport/ID.100#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Sport> .
-<Sport/ID.100#_> <Sport#Name> "Tennis" .
-
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D009-2tables1primarykey1foreingkey/manifest.ttl	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,33 @@
+@prefix test: <http://www.w3.org/2006/03/test-description#> .
+@prefix dcterms: <http://purl.org/dc/elements/1.1/> .
+@prefix rdb2rdftest: <http://purl.org/NET/rdb2rdf-test#> .
+@base <http://mappingpedia.org/rdb2rdf/tc/> .
+
+<d009> a rdb2rdftest:DataBase;
+	dcterms:title "Two tables 1 primary key 1 foreing key" ;
+	dcterms:identifier "D009-2tables1primarykey1foreingkey" ;
+	rdb2rdftest:sqlScriptFile "create.sql";
+	rdb2rdftest:relatedTestCase <dg0009> ;
+	rdb2rdftest:relatedTestCase <tc0009> ;
+.
+
+<dg0009> a rdb2rdftest:DirectMapping ;	
+	dcterms:title "Two tables 1 primary key 1 foreing key"; 
+	dcterms:identifier "Direct Graph TC0009" ;
+	test:purpose "Tests two tables with a primary key and a foreing key" ;
+	test:specificationReference "#rules_table_triples" ;
+	test:reviewStatus test:accepted ;
+	rdb2rdftest:database <d009> ;
+	rdb2rdftest:output "directGraph.nt" ;
+.
+
+<tc0009> a rdb2rdftest:R2RML ;	
+	dcterms:title "Two tables to multiple graphs" ; 
+	dcterms:identifier "R2RMLTC009" ;
+	test:purpose "Test that results from distinct parts of the mapping can be directed to different target graphs." ;
+	test:specificationReference "#dfn-output-dataset" ;
+	test:reviewStatus test:unreviewed ;
+	rdb2rdftest:database <d009> ;
+	rdb2rdftest:output "mapped.nq" ;
+	rdb2rdftest:mappingDocument "r2rml.ttl" ;
+.
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D009-2tables1primarykey1foreingkey/mapped.nq	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,7 @@
+<http://example.com/resource/student_10> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/ontology/Student> <http://example.org/graph/students> .
+<http://example.com/resource/student_10> <http://xmlns.com/foaf/0.1/name> "Venus Williams" <http://example.org/graph/students> .
+<http://example.com/resource/student_20> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/ontology/Student> <http://example.org/graph/students>.
+<http://example.com/resource/student_20> <http://xmlns.com/foaf/0.1/name> "Demi Moore" <http://example.org/graph/students> .
+<http://example.com/resource/sport_100> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/ontology/Sport> <http://example.org/graph/sports> .
+<http://example.com/resource/sport_100> <http://www.w3.org/2000/01/rdf-schema#label> "Tennis" <http://example.org/graph/sports> .
+<http://example.com/resource/student_10> <http://example.com/ontology/practises> <http://example.com/resource/sport_100> <http://example.org/graph/practise> .
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D009-2tables1primarykey1foreingkey/r2rml.ttl	Wed Jul 20 19:25:08 2011 +0100
@@ -0,0 +1,65 @@
+@prefix rr: <http://www.w3.org/ns/r2rml#> .
+@prefix foaf: <http://xmlns.com/foaf/0.1/> .
+@prefix ex: <http://example.com/> .
+@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
+@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
+
+<TriplesMap1>
+    a rr:TriplesMapClass;
+        
+    rr:tableOwner "alex";
+    rr:tableName "Student";
+
+    rr:subjectMap 
+    [ 
+        rr:template "http://example.com/resource/student_{ID}";
+        rr:termType "IRI";
+        rr:class <http://example.com/ontology/Student>;
+        rr.graph <http://example.com/graph/students>;
+    ]; 
+	
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate foaf:name ]; 
+      rr:objectMap    [ 
+             rr:column "Name";
+             rr:termType "Literal";
+      ];
+      rr.graph <http://example.com/graph/students>;
+    ];
+
+    rr:refPredicateObjectMap
+    [ 
+      rr:refPredicateMap [ rr:predicate ex:ontology/practises ]; 
+      rr:refObjectMap    [ 
+           rr:parentTriplesMap <TriplesMap2>;
+           rr:joinCondition "child.{Sport} = parent.{ID}".
+      ];
+      rr.graph <http://example.com/graph/practise>;
+    ];
+    .
+
+<TriplesMap2>
+    a rr:TriplesMapClass;
+        
+    rr:tableOwner "alex";
+    rr:tableName "Sport";
+
+    rr:subjectMap 
+    [ 
+        rr:template "http://example.com/resource/sport_{ID}";
+        rr:termType "IRI";
+        rr:class <http://example.com/ontology/Sport>;
+        rr.graph <http://example.com/graph/sports>;
+    ]; 
+	
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate rdf:label ]; 
+      rr:objectMap    [ 
+             rr:column "Name"; 
+             rr:termType "Literal";
+      ];
+      rr.graph <http://example.com/graph/sports>;
+    ];
+	.
\ No newline at end of file