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:

<!DOCTYPE HTML>
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <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="https://www.google.com/jsapi"></script>
    <script type="text/javascript" src="lib/sgvizler.js"></script>
    <script type="text/javascript">
            $(document).ready(function () {
	                        sgvizler.defaultEndpointURL ("https://ssejtsserver:9443/lqe/sparql");
							sgvizler.defaultQuery(
							                "PREFIX dcterms: <http://purl.org/dc/terms/> \n"+
											"PREFIX rdf:     <http://www.w3.org/1999/02/22-rdf-syntax-ns#> \n"+
											"PREFIX oslc:    <http://open-services.net/ns/core#> \n"+
											"PREFIX oslc_cm: <http://open-services.net/ns/cm#> \n"+
											"PREFIX oslc_qm: <http://open-services.net/ns/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)" );
							sgvizler.formDraw();});
    </script>

  </head>
  <body>
  </body>
</html>

  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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: