Executed where? dbpedia.org/sparql? live.dbpedia.org/sparql?
On Thu, Oct 11, 2012 at 3:48 PM, Venkatesh Channal <
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
>
> Appreciate your feedback and help.
>
> Thanks and regards,
> Venkatesh
>
> On Thu, Oct 11, 2012 at 6:20 PM, Julien Cojan <julien.co...@inria.fr>wrote:
>
>> Hi Mohamed,
>>
>> ------------------------------
>>
>> *De: *"Mohamed Morsey" <mor...@informatik.uni-leipzig.de>
>> *À: *"Julien Cojan" <julien.co...@inria.fr>
>> *Cc: *"Venkatesh Channal" <venkateshchan...@gmail.com>,
>> 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).
>> 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
> Dbpedia-discussion@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>
>
--
---
Pablo N. Mendes
http://pablomendes.com
Events: 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
