RDF / SPARQL "API" for debbugs - Was: Re: Getting rid of bts.d.o files parsing: alternatives

[Olivier Berger]

Hi again.

Oh, one more idea, to better fit with bts-link's use of SPARQL
queries ...

Le mardi 27 janvier 2009 à 09:35 +0100, Olivier Berger a écrit :

> To give an idea of such SPARQL queries that may be done on the
> bugtracker's RDF API, here's an example (real data on a substential copy
> of debbugs data, circa 250000 bugs parsed and stored as RDF in
> openvirtuoso on my laptop, currently) :
> 
>         prefix lino:
>         <http://nepomuk.kde.org/ontologies/2008/11/25/lino#>
>         prefix bom: <http://www.ifi.unizh.ch/ddis/evoont/2008/11/bom#>
>         
>         select * where { 
>         ?a lino:hasReporter <mailto:/olivier.berger at it-sudparis.eu> .
>         ?a bom:isIssueOf ?c
>         } order by ?c
>         
> gives :
> a  	c
> http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=496918 software:/apache2-mpm-prefork
> http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=497534 software:/apache2.2-common
> http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=417898 software:/beagle

This one was not really so much demonstrative as it only returned Debian
bugs.

This next one illustrates what can be done on bugs collected from
various bugtrackers :

prefix bom: <http://www.ifi.unizh.ch/ddis/evoont/2008/11/bom#>
prefix nao:
<http://www.semanticdesktop.org/ontologies/2007/08/15/nao#>

select ?a, ?b where { 
 ?a bom:isIssueOf <software:/konqueror> .
 ?a nao:prefLabel ?b
}

this retuns : 
...
http://bugs.kde.org//176517 Tried to copy jpg from kpdf while viewing a jpg in Konqueror and it crashed 
http://bugs.kde.org//176538 Trying to reproduce bug 169442, JS Debugger crash Konqueror on khtml/ecma/debugger/debugwindow cpp:656 
http://bugs.kde.org//176540 64bit flash plugin loads, but does nothing 
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=252571 konqueror doesn't end process, so CD won't unmount 
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=252620 konqueror: resizing browser font repositions the current window in the document 
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=260195 would like option where konqueror exits when icon is clicked h
...

So we now have a full set of bugs on konqueror both in Mandriva and
Debian... and can start establish links between them, duplicates,
relative status etc.

The guys at Mandriva are working on that, for instance to match bugs
between upstream KDE's bugzilla and Mandriva's bugzilla I think, for the
SWIM tool.

Hope this helps.

Regards,
-- 
Olivier BERGER <olivier.berger at it-sudparis.eu>
http://www-public.it-sudparis.eu/~berger_o/ - OpenPGP-Id: 1024D/6B829EEC
Ingénieur Recherche - Dept INF
Institut TELECOM, SudParis (http://www.it-sudparis.eu/), Evry (France)