MusicBrainz SQL-to-RDF D2RQ mapping from Yves Raimond

More great music-related stuff from Yves Raimond. He’s just announced (on the Music ontology list) a D2RQ mapping of the MusicBrainz SQL into RDF and SPARQL. There’s a running instance of it on his site. The N3 mapping files are on the  motools sourceforge site. Yves writes… Added to the things that are available within […]

Language Expertise in FOAF: Speaks, Reads, Writes revisited

Stephanie Booth asks:  I vaguely remember somebody telling me about some emerging “standard” (too big a word) for encoding language skills. Or was it a dream? That would’ve been me, showing markup from the FOAFX beta from Paola Di Maio and friends, which explores the extension of FOAF with expertise information. This is part of […]

JQbus: social graph query with XMPP/SPARQL

Righto, it’s about time I wrote this one up. One of my last deeds at W3C before leaving at the end of 2005, was to begin the specification of an XMPP binding of the SPARQL querying protocol. For the acronym averse, a quick recap. XMPP is the name the IETF give to the Jabber messaging […]

Small databases, loosly joined

Over the last month or so, I’ve had a SPARQL store (just an ARC instance plus a loader script) running on the Amazon EC2 sandbox I set up for FOAF experiments. Yesterday I installed a fresh SparqlPress bundle into my own blog, which runs on another server. So how to get the data across? Since […]

Graph URIs in SPARQL: Using UUIDs as named views

I’ve been using the SPARQL query language to access a very ad-hoc collection of personal and social graph data, and thanks to Bengee’s ARC system this can sit inside my otherwise ordinary WordPress installation. At the moment, everything in there is public, but lately I’ve been discussing oauth with a few folk as a way […]

RDF in Ruby revisited

If you’re interested in collaborating on Ruby tools for RDF, please join the public-rdf-ruby@w3.org mailing list at W3C. Just send a note to public-rdf-ruby-request@w3.org with a subject line of “subscribe”. Last weekend I had the fortune to run into Rich Kilmer at O’Reilly’s ‘Social graph Foo Camp‘ gathering. In addition to helping decorate my tent, […]

Waving not Drowning? groups as buddylist filters

I’ve lately started writing up and prototyping around a use-case for the “Group” construct in FOAF and for medium-sized, partially private data aggregators like SparqlPress. I think we can do something interesting to deal with the social pressure and information load people are experiencing on sites like Flickr and Twitter. Often people have rather large […]

Embedding queries in RDF – FOAF Group example

Is this crazy or useful? Am not sure yet. This example uses FOAF vocabulary for groups and openid. So the basic structure here is that Agents (including persons) can have an :openid and can be a :member of a :Group. From an openid-augmented WordPress, we get a list of all the openids my blog knows […]

Ruby client for querying SPARQL REST services

I’ve started a Ruby conversion of Ivan Herman’s Python SPARQL client, itself inspired by Lee Feigenbaum’s Javascript library. These are tools which simply transmit a SPARQL query across the ‘net to a SPARQL-protocol database endpoint, and handle the unpacking of the results. These queries can result in yes/no responses, variable-to-value bindings (rather like in SQL), […]

SPARQL results in spreadsheets

I made a little progress with SPARQL and spreadsheets. On Kingsley Idehen’s advice, revisited OpenOffice (NeoOffice on MacOSX) and used the HTML table import utility. It turns out that if I have an HTTP URL for a GET query to ARC‘s SPARQL endpoint, and I pass in the non-standard format=htmltab parameter, I get an HTML […]

SQL, OpenOffice: would a JDBC driver for SPARQL protocol make sense?

I’d like to have access to my SPARQL data from desktop tools like OpenOffice’s spreadsheet. Apparently it can talk to remote databases via JDBC and OBDBC, both for the spreadsheet and database tools within OpenOffice. Many years ago, pre-SPARQL, I hassled Libby into making her Squish RDF query system talk JDBC. There have been related […]

Commandline PHP for loading RDF URLs into ARC (and Twinkle for query UI)

#!/usr/bin/php <?php if ($argc != 2 || in_array($argv[1], array(‘–help’, ‘-help’, ‘-h’, ‘-?’))) { ?> This is a command line PHP script with one option: URL of RDF document to load <?php } else { $supersecret = “123rememberme”; #Security analysts recommend using data of birth + social security ID here # *** be careful with real […]

Querying across ‘social graph’ fragments

PREFIX : <http://xmlns.com/foaf/0.1/> PREFIX owl: <http://www.w3.org/2002/07/owl#> SELECT DISTINCT ?who ?src WHERE { GRAPH <http://xmlns.com/foaf/spec/index.rdf> { ?p a owl:InverseFunctionalProperty . } GRAPH <http://danbri.org/foaf.rdf> { [ :openid <http://danbri.org/> ; ?p ?pv ] } GRAPH ?src { [ ?p ?pv ; :knows [ :name ?who ] ] } } ORDER BY ?who Just a quick post to record […]

Flock browser RDF: describing accounts

Flock is a mozilla-based browser that emphasises social and “web2” themes. From a social-network-mobility thread, I’m reminded to take another look at Flock by Ian McKellar’s recent comments…