dbpedia sparql查询超时.尝试使用多个字段

Question

我使用DBpedia SPARQL查询来获取人员列表和详细信息。我有DBpedia转储数据这是存储在本地。当我查询, 大师被停止。

查询-

SELECT DISTINCT ?dbpedia_link ?freebase_link str(?abstract) as ?abstract str(?alias) as ?alias
                        str(?birthDate) as ?birthDate str(?birthName) as ?birthName str(?birthPlace) as ?birthPlace
                        str(?label) as ?label str(?occupation) as ?occupation str(?residence) as ?residence
                        str(?spouse) as ?spouse str(?education) as ?education str(?networth) as ?networth str(?salary) as ?salary
                        str(?wikiPageID) as ?wikiPageID str(?wikiPageRevisionID) as ?wikiPageRevisionID str(?shortDescription) as ?shortDescription
                        WHERE {
                    {
                        ?dbpedia_link rdf:type dbpedia-owl:Person
                    }
                    OPTIONAL {?dbpedia_link dbpedia-owl:abstract ?abstract. }
                    OPTIONAL {?dbpedia_link dbpedia-owl:alias ?alias .}
                    OPTIONAL {?dbpedia_link dbpprop:birthDate ?birthDate .} 
                    OPTIONAL {?dbpedia_link dbpprop:birthName ?birthName .} 
                    OPTIONAL {?dbpedia_link dbpprop:birthPlace ?birthPlace .} 
                    OPTIONAL {?dbpedia_link rdfs:label ?label .} 
                    OPTIONAL {?dbpedia_link dbpprop:occupation ?occupation .}
                    OPTIONAL {?dbpedia_link dbpprop:residence ?residence .} 
                    OPTIONAL {?dbpedia_link dbpprop:spouse ?spouse .} 
                    OPTIONAL {?dbpedia_link dbpprop:education ?education .}  
                    OPTIONAL {?dbpedia_link dbpprop:networth ?networth .}  
                    OPTIONAL {?dbpedia_link dbpprop:salary ?salary .}  
                    OPTIONAL {?dbpedia_link dbpedia-owl:wikiPageID ?wikiPageID .}  
                    OPTIONAL {?dbpedia_link dbpedia-owl:wikiPageRevisionID ?wikiPageRevisionID .}
                    OPTIONAL {?dbpedia_link dbpprop:shortDescription ?shortDescription .} 
                    OPTIONAL {?dbpedia_link owl:sameAs ?freebase_link
                    FILTER regex(?freebase_link, "^http://rdf.freebase.com") .}
                }LIMIT "1"
            OFFSET "225930"

有什么帮助吗?

Answer 1

第一件事——为了清晰起见，对查询进行了编辑，并进行了一些语法更正。

SELECT  DISTINCT                               ?dbpedia_link 
                                               ?freebase_link 
                 (           str(?abstract) AS ?abstract           ) 
                 (              str(?alias) AS ?alias              )
                 (          str(?birthDate) AS ?birthDate          ) 
                 (          str(?birthName) AS ?birthName          )
                 (         str(?birthPlace) AS ?birthPlace         )
                 (              str(?label) AS ?label              )
                 (         str(?occupation) AS ?occupation         )
                 (          str(?residence) AS ?residence          )
                 (             str(?spouse) AS ?spouse             )
                 (          str(?education) AS ?education          )
                 (           str(?networth) AS ?networth           )
                 (             str(?salary) AS ?salary             )
                 (         str(?wikiPageID) AS ?wikiPageID         )
                 ( str(?wikiPageRevisionID) AS ?wikiPageRevisionID )
                 (   str(?shortDescription) AS ?shortDescription   )
  WHERE  {
                    { ?dbpedia_link          rdf:type                dbpedia-owl:Person  }
           OPTIONAL { ?dbpedia_link  dbpedia-owl:abstract            ?abstract           }
           OPTIONAL { ?dbpedia_link  dbpedia-owl:alias               ?alias              }
           OPTIONAL { ?dbpedia_link      dbpprop:birthDate           ?birthDate          } 
           OPTIONAL { ?dbpedia_link      dbpprop:birthName           ?birthName          } 
           OPTIONAL { ?dbpedia_link      dbpprop:birthPlace          ?birthPlace         } 
           OPTIONAL { ?dbpedia_link         rdfs:label               ?label              } 
           OPTIONAL { ?dbpedia_link      dbpprop:occupation          ?occupation         }
           OPTIONAL { ?dbpedia_link      dbpprop:residence           ?residence          } 
           OPTIONAL { ?dbpedia_link      dbpprop:spouse              ?spouse             } 
           OPTIONAL { ?dbpedia_link      dbpprop:education           ?education          }  
           OPTIONAL { ?dbpedia_link      dbpprop:networth            ?networth           }  
           OPTIONAL { ?dbpedia_link      dbpprop:salary              ?salary             }  
           OPTIONAL { ?dbpedia_link  dbpedia-owl:wikiPageID          ?wikiPageID         }  
           OPTIONAL { ?dbpedia_link  dbpedia-owl:wikiPageRevisionID  ?wikiPageRevisionID }
           OPTIONAL { ?dbpedia_link      dbpprop:shortDescription    ?shortDescription   } 
           OPTIONAL { ?dbpedia_link          owl:sameAs              ?freebase_link
                          FILTER regex( ?freebase_link, "^http://rdf.freebase.com" )     }
         }
  LIMIT  1
 OFFSET  225930

第二件事——你在那里有未定义的前缀。dbpedia-owl吗?dbpprop ?

随机修补并向网络上的随机人员寻求帮助可能会给您一些结果，但您可能会通过在专门针对这些产品和工具的论坛上询问获得更快，更准确，更相关的关于特定产品和工具的答案，例如，DBpedia讨论邮件列表，Virtuoso用户邮件列表等