Setting up Virtuoso

1. Setup virtuoso using http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/

Notes for myself ubuntu build http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSUbuntuNotes /usr/bin/isql-vt -- command-line database-access tool, iSQL /usr/bin/virtuoso-t -- Main daemon executable /etc/virtuoso-opensource-6.1/virtuoso.ini -- configuration file /var/lib/virtuoso-opensource-6.1/db/ -- the database itself /usr/share/virtuoso/vad/ -- datafiles

2. copy data files into /usr/share/virtuoso/vad/ or change virtuoso.ini allowed dir

3. load data using isql /usr/bin/isql-vt

Test sbml data can be downloaded from https://sites.google.com/site/ricordowp4/file-cabinet/sbmltordf

clear graphs if already exist

SPARQL CLEAR GRAPH <http://ricordo.com>;
SPARQL CLEAR GRAPH <http://rdf-schema.com>;
SPARQL CLEAR GRAPH <http://ricordosch.com>;

load graphs

DB.DBA.RDF_LOAD_RDFXML_MT (file_to_string_output ('/usr/share/virtuoso/vad/BIOMD0000000001.rdf'), '', 'http://ricordo.com');
DB.DBA.RDF_LOAD_RDFXML_MT (file_to_string_output ('/usr/share/virtuoso/vad/rdf-schema.rdf'), '', 'http://rdf-schema.com');
DB.DBA.RDF_LOAD_RDFXML_MT (file_to_string_output ('/usr/share/virtuoso/vad/sbmlrdfschema.rdf'), '', 'http://ricordosch.com');

set ricordo-rule

rdfs_rule_set ('ricordo_rule', 'http://ricordosch.com');
rdfs_rule_set ('ricordo_rule', 'http://rdf-schema.com');

To bluk loading of rdf files follow instructions at http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtBulkRDFLoader

SQL> load rdfloader.sql;
SQL> ld_dir('/usr/share/virtuoso/vad/', '*.rdf', 'http://ricordo.com');
SQL> rdf_loader_run();