ADEQUATE : Virtuoso installation

Created by Jan Váňa, last modified by Václav Brodec on Mär 03, 2017

At least one of the knowledge bases, that are made accessible to Odalic Semantic Table Interpretation server through the associated proxies and their configuration, must be modifiable by the user. For most of the publicly accessible bases this is not the case for obvious reasons. Therefore it might be necessary for the user to establish its own knowledge base by running own RDF store. Probably the most popular one is Virtuoso.

Installation

Detailed instructions for the installation and setting-up the Virtuoso (for Windows) can be found at http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSUsageWindows#Getting%20Started%20with%20the%20VOS%20Binary%20Distribution%20for%20Windows. The most important points are the following:

  1. Download pre-compiled binaries (in an archive) from http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSDownload#Pre-built%20binaries%20for%20Windows.
  2. Unpack the archive to a folder of your choice.
  3. Set a system environmental variable VIRTUOSO_HOME to the absolute path of the folder you unpacked the archive.
  4. Add the following values to the PATH environmental variable: "%VIRTUOSO_HOME%/bin" and "VIRTUOSO_HOME%/lib" (usually separated by a semicolon ";").
  5. The configuration files and Virtuoso database are now located in directory "%VIRTUOSO_HOME%/database".
  6. Set up Virtuoso service with the following command: virtuoso-t +service create +instance "New Instance Name" +configfile virtuoso.ini.
  7. If you do intend to use several instances of Virtuoso (e.g. one for DBPedia and another one for a base of different kind, e.g. Wikidata), clone folder from "%VIRTUOSO_HOME%/database" and set up a Virtuoso service also for the newly cloned configuration file.
  8. If you move a folder with configuration files out of its original destination, you have to correct all relative paths in the file virtuoso.ini.
  9. Configuration parameters NumberOfBuffers and MaxDirtyBuffers should be set according to your available computer memory (follow the instructions in the configuration file).
  10. The port number assigned to Virtuoso may be changed as well. Note that if you intend to use several instances of Virtuoso, this is an obligatory step.
  11. Once a Virtuoso service is running, a web interface may be opened. (By default it is accessible at http://localhost:8890/conductor).
  12. A VOS ODBC Driver should be installed as well. Download the driver and follow the instructions at http://virtuoso.openlinksw.com/download/.

Datasets import

Instructions on how to import datasets to Virtuoso may be found at http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtBulkRDFLoader. DBpedia datasets can be found at http://wiki.dbpedia.org/Downloads2015-10. Wikidata datasets can be found at https://www.wikidata.org/wiki/Wikidata:Database_download#RDF_dumps. Note that the import may take a significant amount of time, if a large knowledge base is used.