X-Git-Url: http://lists.indexdata.dk/cgi-bin?a=blobdiff_plain;f=bibframe%2Ftriplestore.xml;h=5e41731432f6aa9824b9b1a04e99faf0e778e5aa;hb=36ef98cd8e62046c02aa1bff3a74ee14f6151d9a;hp=13eee027728ad28131677ce59e047f8bb77b725f;hpb=cca60a38323ce892b615d6643a45fc5f688e506c;p=mp-sparql-moved-to-github.git

diff --git a/bibframe/triplestore.xml b/bibframe/triplestore.xml
index 13eee02..5e41731 100644
--- a/bibframe/triplestore.xml
+++ b/bibframe/triplestore.xml
@@ -1,76 +1,153 @@
 <filters  xmlns="http://indexdata.com/metaproxy">
   <filter type="sparql">
-    <!--defaults uri="http://bibframe.indexdata.com/sparql/"/-->
-    <defaults uri="http://localhost:8890/sparql/"/>
+      <!-- Which sparql server to use, our demo, or your local installation -->
+    <defaults uri="http://bibframe.indexdata.com/sparql/"/>
+    <!--defaults uri="http://localhost:8890/sparql/"/-->
+
+    <!-- Any search in work returns just a list of records.
+         Present will make another request for each record to get the level
+         of details we want, depending on the schema.  -->
     <db path="work" schema="sparql-results">
       <prefix>rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns</prefix>
       <prefix>bf: http://bibframe.org/vocab/</prefix>
-      <form>SELECT
-              ?work
-              (sql:GROUP_DIGEST (?wtitle, ' ; ', 1000, 1)) AS ?title
-              (sql:GROUP_DIGEST (?creatorlabel, ' ; ', 1000, 1))AS ?creator
-              (sql:GROUP_DIGEST (?subjectlabel, ' ; ', 1000, 1))AS ?subject
+      <form>SELECT DISTINCT ?work
       </form>
       <criteria>?work a bf:Work</criteria>
-
-      <criteria> OPTIONAL {
-          ?work bf:workTitle ?wt .
-          ?wt bf:titleValue ?wtitle }
-      </criteria>
-      <criteria> OPTIONAL {
-          ?work bf:creator ?creator .
-          ?creator bf:label ?creatorlabel }
-      </criteria>
-      <criteria>OPTIONAL {
-          ?work bf:subject ?subject .
-          ?subject bf:label ?subjectlabel }
-      </criteria>
-      <index type="4">?wt bf:titleValue %v FILTER(contains(%v, %s))</index>
-      <index type="1003">?creator bf:label %v FILTER(contains(%v, %s))</index>
-      <index type="21">?subject bf:label %v FILTER(contains(%v, %s))</index>
-      <index type="1016"> {
-            ?work ?op1 ?child .
-            ?child ?op2 %v FILTER(contains(STR(%v), %s))
-          }
+      <!-- TODO: Many more indexes like the ones below-->
+      <index type="bf.title">?work bf:workTitle ?wt .
+          ?wt bf:titleValue %v FILTER(contains(%v, %s))</index>
+      <index type="bf.creator">?work bf:creator ?c .
+          ?c bf:label %v FILTER(contains(%v, %s))</index>
+      <index type="bf.subject">?work bf:subject ?subject .
+          ?subject bf:label %v FILTER(contains(%v, %s))
       </index>
-      <modifier>GROUP BY $work</modifier>
-    </db>
-    <db path="works" schema="rdf">
-      <prefix>rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns</prefix>
-      <prefix>bf: http://bibframe.org/vocab/</prefix>
-      <form>CONSTRUCT { 
-          ?work bf:title ?wtitle . 
-          ?work bf:instanceTitle ?title .
-          ?work bf:author ?creator . 
-          ?work bf:subject ?subjectlabel }
-      </form>
-      <criteria>?work a bf:Work</criteria>
-
-      <criteria>?work bf:workTitle ?wt</criteria>
-      <criteria>?wt bf:titleValue ?wtitle</criteria>
-      <index type="4">?wt bf:titleValue %v FILTER(contains(%v, %s))</index>
-      <criteria>?work bf:creator ?creator</criteria>
-      <criteria>?creator bf:label ?creatorlabel</criteria>
-      <index type="1003">?creator bf:label %v FILTER(contains(%v, %s))</index>
-      <criteria>?work bf:subject ?subject</criteria>
-      <criteria>?subject bf:label ?subjectlabel</criteria>
-      <index type="21">?subject bf:label %v FILTER(contains(%v, %s))</index>
+      <uri type="BF-L">
+        CONSTRUCT { ?work ?rel ?subj }
+         WHERE {
+         ?work a bf:Work .
+         ?work ?rel ?subj .
+         ?work ?rel ?obj FILTER( str(?work) = %s )
+        }
+      </uri>
+      <uri type="BF-F">
+        CONSTRUCT { ?work ?rel ?obj .
+                    ?obj ?rel1 ?obj1 .
+                    ?obj1 ?rel2 ?obj2 .
+                    ?obj2 ?rel3 ?obj3 }
+         WHERE {
+         ?work a bf:Work .
+         ?work ?rel ?obj .
+        OPTIONAL { 
+          ?obj ?rel1 ?obj1  
+            MINUS { ?obj a bf:Work } 
+          }
+        OPTIONAL {
+          ?obj1 ?rel2 ?obj2 
+            MINUS { ?obj1 a bf:Work } 
+          } 
+        OPTIONAL { 
+          ?obj2 ?rel3 ?obj3 
+            MINUS { ?obj2 a bf:Work } 
+          }
+         ?work ?rel ?obj FILTER( str(?work) = %s )
+        }
+      </uri>
+      <uri type="BF-FI">  <!-- full, with instances. Experimental! -->
+        CONSTRUCT { %u ?rel ?obj .
+                    ?obj ?rel1 ?obj1 .
+                    ?obj1 ?rel2 ?obj2 .
+                    ?obj2 ?rel3 ?obj3 .
+                    ?inst ?irel1 ?iobj1 .
+                    ?iobj1 ?irel2 ?iobj2 .
+                    ?iobj2 ?irel3 ?iobj3 }
+         WHERE {
+          %u a bf:Work .
+          %u ?rel ?obj .
+          OPTIONAL { 
+              ?obj ?rel1 ?obj1  
+              MINUS { ?obj a bf:Work } 
+              MINUS { ?obj a bf:Instance }
+          }
+          OPTIONAL {
+              ?obj1 ?rel2 ?obj2 
+              MINUS { ?obj1 a bf:Work } 
+              MINUS { ?obj1 a bf:Instance }
+          } 
+          OPTIONAL { 
+              ?obj2 ?rel3 ?obj3 
+              MINUS { ?obj2 a bf:Work } 
+              MINUS { ?obj2 a bf:Instance }
+          }
+          OPTIONAL { <!-- note, this is not in the final construct
+          the linking triplet will get included like any others -->
+            ?inst bf:instanceOf %u
+          } 
+          OPTIONAL {
+            ?inst ?irel1 ?iobj1
+          }
+          OPTIONAL {
+            ?iobj1 ?irel2 ?iobj2
+          }
+          OPTIONAL {
+            ?iobj2 ?irel3 ?iobj3
+          }
+        }
+      </uri>
     </db>
+    <!-- Instance searches, need to be refined later -->
     <db path="instance" schema="sparql-results">
       <prefix>rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns</prefix>
       <prefix>bf: http://bibframe.org/vocab/</prefix>
       <form>SELECT ?instance ?title ?format</form>
       <criteria>?instance a bf:Instance</criteria>
-
       <criteria>?instance bf:title ?title</criteria>
       <index type="4">?instance bf:title %v FILTER(contains(%v, %s))</index>
       <criteria>?instance bf:format ?format</criteria>
       <index type="1013">?instance bf:format %s</index>
     </db>
