Difference between revisions of "Virtuoso"
From phenoscape
Jim Balhoff (talk | contribs) (→Helpful Virtuoso documentation links) |
Jim Balhoff (talk | contribs) |
||
Line 13: | Line 13: | ||
** Within isql: <code>DB.DBA.RDF_OBJ_FT_RULE_ADD (null, null, 'All');</code> | ** Within isql: <code>DB.DBA.RDF_OBJ_FT_RULE_ADD (null, null, 'All');</code> | ||
* [http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFPerformanceTuning Performance tuning] | * [http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFPerformanceTuning Performance tuning] | ||
− | ** | + | ** Add index on predicate: <code>CREATE BITMAP INDEX RDF_QUAD_PGOS ON DB.DBA.RDF_QUAD (G, P, O, S) PARTITION (O VARCHAR (-1, 0hexffff));</code> |
** adjust memory settings | ** adjust memory settings | ||
* Configure [http://en.wikipedia.org/wiki/Cross-origin_resource_sharing CORS] (Cross-Origin Resource Sharing) to allow SPARQL queries from any web application | * Configure [http://en.wikipedia.org/wiki/Cross-origin_resource_sharing CORS] (Cross-Origin Resource Sharing) to allow SPARQL queries from any web application |
Revision as of 00:30, 18 April 2012
Helpful Virtuoso documentation links
- Bulk loading RDF source files
- Within isql:
ld_dir_all('/usr/local/virtuoso/6.1.4/share/virtuoso/vad/kb', '*.owl', 'http://kb.phenoscape.org/');
- then,
rdf_loader_run();
- Before doing the above you may need to
delete from db.dba.load_list;
to make it reload files that have previously been loaded.
- Within isql:
- Removing all triples
- Within isql:
sparql clear graph <http://kb.phenoscape.org/> ;
- Within isql:
- Setting default passwords
- Inference rules and reasoning
- Within isql:
rdfs_rule_set('http://kb.phenoscape.org/', 'http://kb.phenoscape.org/');
- First arg is name of rule set, second is RDF graph to include
- Within isql:
- Full-text indexing
- Within isql:
DB.DBA.RDF_OBJ_FT_RULE_ADD (null, null, 'All');
- Within isql:
- Performance tuning
- Add index on predicate:
CREATE BITMAP INDEX RDF_QUAD_PGOS ON DB.DBA.RDF_QUAD (G, P, O, S) PARTITION (O VARCHAR (-1, 0hexffff));
- adjust memory settings
- Add index on predicate:
- Configure CORS (Cross-Origin Resource Sharing) to allow SPARQL queries from any web application