Hi Andy,

Thank you very much for your help. I must confess that I barely know what I am doing, and I have been tearing my hear out, so I very much appreciate your help.

I have run the query you gave me (select * WHERE { { ?a ?b ?c } UNION { GRAPH ?g { ?s ?p ?o } } } LIMIT 10) , and it returns heaps. Here is the top part:

{
  "head": {
    "vars": [ "a" , "b" , "c" , "s" , "p" , "o" , "g" ]
  } ,
  "results": {
    "bindings": [
      {
        "s": { "type": "uri" , "value": "http://purl.org/dc/terms/modified"; } ,
        "p": { "type": "uri" , "value": 
"http://www.w3.org/1999/02/22-rdf-syntax-ns#type"; } ,
        "o": { "type": "uri" , "value": 
"http://www.w3.org/2002/07/owl#AnnotationProperty"; } ,
        "g": { "type": "uri" , "value": 
"http://vitro.mannlib.cornell.edu/filegraph/tbox/vivo-dcterms-1.5.owl"; }
      } ,
      {
        "s": { "type": "uri" , "value": "http://purl.org/dc/terms/source"; } ,
        "p": { "type": "uri" , "value": 
"http://www.w3.org/1999/02/22-rdf-syntax-ns#type"; } ,
        "o": { "type": "uri" , "value": 
"http://www.w3.org/2002/07/owl#AnnotationProperty"; } ,
        "g": { "type": "uri" , "value": 
"http://vitro.mannlib.cornell.edu/filegraph/tbox/vivo-dcterms-1.5.owl"; }
      } ,
      {



and on it goes. There are no values for a, b and c anywhere I can see, but there are things I put into the db myself, such as this line (I took LIMIT 10 out of the query):

"s": { "type": "uri" , "value": "http://vivo.mydomain.edu/individual/n6763"; } ,
        "p": { "type": "uri" , "value": "http://xmlns.com/foaf/0.1/lastName"; } ,
        "o": { "datatype": "http://www.w3.org/2001/XMLSchema#string"; , "type": "typed-literal" , 
"value": "Tolstoy" } ,
        "g": { "type": "uri" , "value": 
"http://vitro.mannlib.cornell.edu/default/vitro-kb-2"; }




What does this imply for what I am doing? Why does this query return something, and mine does not?

When you say "connect to one that isn't an SDB database": What makes a database//an SDB database? Mine is a MYSQL database, filled with tables by VIVO. Is that an SDB database? It has tables, such as jena_g1t0_reif, and so on, and a table called triplets, and one called quads, so that is all quite promising. I wonder if there is some part missing, where I tell the sparql endpoint just how the queries should match the tables in my database.


Thank you again,



Michel




Reply via email to