Investigate RELM with SPARQL and SGVizler

Because the place available for a Open Social Widget is limited we will elaborate today a basic website with SPARQL Queries and the results are displayed as Tables, Maps, Tree, Line, Charts, Graphs, List …what ever you want. The focus is on learning SPARQL with RELM/LQE.
The real beauty is the interactivity you can have with “D3ForceGraph”…but try it yourself.

All you need is…love(Beatles)…no…we need the following files and structure. 🙂

Bildschirmfoto 2014-04-13 um 13.50.28




Extract the ZIP File to <CLM server>/tomcat/webapps/extensions at your CLM Server.

After that step, start your favorit Webbrowser and use the URL:  https://clmserver:9443/extensions/querySparql/query.html

You should see the following picture:

Bildschirmfoto 2014-04-13 um 13.57.31

The results as D3ForceGraph:
Bildschirmfoto 2014-04-13 um 14.13.49


Here is a short overview what kind of graphic is possible with the SPARQL results:

Bildschirmfoto 2014-04-13 um 14.00.29













The HTML is really small, the main part is the SPARQL Query:

<html xmlns="">
    <meta charset="UTF-8"/>
	<link rel="stylesheet" href="css/querySparql.css" type="text/css" media="screen" />

    <script type="text/javascript" src="lib/jquery-1.10.1.js"></script>
    <script type="text/javascript" src=""></script>
    <script type="text/javascript" src="lib/sgvizler.js"></script>
    <script type="text/javascript">
            $(document).ready(function () {
	                        sgvizler.defaultEndpointURL ("https://ssejtsserver:9443/lqe/sparql");
							                "PREFIX dcterms: <> \n"+
											"PREFIX rdf:     <> \n"+
											"PREFIX oslc:    <> \n"+
											"PREFIX oslc_cm: <> \n"+
											"PREFIX oslc_qm: <> \n"+
                 							"SELECT ?cm_shortTitle ?cm_title ?cm_uri ?status ?qm_title ?qm_uri \n"+
										    "WHERE {\n" +
											"?cm_uri \n"+
											"      oslc:shortTitle ?cm_shortTitle  ; \n"+
											"      dcterms:title ?cm_title  ; \n"+
											"      dcterms:modified ?modified ; \n"+
											"      oslc_cm:status ?status ; \n"+
											"      oslc_cm:testedByTestCase ?qm_uri . \n"+
											"?qm_uri	 \n"+
											"     dcterms:title ?qm_title  . \n"+
											"} \n"+
											      " ORDER BY ASC(?cm_shortTitle)" );


  1. #1 by Todd Dunnavant on 14/07/2017 - 20:18

    Hi, Stefan, you’ve done some truly excellent work with OSLC, SPARQL, and the CM capabilities of the CE tools. Thanks for all your contributions!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: