[ontology-summit] Ontology Summit 2014 Hackathon - Optimized SPARQL perf

[Victor Chernov <vchernov@xxxxxxxxxxxxxx>]

Optimized SPARQL performance management via native API Hackathon took place on March 29, 2014 14:00 - 18:00 MSK (virtual session) with subsequent activities during the next day. 
Four people participated in the event:

1. Victor Chernov (team lead), General Manager at NitrosData Rus, Russia, vchernov@xxxxxxxxxxxxxx;
2. Vladislav Golovkov System Architect at NitrosData Rus, Russia, vgolovkov@xxxxxxxxxxxxxx;
3. Andrej Andrejev, Ph.D. student at Uppsala University, Sweden, andrej.andrejev@xxxxxxxx;
4. Vladimir Salnikov, Head of QA Department at Compile Group, Russia, vladimir.salnikov@xxxxxxxxxxxxxx.

During the event triplestores have been installed, benchmark queries prepared, experiments have been set up and run. The results are discussed and published (see link below). 
The main conclusions are:

1. Performance is bottleneck for ontological technologies.
2. It is desirable to have direct access to database, not through TCP protocol.
3. Sometimes it is worth to simplify the queries as much as possible and make some processing on the client.
4. Very often what is difficult to do with a single large query is easy to implement with a set of small ones. In those cases triplestore should be able to perform small queries quickly. Further performance gain would be reached giving the users direct access to database, bypassing SPARQL processing.
5. The myth that RDF database is slower than SQL does not work anymore. RDF storages perform fast and can compete with SQL databases.

The report can be downloaded from 
http://nitrosbase.com/wp-content/uploads/OptimizedSPARQLreportV11.zip

Regards,
Victor
mailto:vchernov@xxxxxxxxxxxxxx 

_________________________________________________________________
Msg Archives: http://ontolog.cim3.net/forum/ontology-summit/   
Subscribe/Config: http://ontolog.cim3.net/mailman/listinfo/ontology-summit/  
Unsubscribe: mailto:ontology-summit-leave@xxxxxxxxxxxxxxxx
Community Files: http://ontolog.cim3.net/file/work/OntologySummit2014/
Community Wiki: http://ontolog.cim3.net/cgi-bin/wiki.pl?OntologySummit2014  
Community Portal: http://ontolog.cim3.net/wiki/     (01)