%META:TOPICPARENT{name="InteractiveSparqlQueryBuilderTutorials"}%
---+ Interactive SPARQL Query Builder: Basic Tutorial
%TOC%

---++ Creating RDF Instance Data using iSPARQL

   1 Go to http://cname/isparql, for ex. http://id.myopenlink.net/isparql
   1 The iSPARQL initialization window will be shown:
%BR%%BR% <img src="%ATTACHURLPATH%/isparqlload.png" style="wikiautogen"/>%BR%%BR%
   1 Finally will be presented the iSPARQL <strong>Advanced</strong> tab open with a default SPARQL query:     
<verbatim>
SELECT * WHERE {?s ?p ?o}
</verbatim>
%BR%%BR% <img src="%ATTACHURLPATH%/isparql1.png" style="wikiautogen"/>%BR%%BR%
   1 Go to <strong>QBE</strong> tab:
%BR%%BR% <img src="%ATTACHURLPATH%/isparql2.png" style="wikiautogen"/>%BR%%BR%
   1 Click the <strong>Clear Pane</strong> icon on the toolbar to empty the Canvas. 
%BR%%BR% <img src="%ATTACHURLPATH%/isparql3.png" style="wikiautogen"/>%BR%%BR%
%BR%%BR%<img src="%ATTACHURLPATH%/isparql4.png" style="wikiautogen"/>%BR%%BR%
   1 Next we will import the Schemas that contain the Terms to be used in the our Graph Pattern. In the <strong>Schemas</strong> pane enter http://rdfs.org/sioc/types# and click the "Import" button. Perform the same steps for the schema with URL: http://rdfs.org/sioc/ns#
   1 As result the <strong>Schemas</strong> window under "unbound", you should now see the items <strong>sioct</strong> and <strong>sioc</strong>.
%BR%%BR%<img src="%ATTACHURLPATH%/isg1.png" style="wikiautogen"/>%BR%%BR%
   1 Now click on the <strong>sioct</strong> -> <strong>Classes</strong> -> <strong>+</strong>  icon in order to expand the classes list:
%BR%%BR%<img src="%ATTACHURLPATH%/isg2.png" style="wikiautogen"/>%BR%%BR%
   1 Scroll down the shown list and drag-and-drop the Subject Node <strong>Weblog</strong> onto the QBE working Canvas.
%BR%%BR%<img src="%ATTACHURLPATH%/isg3.png" style="wikiautogen"/>%BR%%BR%
   1 As result should be created a Subject node of Datatype <strong>sioct:Weblog</strong> at the point you dropped it. 
   1 The properties of the selected node are shown in the Subject <strong>Node</strong> pane where you can:
      1 Change the <b>Node type</b> to URI or Literal;
      1 Change the <b>Node Variable label</b> value;
      1 Set the <b>Node Datatype</b>;
      1 Set the <b>visibility property</b> of the variable by hatching the "Visible?" check-box;
      1 Set <b>participation</b> in the "Order By" clause bz hatching the "Order By" check-box:
%BR%%BR%<img src="%ATTACHURLPATH%/isg4.png" style="wikiautogen"/>%BR%%BR%
   1 You can <strong>add a new node</strong> from the QBE toolbar. Click the <strong>Add mode</strong> icon, and drag-and-drop an Object Node onto the Canvas.
%BR%%BR%<img src="%ATTACHURLPATH%/isg5.png" style="wikiautogen"/>%BR%%BR%
   1 In the Object <strong>Node</strong> pane, change the <strong>type</strong> to <strong>Literal</strong> and change the <strong>Variable</strong> label value to <strong>?s</strong>.
%BR%%BR%<img src="%ATTACHURLPATH%/isg6.png" style="wikiautogen"/>%BR%%BR%
   1 You can <strong>add a Datatype to a node</strong> through the <strong>Schemas</strong> pane or enter it manually.  To use the Schemas pane --
      1 Import the schema that contains the terms you wish to use in your Graph Pattern. For ex. import the foaf schema: http://xmlns.com/foaf/0.1/
%BR%%BR%<img src="%ATTACHURLPATH%/isg7.png" style="wikiautogen"/>%BR%%BR%
      1 Drag-and-drop the Class <strong>Document</strong> item from the Concepts list over the Node with <strong>Literal</strong> type that we created above.
      1 You should now see that the <strong>Datatype</strong> in the <strong>Node</strong> pane for the selected node has changed, from <strong>Literal</strong> to <strong>foaf:Document</strong>.
