Hi Julien,
Thank you for your reply.
I have been using http://live.dbpedia.org/sparql to run the queries all
along.
Earlier Piyu_Bole was one of the replies being returned for song, artist,
runtime information with a limit of 100. Now there is no such song with
Piyu_Bole.
Describe works for <http://dbpedia.org/resource/Piyu_Bole>. So this entity
is present and is a song.
http://live.dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&query=Describe+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FPiyu_Bole%3E+&should-sponge=&format=text%2Frdf%2Bn3&timeout=0&debug=on
but is not being fetched with select query.
Is it possible that the dataset may be getting changed in the last 10-12
hours?
Just to clarify I am looking to fetch song information and related album
information.
Song information fields: Song name, lyricist, singers, song length, composer
Album information fields : Album/Movie name, language, producer, director,
music director, release year
It is fine if from a given movie I can fetch all song information or given
a song title fetch all the other information.
Thanks and regards,
Venkatesh
On Wed, Oct 10, 2012 at 9:04 PM, Julien Cojan <julien.co...@inria.fr> 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/ontology/wikiPageRedirects> <
> 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><http://live.dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&query=describe+%3Chttp%3A%2F%2Fen.wikipedia.org%2Fwiki%2FParineeta_%282005_film%29%3E&should-sponge=&format=text%2Fx-html%2Btr&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.
>
> Anyone knows why ?
>
> Julien
>
>
>
>
>
>
> ------------------------------
>
> *De: *"Venkatesh Channal" <venkateshchan...@gmail.com>
> *À: *"Mohamed Morsey" <mor...@informatik.uni-leipzig.de>
> *Cc: *dbpedia-discussion@lists.sourceforge.net
> *Envoyé: *Mercredi 10 Octobre 2012 16:24:11
> *Objet: *Re: [Dbpedia-discussion] Fetching song and movie related
> information
>
>
> Hi Mohamed,
>
> Thank you for your reply. I wanted to convey the difference in the values
> rather than to fetch it using sparql query.
>
>
> As I mentioned in my earlier mail,Producer, Artist name is different in
> the DBPedia result and Wikipedia.
>
> For Piyu_Bole the artist is mentioned as
>
> http://dbpedia.org/resource/Shantanu_Moitra
>
> where as in wikipedia the artists are: Sonu
> Nigam<http://en.wikipedia.org/wiki/Sonu_Nigam>
> , Shreya Ghoshal <http://en.wikipedia.org/wiki/Shreya_Ghoshal>
>
> the producer result from DBPedia is :
>
> http://dbpedia.org/resource/Shantanu_Moitra
> in wikipedia the result is: Vidhu Vinod Chopra. I am looking for ways to
> get the same information provided by Wikipedia using DBPedia.
>
> Hope the problem is clear now.
>
> Thanks and regards,
> Venkatesh
>
>
> On Wed, Oct 10, 2012 at 7:21 PM, Mohamed Morsey <
> mor...@informatik.uni-leipzig.de> wrote:
>
>> Hi Venkatesh,
>>
>>
>> On 10/10/2012 10:18 AM, Venkatesh Channal wrote:
>>
>> Hi,
>>
>> I executed the sparql query provided by Pablo on
>> http://live.dbpedia.org/sparql endpoint to fetch the song name, artist
>> and length information.
>>
>> 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 . } limit 100
>>
>> The query executed but the information that is available is not
>> matching with the information in Wikipedia.
>>
>> As an example,
>>
>> One of the returned triples is after executing the :
>>
>> http://dbpedia.org/resource/Piyu_Bole
>> http://dbpedia.org/resource/Shantanu_Moitra 266.0
>> I then did a describe on the subject returned
>>
>> Describe <http://dbpedia.org/resource/Piyu_Bole>
>>
>>
>> Actually the resource you mentioned just redirects to another resource,
>> specifically
>> "http://dbpedia.org/resource/Parineeta_(2005_film)"<http://dbpedia.org/resource/Parineeta_(2005_film)>,
>> which is a movie.
>>
>> Regarding runtime, the runtime is in seconds.
>> So if we consider resource
>> "http://dbpedia.org/resource/Chaiyya_Chaiyya";<http://dbpedia.org/resource/Chaiyya_Chaiyya>as
>> an example, and its corresponding Wikipedia page
>> "http://en.wikipedia.org/wiki/Chaiyya_Chaiyya";<http://en.wikipedia.org/wiki/Chaiyya_Chaiyya>,
>> you will find that in the Wikipedia article that its length is "6:48",
>> which is equivalent to 408 seconds.
>>
>>
>>
>> I was expecting to find the singer information, album information,
>> producer, movie director other song and album related information.
>>
>>
>> If you want to get more information you should just extend that query,
>> e.g. the following one will give you the producer information as well:
>>
>> Select ?song ?artist ?runtime ?producer ?prodInfo where { ?song
>> dcterms:subject
>> <http://dbpedia.org/resource/Category:Hindi_songs><http://dbpedia.org/resource/Category:Hindi_songs>.
>> ?song rdf:type dbpedia-owl:Song . ?song dbpedia-owl:artist ?artist .
>> ?song dbpedia-owl:runtime ?runtime. ?song dbpedia-owl:producer ?producer.
>> ?producer ?prod ?prodInfo } limit 1000
>>
>>
>>
>> The corresponding wikipedia link is
>> http://en.wikipedia.org/wiki/Piyu_Bole
>>
>> Here for the song Piyu Bole the information is:
>>
>> No. Title Singer(s) Length
>> 1. "Piyu Bole <http://en.wikipedia.org/wiki/Piyu_Bole>" Sonu
>> Nigam<http://en.wikipedia.org/wiki/Sonu_Nigam>
>> , Shreya Ghoshal <http://en.wikipedia.org/wiki/Shreya_Ghoshal> 4:21
>> Album/Movie information in which the song is present is:
>>
>> Directed by Pradeep Sarkar<http://en.wikipedia.org/wiki/Pradeep_Sarkar>
>> Produced
>> by Vidhu Vinod Chopra <http://en.wikipedia.org/wiki/Vidhu_Vinod_Chopra>
>> Screenplay
>> by Vidhu Vinod Chopra
>> Pradeep Sarkar Story by Vidhu Vinod Chopra
>> Pradeep Sarkar Starring Vidya
>> Balan<http://en.wikipedia.org/wiki/Vidya_Balan>
>> Sanjay Dutt <http://en.wikipedia.org/wiki/Sanjay_Dutt>
>> Saif Ali Khan <http://en.wikipedia.org/wiki/Saif_Ali_Khan>
>> Raima Sen <http://en.wikipedia.org/wiki/Raima_Sen>
>> Diya Mirza <http://en.wikipedia.org/wiki/Diya_Mirza> Music by Shantanu
>> Moitra <http://en.wikipedia.org/wiki/Shantanu_Moitra> Cinematography
>> Natarajan
>> Subramaniam <http://en.wikipedia.org/wiki/Natarajan_Subramaniam> Editing
>> by Hemanti Sarkar
>> Nitish Sharma Distributed by Vinod Chopra
>> Productions<http://en.wikipedia.org/wiki/Vinod_Chopra_Productions>
>> Release date(s)
>>
>> - June 10, 2005
>>
>> Running time 131 minutes Country India Language
>> Hindi<http://en.wikipedia.org/wiki/Hindi_language>
>> Budget [image: INR]25 crore <http://en.wikipedia.org/wiki/Crore>
>> (US$<http://en.wikipedia.org/wiki/United_States_dollar>4.73
>> million)[1] <http://en.wikipedia.org/wiki/Piyu_Bole#cite_note-ref1-0> Box
>> office [image: INR]32.35 crore <http://en.wikipedia.org/wiki/Crore>
>> (US$<http://en.wikipedia.org/wiki/United_States_dollar>6.11
>> million)
>>
>> Information that is different: Producer, Artist name is different in the
>> DBPedia result and Wikipedia.
>>
>> For Artist I expect the information available in the song infobox of
>> wikipedia. Is it because the dump that is used for dbpedia may not be the
>> latest?
>>
>>
>> Thanks and regards,
>> Venkatesh
>>
>>
>> Hope that helps.
>>
>> --
>> 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
