Lab: SPARQL - Revision history

Sinoa: /* Installing and running GraphDB */

2025-01-30T12:22:39Z

Installing and running GraphDB

← Older revision		Revision as of 12:22, 30 January 2025
Line 25:		Line 25:
	Follow the instructions in [https://graphdb.ontotext.com/documentation/10.8/ Getting Started with GraphDB] to download and install GraphDB.		Follow the instructions in [https://graphdb.ontotext.com/documentation/10.8/ Getting Started with GraphDB] to download and install GraphDB.

	From [https://graphdb.ontotext.com/documentation/10.8/graphdb-desktop-installation.html ~~the~~ Desktop Installation page] you can click on ~~the~~ ''"GraphDB download page"'' to register and request ~~a Free version of GraphDB~~ to download.		From the [https://graphdb.ontotext.com/documentation/10.8/graphdb-desktop-installation.html Desktop Installation page] you can click on ''"GraphDB download page"'' and then on ''"Download GraphDB"'' to register and request to download ''GraphDB Free''.

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

Sinoa: /* Installing and running GraphDB */

2025-01-30T12:19:29Z

Installing and running GraphDB

← Older revision		Revision as of 12:19, 30 January 2025
Line 23:		Line 23:

	===Installing and running GraphDB===		===Installing and running GraphDB===
	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 ~~(please let Andreas and Sondre know if that is not correct and we will update~~.)		Follow the instructions in [https://graphdb.ontotext.com/documentation/10.8/ Getting Started with GraphDB] to download and install GraphDB.

			From [https://graphdb.ontotext.com/documentation/10.8/graphdb-desktop-installation.html the Desktop Installation page] you can click on the ''"GraphDB download page"'' to register and request a Free version of GraphDB to download.

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

Sogar7469: /* Load data */

2025-01-30T12:07:11Z

Load data

← Older revision		Revision as of 12:07, 30 January 2025
Line 33:		Line 33:

	===Load data===		===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.		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 Load the Russia_investigation data through the GraphDB Workbench as described in the QuickStart guide.

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

Sinoa: /* Installing and running GraphDB */

2025-01-29T15:16:27Z

Installing and running GraphDB

← Older revision		Revision as of 15:16, 29 January 2025
Line 23:		Line 23:

	===Installing and running GraphDB===		===Installing and running GraphDB===
	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.		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 (please let Andreas and Sondre know if that is not correct and we will update.)

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

Sinoa: /* Tasks */

2025-01-29T15:15:33Z

Tasks

← Older revision		Revision as of 15:15, 29 January 2025
Line 18:		Line 18:

	==Tasks==		==Tasks==
	We recommend you download and install the free desktop version of OntoText's GraphDB.		We recommend you download and install the free desktop version of OntoText's GraphDB to run the SPARQL exercises.

	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.		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.

Sinoa at 15:13, 29 January 2025

2025-01-29T15:13:15Z

← Older revision		Revision as of 15:13, 29 January 2025
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.

Bamos3003 at 10:46, 11 February 2024

2024-02-11T10:46:10Z

@@ Line 22: / Line 22: @@
 ===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 according to this [https://graphdb.ontotext.com/documentation/10.0/quick-start-guide.html Quick Start Guide]. Follow the guide up to and including the section
+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:
-''Run GraphDB as a Standalone Server¶''.
+* On Windows:
 ===Setting up a repository===
-Jump forward in the [https://graphdb.ontotext.com/documentation/10.0/quick-start-guide.html Quick Start Guide] to the section ''Create a Repository''.
+Follow the ''Create a Repository'' section in the [https://graphdb.ontotext.com/documentation/10.0/quick-start-guide.html Quick Start Guide].
 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.
@@ Line 38: / Line 54: @@
 ===Graph visualisation===
-Go to ''Explore'' -> ''Visual graph'' and create an ''Easy graph'' around the resource ''http://example.org#Roger_Stone''. Double-click on nodes to expand them. Have there been more investigations involving ''Russia''?
+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===
@@ Line 56: / Line 72: @@
 * 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:

Bamos3003 at 07:02, 5 February 2024

2024-02-05T07:02:11Z

← Older revision		Revision as of 07:02, 5 February 2024
Line 10:		Line 10:
	SPARQL reference:		SPARQL reference:
	* [https://www.w3.org/TR/sparql11-query/ SPARQL Query Documentation]		* [https://www.w3.org/TR/sparql11-query/ SPARQL Query Documentation]
			<!--
	* [http://www.w3.org/TR/sparql11-update/ SPARQL Update Documentation]		* [http://www.w3.org/TR/sparql11-update/ SPARQL Update Documentation]
			-->
	* [https://en.wikibooks.org/wiki/SPARQL/Expressions_and_Functions SPARQL Expressions and Functions]		* [https://en.wikibooks.org/wiki/SPARQL/Expressions_and_Functions SPARQL Expressions and Functions]

Line 54:		Line 56:
	* For each investigation with multiple indictments, list the number of indictments made, sorted with the most indictments first.		* 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.		* For each president, list the numbers of convictions and of pardons made after conviction.
			<!--
	'''Task:'''		'''Task:'''
	Write the following SPARQL updates:		Write the following SPARQL updates:
Line 61:		Line 63:

	'''Task:'''		'''Task:'''
	Load the RDF graph you created in exercises 1 and 2. (Maybe you want to create a new namespace in ~~Blazegraph~~ first.) Use INSERT DATA updates to add these triples to your graph:		Load the RDF graph you created in exercises 1 and 2. (Maybe you want to create a new namespace in GraphDB first.) Use INSERT DATA updates to add these triples to your graph:
	* George Papadopoulos was adviser to the Trump campaign.		* George Papadopoulos was adviser to the Trump campaign.
	** He pleaded guilty to lying to the FBI.		** He pleaded guilty to lying to the FBI.
Line 79:		Line 81:
	* Use a DESCRIBE query to show the updated information about Roger Stone.		* Use a DESCRIBE query to show the updated information about Roger Stone.
	* Use a CONSTRUCT query to create a new RDF group with triples only about Roger Stone (in other words, having Roger Stone as the subject.)		* Use a CONSTRUCT query to create a new RDF group with triples only about Roger Stone (in other words, having Roger Stone as the subject.)
			-->
	==If you have more time==		==If you have more time==
			<!--
	'''Task:'''		'''Task:'''
	In the ''russia_investigation_kg.ttl'' dataset, the ''muellerkg:name'' property used as predicate is already covered by a standard term from an estalished vocabulary in the LOD cloud: ''foaf:name'', where ''foaf:'' is ''http://xmlns.com/foaf/0.1/''.		In the ''russia_investigation_kg.ttl'' dataset, the ''muellerkg:name'' property used as predicate is already covered by a standard term from an estalished vocabulary in the LOD cloud: ''foaf:name'', where ''foaf:'' is ''http://xmlns.com/foaf/0.1/''.
Line 89:		Line 92:

	'''Task:''' Write an INSERT statement to add at least one significant date to the Mueller investigation, with literal type xsd:date. Write a DELETE/INSERT statement to change the date to a string, and a new DELETE/INSERT statement to change it back to xsd:date.		'''Task:''' Write an INSERT statement to add at least one significant date to the Mueller investigation, with literal type xsd:date. Write a DELETE/INSERT statement to change the date to a string, and a new DELETE/INSERT statement to change it back to xsd:date.
			-->
	'''Task:''' Try to program some of the queries~~/updates~~ in a Python program (this will be the topic of later labs). You have two options:		'''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:''		''Using rdflib:''
Line 100:		Line 103:

	''Using SPARQLwrapper:''		''Using SPARQLwrapper:''
	You can use SPARQLwrapper (another Python API) to connect to your running ~~Blazegraph~~ endpoint. See the Python example page for how to do this.		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):		'''Task:''' If you want to explore more, try out the Wikidata Query Service (WDQS):

Sinoa: /* Load data */

2024-01-31T12:08:05Z

Load data

← Older revision		Revision as of 12:08, 31 January 2024
Line 32:		Line 32:
	===Load data===		===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.		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===		===Graph visualisation===

Sinoa: /* Setting up a repository */

2024-01-31T12:06:42Z

Setting up a repository

← Older revision		Revision as of 12:06, 31 January 2024
Line 25:		Line 25:
	===Setting up a repository===		===Setting up a repository===
	Jump forward in the [https://graphdb.ontotext.com/documentation/10.0/quick-start-guide.html Quick Start Guide] to the section ''Create a Repository''.		Jump forward in the [https://graphdb.ontotext.com/documentation/10.0/quick-start-guide.html Quick Start Guide] to the section ''Create a Repository''.
	Create a new GraphDB Repository called, for example, ''info216_lab3_NN'', where ''NN'' are your initials. Connect to it and ~~set~~ it as your default repository.		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.

	===Load data===		===Load data===