Hi Chuck,
You can determine the version of the Virtuoso server is use by running a
command of the form:
$ /usr/local/virtuoso-opensource/bin/virtuoso-t -?
Virtuoso Open Source Edition (multi threaded)
Version 05.00.3026-pthreads as of Feb 11 2008
Compiled for Darwin (i386-apple-darwin8.11.1)
Copyright (C) 1999-2008 OpenLink Software
.
.
Which equates to the Virtuoso 5.0.5 build available from source forge.
The following section of the Virtuoso documentation details the creation of
indexes on RDF graphs:
http://docs.openlinksw.com/virtuoso/rdfsparqlrulefulltext.html
I would recommend you subscribe to the Virtuoso open source (VOS) mailing
lists on source forge( http://sourceforge.net/mail/?group_id=161622) where
similar such questions have been asked one of which I have attached to this
response as it provides addition information on index creation from one of
the developers ...
I hope this information is sufficient for your needs ...
Best Regards,
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
On 13/03/2008 13:56, "Chuck Borromeo" <charles.borro...@brainstage.com>
wrote:
> Hi Hugh,
> I am working with Don Doherty at BrainStage. I am starting to work with the
> Open Source Edition of OpenLink Virtuoso version 2.5.4. Actually, I¹m not 100%
> sure about the version number, how do you determine it? Is there a query I
> can run from iSQL? I am trying to speed up some of the queries from the
> graphs in Virtuoso. I was hoping to use an index to speed things up. Can I
> create an index on a RDF graph? If so, how do I do it?
> Thanks,
> Chuck Borromeo
>
--- Begin Message ---
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 sources.)
If you performs queries that does not specify fixed graph names, but
specify fixed predicates, the following indexes are quite useful:
create bitmap index RDF_QUAD_PSOG on DB.DBA.RDF_QUAD (P, S, O, G);
create bitmap index RDF_QUAD_POSG on DB.DBA.RDF_QUAD (P, O, S, G);
You can create other indexes as well. Bitmap indexes are preferable, but
if O is the last column then the index can not be bitmap, so it could
be, e.g.
create index RDF_QUAD_PSGO on DB.DBA.RDF_QUAD (P, S, G, O);
but not
create bitmap index RDF_QUAD_PSGO on DB.DBA.RDF_QUAD (P, S, G, O);
Best Regards,
Ivan Mikhailov,
OpenLink Software.
On Fri, 2008-02-22 at 15:46 +0100, Thomas Hornung wrote:
> 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/rdfsparqlrulefulltext.html), but I
> couldn't find information on where to tweak other indices.
>
> Does somebody know, if "special" indices are supported or are all
> indices generated as a default setting.
>
> Best regards,
> Thomas
>
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--- End Message ---
