Re: [Virtuoso-users] Indices for RDF data

2008-02-22 Thread Ivan Mikhailov
Thomas, Quads are stored in RDF_QUAD table, as follows: create table DB.DBA.RDF_QUAD ( G IRI_ID, S IRI_ID, P IRI_ID, O any, primary key (G,S,P,O) ) create bitmap index RDF_QUAD_OGPS on DB.DBA.RDF_QUAD (O, G, P, S) ; (the very beginning of libsrc/Wi/sparql.sql if you build from source

Re: [Virtuoso-users] Problem when loading large RDF dataset

2008-02-22 Thread Ivan Mikhailov
Thomas, Yes, DB.DBA.TTLP_MT() is more suitable. Among other things it does not try to fit everything into single transaction. Best Regards, Ivan Mikhailov, OpenLink Software. On Fri, 2008-02-22 at 15:03 +0100, Thomas Hornung wrote: > Hi, > > I have a problem when I try to load a "large" (~109M

Re: [Virtuoso-users] SPARQL Conformance

2008-02-22 Thread Ivan Mikhailov
Thomas, I've also tried to write the query in pure SPARQL but failed. I'm afraid that in that case you need SPARQL-BI extensions, not pure SPARQL. Like this: PREFIX rdf: PREFIX foaf: PREFIX dc:

[Virtuoso-users] Indices for RDF data

2008-02-22 Thread Thomas Hornung
Hi, are there any special indices that can be turned on for querying RDF data, e.g. subject/object -> predicate? AFAI understand the documentation there is the possibility to use full text indices for literals in the object position ( as mentioned in http://docs.openlinksw.com/virtuoso/rdfspa

Re: [Virtuoso-users] post-processing query

2008-02-22 Thread Ivan Mikhailov
Hi Ward, Correction. The error is compile-time, you need to increase MaxMemPoolSize parameter in the [Parameters] section of your virtuoso.ini file. This is maximum allowed amount of memory SQL optimizer can temporarily occupy. I set it to 10, for approx 1 gigabyte, on a box with 4Gb RAM,

[Virtuoso-users] Problem when loading large RDF dataset

2008-02-22 Thread Thomas Hornung
Hi, I have a problem when I try to load a "large" (~109MB, approx. 1.000.000 triples) RDF data set into Virtuoso. Ideally I'd like to load files of up to several GBs into Virtuoso. I always get the same error message: Connected to OpenLink Virtuoso Driver: 05.00.3026 OpenLink Virtuoso ODBC D