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/ontology/wikiPageRedirects>
> <http://dbpedia.org/resource/Parineeta_(2005_film)> .
but describe <http://dbpedia.org/resource/Parineeta_(2005_film)> gives only
this triple
and describe <http://dbpedia.org/resource/Parineeta_%282005_film%29> very
little.
Anyone knows why ?
Julien
----- Mail original -----
> 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 , 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)" , which is a
> > movie.
>
> > Regarding runtime, the runtime is in seconds.
>
> > So if we consider resource
> > "http://dbpedia.org/resource/Chaiyya_Chaiyya"; as an example, and
> > its
> > corresponding Wikipedia page
> > "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>
> > > .
> > > ?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 " Sonu Nigam , Shreya Ghoshal 4:21
> >
>
> > > Album/Movie information in which the song is present is:
> >
>
> > > Directed by Pradeep Sarkar
> >
>
> > > Produced by Vidhu Vinod Chopra
> >
>
> > > Screenplay by Vidhu Vinod Chopra
> >
>
> > > Pradeep Sarkar
> >
>
> > > Story by Vidhu Vinod Chopra
> >
>
> > > Pradeep Sarkar
> >
>
> > > Starring Vidya Balan
> >
>
> > > Sanjay Dutt
> >
>
> > > Saif Ali Khan
> >
>
> > > Raima Sen
> >
>
> > > Diya Mirza
> >
>
> > > Music by Shantanu Moitra
> >
>
> > > Cinematography Natarajan Subramaniam
> >
>
> > > Editing by Hemanti Sarkar
> >
>
> > > Nitish Sharma
> >
>
> > > Distributed by Vinod Chopra Productions
> >
>
> > > Release date(s)
> >
>
> > > * June 10, 2005
> >
>
> > > Running time 131 minutes
> >
>
> > > Country India
> >
>
> > > Language Hindi
> >
>
> > > Budget INR25 crore ( US$ 4.73 million) [1]
> >
>
> > > Box office INR32.35 crore ( US$ 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
