Difference between revisions of "Virtuoso"
From phenoscape
Jim Balhoff (talk | contribs) |
Jim Balhoff (talk | contribs) (→Helpful Virtuoso documentation links) |
||
| (9 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
** Within isql: <code>ld_dir_all('/usr/local/virtuoso/6.1.4/share/virtuoso/vad/kb', '*.owl', 'http://kb.phenoscape.org/');</code> | ** Within isql: <code>ld_dir_all('/usr/local/virtuoso/6.1.4/share/virtuoso/vad/kb', '*.owl', 'http://kb.phenoscape.org/');</code> | ||
** then, <code>rdf_loader_run();</code> | ** then, <code>rdf_loader_run();</code> | ||
| + | ** Before doing the above you may need to <code>delete from db.dba.load_list;</code> to make it reload files that have previously been loaded. | ||
* [http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtRemoveTriples Removing all triples] | * [http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtRemoveTriples Removing all triples] | ||
** Within isql: <code>sparql clear graph <http://kb.phenoscape.org/> ;</code> | ** Within isql: <code>sparql clear graph <http://kb.phenoscape.org/> ;</code> | ||
| + | ** Or, to remove all triples except those from the system: <code>RDF_GLOBAL_RESET ();</code> | ||
* [http://docs.openlinksw.com/virtuoso/newadminui.html Setting default passwords] | * [http://docs.openlinksw.com/virtuoso/newadminui.html Setting default passwords] | ||
* [http://docs.openlinksw.com/virtuoso/rdfsparqlrule.html Inference rules and reasoning] | * [http://docs.openlinksw.com/virtuoso/rdfsparqlrule.html Inference rules and reasoning] | ||
** Within isql: <code>rdfs_rule_set('http://kb.phenoscape.org/', 'http://kb.phenoscape.org/');</code> | ** Within isql: <code>rdfs_rule_set('http://kb.phenoscape.org/', 'http://kb.phenoscape.org/');</code> | ||
***First arg is name of rule set, second is RDF graph to include | ***First arg is name of rule set, second is RDF graph to include | ||
| − | * Performance tuning | + | * [http://docs.openlinksw.com/virtuoso/sparqlextensions.html Full-text indexing] |
| − | ** http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/ | + | ** 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] | ||
| + | ** 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 | ||
| + | * Configure [http://en.wikipedia.org/wiki/Cross-origin_resource_sharing CORS] (Cross-Origin Resource Sharing) to allow SPARQL queries from any web application | ||
| + | ** http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideCORSSetup#CORS%20Setup%20for%20Virtuoso%20servers | ||
[[Category:Informatics]] | [[Category:Informatics]] | ||
[[Category:Software]] | [[Category:Software]] | ||
Latest revision as of 21:49, 8 August 2013
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/> ; - Or, to remove all triples except those from the system:
RDF_GLOBAL_RESET ();
- 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
