Revision as of 11:00, 4 May 2015

Downloads

The packages are available for download at sourceforge.net

LUBM-SP: http://sourceforge.net/projects/graphke/files/lubmsp_1.0.0.jar/download

LUBM-SP ontology: http://sourceforge.net/projects/graphke/files/lubmsp_onto.nt/download

SPARQL queries http://sourceforge.net/projects/graphke/files/queries.tar.gz/download

Jena Query evaluation http://sourceforge.net/projects/graphke/files/lubmsp_query_eval_1.0.0.jar/download

Instructions

Setting up files

1. mkdir lubmsp
2. cd lubmsp
3. Download all the files provided in the Download section above into this folder
4. tar -xzvf queries.tar.gz
5. You may want to install the rlwrap package for command history

Here we explain the step-by-step to generate the LUBM-SP datasets, and run the query evaluation

Generating LUBM and LUBM-SP datasets

1. cd lubmsp
2. Run the code, the number of university may be 50, 500, or 1000
java -jar lubmsp_1.0.0.jar -univ 500 -index 0 -onto http://knoesis.org/lubmsp
3. Check for three data files generated
LUBM_500.nt: the original LUBM in the form of ntriples
LUBM_500_sp.nt: the LUBM-SP in the form of ntriples
LUBM_500.rdf: the original LUBM in the form of RDF/XML

Query evaluation in Jena

1. cd lubmsp
2. java -jar lubmsp_query_eval_1.0.0.jar 
or
rlwrap java -jar lubmsp_query_eval_1.0.0.jar
reasoner:
rdfs
ontology:
lubmsp_onto.nt
instances:
LUBM_500_sp.nt
query:
queries/lubm_query1.sparql

Preparing Oracle 12c

1. Download and install Oracle database 12c to $ORACLE_HOME
2. Download and install Oracle client: sqlplus
3. Create one Oracle instance using dbca 
4. Connect to sqlplus
sqlplus / as sysdba
4. Execute the two files $ORACLE_HOME/md/admin/catsem.sql and $ORACLE_HOME/md/admin/sdordfwm.sql
SQL> @'?/md/admin/catsem.sql'
SQL> @'?/md/admin/sdordfwm.sql'

== Loading data to Oracle 12c