SPARQL Tutorial: Using BIND to Create New Variables and Perform Calculations

  

One of the most useful features in SPARQL is the ability to create new variables from existing data using the BIND keyword.

 

In this tutorial, we'll learn how BIND works by calculating how many years passed between a character's first and latest movie appearances.

 

1. The Problem

Suppose we want to know how many years elapsed between the first and last Marvel movie appearances of each character in our RDF graph.

 

Looking at the data, Tony Stark appears in:

·      Avengers: Infinity War (2018)

·      Avengers: Endgame (2019)

 

We want SPARQL to calculate: 2019 - 2018 = 1

 

To do that, we'll need a new variable to hold the result of the subtraction.

 

This is exactly what BIND is designed for.

 

Step 1: Retrieve the Movie Years

Let's first retrieve the years of the movies in which Tony Stark appears.

PREFIX : <http://example.org/marvel/> 

SELECT ?movie ?year 
WHERE { 
  :Tony_Stark :appearsIn ?movie . 
  ?movie :releasedIn ?year . }

Output

movie	year
<http://example.org/marvel/Avengers_Endgame>	2019
<http://example.org/marvel/Infinity_War>	2018

 

Now we have the values we need for our calculation.

 

Step 2: Find the Earliest and Latest Appearance Years

We can use aggregation functions to determine the first and last appearance years.

 

PREFIX : <http://example.org/marvel/> 

SELECT (MIN(?year) AS ?firstYear) (MAX(?year) AS ?lastYear)
WHERE { 
  :Tony_Stark :appearsIn ?movie . 
  ?movie :releasedIn ?year . }

Output

firstYear	lastYear
2018	2019

 

Step 3: Calculate the Difference Using BIND

Now comes the interesting part. We need a new variable that stores: lastYear - firstYear.

 

SPARQL allows us to create this variable using BIND.

 

PREFIX : <http://example.org/marvel/> 

SELECT ?firstYear ?lastYear ?yearsBetween 
WHERE { 
  { 
    SELECT (MIN(?year) AS ?firstYear) (MAX(?year) AS ?lastYear) 
    WHERE { 
      :Tony_Stark :appearsIn ?movie . 
      ?movie :releasedIn ?year . 
    } 
  } 
  BIND((?lastYear - ?firstYear) AS ?yearsBetween) 
}

   

Output

firstYear	lastYear	yearsBetween
2018	2019	1

 

The variable ?yearsBetween does not exist in the RDF graph. It is created dynamically during query execution using:

 

BIND((?lastYear - ?firstYear) AS ?yearsBetween)

   

This is one of the most powerful features of SPARQL because it allows us to derive new information from existing data.

 

2. Understanding BIND

The syntax is:

 

BIND(expression AS ?variable)

Examples:

 

BIND((?a + ?b) AS ?sum)
BIND((?salary * 12) AS ?annualSalary)
BIND(CONCAT(?firstName, " ", ?lastName) AS ?fullName)
BIND(UCASE(?name) AS ?upperCaseName)

   

Think of BIND as creating a temporary calculated column in the query result.

 

3. Another Example: Add 10 Years to a Movie Release Year

 

PREFIX : <http://example.org/marvel/> 

SELECT ?movie ?year ?futureYear 
WHERE { 
  ?movie a :Movie ; 
         :releasedIn ?year . 
  
  BIND((?year + 10) AS ?futureYear) 
}

   

Output

movie	year	futureYear
<http://example.org/marvel/Avengers_Endgame>	2019	2029
<http://example.org/marvel/Infinity_War>	2018	2028

 

Again, ?futureYear is calculated on the fly and does not exist in the RDF graph.

 

In summary,

·      BIND creates a new variable from an expression.

·      The new variable exists only during query execution.

·      Mathematical operations such as +, -, *, and / can be used inside BIND.

·      BIND can also be used with string functions, date functions, and conditional expressions.

·      Think of BIND as creating a computed column similar to SQL.

 

Once you understand BIND, you can start transforming raw RDF data into meaningful business insights directly inside your SPARQL queries.

 

Previous                                                    Next                                                    Home