+
+    <!-- Simple databases -->
     <db path="place" schema="sparql-results">
       <prefix>rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns</prefix>
       <prefix>bf: http://bibframe.org/vocab/</prefix>
-      <form>SELECT  ?label ?id ?place ?relatedTo ?authorizedAccessPoint </form>
+      <form>SELECT DISTINCT ?place </form>
+      <criteria>?place a bf:Place</criteria>
+      <criteria>?place ?rel ?obj</criteria>
+      <index type="bf.place">?place bf:label %v FILTER(contains(%v, %s))</index>
+      <index type="any">?place bf:label %v FILTER(contains(%v, %s))</index>
+      <index type="1016">?place bf:label %v FILTER(contains(%v, %s))</index>
+      <uri type="BF-L">
+        CONSTRUCT { %u ?rel ?obj }
+         WHERE {
+           %u ?rel ?obj .
+         }
+      </uri>
+      <!-- Experimental, to get just the URIs out, in proper rdf. Probably not useful 
+      <uri type="BF-U">
+        CONSTRUCT { %u bf:uri %u }
+         WHERE {
+           %u bf:label ?lbl .
+         }
+      </uri>
+      -->
+      <uri type="BF-F">
+          <!-- I don't think we need more than one level for these simple 
+          databases -->
+        CONSTRUCT { %u ?rel ?obj . 
+                    ?obj ?rel1 ?obj1 .
+                    <!--  ?obj1 ?rel2 ?obj2 -->
+                  }
+         WHERE {
+           %u ?rel ?obj .
+           OPTIONAL { ?obj ?rel1 ?obj1 }
+           <!-- OPTIONAL { ?obj1 ?rel2 ?obj2 }   Seems not to be necessary -->
+         }
+      </uri>
+    </db>
+    <db path="place-old" schema="sparql-results">
+      <prefix>rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns</prefix>
+      <prefix>bf: http://bibframe.org/vocab/</prefix>
+      <form>SELECT DISTINCT  ?label ?id ?place ?relatedTo ?authorizedAccessPoint </form>
       <criteria>?place a bf:Place</criteria>
       <criteria>?place bf:label ?label</criteria>
       <criteria>OPTIONAL { ?place bf:identifier ?id}</criteria>
@@ -82,7 +159,7 @@
     <db path="person" schema="sparql-results">
       <prefix>rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns</prefix>
       <prefix>bf: http://bibframe.org/vocab/</prefix>
-      <form>SELECT  ?label ?id ?person ?relatedTo ?authorizedAccessPoint </form>
+      <form>SELECT DISTINCT  ?label ?id ?person ?relatedTo ?authorizedAccessPoint </form>
       <criteria>?person a bf:Person</criteria>
       <criteria>?person bf:label ?label</criteria>
       <criteria>OPTIONAL { ?person bf:identifier ?id}</criteria>
@@ -94,7 +171,7 @@
     <db path="meeting" schema="sparql-results">
       <prefix>rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns</prefix>
       <prefix>bf: http://bibframe.org/vocab/</prefix>
-      <form>SELECT  ?label ?id ?meeting ?relatedTo ?authorizedAccessPoint </form>
+      <form>SELECT DISTINCT  ?label ?id ?meeting ?relatedTo ?authorizedAccessPoint </form>
       <criteria>?meeting a bf:Meeting</criteria>
       <criteria>?meeting bf:label ?label</criteria>
       <criteria>OPTIONAL { ?meeting bf:identifier ?id}</criteria>
@@ -106,7 +183,7 @@
     <db path="agent" schema="sparql-results">
       <prefix>rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns</prefix>
       <prefix>bf: http://bibframe.org/vocab/</prefix>
-      <form>SELECT  ?label ?id ?agent ?relatedTo ?authorizedAccessPoint </form>
+      <form>SELECT DISTINCT  ?label ?id ?agent ?relatedTo ?authorizedAccessPoint </form>
       <criteria>?agent a bf:Agent</criteria>
       <criteria>?agent bf:label ?label</criteria>
       <criteria>OPTIONAL { ?agent bf:identifier ?id}</criteria>
@@ -118,7 +195,7 @@
     <db path="event" schema="sparql-results">
       <prefix>rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns</prefix>
       <prefix>bf: http://bibframe.org/vocab/</prefix>
-      <form>SELECT  ?label ?id ?event ?relatedTo ?authorizedAccessPoint </form>
+      <form>SELECT DISTINCT  ?label ?id ?event ?relatedTo ?authorizedAccessPoint </form>
       <criteria>?event a bf:Event</criteria>
       <criteria>?event bf:label ?label</criteria>
       <criteria>OPTIONAL { ?event bf:identifier ?id}</criteria>
@@ -130,7 +207,7 @@
     <db path="organization" schema="sparql-results">
       <prefix>rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns</prefix>
       <prefix>bf: http://bibframe.org/vocab/</prefix>
-      <form>SELECT  ?label ?id ?organization ?relatedTo ?authorizedAccessPoint </form>
+      <form>SELECT DISTINCT  ?label ?id ?organization ?relatedTo ?authorizedAccessPoint </form>
       <criteria>?organization a bf:Organization</criteria>
       <criteria>?organization bf:label ?label</criteria>
       <criteria>OPTIONAL { ?organization bf:identifier ?id}</criteria>
@@ -142,7 +219,7 @@
     <db path="topic" schema="sparql-results">
       <prefix>rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns</prefix>
       <prefix>bf: http://bibframe.org/vocab/</prefix>
-      <form>SELECT  ?label ?id ?topic ?relatedTo ?authorizedAccessPoint </form>
+      <form>SELECT DISTINCT  ?label ?id ?topic ?relatedTo ?authorizedAccessPoint </form>
       <criteria>?topic a bf:Topic</criteria>
       <criteria>?topic bf:label ?label</criteria>
       <criteria>OPTIONAL { ?topic bf:identifier ?id}</criteria>
@@ -151,10 +228,13 @@
       <index type="bf.topic">?topic bf:label %v FILTER(contains(%v, %s))</index>
       <index type="any">?topic bf:label %v FILTER(contains(%v, %s))</index>
     </db>
+
+    <!-- Title search, probably not needed. Will need to be rewritten to the same
+    system as the work search above, with separate present query -->
     <db path="title" schema="sparql-results">
         <prefix>rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns</prefix>
         <prefix>bf: http://bibframe.org/vocab/</prefix>
-        <form>SELECT ?title ?titleValue 
+        <form>SELECT DISTINCT ?title ?titleValue 
             ?formDesignation ?partNumber ?partTitle ?subtitle 
             ?titleAttribute ?titleQualifier ?titleSource 
             ?titleType ?titleVariationDate</form>
@@ -174,12 +254,20 @@
         <index type="bf.parttitle">?title bf:partTitle %v FILTER(contains(%v, %s))</index>
         <index type="any">?title ?rel  %v FILTER(contains(str(%v), %s))</index>
     </db>
-    <db path="node" schema="rdf">
+    <!-- A hack to be able to look at any triplet in the base -->
+    <db path="node" schema="sparql-results">
       <prefix>rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns</prefix>
       <prefix>bf: http://bibframe.org/vocab/</prefix>
-      <form>DESCRIBE ?node </form>
+      <form>SELECT ?node ?rel ?obj</form>
       <index type="any">?node ?rel ?obj FILTER( str(?node) = %s )</index>
     </db>
+    <!-- A way to see which triplets refers to a given uri. -->
+    <db path="ref" schema="sparql-results">
+      <prefix>rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns</prefix>
+      <prefix>bf: http://bibframe.org/vocab/</prefix>
+      <form>SELECT ?node ?rel ?obj</form>
+      <index type="any">?node ?rel ?obj FILTER( str(?obj) = %s )</index>
+    </db>
   </filter>
   <filter type="log">
     <message>http</message>