StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
17266217
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-06-23T23:22:21.383
FavoriteCount
0
LastActivityDate
2018-05-14T18:49:32.510
LastEditDate
2018-05-14T18:49:32.510
LastEditorUserId
1281433
OwnerUserId
1281433
ParentId
14980386
PostTypeId
2
Score
5
ViewCount
0
LastEditorDisplayName
text
Body
You want a <a href="http://www.w3.org/TR/sparql11-federated-query/" rel="nofollow noreferrer">federated SPARQL query</a>. You do not need to write code (other than the SPARQL query). You'll need an endpoint that supports them, and since it requires querying multiple endpoints, you might need to run your own endpoint (that might not contain any actual data, but can do the federation for you). Based on the requirements you outlined above, you probably want a query like the following. Notice that I removed <code>?dbpediaLink</code> from the projected variables; that is, this query does not <code>SELECT ?dbpediaLink</code>, since you're probably not interested in seeing that value so much as using it to retrieve data from DBpedia. You can add it back if you want it, of course. <pre class="lang-sql prettyprint-override"><code>PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX movie: <http://data.linkedmdb.org/resource/movie/> PREFIX dcterms: <http://purl.org/dc/terms/> SELECT ?film ?label ?subject WHERE { SERVICE <http://data.linkedmdb.org/sparql> { ?film a movie:film . ?film rdfs:label ?label . ?film owl:sameAs ?dbpediaLink FILTER(regex(str(?dbpediaLink), "dbpedia", "i")) } SERVICE <http://dbpedia.org/sparql> { ?dbpediaLink dcterms:subject ?subject } } LIMIT 50 </code></pre> You cannot run that directly against the <a href="http://dbpedia.org/sparql" rel="nofollow noreferrer">DBpedia SPARQL endpoint</a>, but you can use <a href="http://jena.apache.org/documentation/query/" rel="nofollow noreferrer">Jena's ARQ</a> to run the query locally, and ARQ will do the queries to the other endpoints for you. I created an empty file, <code>data.n3</code> to pass to ARQ as the <code>--query</code> argument, and was able to run the query like this (where <code>query.sparql</code> is the query above): <pre><code>$ arq --query query.sparql --data data.n3 </code></pre> The results look like the following. Note that each DBpedia resource can be related to a number of categories by the <code>dcterms:subject</code> property, so even though we have a <code>LIMIT 50</code> there, we're not actually getting fifty movies, but fifty result rows. <pre><code>-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | film | label | subject | ================================================================================================================================================================================ | <http://data.linkedmdb.org/resource/film/11> | "Godzilla vs. the Sea Monster" | <http://dbpedia.org/resource/Category:1960s_horror_films> | | <http://data.linkedmdb.org/resource/film/11> | "Godzilla vs. the Sea Monster" | <http://dbpedia.org/resource/Category:Films_directed_by_Jun_Fukuda> | | <http://data.linkedmdb.org/resource/film/11> | "Godzilla vs. the Sea Monster" | <http://dbpedia.org/resource/Category:Giant_monster_films> | | <http://data.linkedmdb.org/resource/film/11> | "Godzilla vs. the Sea Monster" | <http://dbpedia.org/resource/Category:Monster_movies> | | <http://data.linkedmdb.org/resource/film/11> | "Godzilla vs. the Sea Monster" | <http://dbpedia.org/resource/Category:1966_films> | | <http://data.linkedmdb.org/resource/film/11> | "Godzilla vs. the Sea Monster" | <http://dbpedia.org/resource/Category:Godzilla_films> | | <http://data.linkedmdb.org/resource/film/11> | "Godzilla vs. the Sea Monster" | <http://dbpedia.org/resource/Category:Japanese_films> | | <http://data.linkedmdb.org/resource/film/11> | "Godzilla vs. the Sea Monster" | <http://dbpedia.org/resource/Category:Kaiju_films> | | <http://data.linkedmdb.org/resource/film/11> | "Godzilla vs. the Sea Monster" | <http://dbpedia.org/resource/Category:Mothra> | | <http://data.linkedmdb.org/resource/film/11> | "Godzilla vs. the Sea Monster" | <http://dbpedia.org/resource/Category:Terrorism_in_fiction> | | <http://data.linkedmdb.org/resource/film/11> | "Godzilla vs. the Sea Monster" | <http://dbpedia.org/resource/Category:1960s_science_fiction_films> | | <http://data.linkedmdb.org/resource/film/11> | "Godzilla vs. the Sea Monster" | <http://dbpedia.org/resource/Category:Sequel_films> | | <http://data.linkedmdb.org/resource/film/11> | "Godzilla vs. the Sea Monster" | <http://dbpedia.org/resource/Category:Japanese-language_films> | | <http://data.linkedmdb.org/resource/film/11> | "Godzilla vs. the Sea Monster" | <http://dbpedia.org/resource/Category:Mystery_Science_Theater_3000_episodes> | | <http://data.linkedmdb.org/resource/film/105> | "Top Hat" | <http://dbpedia.org/resource/Category:1930s_musical_films> | | <http://data.linkedmdb.org/resource/film/105> | "Top Hat" | <http://dbpedia.org/resource/Category:American_musical_comedy_films> | | <http://data.linkedmdb.org/resource/film/105> | "Top Hat" | <http://dbpedia.org/resource/Category:American_romantic_comedy_films> | | <http://data.linkedmdb.org/resource/film/105> | "Top Hat" | <http://dbpedia.org/resource/Category:American_romantic_musical_films> | | <http://data.linkedmdb.org/resource/film/105> | "Top Hat" | <http://dbpedia.org/resource/Category:1935_films> | | <http://data.linkedmdb.org/resource/film/105> | "Top Hat" | <http://dbpedia.org/resource/Category:American_screwball_comedy_films> | | <http://data.linkedmdb.org/resource/film/105> | "Top Hat" | <http://dbpedia.org/resource/Category:Black-and-white_films> | | <http://data.linkedmdb.org/resource/film/105> | "Top Hat" | <http://dbpedia.org/resource/Category:Films_directed_by_Mark_Sandrich> | | <http://data.linkedmdb.org/resource/film/105> | "Top Hat" | <http://dbpedia.org/resource/Category:1930s_romantic_comedy_films> | | <http://data.linkedmdb.org/resource/film/105> | "Top Hat" | <http://dbpedia.org/resource/Category:United_States_National_Film_Registry_films> | | <http://data.linkedmdb.org/resource/film/105> | "Top Hat" | <http://dbpedia.org/resource/Category:Films_set_in_London> | | <http://data.linkedmdb.org/resource/film/105> | "Top Hat" | <http://dbpedia.org/resource/Category:RKO_Pictures_films> | | <http://data.linkedmdb.org/resource/film/154> | "E.T. the Extra-Terrestrial" | <http://dbpedia.org/resource/Category:American_children's_fantasy_films> | | <http://data.linkedmdb.org/resource/film/154> | "E.T. the Extra-Terrestrial" | <http://dbpedia.org/resource/Category:Best_Original_Music_Score_Academy_Award_winners> | | <http://data.linkedmdb.org/resource/film/154> | "E.T. the Extra-Terrestrial" | <http://dbpedia.org/resource/Category:E.T._the_Extra-Terrestrial> | | <http://data.linkedmdb.org/resource/film/154> | "E.T. the Extra-Terrestrial" | <http://dbpedia.org/resource/Category:English-language_films> | | <http://data.linkedmdb.org/resource/film/154> | "E.T. the Extra-Terrestrial" | <http://dbpedia.org/resource/Category:1980s_science_fiction_films> | | <http://data.linkedmdb.org/resource/film/154> | "E.T. the Extra-Terrestrial" | <http://dbpedia.org/resource/Category:1982_films> | | <http://data.linkedmdb.org/resource/film/154> | "E.T. the Extra-Terrestrial" | <http://dbpedia.org/resource/Category:Alien_visitation_films> | | <http://data.linkedmdb.org/resource/film/154> | "E.T. the Extra-Terrestrial" | <http://dbpedia.org/resource/Category:Amblin_Entertainment_films> | | <http://data.linkedmdb.org/resource/film/154> | "E.T. the Extra-Terrestrial" | <http://dbpedia.org/resource/Category:Films_directed_by_Steven_Spielberg> | | <http://data.linkedmdb.org/resource/film/154> | "E.T. the Extra-Terrestrial" | <http://dbpedia.org/resource/Category:1985_novels> | | <http://data.linkedmdb.org/resource/film/154> | "E.T. the Extra-Terrestrial" | <http://dbpedia.org/resource/Category:American_science_fiction_films> | | <http://data.linkedmdb.org/resource/film/154> | "E.T. the Extra-Terrestrial" | <http://dbpedia.org/resource/Category:Films_produced_by_Steven_Spielberg> | | <http://data.linkedmdb.org/resource/film/154> | "E.T. the Extra-Terrestrial" | <http://dbpedia.org/resource/Category:Films_set_in_the_San_Fernando_Valley> | | <http://data.linkedmdb.org/resource/film/154> | "E.T. the Extra-Terrestrial" | <http://dbpedia.org/resource/Category:Films_that_won_the_Best_Sound_Mixing_Academy_Award> | | <http://data.linkedmdb.org/resource/film/154> | "E.T. the Extra-Terrestrial" | <http://dbpedia.org/resource/Category:United_States_National_Film_Registry_films> | | <http://data.linkedmdb.org/resource/film/154> | "E.T. the Extra-Terrestrial" | <http://dbpedia.org/resource/Category:Universal_Pictures_films> | | <http://data.linkedmdb.org/resource/film/154> | "E.T. the Extra-Terrestrial" | <http://dbpedia.org/resource/Category:Best_Drama_Picture_Golden_Globe_winners> | | <http://data.linkedmdb.org/resource/film/154> | "E.T. the Extra-Terrestrial" | <http://dbpedia.org/resource/Category:Films_that_won_the_Best_Visual_Effects_Academy_Award> | | <http://data.linkedmdb.org/resource/film/155> | "Easy Rider" | <http://dbpedia.org/resource/Category:1960s_drama_films> | | <http://data.linkedmdb.org/resource/film/155> | "Easy Rider" | <http://dbpedia.org/resource/Category:American_films> | | <http://data.linkedmdb.org/resource/film/155> | "Easy Rider" | <http://dbpedia.org/resource/Category:1969_films> | | <http://data.linkedmdb.org/resource/film/155> | "Easy Rider" | <http://dbpedia.org/resource/Category:Films_shot_in_New_Orleans,_Louisiana> | | <http://data.linkedmdb.org/resource/film/155> | "Easy Rider" | <http://dbpedia.org/resource/Category:Directorial_debut_films> | | <http://data.linkedmdb.org/resource/film/155> | "Easy Rider" | <http://dbpedia.org/resource/Category:Films_about_drugs> | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POConnecting Linkedmdb and DBpedia via federated SPARQL queries
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USJoshua Taylor
UserOwnerUserId
1. USJoshua Taylor
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POConnecting Linkedmdb and DBpedia via federated SPARQL queries
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.