Virtuoso

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.
• 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