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
Appreciate your feedback and help.
Thanks and regards,
Venkatesh
On Thu, Oct 11, 2012 at 6:20 PM, Julien Cojan <[email protected]> wrote:
> Hi Mohamed,
>
> ------------------------------
>
> *De: *"Mohamed Morsey" <[email protected]>
> *À: *"Julien Cojan" <[email protected]>
> *Cc: *"Venkatesh Channal" <[email protected]>,
> [email protected]
> *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_Bolein
> 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).
> 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_(2005_film)>.
>
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