%BR%%BR%<img src="%ATTACHURLPATH%/isg8.png" style="wikiautogen"/>%BR%%BR%
   1 To <strong>delete a node</strong>, select the desired node, e.g., the Node with Variable label <strong>?s</strong>, and click the <strong>Remove</strong> button in the QBE toolbar. You will be prompted to verify deletion. Click <strong>OK</strong> to delete.
%BR%%BR%<img src="%ATTACHURLPATH%/isg9.png" style="wikiautogen"/>%BR%%BR%
   1 You can add more nodes:
%BR%%BR%<img src="%ATTACHURLPATH%/isg10.png" style="wikiautogen"/>%BR%%BR%
   1 <strong>Add connections</strong> by clicking the <strong>Connector</strong> icon on the QBE toolbar and drag from one node to another.
      1 For example, drag a connection from the node with Variable label <strong>?forum</strong> to the <strong>?post</strong> node.
      1 A connection will now be shown between the two nodes and a <strong>Connector</strong> pane will be shown above the <strong>Schema</strong> pane; this is the property window for the currently selected connection.
%BR%%BR%<img src="%ATTACHURLPATH%/isg11.png" style="wikiautogen"/>%BR%%BR%
      1 Enter for <strong>Name</strong> for ex. <strong>sioc:container_of</strong> and un-hatch the <strong>Visible?</strong> check-box.
%BR%%BR%<img src="%ATTACHURLPATH%/isg12.png" style="wikiautogen"/>%BR%%BR%
      1 Click the <strong>Connector</strong> icon from the QBE toolbar and drag from the <strong>?post</strong> node to to the <strong>?maker</strong> node.
%BR%%BR%<img src="%ATTACHURLPATH%/isg13.png" style="wikiautogen"/>%BR%%BR%
      1 In the <strong>Connector</strong> pane, check the <strong>Optional?</strong> check-box and un-hatch the <strong>Visible?</strong> check-box.
%BR%%BR%<img src="%ATTACHURLPATH%/isg14.png" style="wikiautogen"/>%BR%%BR%
      1 Now we will add a type (from the foaf schema) to this connection. The type can be an <strong>Attribute</strong> (A) or <strong>Relationship</strong> (R) property from the Schema pane. "Attribute" (A) items are shown under each imported Schema's Properties with a green letter "A" icon. "Relationship" (R) items are shown under each imported Schema's Properties with a blue letter "R" icon.  In the <strong>Schemas</strong> pane, go to foaf -> Properties and drag the "Relationship" (R) property <strong>maker</strong> onto the selected connection on the Canvas.
      1 In the <strong>Connector</strong> pane, the value of the <strong>Name</strong> field will change to <strong>foaf:maker</strong>. Note that the connection line between the nodes <strong>?post</strong> and <strong>?maker</strong> is not solid, because we set it to be optional in the <strong>Connector</strong> window:
%BR%%BR%<img src="%ATTACHURLPATH%/isg15.png" style="wikiautogen"/>%BR%%BR%
      1 Click the "Connector" icon from the QBE toolbar and drag from the <strong>?maker</strong> node to the <strong>?nick</strong> node.
%BR%%BR%<img src="%ATTACHURLPATH%/isg16.png" style="wikiautogen"/>%BR%%BR%
      1 In the <strong>Connector</strong> window hatch the <strong>Optional?</strong> check-box and un-hatch the <strong>Visible?</strong> check-box. Enter <strong>foaf:nick</strong> for <strong>Name</strong>.
%BR%%BR%<img src="%ATTACHURLPATH%/isg17.png" style="wikiautogen"/>%BR%%BR%
   1 <strong>The Final Graph Model</strong> can be viewed in the QBE working pane.
%BR%%BR%<img src="%ATTACHURLPATH%/isg18.png" style="wikiautogen"/>%BR%%BR%

---++ Querying
   1 We now have the final graph model. Before using it in a query, we need to set a proper target Graph URI. For this, change the value in the <strong>Data Source URI</strong> field for ex. to http://id.myopenlink.net/dataspace
%BR%%BR%<img src="%ATTACHURLPATH%/isg19.png" style="wikiautogen"/>%BR%%BR%
   1 Click the <strong>Run Query</strong> button on the QBE toolbar.
   1 The query results will be shown in the <strong>Results</strong> tab.
