--- a/D012-2tables2duplicates0nulls/create.sql Mon Aug 08 01:12:58 2011 +0100
+++ b/D012-2tables2duplicates0nulls/create.sql Mon Aug 29 22:43:50 2011 +0100
@@ -10,6 +10,6 @@
fname CHAR(20),
lname CHAR(20),
city CHAR(20));
-INSERT INTO IOUs (fname, lname, amount) VALUES ('Bob', 'Smith', 'London');
-INSERT INTO IOUs (fname, lname, amount) VALUES ('Sue', 'Jones', 'Madrid');
-INSERT INTO IOUs (fname, lname, amount) VALUES ('Bob', 'Smith', 'London');
+INSERT INTO Lives (fname, lname, city) VALUES ('Bob', 'Smith', 'London');
+INSERT INTO Lives (fname, lname, city) VALUES ('Sue', 'Jones', 'Madrid');
+INSERT INTO Lives (fname, lname, city) VALUES ('Bob', 'Smith', 'London');
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/r2rmlvocab.owl Mon Aug 29 22:43:50 2011 +0100
@@ -0,0 +1,365 @@
+@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
+@prefix : <http://www.w3.org/ns/r2rml##> .
+@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
+@prefix xml: <http://www.w3.org/XML/1998/namespace> .
+@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
+@prefix owl: <http://www.w3.org/2002/07/owl#> .
+@base <http://www.w3.org/ns/r2rml#> .
+
+<http://www.w3.org/ns/r2rml#> rdf:type owl:Ontology .
+
+
+#################################################################
+#
+# Datatypes
+#
+#################################################################
+
+
+
+
+#################################################################
+#
+# Object Properties
+#
+#################################################################
+
+
+### http://www.w3.org/ns/r2rml#class
+
+<http://www.w3.org/ns/r2rml#class> rdf:type owl:ObjectProperty ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#SubjectMap> .
+
+
+
+### http://www.w3.org/ns/r2rml#datatype
+
+<http://www.w3.org/ns/r2rml#datatype> rdf:type owl:ObjectProperty ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#ObjectMap> .
+
+
+
+### http://www.w3.org/ns/r2rml#graph
+
+<http://www.w3.org/ns/r2rml#graph> rdf:type owl:ObjectProperty ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#GraphMap> .
+
+
+
+### http://www.w3.org/ns/r2rml#graphMap
+
+<http://www.w3.org/ns/r2rml#graphMap> rdf:type owl:ObjectProperty ;
+
+ rdfs:range <http://www.w3.org/ns/r2rml#GraphMap> ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#PredicateObjectMap> ,
+ <http://www.w3.org/ns/r2rml#SubjectMap> .
+
+
+
+### http://www.w3.org/ns/r2rml#joinCondition
+
+<http://www.w3.org/ns/r2rml#joinCondition> rdf:type owl:ObjectProperty ;
+
+ rdfs:range <http://www.w3.org/ns/r2rml#Join> ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#RefObjectMap> .
+
+
+
+### http://www.w3.org/ns/r2rml#logicalTable
+
+<http://www.w3.org/ns/r2rml#logicalTable> rdf:type owl:ObjectProperty ;
+
+ rdfs:range <http://www.w3.org/ns/r2rml#LogicalTable> ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#TriplesMap> .
+
+
+
+### http://www.w3.org/ns/r2rml#object
+
+<http://www.w3.org/ns/r2rml#object> rdf:type owl:ObjectProperty ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#ObjectMap> .
+
+
+
+### http://www.w3.org/ns/r2rml#objectMap
+
+<http://www.w3.org/ns/r2rml#objectMap> rdf:type owl:ObjectProperty ;
+
+ rdfs:range <http://www.w3.org/ns/r2rml#ObjectMap> ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#PredicateObjectMap> .
+
+
+
+### http://www.w3.org/ns/r2rml#parentTriplesMap
+
+<http://www.w3.org/ns/r2rml#parentTriplesMap> rdf:type owl:ObjectProperty ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#RefObjectMap> ;
+
+ rdfs:range <http://www.w3.org/ns/r2rml#TriplesMap> .
+
+
+
+### http://www.w3.org/ns/r2rml#predicate
+
+<http://www.w3.org/ns/r2rml#predicate> rdf:type owl:ObjectProperty ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#PredicateMap> .
+
+
+
+### http://www.w3.org/ns/r2rml#predicateMap
+
+<http://www.w3.org/ns/r2rml#predicateMap> rdf:type owl:ObjectProperty ;
+
+ rdfs:range <http://www.w3.org/ns/r2rml#PredicateMap> ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#PredicateObjectMap> .
+
+
+
+### http://www.w3.org/ns/r2rml#predicateObjectMap
+
+<http://www.w3.org/ns/r2rml#predicateObjectMap> rdf:type owl:ObjectProperty ;
+
+ rdfs:range <http://www.w3.org/ns/r2rml#PredicateObjectMap> ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#TriplesMap> .
+
+
+
+### http://www.w3.org/ns/r2rml#refObjectMap
+
+<http://www.w3.org/ns/r2rml#refObjectMap> rdf:type owl:ObjectProperty ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#PredicateObjectMap> ;
+
+ rdfs:range <http://www.w3.org/ns/r2rml#RefObjectMap> .
+
+
+
+### http://www.w3.org/ns/r2rml#sqlVersion
+
+<http://www.w3.org/ns/r2rml#sqlVersion> rdf:type owl:ObjectProperty ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#LogicalTable> .
+
+
+
+### http://www.w3.org/ns/r2rml#subject
+
+<http://www.w3.org/ns/r2rml#subject> rdf:type owl:ObjectProperty ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#SubjectMap> .
+
+
+
+### http://www.w3.org/ns/r2rml#subjectMap
+
+<http://www.w3.org/ns/r2rml#subjectMap> rdf:type owl:ObjectProperty ;
+
+ rdfs:range <http://www.w3.org/ns/r2rml#SubjectMap> ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#TriplesMap> .
+
+
+
+### http://www.w3.org/ns/r2rml#termType
+
+<http://www.w3.org/ns/r2rml#termType> rdf:type owl:ObjectProperty ;
+
+ rdfs:domain [ rdf:type owl:Class ;
+ owl:unionOf ( <http://www.w3.org/ns/r2rml#GraphMap>
+ <http://www.w3.org/ns/r2rml#ObjectMap>
+ <http://www.w3.org/ns/r2rml#PredicateMap>
+ <http://www.w3.org/ns/r2rml#SubjectMap>
+ )
+ ] .
+
+
+
+
+
+#################################################################
+#
+# Data properties
+#
+#################################################################
+
+
+### http://www.w3.org/ns/r2rml#child
+
+<http://www.w3.org/ns/r2rml#child> rdf:type owl:DatatypeProperty ;
+
+ rdfs:range xsd:string ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#Join> .
+
+
+
+### http://www.w3.org/ns/r2rml#column
+
+<http://www.w3.org/ns/r2rml#column> rdf:type owl:DatatypeProperty ;
+
+ rdfs:range xsd:string ;
+
+ rdfs:domain [ rdf:type owl:Class ;
+ owl:unionOf ( <http://www.w3.org/ns/r2rml#GraphMap>
+ <http://www.w3.org/ns/r2rml#ObjectMap>
+ <http://www.w3.org/ns/r2rml#PredicateMap>
+ <http://www.w3.org/ns/r2rml#SubjectMap>
+ )
+ ] .
+
+
+
+### http://www.w3.org/ns/r2rml#inverseExpression
+
+<http://www.w3.org/ns/r2rml#inverseExpression> rdf:type owl:DatatypeProperty ;
+
+ rdfs:domain [ rdf:type owl:Class ;
+ owl:unionOf ( <http://www.w3.org/ns/r2rml#GraphMap>
+ <http://www.w3.org/ns/r2rml#ObjectMap>
+ <http://www.w3.org/ns/r2rml#PredicateMap>
+ <http://www.w3.org/ns/r2rml#SubjectMap>
+ )
+ ] .
+
+
+
+### http://www.w3.org/ns/r2rml#parent
+
+<http://www.w3.org/ns/r2rml#parent> rdf:type owl:DatatypeProperty ;
+
+ rdfs:range xsd:string ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#Join> .
+
+
+
+### http://www.w3.org/ns/r2rml#sqlQuery
+
+<http://www.w3.org/ns/r2rml#sqlQuery> rdf:type owl:DatatypeProperty ;
+
+ rdfs:range xsd:string ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#LogicalTable> .
+
+
+
+### http://www.w3.org/ns/r2rml#tableName
+
+<http://www.w3.org/ns/r2rml#tableName> rdf:type owl:DatatypeProperty ;
+
+ rdfs:range xsd:string ;
+
+ rdfs:domain <http://www.w3.org/ns/r2rml#LogicalTable> .
+
+
+
+### http://www.w3.org/ns/r2rml#template
+
+<http://www.w3.org/ns/r2rml#template> rdf:type owl:DatatypeProperty ;
+
+ rdfs:range xsd:string ;
+
+ rdfs:domain [ rdf:type owl:Class ;
+ owl:unionOf ( <http://www.w3.org/ns/r2rml#GraphMap>
+ <http://www.w3.org/ns/r2rml#ObjectMap>
+ <http://www.w3.org/ns/r2rml#PredicateMap>
+ <http://www.w3.org/ns/r2rml#SubjectMap>
+ )
+ ] .
+
+
+
+
+
+#################################################################
+#
+# Classes
+#
+#################################################################
+
+
+### http://www.w3.org/ns/r2rml#GraphMap
+
+<http://www.w3.org/ns/r2rml#GraphMap> rdf:type owl:Class .
+
+
+
+### http://www.w3.org/ns/r2rml#Join
+
+<http://www.w3.org/ns/r2rml#Join> rdf:type owl:Class ;
+
+ rdfs:subClassOf owl:Thing .
+
+
+
+### http://www.w3.org/ns/r2rml#LogicalTable
+
+<http://www.w3.org/ns/r2rml#LogicalTable> rdf:type owl:Class ;
+
+ rdfs:subClassOf owl:Thing .
+
+
+
+### http://www.w3.org/ns/r2rml#ObjectMap
+
+<http://www.w3.org/ns/r2rml#ObjectMap> rdf:type owl:Class ;
+
+ rdfs:subClassOf owl:Thing .
+
+
+
+### http://www.w3.org/ns/r2rml#PredicateMap
+
+<http://www.w3.org/ns/r2rml#PredicateMap> rdf:type owl:Class ;
+
+ rdfs:subClassOf owl:Thing .
+
+
+
+### http://www.w3.org/ns/r2rml#PredicateObjectMap
+
+<http://www.w3.org/ns/r2rml#PredicateObjectMap> rdf:type owl:Class ;
+
+ rdfs:subClassOf owl:Thing .
+
+
+
+### http://www.w3.org/ns/r2rml#RefObjectMap
+
+<http://www.w3.org/ns/r2rml#RefObjectMap> rdf:type owl:Class ;
+
+ rdfs:subClassOf owl:Thing .
+
+
+
+### http://www.w3.org/ns/r2rml#SubjectMap
+
+<http://www.w3.org/ns/r2rml#SubjectMap> rdf:type owl:Class ;
+
+ rdfs:subClassOf owl:Thing .
+
+
+
+### http://www.w3.org/ns/r2rml#TriplesMap
+
+<http://www.w3.org/ns/r2rml#TriplesMap> rdf:type owl:Class ;
+
+ rdfs:subClassOf owl:Thing .
+
+
+
+
+### Generated by the OWL API (version 3.2.3.1824) http://owlapi.sourceforge.net
+