Download to read offline
![Hands onStart with this cats example1. Go to query.wikidata.org2. Choose examples3. Click on catsSELECT ?item ?itemLabel WHERE {?item wdt:P31 wd:Q146.SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }}Play along at home at http://bit.ly/vala_sparql](/image.pl?url=https%3a%2f%2fimage.slidesharecdn.com%2fvalatechcampintrotosparql-190609080817%2f75%2fVALA-Tech-Camp-2017-Intro-to-Wikidata-SPARQL-25-2048.jpg&f=jpg&w=240)
![Improving our queryOur Query would work better if we found all librariesSELECT ?item ?itemLabel WHERE {?item wdt:P31/wdt:P279* wd:Q7075.SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }?item wdt:P17 wd:Q408.}http://tinyurl.com/y7ysrngp](/image.pl?url=https%3a%2f%2fimage.slidesharecdn.com%2fvalatechcampintrotosparql-190609080817%2f75%2fVALA-Tech-Camp-2017-Intro-to-Wikidata-SPARQL-28-2048.jpg&f=jpg&w=240)
Uploaded byJane Frazier
140 views
VALA Tech Camp 2017: Intro to Wikidata & SPARQL
The document is an introduction to Wikidata and SPARQL, focusing on RDF, linked open data, and examples of using SPARQL for querying. It covers essential concepts such as unique identifiers for objects, the importance of semantic data, and the interoperability of data across platforms. Additionally, it includes hands-on examples and resources for further exploration of SPARQL and data accessibility.
Related topics:
Recommended
More Related Content
What's hot
Similar to VALA Tech Camp 2017: Intro to Wikidata & SPARQL
More from Jane Frazier
![Day in the life of a data librarian [presentation for ANU 23Things group]](/image.pl?url=https%3a%2f%2fcdn.slidesharecdn.com%2fss_thumbnails%2fdayinthelifeofadatalibrarianpresentationforanu23tgroup-160502033355-thumbnail.jpg%3fwidth%3d640%26amp%3bheight%3d640%26amp%3bfit%3dbounds&f=jpg&w=240)
![Intro to metadata, RIF-CS, RDA records [ANU 2016]](/image.pl?url=https%3a%2f%2fcdn.slidesharecdn.com%2fss_thumbnails%2fintrotometadatarif-csrdarecordsanu2016-160412070816-thumbnail.jpg%3fwidth%3d640%26amp%3bheight%3d640%26amp%3bfit%3dbounds&f=jpg&w=240)
Recently uploaded
VALA Tech Camp 2017: Intro to Wikidata & SPARQL
- 1.Intro to WikiData& SPARQLVALA Tech Camp W4aJane FrazierOntology Operations LeadSEEK@mignon1915Peter NeishResearch Data CuratorUniversity of Melbourne@peterneish
- 2.AgendaWhat is RDF?Whatis Linked Open Data?What is SPARQL?Examples and hands-onThis presentation >>> http://bit.ly/vala_sparql
- 3.What is RDF?RDFresourcedescription frameworkSKOSsimple knowledgeorganization systemOWLweb ontologylanguageSPARQLSPARQL protocoland RDF querylanguageTriplestoredatabase for RDFdatastandards
- 4.
- 5.adapted from https://www.w3.org/TR/rdf11-primer/example-graph-iris.jpgisinterested insubjectpredicateobjectTriples
- 6.adapted from https://www.w3.org/TR/rdf11-primer/example-graph-iris.jpgBeyoncehttp://dbpedia.org/resource/BeyoncéUniformResource Identifiers (URIs)Resources can be…● People● Places● Things● Documents● Data● Publications● Relationships
- 7.
- 8.Beyoncehttp://dbpedia.org/resource/Beyoncéhttp://dbpedia.org/resource/Jay_ZJay Z1981-09-04adapted fromhttps://www.w3.org/TR/rdf11-primer/example-graph-iris.jpg
- 9.Beyoncehttp://dbpedia.org/resource/Beyoncéhttp://dbpedia.org/resource/Jay_ZJay Z1981-09-04adapted fromhttps://www.w3.org/TR/rdf11-primer/example-graph-iris.jpgTriplestoredatabase for RDF dataDifferent from arelationaldatabase!
- 11.What is LinkedOpen Data?semantically linked structured data on the open web
- 12.
- 13.5-Star Open Datahttp://5stardata.infoMakeyour stuff available on theWeb (whatever format) under anopen license
- 14.5-Star Open Datahttp://5stardata.infoMakeit available as structureddata (e.g., Excel instead ofimage scan of a table)
- 15.5-Star Open Datahttp://5stardata.infoMakeit available in anon-proprietary open format(e.g., CSV instead of Excel)
- 16.5-Star Open Datahttp://5stardata.infoUseURIs to denote things, sothat people can point at yourstuff
- 17.5-Star Open Datahttp://5stardata.infoLinkyour data to other data toprovide context
- 18.Why is thisstuff important?● W3C approved standards for representing knowledge graphs○ Lots of tools are built upon the same formats● Each object is identified by a globally-unique machine-readable ID instead of a human-readable word orphrase○ Human-readable word or phrase can change when necessary without disrupting use○ Can capture data in any language● Any object can relate to any other object & relationship types are standard (i.e. SKOS) OR customisable(i.e. OWL)● Data (& the relationships between them) can be reused by people (human consumption) & products(machine consumption) all over the web● Can easily leverage other open data based on the same standards○ schema.org○ Geonames○ Getty vocabularies (AAT, etc.)○ Wikidata● Lay the framework for international (multilingual & multicultural) interoperability
- 19.What is SPARQL?●SPARQL Protocol and RDF Query Language● Allows us to translate interlinked graph data into normalised tabular data that youcan do something with (eg graph or visualise)● Is *kind of* like SQL● Is used through a SPARQL endpoint
- 20.ExampleSELECT ?paintingWHERE {?painting<has medium> <oil on canvas>}subject predicate object
- 21.WikidataWikidata is afree, collaborative, multilingual, secondary database, collecting structureddata to provide support for Wikipedia, Wikimedia Commons, the other wikis of theWikimedia movement, and to anyone in the world.https://www.wikidata.orgSPARQL endpoint: https://query.wikidata.org/
- 22.
- 23.
- 24.Build things onwikidatahttp://histropedia.com/timeline/vz1ndyv56m/Apple-Computers
- 25.Hands onStart withthis cats example1. Go to query.wikidata.org2. Choose examples3. Click on catsSELECT ?item ?itemLabel WHERE {?item wdt:P31 wd:Q146.SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }}Play along at home at http://bit.ly/vala_sparql
- 26.
- 27.Modifying Wikidata query1.Search for instance of library instead of cata. Change cat to libraryb. Click run2. Search for libraries in Australiaa. Click on +Filter and search for Australiab. Click on instance of and change to countryc. Click run - seems a bit low - why don’t we get lots of libraries? (hint)
- 28.Improving our queryOurQuery would work better if we found all librariesSELECT ?item ?itemLabel WHERE {?item wdt:P31/wdt:P279* wd:Q7075.SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }?item wdt:P17 wd:Q408.}http://tinyurl.com/y7ysrngp
- 29.Adding columnsStart withhttp://tinyurl.com/y7ysrngp from the last step1. Click on +Show2. Search for inception3. Click on +Show4. Search for imageShould now look like http://tinyurl.com/y8r3rp8tNote the default behaviour is a table, check out the image grid and timeline
- 30.Accessing data● Throughthe query page using query helper or sparql● Through the download on the query page● Using Linked Data content negotiation: http://www.wikidata.org/entity/Q42● Using data url: http://www.wikidata.org/wiki/Special:EntityData/Q42.json● Database dumps in rdf, json and xml● SPARQL endpoint GET and POST requests. Eg cats as json
- 31.Further Resources● Thispresentation: http://bit.ly/vala_sparql● 5-Star Open Data: http://5stardata.info/en/● Wikidata query manual:https://www.mediawiki.org/wiki/Wikidata_query_service/User_Manual● Wikidata properties: https://www.wikidata.org/wiki/Wikidata:List_of_properties● Reasonator: https://tools.wmflabs.org/reasonator/● Histropedia: http://histropedia.com● Programming Historian - Linked Open Data lesson:http://programminghistorian.org/lessons/graph-databases-and-SPARQL● Comparison of SQL and SPARQL:http://www.cambridgesemantics.com/semantic-university/sparql-vs-sql-intro