%BR%%BR%<img src="%ATTACHURLPATH%/isg20.png" style="wikiautogen"/>%BR%%BR%
   1 You can also change dereferencing:
      * "SPARQL Describe" ( by default ): for selected link of the result set performs describe, for ex. for link "http://id.myopenlink.net/dataspace/Bratsas/weblog/Bratsas%27s%20Weblog":
%BR%%BR%<img src="%ATTACHURLPATH%/isg21.png" style="wikiautogen"/>%BR%%BR%
      * "SELECT IRI as S or O": for selected link of the result set performs select IRI as S or O, for ex. for link "http://id.myopenlink.net/dataspace/Bratsas/weblog/Bratsas%27s%20Weblog":
%BR%%BR%<img src="%ATTACHURLPATH%/isg22.png" style="wikiautogen"/>%BR%%BR%
      * "GET PAGE": for selected link of the result set performs redirect to this link, for ex. for link "http://id.myopenlink.net/dataspace/Bratsas/weblog/Bratsas%27s%20Weblog":
%BR%%BR%<img src="%ATTACHURLPATH%/isg23.png" style="wikiautogen"/>%BR%%BR%
      * "Use Virtuoso Web Service", for selected link of the result set performs Virtuoso Web Service execution, for ex. link for "http://id.myopenlink.net/dataspace/Bratsas/weblog/Bratsas%27s%20Weblog":
%BR%%BR%<img src="%ATTACHURLPATH%/isg24.png" style="wikiautogen"/>%BR%%BR%
   1 View the SPARQL parameters values in the <strong>SPARQL Params</strong> sub-tab:   
%BR%%BR%<img src="%ATTACHURLPATH%/isg25.png" style="wikiautogen"/>%BR%%BR%
   1 View the response values from the <strong>Response</strong> sub-tab:
%BR%%BR%<img src="%ATTACHURLPATH%/isg26.png" style="wikiautogen"/>%BR%%BR%
   1 View the SPARQL query produced from the graph model you have built from the <strong>Query</strong> sub-tab:
%BR%%BR%<img src="%ATTACHURLPATH%/isg27.png" style="wikiautogen"/>%BR%%BR%

---++ Saving the Graph Model
   1 Go to QBE  tab and click the <strong>Save As</strong> icon from the QBE toolbar.
   1 As result should be shown the WebDAV Browser:
%BR%%BR%<img src="%ATTACHURLPATH%/isg28.png" style="wikiautogen"/>%BR%%BR%
   1 Select a destination folder, input a file name, for e.g., MySimpleTest, and select <strong>SPARQL Definitions (*.rq)</strong> for <strong>File type</strong>. You may also save the query in XML format, by choosing <strong>Dynamic Data Web Page (*.isparql)</strong> for <strong>File type</strong>.
%BR%%BR%<img src="%ATTACHURLPATH%/isg29.png" style="wikiautogen"/>%BR%%BR%
   1 Click "Save".

---++ Generating a SPARQL Query from the Graph Model
   1 Go to QBE tab.
   1 Click the <strong>Generate</strong> icon on the toolbar.
   1 The <strong>Advanced</strong> tab will open, with the query generated from your Graph in the <strong>SPARQL Query</strong> text-area.
%BR%%BR%<img src="%ATTACHURLPATH%/isg30.png" style="wikiautogen"/>%BR%%BR%
   1 Use the <strong>Prefixes</strong>, <strong>Templates</strong>, and <strong>Statement Help</strong> drop-down lists above the <strong>SPARQL Query</strong> text-area to format the query. 
      * <i>Note</i>: You can revert your changes by clicking the "Get from QBE" button on the <strong>Advanced</strong> tab toolbar.
%BR%%BR%<img src="%ATTACHURLPATH%/isg31.png" style="wikiautogen"/>%BR%%BR%
   1 Now in the SPARQL Query Working area of the Advanced tab, add a new optional node to the query for <strong>foaf:phone</strong>.
%BR%%BR%<img src="%ATTACHURLPATH%/isg32.png" style="wikiautogen"/>%BR%%BR%
   1 To apply the query changes to the Graph model, click the "Visualize" button on the <strong>Advanced</strong> tab toolbar.
%BR%%BR%<img src="%ATTACHURLPATH%/isg33.png" style="wikiautogen"/>%BR%%BR%

---++ Setting Results Rows
   1 Go to the <strong>QBE</strong> tab.
   1 At the bottom of the page change in "Query options" the <strong>Resize site limit</strong> value, for ex. to 10:
