Difference between revisions of "Virtuoso"

Latest revision as of 21:49, 8 August 2013

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.
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 ();
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
Full-text indexing
- Within isql: DB.DBA.RDF_OBJ_FT_RULE_ADD (null, null, 'All');
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
Configure 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

@@ Line 6: / Line 6: @@
 * [http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtRemoveTriples Removing all triples]
 ** 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/rdfsparqlrule.html Inference rules and reasoning]