Lab: SPARQL: Difference between revisions

From info216
No edit summary
No edit summary
Line 5: Line 5:
==Useful materials==
==Useful materials==
GraphDB documentation:
GraphDB documentation:
* [https://graphdb.ontotext.com/documentation/10.0/quick-start-guide.html GraphDB 10.0 Quick Start Guide]
* [https://graphdb.ontotext.com/documentation/10.8/ Getting Started with GraphDB]
* [https://graphdb.ontotext.com/documentation/10.5/ GraphDB 10.5 Documentation]
 
Introduction to SPARQL:
* [https://graphdb.ontotext.com/documentation/10.8/sparql.html Getting Started with SPARQL]


SPARQL reference:
SPARQL reference:
Line 16: Line 18:


==Tasks==
==Tasks==
===Registering for GraphDB Free===
We recommend you download and install the free desktop version of OntoText's GraphDB.
To retrieve a download link for Ontotext's GraphDB Free tool, you first need to register. Here is the [https://www.ontotext.com/products/graphdb/download/?utm_source=adwords&utm_medium=ppc&utm_term=ontotext%20graphdb&utm_campaign=Search+Graphdb&hsa_cam=19852701758&hsa_mt=p&hsa_ver=3&hsa_src=g&hsa_ad=651747487851&hsa_net=adwords&hsa_tgt=kwd-1467556044238&hsa_acc=9129462532&hsa_grp=148766495402&hsa_kw=ontotext%20graphdb&gad_source=1&gclid=Cj0KCQiAh8OtBhCQARIsAIkWb69Mvno3kVHLrHHpZ_FV2_vnwf9IWoMa207bd43maPDUOm2R53UAuYYaAgCxEALw_wcB registration link] (or search for "ontotext graphdb registration").


''If you do not like registering for proprietary software, it is still possible to do most of the exercises using Blazegraph, which you can [https://blazegraph.com/ download here] (requires Java). Blazegraph is a powerful open-source tool, but GraphDB offers even more functionality and is what the lab leaders will prepare for this semester.
If you do not like proprietary software, it is still possible to do most of the exercises using Blazegraph, which you can [https://blazegraph.com/ download here] (requires Java). Blazegraph is a powerful open-source tool, but GraphDB offers even more functionality and is what the lab leader will prepare for this semester.


===Installing and running GraphDB===
===Installing and running GraphDB===
When you have received the download link in an email from the ''GraphDB Team'', you can proceed to install and run GraphDB in the following manner, depending on your system:
Follow the instructions in [https://graphdb.ontotext.com/documentation/10.8/ Getting Started with GraphDB] to download and install GraphDB. It seems pre-registration is no longer needed for the Free version.
* On Windows:
** Download the GraphDB Desktop .msi installer file.
** Double-click the application file and follow the on-screen installer prompts.
** Locate the GraphDB Desktop application in the Windows Start menu and start it. The GraphDB Workbench opens at http://localhost:7200/.
 
* On MacOS
** Download the GraphDB Desktop .dmg file.
** Double-click it and get a virtual disk on your desktop. Copy the program from the virtual disk to your hard disk Applications folder, and you’re set.
** Start GraphDB Desktop by clicking the application icon. The GraphDB Workbench opens at http://localhost:7200/.
 
* On Linux
** Download the GraphDB Desktop .deb or .rpm file.
** Install the package with sudo dpkg -i or sudo rpm -i and the name of the downloaded package. Alternatively, you can double-click the package name.
** Start GraphDB Desktop by clicking the application icon. The GraphDB Workbench opens at http://localhost:7200/.


For more information about setting up GraphDB you can check out their quick start guide:
When GraphDB has been properly installed and is started, it should open in a web browser window at the address http://localhost:7200/ .
[https://graphdb.ontotext.com/documentation/10.0/quick-start-guide.html Quick Start Guide].


===Setting up a repository===
===Setting up a repository===
Follow the ''Create a Repository'' section in the [https://graphdb.ontotext.com/documentation/10.0/quick-start-guide.html Quick Start Guide].
Follow the instructions in [https://graphdb.ontotext.com/documentation/10.8/ Getting Started with GraphDB] to create a new GraphDB Repository called, for example, ''info216_lab2_NN'', where ''NN'' are your initials. Choose ''No inference'' for now. Otherwise, the default parameters are fine.
Create a new GraphDB Repository called, for example, ''info216_lab3_NN'', where ''NN'' are your initials. Choose ''No inference'' for now.
Otherwise, the default parameters are fine.


Connect to the new repository and pin it as your default repository.
Connect to the new repository and pin it as your default repository.

Revision as of 15:13, 29 January 2025

Topics

  • Setting up GraphDB
  • SPARQL queries and updates

Useful materials

GraphDB documentation:

Introduction to SPARQL:

SPARQL reference:

Tasks

We recommend you download and install the free desktop version of OntoText's GraphDB.

If you do not like proprietary software, it is still possible to do most of the exercises using Blazegraph, which you can download here (requires Java). Blazegraph is a powerful open-source tool, but GraphDB offers even more functionality and is what the lab leader will prepare for this semester.

Installing and running GraphDB

Follow the instructions in Getting Started with GraphDB to download and install GraphDB. It seems pre-registration is no longer needed for the Free version.

When GraphDB has been properly installed and is started, it should open in a web browser window at the address http://localhost:7200/ .

Setting up a repository

Follow the instructions in Getting Started with GraphDB to create a new GraphDB Repository called, for example, info216_lab2_NN, where NN are your initials. Choose No inference for now. Otherwise, the default parameters are fine.

Connect to the new repository and pin it as your default repository.

Load data

Download the Turtle file File:Russia investigation kg.txt, and save it with the correct extension, as russia_investigation_kg.ttl (not .txt). (You can also experiment with the Turtle file you saved after exercises 1 and 2.) Load the Russia_investigation data through the GraphDB Workbench as described in the QuickStart guide.

You can use http://example.org/ as Base IRI.

Graph visualisation

Go to Explore -> Visual graph and create an Easy graph around the resource http://example.org#investigation_0. Double-click on nodes to expand them. Are there any more investigations related to Richard Nixon?

SPARQL tasks

Go to the SPARQL Query & Update tab.

Task: Using the data in russia_investigation_kg.ttl, write the following SPARQL SELECT queries. ( This page explains the Russian investigation KG a bit more.)

  • List all triples in your graph.
  • List the first 100 triples in your graph.
  • Count the number of triples in your graph.
  • Count the number of indictments in your graph.
  • List everyone who pleaded guilty, along with the name of the investigation.
  • List everyone who were convicted, but who had their conviction overturned by which president.
  • For each investigation, list the number of indictments made.
  • For each investigation with multiple indictments, list the number of indictments made.
  • For each investigation with multiple indictments, list the number of indictments made, sorted with the most indictments first.
  • For each president, list the numbers of convictions and of pardons made after conviction.

If you have more time

Task: Try to program some of the queries in a Python program (this will be the topic of later labs). You have two options:

Using rdflib: Read the Turtle file into an rdflib Graph and use the query() method. 

g = Graph()
g.parse(..., format='ttl')
r = g.query(...your_query_string...)

The hard part is picking the results out of the object r...

Using SPARQLwrapper: You can use SPARQLwrapper (another Python API) to connect to your running GraphDB endpoint. See the Python example page for how to do this.

Task: If you want to explore more, try out the Wikidata Query Service (WDQS):

WDQS tutorials:

Retrieved from "http://info216.wiki.uib.no/index.php?title=Lab:_SPARQL&oldid=2592"