--- a/1table0rows/create.sql Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-CREATE TABLE Student (
- Name varchar(50)
-);
--- a/1table0rows/directGraph.ttl Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,1 +0,0 @@
-# empty graph
--- a/1table0rows/mapped.trig Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,1 +0,0 @@
-# empty database
--- a/1table0rows/r2rml.ttl Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,20 +0,0 @@
-@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";
-
- rr:subjectMap [ rr:template "http://example.com/{Name}" ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [ rr:column "Name" ]
- ]
- .
\ No newline at end of file
--- a/1table1compositeprimarykey3columns1row/create.sql Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,7 +0,0 @@
-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");
--- a/1table1compositeprimarykey3columns1row/directGraph.ttl Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,5 +0,0 @@
-<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> .
-
--- a/1table1primarykey1column1row/create.sql Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-CREATE TABLE Student (
-Name varchar(50) PRIMARY KEY
-);
-INSERT INTO Student (Name) VALUES ("Venus");
--- a/1table1primarykey1column1row/directGraph.ttl Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-<Student/Name.Venus#_> <Student#Name> "Venus" .
-<Student/Name.Venus#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
-
--- a/1table1row/create.sql Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-CREATE TABLE Student (
-Name varchar(50)
-);
-INSERT INTO Student (Name) VALUES ("Venus");
--- a/1table1row/directGraph.ttl Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,2 +0,0 @@
-_:a <Student#Name> "Venus".
-_:a a <Student> .
--- a/1table1row/mappeda.trig Sun Mar 13 12:13:44 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".
--- a/1table1row/mappedb.trig Sun Mar 13 12:13:44 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".
--- a/1table1row/r2rmla.ttl Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,20 +0,0 @@
-@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";
-
- rr:subjectMap [ rr:template "http://example.com/{Name}" ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [ rr:column "Name" ]
- ]
- .
\ No newline at end of file
--- a/1table1row/r2rmlb.ttl Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,20 +0,0 @@
-@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";
-
- rr:subjectMap [ rr:column "Name"; rr:termtype "BlankNode" ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [ rr:column "Name" ]
- ]
- .
\ No newline at end of file
--- a/1table2columns1row/create.sql Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,5 +0,0 @@
-CREATE TABLE Student (
-ID integer,
-Name varchar(50)
-);
-INSERT INTO Student (ID, Name) VALUES(10,"Venus");
--- a/1table2columns1row/directGraph.ttl Sun Mar 13 12:13:44 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" .
--- a/1table2columns1row/mappeda.trig Sun Mar 13 12:13:44 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
--- a/1table2columns1row/mappedb.trig Sun Mar 13 12:13:44 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
--- a/1table2columns1row/r2rmla.ttl Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,27 +0,0 @@
-@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";
-
- rr:subjectMap [ rr:template "http://example.com/{ID}{Name}";
- rr:class foaf:Person ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:id ];
- rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [ rr:column "Name" ]
- ]
- .
--- a/1table2columns1row/r2rmlb.ttl Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,30 +0,0 @@
-@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' || ID ) AS "StudentId"
- , ID
- , Name
- from Student
- """;
-
- rr:subjectMap [ rr:column "StudentId"; rr:termtype "BlankNode"; rr:class foaf:Person ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:id ];
- rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [ rr:column "Name" ]
- ]
- .
\ No newline at end of file
--- a/1table2columnsprojection/create.sql Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,5 +0,0 @@
-CREATE TABLE Student_Sport(
- Student varchar(50),
- Sport varchar(50)
-);
-INSERT INTO Student_Sport (Student,Sport) VALUES ("Venus", "Tennis");
--- a/1table2columnsprojection/directGraph.ttl Sun Mar 13 12:13:44 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" .
--- a/1table3columns1row/create.sql Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,6 +0,0 @@
-CREATE TABLE Student (
-ID integer,
-FirstName varchar(50),
-LastName varchar(50)
-);
-INSERT INTO Student (ID, FirstName, LastName) VALUES (10,"Venus", "Williams");
--- a/1table3columns1row/directGraph.ttl Sun Mar 13 12:13:44 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" .
--- a/1table3columns1row/mappeda.trig Sun Mar 13 12:13:44 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".
\ No newline at end of file
--- a/1table3columns1row/mappedb.trig Sun Mar 13 12:13:44 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".
\ No newline at end of file
--- a/1table3columns1row/mappedc.trig Sun Mar 13 12:13:44 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".
\ No newline at end of file
--- a/1table3columns1row/mappedd.trig Sun Mar 13 12:13:44 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".
\ No newline at end of file
--- a/1table3columns1row/r2rmla.ttl Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,33 +0,0 @@
-@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";
-
- rr:subjectMap [ rr:template "http://example.com/Student{ID}{FirstName}{LastName}";
- rr:class foaf:Person ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:id ];
- rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:firstName ];
- rr:objectMap [ rr:column "FirstName" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:lastName ];
- rr:objectMap [ rr:column "LastName" ]
- ]
- .
\ No newline at end of file
--- a/1table3columns1row/r2rmlb.ttl Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,32 +0,0 @@
-@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 ID,
- (FirstName || ' ' || LastName) AS Name,
- FirstName,
- LastName
- FROM Student
- """;
-
- rr:subjectMap [ rr:template "http://example.com/Student{ID}{FirstName}{LastName}";
- rr:class foaf:Person ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:id ];
- rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [ rr:column "Name" ]
- ]
- .
\ No newline at end of file
--- a/1table3columns1row/r2rmlc.ttl Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,38 +0,0 @@
-@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' || ID || FirstName || LastName) as StudentID,
- ID,
- FirstName,
- LastName
- FROM Student
- """;
-
- rr:subjectMap [ rr:column "StudentID"; rr:termtype "BlankNode";
- rr:class foaf:Person ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:id ];
- rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:firstName ];
- rr:objectMap [ rr:column "FirstName" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:lastName ];
- rr:objectMap [ rr:column "LastName" ]
- ]
- .
\ No newline at end of file
--- a/1table3columns1row/r2rmld.ttl Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,31 +0,0 @@
-@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' || ID || FirstName || LastName) as StudentID,
- ID,
- (FirstName || ' ' || LastName) AS Name
- FROM Student
- """;
-
- rr:subjectMap [ rr:column "StudentID"; rr:termtype "BlankNode";
- rr:class foaf:Person ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:id ];
- rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [ rr:column "Name" ]
- ]
- .
\ No newline at end of file
--- a/2duplicates0nulls/create.sql Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,7 +0,0 @@
-CREATE TABLE IOUs (
- fname CHAR(20),
- lname CHAR(20),
- amount FLOAT);
-INSERT INTO IOUs (fname, lname, amount) VALUES ("Bob", "Smith", 30);
-INSERT INTO IOUs (fname, lname, amount) VALUES ("Sue", "Jones", 20);
-INSERT INTO IOUs (fname, lname, amount) VALUES ("Bob", "Smith", 30);
--- a/2duplicates0nulls/directGraph.ttl Sun Mar 13 12:13:44 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 .
-
--- a/2tables1primarykey1foreingkey/create.sql Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,17 +0,0 @@
-CREATE TABLE Student (
-ID integer,
-Name varchar(50),
-Sport integer,
-PRIMARY KEY (ID),
-FOREIGN KEY(Sport) REFERENCES Sport(ID)
-);
-
-CREATE TABLE Sport (
-ID integer,
-Name varchar (50),
-PRIMARY KEY (ID)
-);
-
-INSERT INTO Student (ID, Name, Sport) VALUES (10,"Venus Williams", 100);
-INSERT INTO Student (ID, Name, Sport) VALUES (20,"Demi Moore", NULL);
-INSERT INTO Sport (ID, Name) VALUES (100,"Tennis");
--- a/2tables1primarykey1foreingkey/directGraph.ttl Sun Mar 13 12:13:44 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/D000-1table0rows/create.sql Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,3 @@
+CREATE TABLE Student (
+ Name varchar(50)
+);
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D000-1table0rows/directGraph.ttl Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,1 @@
+# empty graph
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D000-1table0rows/mapped.trig Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,1 @@
+# empty database
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D000-1table0rows/r2rml.ttl Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,20 @@
+@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";
+
+ rr:subjectMap [ rr:template "http://example.com/{Name}" ];
+
+ rr:predicateObjectMap
+ [
+ rr:predicateMap [ rr:predicate foaf:name ];
+ rr:objectMap [ rr:column "Name" ]
+ ]
+ .
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D001-1table1row/create.sql Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,4 @@
+CREATE TABLE Student (
+Name varchar(50)
+);
+INSERT INTO Student (Name) VALUES ("Venus");
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D001-1table1row/directGraph.ttl Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,2 @@
+_:a <Student#Name> "Venus".
+_:a a <Student> .
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D001-1table1row/mappeda.trig Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,4 @@
+@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.trig Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,4 @@
+@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/D001-1table1row/r2rmla.ttl Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,20 @@
+@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";
+
+ rr:subjectMap [ rr:template "http://example.com/{Name}" ];
+
+ rr:predicateObjectMap
+ [
+ rr:predicateMap [ rr:predicate foaf:name ];
+ rr:objectMap [ rr:column "Name" ]
+ ]
+ .
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D001-1table1row/r2rmlb.ttl Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,20 @@
+@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";
+
+ rr:subjectMap [ rr:column "Name"; rr:termtype "BlankNode" ];
+
+ rr:predicateObjectMap
+ [
+ rr:predicateMap [ rr:predicate foaf:name ];
+ rr:objectMap [ rr:column "Name" ]
+ ]
+ .
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D002-1table2columns1row/create.sql Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,5 @@
+CREATE TABLE Student (
+ID integer,
+Name varchar(50)
+);
+INSERT INTO Student (ID, Name) VALUES(10,"Venus");
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D002-1table2columns1row/directGraph.ttl Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,3 @@
+_:a a <Student> .
+_:a <Student#id> 10 .
+_:a <Student#name> "Venus" .
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D002-1table2columns1row/mappeda.trig Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,8 @@
+@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.trig Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,8 @@
+@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/D002-1table2columns1row/r2rmla.ttl Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,27 @@
+@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";
+
+ rr:subjectMap [ rr:template "http://example.com/{ID}{Name}";
+ rr:class foaf:Person ];
+
+ rr:predicateObjectMap
+ [
+ rr:predicateMap [ rr:predicate ex:id ];
+ rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
+ ];
+
+ rr:predicateObjectMap
+ [
+ rr:predicateMap [ rr:predicate foaf:name ];
+ rr:objectMap [ rr:column "Name" ]
+ ]
+ .
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D002-1table2columns1row/r2rmlb.ttl Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,30 @@
+@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' || ID ) AS "StudentId"
+ , ID
+ , Name
+ from Student
+ """;
+
+ rr:subjectMap [ rr:column "StudentId"; rr:termtype "BlankNode"; rr:class foaf:Person ];
+
+ rr:predicateObjectMap
+ [
+ rr:predicateMap [ rr:predicate ex:id ];
+ rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
+ ];
+
+ rr:predicateObjectMap
+ [
+ rr:predicateMap [ rr:predicate foaf:name ];
+ rr:objectMap [ rr:column "Name" ]
+ ]
+ .
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/create.sql Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,6 @@
+CREATE TABLE Student (
+ID integer,
+FirstName varchar(50),
+LastName varchar(50)
+);
+INSERT INTO Student (ID, FirstName, LastName) VALUES (10,"Venus", "Williams");
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/directGraph.ttl Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,4 @@
+_: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/mappeda.trig Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,9 @@
+@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".
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/mappedb.trig Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,8 @@
+@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".
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/mappedc.trig Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,9 @@
+@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".
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/mappedd.trig Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,8 @@
+@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".
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/r2rmla.ttl Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,33 @@
+@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";
+
+ rr:subjectMap [ rr:template "http://example.com/Student{ID}{FirstName}{LastName}";
+ rr:class foaf:Person ];
+
+ rr:predicateObjectMap
+ [
+ rr:predicateMap [ rr:predicate ex:id ];
+ rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
+ ];
+
+ rr:predicateObjectMap
+ [
+ rr:predicateMap [ rr:predicate foaf:firstName ];
+ rr:objectMap [ rr:column "FirstName" ]
+ ];
+
+ rr:predicateObjectMap
+ [
+ rr:predicateMap [ rr:predicate foaf:lastName ];
+ rr:objectMap [ rr:column "LastName" ]
+ ]
+ .
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/r2rmlb.ttl Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,32 @@
+@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 ID,
+ (FirstName || ' ' || LastName) AS Name,
+ FirstName,
+ LastName
+ FROM Student
+ """;
+
+ rr:subjectMap [ rr:template "http://example.com/Student{ID}{FirstName}{LastName}";
+ rr:class foaf:Person ];
+
+ rr:predicateObjectMap
+ [
+ rr:predicateMap [ rr:predicate ex:id ];
+ rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
+ ];
+
+ rr:predicateObjectMap
+ [
+ rr:predicateMap [ rr:predicate foaf:name ];
+ rr:objectMap [ rr:column "Name" ]
+ ]
+ .
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/r2rmlc.ttl Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,38 @@
+@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' || ID || FirstName || LastName) as StudentID,
+ ID,
+ FirstName,
+ LastName
+ FROM Student
+ """;
+
+ rr:subjectMap [ rr:column "StudentID"; rr:termtype "BlankNode";
+ rr:class foaf:Person ];
+
+ rr:predicateObjectMap
+ [
+ rr:predicateMap [ rr:predicate ex:id ];
+ rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
+ ];
+
+ rr:predicateObjectMap
+ [
+ rr:predicateMap [ rr:predicate foaf:firstName ];
+ rr:objectMap [ rr:column "FirstName" ]
+ ];
+
+ rr:predicateObjectMap
+ [
+ rr:predicateMap [ rr:predicate foaf:lastName ];
+ rr:objectMap [ rr:column "LastName" ]
+ ]
+ .
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/r2rmld.ttl Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,31 @@
+@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' || ID || FirstName || LastName) as StudentID,
+ ID,
+ (FirstName || ' ' || LastName) AS Name
+ FROM Student
+ """;
+
+ rr:subjectMap [ rr:column "StudentID"; rr:termtype "BlankNode";
+ rr:class foaf:Person ];
+
+ rr:predicateObjectMap
+ [
+ rr:predicateMap [ rr:predicate ex:id ];
+ rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
+ ];
+
+ rr:predicateObjectMap
+ [
+ rr:predicateMap [ rr:predicate foaf:name ];
+ rr:objectMap [ rr:column "Name" ]
+ ]
+ .
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D004-1table2columnsprojection/create.sql Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,5 @@
+CREATE TABLE Student_Sport(
+ Student varchar(50),
+ Sport varchar(50)
+);
+INSERT INTO Student_Sport (Student,Sport) VALUES ("Venus", "Tennis");
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D004-1table2columnsprojection/directGraph.ttl Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,3 @@
+_: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/D005-2duplicates0nulls/create.sql Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,7 @@
+CREATE TABLE IOUs (
+ fname CHAR(20),
+ lname CHAR(20),
+ amount FLOAT);
+INSERT INTO IOUs (fname, lname, amount) VALUES ("Bob", "Smith", 30);
+INSERT INTO IOUs (fname, lname, amount) VALUES ("Sue", "Jones", 20);
+INSERT INTO IOUs (fname, lname, amount) VALUES ("Bob", "Smith", 30);
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D005-2duplicates0nulls/directGraph.ttl Wed Jul 13 15:39:53 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 .
+
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D009-2tables1primarykey1foreingkey/create.sql Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,17 @@
+CREATE TABLE Student (
+ID integer,
+Name varchar(50),
+Sport integer,
+PRIMARY KEY (ID),
+FOREIGN KEY(Sport) REFERENCES Sport(ID)
+);
+
+CREATE TABLE Sport (
+ID integer,
+Name varchar (50),
+PRIMARY KEY (ID)
+);
+
+INSERT INTO Student (ID, Name, Sport) VALUES (10,"Venus Williams", 100);
+INSERT INTO Student (ID, Name, Sport) VALUES (20,"Demi Moore", NULL);
+INSERT INTO Sport (ID, Name) VALUES (100,"Tennis");
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/D009-2tables1primarykey1foreingkey/directGraph.ttl Wed Jul 13 15:39:53 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" .
+