Sesame installation with PHP in Ubuntu

Before going to installation process, we can understand what is RDF, SPARQL, SESAME etc…

RDF stands for Resource Description Framework. It is used for conceptual description or modeling of information that is implemented in web resources, using a variety of syntax formats [more].

SPARQL is a query language for RDF.  Using this we can manipulate, store and retrieve data which is stored in RDF. This standard was introduced by RDF data access working group of the w3c [more].

SESAME is a de-facto standard framework for processing RDF data [more].

Since providing SDK which is a Java based interface, we need to configure Tomcat (version 6 or higher) on our system. Steps to install Tomcat web server is:

i. Ensure that the you already installed Java

ii. Open the terminal

iii. Run the following commands

sudo apt-get update

sudo apt-get install tomcat6

Then download the SDK provided by [download link]. Go to the location where you are downloaded the SDK. Extract the downloaded SDK. You can see both Sesame server and OpenRdf workbench files inside the extracted folder. Open the war folder. You have to deploy those war-files inside Java Servlet Container (like Apache Tomcat 6 web server). By deploying means nothing but copying the war files found inside the extracted folder to the Java Servlet Container (tomcat6 web path. Most probably the path will be /var/lib/tomcat6/webapps).  Then take the following URL in your browser: http://<your servername>:8080/openrdf-sesame.

After that you have given full permission to the .aduna folder which you can found in the path /usr/share/tomcat6. Since we are using MYSQL as back end, we need to download the JDBC driver which will make the communication between the Sesame Workbench and MYSQL database. To download the MYSQL JDBC driver click here.  Copy the jar file from the downloaded JDBC driver and paste in to the WEB-INF/lib folder which you can see in the web application path (both /var/lib/tomcat6/webapps/openrdf-sesame/WEB-INF/lib/var/lib/tomcat6/webapps/openrdf-workbench/WEB-INF/lib).

If you have done this much work successfully, you are almost installed the Sesame Workbench in your machine. You can manage your Sesame Workbench through both http://<your servername>:8080/openrdf-sesame & http://<your servername>:8080/openrdf-workbench.

Note: If you are using MYSQL as back-end, sometimes the Workbench will crash if we haven’t properly shutdown the service of tomcat6 web server. That time just delete the locked table which you can see in the database where RDBMS repository created.

Read More