September, 2016

SPARQL-to-SQL on Internet of Things Databases and Streams

Eugene Siow, Thanassis Tiropanis, Wendy Hall


To realise a semantic Web of Things, the challenge of achieving efficient Resource Description Format (RDF) storage and SPARQL query performance on Internet of Things (IoT) devices with limited resources has to be addressed. State-of-the-art SPARQL-to-SQL engines have been shown to outperform RDF stores on some benchmarks. In this paper, we describe an optimisation to the SPARQL-to-SQL approach, based on a study of time-series IoT data structures, that employs metadata abstraction and efficient translation by reusing existing SPARQL engines to produce Linked Data ‘just-in-time’. We evaluate our approach against RDF stores, state-of-the-art SPARQL-to-SQL engines and streaming SPARQL engines, in the context of IoT data and scenarios. We show that storage efficiency, with succinct row storage, and query performance can be improved from 2 times to 3 orders of magnitude.

Publication Meta Information

In Proceedings of the 15th International Semantic Web Conference held in Kobe, Japan
DOI: 10.1007 /978-3-319-46523-4_31



Webcast of ISWC2016 talk

Source Code