- From: Martin Hepp <mfhepp@gmail.com>
- Date: Sat, 11 Dec 2010 09:33:15 +0100
- To: public-lod@w3.org
Dear all:
There are many different ways of exposing existing relational
databases as SPARQL, e.g. as summarized by [1], namely Virtuoso's RDF
Views, D2RQ, and Triplify.
I am looking for best practices / recommendations for the following
scenario:
1. There is a large and highly dynamic product or services database;
part of the data (e.g. prices) may even come from external Web
services (think of airfare, hotel prices).
2. I want to make this accessible as a SPARQL endpoint using
GoodRelations and FOAF.
3. The mapping from the original data structures to the proper RDF
must be hand-crafted anyway, so automation of this process is not
important
4. Creating RDF dumps is not feasible due to
- the dynamics of the data
- the combinatorial complexity (not all combinations may be
materialized in the database; think of product variants).
Key requirements for me are:
1. Maturity of the software (alpha / beta releases are no option)
2. Scalability - the SPARQL endpoint must handle tens of thousands of
request per hour
3. Resource management for the endpoint - it must be possible to
protect the SPARQL endpoint from costly queries and return just a
subset or refuse a query
4. Resource management for the underlying RDBMS or Web services - it
must be possible to protect the original RDBMS and involved Web
services from excessive traffic (both willful ("Semantic DDoS") and
unintentional (PhD students' Python scrips gone wild).
What would you recommend? My main point is really: Which tools /
architecture would you recommend if failure is not an option?
Thanks for any opinions!
Best
Martin
[1] A Survey of Current Approaches for Mapping of Relational
Databases to RDF (PDF), Satya S. Sahoo, Wolfgang Halb, Sebastian
Hellmann, Kingsley Idehen, Ted Thibodeau Jr, Sören Auer, Juan Sequeda,
Ahmed Ezzat, 2009-01-31.
http://www.w3.org/2005/Incubator/rdb2rdf/RDB2RDF_SurveyReport.pdf
--------------------------------------------------------
martin hepp
e-business & web science research group
universitaet der bundeswehr muenchen
e-mail: hepp@ebusiness-unibw.org
phone: +49-(0)89-6004-4217
fax: +49-(0)89-6004-4620
www: http://www.unibw.de/ebusiness/ (group)
http://www.heppnetz.de/ (personal)
skype: mfhepp
twitter: mfhepp
Check out GoodRelations for E-Commerce on the Web of Linked Data!
=================================================================
* Project Main Page: http://purl.org/goodrelations/
* Quickstart Guide for Developers: http://bit.ly/quickstart4gr
* Vocabulary Reference: http://purl.org/goodrelations/v1
* Developer's Wiki: http://www.ebusiness-unibw.org/wiki/GoodRelations
* Examples: http://bit.ly/cookbook4gr
* Presentations: http://bit.ly/grtalks
* Videos: http://bit.ly/grvideos
Received on Saturday, 11 December 2010 08:33:46 UTC