Hello users, I have loaded some dbpedia parts into virtuoso merged to just one graph. All works fine.
Now I have the idea to extract via sparql-construct all data belong to resources of type person. This is my sparql construct: define output:format "TTL" PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> CONSTRUCT { ?s ?p ?lo. ?p rdfs:label ?lp.} WHERE { ?s a <http://dbpedia.org/ontology/Person>. { ?s ?p ?lo. FILTER isLiteral(?lo) } UNION { ?s ?p ?o. ?o rdfs:label ?lo. FILTER isIRI(?o) } ?p rdfs:label ?lp.}; Explained: I collect all information to any resource of type person. The resource must be subject. If it is linked with another resource like a place, I collect the label of it too. I tried different ways. The construct works for type actor over httpendpoint, but for person not all data is in the result. I think virtuoso breaks if the query takes to much time. My virtuoso.ini: ; ; Server parameters ; [Parameters] ServerPort = 1111 DisableUnixSocket = 1 ;SSLServerPort = 2111 ;SSLCertificate = cert.pem ;SSLPrivateKey = pk.pem ;X509ClientVerify = 0 ;X509ClientVerifyDepth = 0 ;X509ClientVerifyCAFile = ca.pem ServerThreads = 20 CheckpointInterval = 60 O_DIRECT = 0 NumberOfBuffers = 400000 MaxDirtyBuffers = 1200 CaseMode = 2 MaxStaticCursorRows = 5000 CheckpointAuditTrail = 0 AllowOSCalls = 0 SchedulerInterval = 10 DirsAllowed = ., /foo/vad, /bar/dbpedia, ThreadCleanupInterval = 0 ThreadThreshold = 10 ResourcesCleanupInterval = 0 FreeTextBatchSize = 100000 SingleCPU = 0 VADInstallDir = /moo/vad/ PrefixResultNames = 0 [SPARQL] ;ExternalQuerySource = 1 ;ExternalXsltSource = 1 ResultSetMaxRows = 9223372036854775807 DefaultGraph = http://neofonie.de/dbpedia_3_2 ;ImmutableGraphs = http://localhost:8890/dataspace ;MaxQueryCostEstimationTime = 120 ; in seconds ;MaxQueryExecutionTime = 10 ; in seconds ;PingService = http://rpc.pingthesemanticweb.com/ DefaultQuery = select * where { ?s ?p ?o . } Limit 100 I tried over isql with following command: /isql 1111 foo bar test.sql > test_r.nt test.sql contains: sparl PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> CONSTRUCT { ?s ?p ?lo. ?p rdfs:label ?lp.} WHERE { ?s a <http://dbpedia.org/ontology/Person>. { ?s ?p ?lo. FILTER isLiteral(?lo) } UNION { ?s ?p ?o. ?o rdfs:label ?lo. FILTER isIRI(?o) } ?p rdfs:label ?lp.}; It' breaks with warning Warning 01004: [Virtuoso Driver]CL077: Data truncated in column 1 of the result-se(callretRDF/XML-0, type 125) Is there any way to extract such huge data without breaking virtuoso? Kind regards Armin Nagel -- Sie finden uns auch mit unserer Web 2.0 Suchmaschine WeFind auf der CeBIT in Halle 006, Stand G60 (in der Webciety). Wir freuen uns auf Ihr Kommen! ________________________________ Armin Nagel Softwareentwickler neofonie Technologieentwicklung und Informationsmanagement GmbH Robert-Koch-Platz 4 10115 Berlin fon: +49.30 24627 257 fax: +49.30 24627 120 armin.na...@neofonie.de http://www.neofonie.de Handelsregister Berlin-Charlottenburg: HRB 67460 Geschäftsführung Helmut Hoffer von Ankershoffen (Sprecher der Geschäftsführung) Nurhan Yildirim Uwe-Gernot Fasold ________________________________ Die erste Web 2.0 Suchmaschine jetzt auf http://www.wefind.de . Unterwegs immer bestens informiert mit WeFind Mobile für iPhone und jetzt auch mit WeFind Mobile für Android: kostenloser Download im iTunes AppStore und im Android Market.
