Hi Venkatesh and all,
the question here is "is there a Wikipedia page for song "Pappu Can't
Dance"? ".
On 10/11/2012 05:07 PM, Venkatesh Channal wrote:
Even with rdf:type Work the song starting with "Pappu" is not among
the returned values.
Regards,
Venkatesh
On Thu, Oct 11, 2012 at 8:33 PM, Pablo N. Mendes
<pablomen...@gmail.com <mailto:pablomen...@gmail.com>> wrote:
Good point, Tom.
That article is in Category:Hindi_films, not
Category:Hindi_songs and it's a Film, not a song, so it's not
going to meet the requirements of your query.
But maybe the class hierarchy comes to the rescue (Work is a
supertype of Song and Film)?
Select distinct * where { ?song <http://purl.org/dc/terms/subject>
<http://dbpedia.org/resource/Category:Hindi_songs> . ?song
rdf:type <http://dbpedia.org/ontology/Work> . ?song
<http://dbpedia.org/ontology/artist> ?artist . ?song
<http://dbpedia.org/ontology/runtime> ?runtime . filter
(regex(str(?song),'P'))} limit 100
Cheers,
Pablo
On Thu, Oct 11, 2012 at 4:15 PM, Tom Morris <tfmor...@gmail.com
<mailto:tfmor...@gmail.com>> wrote:
On Thu, Oct 11, 2012 at 9:48 AM, Venkatesh Channal
<venkateshchan...@gmail.com
<mailto:venkateshchan...@gmail.com>> wrote:
Hi,
I think I am still missing on how to query the information.
On executing the query:
SELECT * WHERE { ?s <http://purl.org/dc/terms/subject>
<http://dbpedia.org/resource/Category:Hindi-language_films>.
?s rdf:type <http://dbpedia.org/ontology/Film> } LIMIT 100
One of the values got was -
http://dbpedia.org/resource/Jaane_Tu..._Ya_Jaane_Na.
To find the information about all triples that has the
film name as subject. The idea was to find song and singer
of those songs. The query executed:
select * where {
<http://dbpedia.org/resource/Jaane_Tu..._Ya_Jaane_Na> ?p
?o . }
One of the values returned is -
http://dbpedia.org/property/title "Pappu Can't Dance"@en
Here "Pappu Can't Dance"@en is a song.
I executed the following query to find artist associated
with the song that begin with the character 'P'. The song
"Pappu Can't Dance" was not returned.
Select distinct * where { ?song
<http://purl.org/dc/terms/subject>
<http://dbpedia.org/resource/Category:Hindi_songs> . ?song
rdf:type <http://dbpedia.org/ontology/Song> . ?song
<http://dbpedia.org/ontology/artist> ?artist . ?song
<http://dbpedia.org/ontology/runtime> ?runtime . filter
(regex(str(?song),'P'))} limit 100
The correspong wikipedia link is -
http://en.wikipedia.org/wiki/Jaane_Tu..._Ya_Jaane_Na
That article is in Category:Hindi_films, not
Category:Hindi_songs and it's a Film, not a song, so it's not
going to meet the requirements of your query. It looks like
the DBpedia extractor attempted to extract as much information
as possible from the page, but that strategy, combined with
the way Wikipedians edit is causing confusion.
Even the article contains infoboxes for both the film and the
soundtrack album, the subject is principally, in my opinion,
the film. Including triples related to the soundtrack album
associated with the same URI is just going to cause confusion.
Tom
Appreciate your feedback and help.
Thanks and regards,
Venkatesh
On Thu, Oct 11, 2012 at 6:20 PM, Julien Cojan
<julien.co...@inria.fr <mailto:julien.co...@inria.fr>> wrote:
Hi Mohamed,
------------------------------------------------------------------------
*De: *"Mohamed Morsey"
<mor...@informatik.uni-leipzig.de
<mailto:mor...@informatik.uni-leipzig.de>>
*À: *"Julien Cojan" <julien.co...@inria.fr
<mailto:julien.co...@inria.fr>>
*Cc: *"Venkatesh Channal"
<venkateshchan...@gmail.com
<mailto:venkateshchan...@gmail.com>>,
dbpedia-discussion@lists.sourceforge.net
<mailto:dbpedia-discussion@lists.sourceforge.net>
*Envoyé: *Jeudi 11 Octobre 2012 10:49:45
*Objet: *Re: [Dbpedia-discussion] Fetching song
and movie related information
Hi Julien,
On 10/10/2012 05:34 PM, Julien Cojan wrote:
Hi,
Are you running the query on
http://live.dbpedia.org/sparql ?
I don't get any artist associated to
http://dbpedia.org/resource/Piyu_Bole in this
endpoint.
You must have got from
http://dbpedia.org/sparql which is not synched
with wikipedia.
As Mohamed said, the wikipedia page was
redirected to
http://en.wikipedia.org/wiki/Parineeta_(2005_film)
<http://en.wikipedia.org/wiki/Parineeta_%282005_film%29>.
There is something weird though, there is a triple
<http://dbpedia.org/resource/Piyu_Bole>
<http://dbpedia.org/resource/Piyu_Bole>
<http://dbpedia.org/ontology/wikiPageRedirects>
<http://dbpedia.org/ontology/wikiPageRedirects>
<http://dbpedia.org/resource/Parineeta_(2005_film)>
<http://dbpedia.org/resource/Parineeta_%282005_film%29>
.
but describe
<http://dbpedia.org/resource/Parineeta_(2005_film)>
<http://live.dbpedia.org/sparql?default-graph-uri=&query=describe+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FParineeta_%282005_film%29%3E&should-sponge=&format=text%2Fplain&timeout=0&debug=on>
gives only this triple
and describe
<http://dbpedia.org/resource/Parineeta_%282005_film%29>
<http://live.dbpedia.org/sparql?default-graph-uri=&query=describe+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FParineeta_%25282005_film%2529%3E&should-sponge=&format=text%2Fplain&timeout=0&debug=on>
very little.
sorry I didn't get what you mean by very little.
I tried query " describe
<http://dbpedia.org/resource/Parineeta_%282005_film%29>
<http://dbpedia.org/resource/Parineeta_%282005_film%29>
", and it gives 109 triples.
Same for me now, when I tried I had about 10. Maybe
the page was being extracted after a change.
There is bug though about the use of two different
URI/IRIs for Parineeta_(2005_film)
<http://live.dbpedia.org/sparql?default-graph-uri=&query=describe+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FParineeta_%282005_film%29%3E&should-sponge=&format=text%2Fplain&timeout=0&debug=on>
.
Anyone knows why ?
Julien
--
Kind Regards
Mohamed Morsey
Department of Computer Science
University of Leipzig
------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy
New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and
.NET app
Try New Relic at no cost today and get our sweet Data Nerd
shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
Dbpedia-discussion mailing list
Dbpedia-discussion@lists.sourceforge.net
<mailto:Dbpedia-discussion@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New
Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and
.NET app
Try New Relic at no cost today and get our sweet Data Nerd
shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
Dbpedia-discussion mailing list
Dbpedia-discussion@lists.sourceforge.net
<mailto:Dbpedia-discussion@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
--
---
Pablo N. Mendes
http://pablomendes.com
Events: http://wole2012.eurecom.fr <http://wole2012.eurecom.fr/>
------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
Dbpedia-discussion mailing list
Dbpedia-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
--
Kind Regards
Mohamed Morsey
Department of Computer Science
University of Leipzig
------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
Dbpedia-discussion mailing list
Dbpedia-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
