Lab: SPARQL Programming - Revision history

Sogar7469: added back the describe task

2025-02-18T11:14:03Z

added back the describe task

← Older revision		Revision as of 11:14, 18 February 2025
Line 24:		Line 24:
	* Print out a sorted list of all the presidents represented in your graph.		* Print out a sorted list of all the presidents represented in your graph.
	* Create dictionary (Python ''dict'') with all the represented presidents as keys. For each key, the value is a list of names of people indicted under that president.		* Create dictionary (Python ''dict'') with all the represented presidents as keys. For each key, the value is a list of names of people indicted under that president.
	* Use an ASK query to investigate whether Donald Trump has pardoned more than 5 people.		* Use an ASK query to investigate whether Donald Trump has pardoned more than 5 people.Use a DESCRIBE query to create a new graph with information about Donald Trump. Print out the graph in Turtle format.
			* Use a DESCRIBE query to create a new graph with information about Donald Trump. Print out the graph in Turtle format.

	Note that different types of queries return objects with different contents. You can use core completion in your IDE or Python's ''dir()'' function to explore this further (for example ''dir(results)'').		Note that different types of queries return objects with different contents. You can use core completion in your IDE or Python's ''dir()'' function to explore this further (for example ''dir(results)'').

Sogar7469: removed describe task because it seems it does not work with Rdflib

2025-02-17T12:33:48Z

removed describe task because it seems it does not work with Rdflib

← Older revision		Revision as of 12:33, 17 February 2025
Line 25:		Line 25:
	* Create dictionary (Python ''dict'') with all the represented presidents as keys. For each key, the value is a list of names of people indicted under that president.		* Create dictionary (Python ''dict'') with all the represented presidents as keys. For each key, the value is a list of names of people indicted under that president.
	* Use an ASK query to investigate whether Donald Trump has pardoned more than 5 people.		* Use an ASK query to investigate whether Donald Trump has pardoned more than 5 people.
	* Use a DESCRIBE query to create a new graph with information about Donald Trump. Print out the graph in Turtle format.

	Note that different types of queries return objects with different contents. You can use core completion in your IDE or Python's ''dir()'' function to explore this further (for example ''dir(results)'').		Note that different types of queries return objects with different contents. You can use core completion in your IDE or Python's ''dir()'' function to explore this further (for example ''dir(results)'').

Bamos3003 at 12:58, 19 February 2024

2024-02-19T12:58:10Z

← Older revision		Revision as of 12:58, 19 February 2024
Line 144:		Line 144:
	REPOSITORY = 'lab04' # you most likely want to change this		REPOSITORY = 'lab04' # you most likely want to change this

	endpoint = f'{SERVER}/repositories/{REPOSITORY}' # standard path for GraphDB updates		endpoint = f'{SERVER}/repositories/{REPOSITORY}/statements' # standard path for GraphDB updates

	update_str = """		update_str = """

Bamos3003 at 12:14, 16 February 2024

2024-02-16T12:14:45Z

← Older revision		Revision as of 12:14, 16 February 2024
Line 113:		Line 113:
	from SPARQLWrapper import SPARQLWrapper		from SPARQLWrapper import SPARQLWrapper

	SERVER = 'http://localhost:7200/' # you may want to change this		SERVER = 'http://localhost:7200' # you may want to change this
	REPOSITORY = 'lab04' # you most likely want to change this		REPOSITORY = 'lab04' # you most likely want to change this

	endpoint = f'{SERVER}~~repository~~/{REPOSITORY}' # standard path for GraphDB queries		endpoint = f'{SERVER}/repositories/{REPOSITORY}' # standard path for GraphDB queries

	query = """		query = """
Line 141:		Line 141:
	from SPARQLWrapper import SPARQLWrapper		from SPARQLWrapper import SPARQLWrapper

	SERVER = 'http://localhost:7200/' # you may want to change this		SERVER = 'http://localhost:7200' # you may want to change this
	REPOSITORY = 'lab04' # you most likely want to change this		REPOSITORY = 'lab04' # you most likely want to change this

	endpoint = f'{SERVER}~~repository~~/{REPOSITORY}' # standard path for GraphDB updates		endpoint = f'{SERVER}/repositories/{REPOSITORY}' # standard path for GraphDB updates

	update_str = """		update_str = """

