Ok, it is hard to discuss about results on changing data.
There there is a mess about this example Piyu_Bole because it was the page of a
song :
http://en.wikipedia.org/w/index.php?title=Piyu_Bole&direction=prev&oldid=503695506
then it was redirected to a film :
http://en.wikipedia.org/w/index.php?title=Piyu_Bole&redirect=no
As far as I understand live.dbpedia.org sparql endpoint contains as well data
from the time of dbpedia 3.8 (in graph http://dbpedia.org) and data extracted
live (in graph http://live.dbpedia.org)
So if you restrict to graph http://live.dbpedia.org, you should have it
alright.
Julien
----- Mail original -----
> De: "Venkatesh Channal" <[email protected]>
> À: "Julien Cojan" <[email protected]>
> Cc: [email protected], "Mohamed Morsey"
> <[email protected]>
> Envoyé: Mercredi 10 Octobre 2012 17:40:13
> Objet: Re: [Dbpedia-discussion] Fetching song and movie related
> information
> 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 < [email protected]
> > 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/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
>
> > > De: "Venkatesh Channal" < [email protected] >
> >
>
> > > À: "Mohamed Morsey" < [email protected] >
> >
>
> > > Cc: [email protected]
> >
>
> > > 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 <
> > > [email protected] > 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
> >
>
> > > [email protected]
> >
>
> > > 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
