sparql2sql's Introduction

sparql2sql

SPARQL to SQL with less joins. Most information about sparql2sql can be found on the wiki. This includes a reference for the S2SML language for sparql2sql mappings, benchmarks, implementation of the swappable BGP resolution interface, etc.

Transforming Linked Sensor Data from RDF to RDBMS

To run SRBench on sparql2sql, follow the procedure using the LSD-ETL tool to transform LSD from RDF to RDBMS at https://github.com/eugenesiow/lsd-ETL.

SRBench

The translated queries using the engine can be found on https://github.com/eugenesiow/sparql2sql/wiki

Smart Home Benchmark

The translated queries using the engine can be found on https://github.com/eugenesiow/ldanalytics-PiSmartHome/wiki.

Running the engine for translating benchmark queries

Download the release.

Uncompress the release unzip sparql2sql.zip
chmod 775 test_queries_smarthome.sh
chmod 775 test_queries_srbench.sh
./test_queries_smarthome.sh to run the smart home benchmark
./test_queries_srbench.sh to run SRBench
Output will contain the time taken to run reach query and after that will do a diff in the directories of all engines (e.g. Jena, Sesame) and a gold standard SQL output
Modify test_queries_smarthome.sh or test_queries_srbench.sh to change parameters of the run

The usage of the GenerateQueries class is as follows

  usage: LSDTransform -C <folder path> -E <engine name> -I <folder path> -O
         <folder path>
   -C,--config <folder path>   the config folder path
   -E,--engine <engine name>   the engine to use (e.g. Jena, Sesame)
   -I,--src <folder path>      the source folder path
   -O,--output <folder path>   the output folder path

Config files contain a relative path to the mapping from the config path on each line

Running sparql2sql benchmarks

Benchmarking with SRBench and the Smart Home Analytics Benchmark.

Streaming version and benchmarks (sparql2stream)

Benchmarking with SRBench and the Smart Home Analytics Benchmark.

For sparql2stream
For CQELS

CityBench benchmarking with the new sparql2stream RSP-QL engine.

CityBench with sparql2stream
CityBench Queries

sparql2sql Server

A Jetty-based server to provide a SPARQL endpoint with an RDBMS backend and using the sparql2sql translation engine can be found at https://github.com/eugenesiow/sparql2sql-server.

Other Projects

sparql2sql's People

Contributors

Stargazers

Watchers

sparql2sql's Issues

Empty SQL result

Hi,
I am trying to use sparql2sql to translate SPARQL queries to SQL, but I keep getting empty result in the .sql files. If my understanding is correct, all I need to do is to create a similar .sh file as the test_queries_smarthome.sh and replace the input, output, and config paths with mine. In the input files I give the sparql query and inside config files I give the dataset path. Program runs without errors.

My .sh file:
java -cp sparql2sql-0.2.0.jar uk.ac.soton.ldanalytics.sparql2sql.GenerateQueries -I custom_test/ -O custom_test/jena -C custom_test/ -E Jena
(custom_test file is organised like your test_queries)
Any ideas??
Thanks

Empty sql string as translation

Hi,
I am trying to work with the package, and it seems that although the definition of the model and the sparql are legitimate and even quite easy, the resulting sql is null.
Is there a way to receive the sql translation without querying the datasource for the specific filtered values ?

eugenesiow / sparql2sql Goto Github PK