Sinoa: /* If you have more time */

2024-02-14T15:06:32Z

If you have more time

← Older revision		Revision as of 15:06, 14 February 2024
Line 229:		Line 229:
	NAMESPACE = 'lab04' # you most likely want to change this		NAMESPACE = 'lab04' # you most likely want to change this

	# endpoint = f'{SERVER}namespace/{NAMESPACE}/sparql' # standard path for Blazegraph queries (and updates)		endpoint = f'{SERVER}namespace/{NAMESPACE}/sparql' # standard path for Blazegraph queries (and updates)
	</syntaxhighlight>		</syntaxhighlight>

Sinoa at 08:46, 14 February 2024

2024-02-14T08:46:26Z

← Older revision		Revision as of 08:46, 14 February 2024
Line 114:		Line 114:

	SERVER = 'http://localhost:7200/' # you may want to change this		SERVER = 'http://localhost:7200/' # you may want to change this
	REPOSITORY = 'lab04' # you most likely want to change this ~~(called NAMESPACE in Blazegraph)~~		REPOSITORY = 'lab04' # you most likely want to change this

	endpoint = f'{SERVER}repository/{REPOSITORY}' # standard path for ~~Blazegraph queries~~		endpoint = f'{SERVER}repository/{REPOSITORY}' # standard path for GraphDB queries
	~~# endpoint = f'{SERVER}namespace/{NAMESPACE}/sparql' # standard path for Blazegraph~~ queries

	query = """		query = """
Line 143:		Line 142:

	SERVER = 'http://localhost:7200/' # you may want to change this		SERVER = 'http://localhost:7200/' # you may want to change this
	REPOSITORY = 'lab04' # you most likely want to change this ~~(called NAMESPACE in Blazegraph)~~		REPOSITORY = 'lab04' # you most likely want to change this

	endpoint = f'{SERVER}repository/{REPOSITORY}' # standard path for ~~Blazegraph queries~~		endpoint = f'{SERVER}repository/{REPOSITORY}' # standard path for GraphDB updates
	~~# endpoint = f'{SERVER}namespace/{NAMESPACE}/sparql' # standard path for Blazegraph queries~~

	update_str = """		update_str = """