%BR%%BR%<img src="%ATTACHURLPATH%/isg34.png" style="wikiautogen"/>%BR%%BR%

---++ Adding a dataset
   1 On the QBE toolbar, click the <strong>Dataset</strong> button.
   1 Choose <strong>Type</strong> and enter a <strong>Data Source URI</strong> value.
   1 Click the <strong>Add</strong> button.
%BR%%BR%<img src="%ATTACHURLPATH%/isg35.png" style="wikiautogen"/>%BR%%BR%

---++ Other iSPARQL Features
---+++ Auto arrange the Graph Model
   1 Go to the <strong>QBE</strong> tab.
%BR%%BR%<img src="%ATTACHURLPATH%/isg36.png" style="wikiautogen"/>%BR%%BR%
   1 Click the <strong>Auto arrange</strong> icon on the toolbar.
   1 The Graph model layout will be re-arranged to a more compact form.
%BR%%BR%<img src="%ATTACHURLPATH%/isg37.png" style="wikiautogen"/>%BR%%BR%

---+++ Group selected nodes of the Graph Model
   1 Go to the <strong>QBE</strong> tab.
   1 Select several nodes from the Graph. You can do this by holding the "Shift" (on Windows) or "Command"/"Apple" (on Mac) key while clicking the nodes.
   1 Click the "Group Selected" icon from the toolbar.
   1 The selected nodes will be shown on the Canvas in one-color area as grouped. You can use the <strong>Group</strong> pane which will be shown above the <strong>Schemas</strong> window to:
      * Change the <strong>Group Type</strong>: Graph, Optional, Union or Construct
      * Set the Group's ID label.
%BR%%BR%<img src="%ATTACHURLPATH%/isg38.png" style="wikiautogen"/>%BR%%BR%

---+++ Add Named Graph(s) to the SPARQL query
   1 Click to the <strong>Advanced</strong> tab.
   1 Click to the <strong>Named Graph(s)</strong> sub-tab.
   1 In the form, enter a value for <strong>Named Graph</strong>, and click the <strong>Add</strong> button.
   1 The number of added Graphs will be shown, right-aligned to the <strong>Named Graph(s)</strong> sub-tab.
%BR%%BR%<img src="%ATTACHURLPATH%/isg39.png" style="wikiautogen"/>%BR%%BR%

---+++ Add statement to the SPARQL query
   1 Go to the <strong>Advanced</strong> tab.
   1 You can add a statement to the SPARQL Query with
      * the <strong>Statement Help</strong> drop-down list or 
      * the <strong>Statement Help</strong> button shown right after it.
         1 Click the  button "Statement Help".
         1 Click on the desired statement name in the <strong>Statement Help</strong> window which appears.
%BR%%BR%<img src="%ATTACHURLPATH%/isg40.png" style="wikiautogen"/>%BR%%BR%


---++ Related

   * [[InteractiveSparqlQueryBuilderTutorials][iSPARQL Tutorials]]
   * [[InteractiveSparqlQueryBuilderBasicTutorial1][Basic iSPARQL Tutorial with query built from a blank canvas and pre-typed Nodes]]
   * [[InteractiveSparqlQueryBuilderBasicTutorial2][Basic iSPARQL Tutorial with query built from a blank canvas and Nodes dragged from the Toolbar]]
   * [[InteractiveSparqlQueryBuilderQueryTutorialConstruct][iSPARQL Querying Tutorial with SPARQL Query type "CONSTRUCT"]]
   * [[InteractiveSparqlQueryBuilderQueryTutorialDescribe][iSPARQL Querying Tutorial with SPARQL Query type "DESCRIBE"]]
   * [[InteractiveSparqlQueryBuilderQueryTutorialDescribeGoogleMapView][iSPARQL Querying Tutorial "DESCRIBE" with Google Maps View Results]]
   * [[InteractiveSparqlQueryBuilderQueryTutorialInsert][iSPARQL Querying Tutorial with SPARQL Query type "INSERT"]]
   * [[InteractiveSparqlQueryBuilderQueryTutorialDelete][iSPARQL Querying Tutorial with SPARQL Query type "DELETE"]]
   * [[InteractiveSparqlQueryBuilderQueryTutorialSlc][iSPARQL Querying Tutorial with SPARQL Query type "SELECT"]]   
   * [[OATWikiWebIndex][OpenLink AJAX Toolkit (OAT)]]
   
   
CategorySPARQL CategoryRDF CategoryOpenSource CategoryOAT CategoryTutorial CategoryDocumentation