Hi,
Pablo - The query was executed at http://live.dbpedia.org.
Tom - The first query identifies the name of the movie/film - "Jaane
Tu...Ya Jaane Na" From the movie I get the list of songs. One of the songs
is - Pappu Can't Dance.
Then I try to execute the query to find the artist information for all song
having 'P' expecting Pappu Can't Dance to be one of the songs. It is not
listed though.
Thanks and regards,
Venkatesh
On Thu, Oct 11, 2012 at 7:45 PM, Tom Morris <tfmor...@gmail.com> wrote:
>
>
> On Thu, Oct 11, 2012 at 9:48 AM, 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
>>
>>
> 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>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
>>
>>
>
------------------------------------------------------------------------------
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
