Question posed by Dan Brickley via a blog post: SQL, OpenOffice:
would a JDBC driver for SPARQL protocol make
sense?
Writing a JDBC Driver for SPARQL is a little overkill. OpenOffice.org simply needs to make XML or
Web Data (HTML, XHTML,
and XML) bonafide data sources within its "Pivot Table" functionality realm. Then all
that would then be required is a SPARQL SELECT Query transported via the
SPARQL Protocol with results sent back using
the SPARQL XML results serialization format (all
part of a single SPARQL Protocol URL).
Excel successfully consumes the following information resource
URI: http://tinyurl.com/yvoccj (a tiny url for a SPARQL SELECT
against my FOAF file).
Alternatively, and currently achievable, you could simply use
SPASQL (SPARQL within SQL) using a DBMS
engine that supports SQL, SPARQL, and SPARQL e.g. Virtuoso.
Virtuoso SPASQL support is exposed via
it's ODBC and/or JDBC Drivers. Thus you can do
things such as:
- Use a SPARQL Query in the FROM CLAUSE of a SQL
statement
- Execute SPARQL via SQL processor by prepending SPARQL query
text with the literals "sparql"
BTW - My News Years Resolution: get my act together and shrink
the ever increasing list of "simple & practical Virtuoso use
case demos" on my todo which now spans all the way back to 2006
:-(
About this entry:
Author: Kingsley Uyi Idehen
Published: 01/04/2008 21:50 GMT-0500
Modified: 02/04/2008 20:42 GMT-0500
Tags: rdf , xml , jdbc , sql , odbc , foaf , semanticweb , sparql , socialnetworking , virtuoso , DataSpace , .net , dataspace
Categories: Virtual Database ,
Data Access ,
SQL , Semantic Web
Comment Status: 1
Comments
Permalink:
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1288