Line 226:		Line 224:

	Both SPARQL endpoints run [https://blazegraph.com/ Blazegraph], which uses "namespaces" instead of "repositories", so the URLs are a little different. In the web UI , the "NAMESPACES" tab lets you select an existing or create a new namespace to use.''		Both SPARQL endpoints run [https://blazegraph.com/ Blazegraph], which uses "namespaces" instead of "repositories", so the URLs are a little different. In the web UI , the "NAMESPACES" tab lets you select an existing or create a new namespace to use.''

			<syntaxhighlight>
			SERVER = 'http://info216.i2s.uib.no/bigdata/' # you may want to change this
			NAMESPACE = 'lab04' # you most likely want to change this

			# endpoint = f'{SERVER}namespace/{NAMESPACE}/sparql' # standard path for Blazegraph queries (and updates)
			</syntaxhighlight>

Sinoa: /* If you have more time */

2024-02-14T08:42:03Z

If you have more time

← Older revision		Revision as of 08:42, 14 February 2024
Line 221:		Line 221:
	LIMIT 10		LIMIT 10
	</syntaxhighlight>		</syntaxhighlight>

			'''Task:'''
			You can also try to connect to the [http://info216.i2s.uib.no/ INFO216 Sandbox] (read/write) and [http://kg4news.newsangler.uib.no KG4News Server] (read-only).

			Both SPARQL endpoints run [https://blazegraph.com/ Blazegraph], which uses "namespaces" instead of "repositories", so the URLs are a little different. In the web UI , the "NAMESPACES" tab lets you select an existing or create a new namespace to use.''

Sinoa: /* SPARQL programming in Python with SPARQLWrapper and GraphDB */

2024-02-14T08:41:16Z

SPARQL programming in Python with SPARQLWrapper and GraphDB

← Older revision		Revision as of 08:41, 14 February 2024
Line 84:		Line 84:
	'''Getting ready:'''		'''Getting ready:'''
	You need a running ''and activated'' GraphDB repository as in [[Lab: SPARQL \| Exercise 3: SPARQL]]. You will run GraphDB locally to keep things simple.		You need a running ''and activated'' GraphDB repository as in [[Lab: SPARQL \| Exercise 3: SPARQL]]. You will run GraphDB locally to keep things simple.

	''(If you want, you can also try to connect to the [http://info216.i2s.uib.no/ INFO216 Sandbox] (read/write) and [http://kg4news.newsangler.uib.no KG4News Server] (read-only). Both SPARQL endpoints run [https://blazegraph.com/ Blazegraph], which uses "namespaces" instead of "repositories", so the URLs are a little different. In the web UI , the "NAMESPACES" tab lets you select an existing or create a new namespace to use.)''

	Install SPARQLWrapper (in your virtual environment):		Install SPARQLWrapper (in your virtual environment):

Sinoa at 08:39, 14 February 2024

2024-02-14T08:39:12Z

← Older revision		Revision as of 08:39, 14 February 2024
Line 85:		Line 85:
	You need a running ''and activated'' GraphDB repository as in [[Lab: SPARQL \| Exercise 3: SPARQL]]. You will run GraphDB locally to keep things simple.		You need a running ''and activated'' GraphDB repository as in [[Lab: SPARQL \| Exercise 3: SPARQL]]. You will run GraphDB locally to keep things simple.

	''(If you want, you can also try to connect to the [http://info216.i2s.uib.no/ INFO216 Sandbox] (read/write) and [http://kg4news.~~i2s~~.no KG4News Server] (read-only). Both SPARQL endpoints run Blazegraph.)''		''(If you want, you can also try to connect to the [http://info216.i2s.uib.no/ INFO216 Sandbox] (read/write) and [http://kg4news.newsangler.uib.no KG4News Server] (read-only). Both SPARQL endpoints run [https://blazegraph.com/ Blazegraph], which uses "namespaces" instead of "repositories", so the URLs are a little different. In the web UI , the "NAMESPACES" tab lets you select an existing or create a new namespace to use.)''

	Install SPARQLWrapper (in your virtual environment):		Install SPARQLWrapper (in your virtual environment):
Line 115:		Line 115:
	from SPARQLWrapper import SPARQLWrapper		from SPARQLWrapper import SPARQLWrapper

	SERVER = 'http://~~sandbox.i2s.uib.no/bigdata~~/' # you may want to change this		SERVER = 'http://localhost:7200/' # you may want to change this
	~~NAMESPACE~~ = '~~s03~~' # you most likely want to change this		REPOSITORY = 'lab04' # you most likely want to change this (called NAMESPACE in Blazegraph)

	endpoint = f'{SERVER}namespace/{NAMESPACE}/sparql' # standard path for Blazegraph queries		endpoint = f'{SERVER}repository/{REPOSITORY}' # standard path for Blazegraph queries
			# endpoint = f'{SERVER}namespace/{NAMESPACE}/sparql' # standard path for Blazegraph queries

	query = """		query = """
Line 143:		Line 144:
	from SPARQLWrapper import SPARQLWrapper		from SPARQLWrapper import SPARQLWrapper

	SERVER = 'http://~~sandbox.i2s.uib.no/bigdata~~/' # you may want to change this		SERVER = 'http://localhost:7200/' # you may want to change this
	~~NAMESPACE~~ = '~~s03~~' # you most likely want to change this		REPOSITORY = 'lab04' # you most likely want to change this (called NAMESPACE in Blazegraph)

	endpoint = f'{SERVER}namespace/{NAMESPACE}/sparql' # standard path for Blazegraph ~~updates~~		endpoint = f'{SERVER}repository/{REPOSITORY}' # standard path for Blazegraph queries
			# endpoint = f'{SERVER}namespace/{NAMESPACE}/sparql' # standard path for Blazegraph queries

	update_str = """		update_str = """

Sinoa at 08:20, 14 February 2024

2024-02-14T08:20:45Z

← Older revision		Revision as of 08:20, 14 February 2024
Line 2:		Line 2:
	SPARQL programming in Python:		SPARQL programming in Python:
	* with ''rdflib'': to manage an rdflib Graph internally in a program		* with ''rdflib'': to manage an rdflib Graph internally in a program
	* with ''SPARQLWrapper'' and ''~~Blazegraph~~'': to manage an RDF graph stored externally in ~~Blazegraph~~ (on your own local machine or on the ~~shared online server~~)		* with ''SPARQLWrapper'' and ''GraphDB'': to manage an RDF graph stored externally in GraphDB (on your own local machine, but in principle it could be anywhere on the internet)

	''Motivation:'' Last week we entered SPARQL queries and updates manually from the web interface. But in the majority of cases we want to ''program'' the management of triples in our graphs, for example to handle automatic or scheduled updates.		''Motivation:'' Last week we entered SPARQL queries and updates manually from the web interface. But in the majority of cases we want to ''program'' the management of triples in our graphs, for example to handle automatic or scheduled updates.
Line 10:		Line 10:
	==Useful materials==		==Useful materials==
	*[https://github.com/RDFLib/sparqlwrapper SPARQLWrapper]		*[https://github.com/RDFLib/sparqlwrapper SPARQLWrapper]
	*[https://rdflib.readthedocs.io/en/stable/intro_to_sparql.html RDFlib - Querying with ~~Sparql~~]		*[https://rdflib.readthedocs.io/en/stable/intro_to_sparql.html RDFlib - Querying with SPARQL]

	==Tasks==		==Tasks==
Line 81:		Line 81:
	</syntaxhighlight>		</syntaxhighlight>

	===SPARQL programming in Python with SPARQLWrapper and ~~Blazegraph~~===		===SPARQL programming in Python with SPARQLWrapper and GraphDB===
	'''Getting ready:'''		'''Getting ready:'''
	~~Make sure you have to access to~~ a running ~~Blazegraph~~ as in [[Lab: SPARQL \| Exercise 3: SPARQL]]. You ~~can either~~ run ~~Blazegraph~~ locally ~~on your own machine~~ (~~best~~) ~~or online on a shared server at UiB~~ (~~also ok~~).		You need a running ''and activated'' GraphDB repository as in [[Lab: SPARQL \| Exercise 3: SPARQL]]. You will run GraphDB locally to keep things simple.

			''(If you want, you can also try to connect to the [http://info216.i2s.uib.no/ INFO216 Sandbox] (read/write) and [http://kg4news.i2s.no KG4News Server] (read-only). Both SPARQL endpoints run Blazegraph.)''

	Install SPARQLWrapper (in your virtual environment):		Install SPARQLWrapper (in your virtual environment):
Line 92:		Line 94:

	'''Task:'''		'''Task:'''
	Program the following queries and updates with SPARQLWrapper and ~~Blazegraph~~.		Program the following queries and updates with SPARQLWrapper and GraphDB.
	* Ask whether there was an ongoing investigation on the date 1990-01-01.		* Ask whether there was an ongoing investigation on the date 1990-01-01.
	* List ongoing investigations on that date 1990-01-01.		* List ongoing investigations on that date 1990-01-01.
Line 107:		Line 109:
	* SELECT and ASK: return a SPARQL Results Document in either XML, JSON, or CSV/TSV format.		* SELECT and ASK: return a SPARQL Results Document in either XML, JSON, or CSV/TSV format.
	* DESCRIBE and CONSTRUCT: return an RDF graph serialised in TURTLE or RDF/XML syntax, for example.		* DESCRIBE and CONSTRUCT: return an RDF graph serialised in TURTLE or RDF/XML syntax, for example.

	* Use a DESCRIBE query to create an rdflib Graph about Oliver Stone. Print the graph out in Turtle format.		* Use a DESCRIBE query to create an rdflib Graph about Oliver Stone. Print the graph out in Turtle format.