%META:TOPICPARENT{name="InteractiveSparqlQueryBuilderTutorials"}%

---++iSPARQL Querying Tutorial with SPARQL Query type "CONSTRUCT".

This tutorial shows how to execute a SPARQL query with type "CONSTRUCT". 
You can find a rich list of Virtuoso SPARQL Queries in the 
[[#References][References]] section.


%TOC%

---+++Enter and execute a query

Choose a SPARQL query from the [[#References][References]] list. For this example, let's use the SPARQL query which dumps sender, nick, and name details for all Weblog posts. You can find this SPARQL Query in the [[ODSFOAFRef][ODS FOAF Queries List]].

<verbatim>
PREFIX sioc: <http://rdfs.org/sioc/ns#>
PREFIX sioct: <http://rdfs.org/sioc/types#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
CONSTRUCT
{
  ?post foaf:maker ?maker .
  ?maker foaf:nick ?nick .
  ?maker foaf:name ?fname .
}
FROM <http://id.myopenlink.net/dataspace>
WHERE
   {
    ?forum a sioct:Weblog .
    ?forum sioc:container_of ?post.
    OPTIONAL { ?post foaf:maker ?maker }.
    OPTIONAL { ?maker foaf:nick ?nick  } .
    OPTIONAL { ?maker foaf:name ?fname } .
  }
</verbatim>


   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 On successful initialization 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 Change the <strong>Data Source URI</strong> field value on the QBE tab to the Graph of the database against which you want to execute your query, i.e., http://id.myopenlink.net/dataspace
%BR%%BR%<img src="%ATTACHURLPATH%/isparql5.png" style="wikiautogen"/>%BR%%BR%
   1 Click the <strong>Advanced</strong> tab.
   1 Change the <strong>Graph<strong> value to also be as in our example 
   <code> http://id.myopenlink.net/dataspace </code> and enter (copy-and-paste) the query chosen above into the <strong>SPARQL Query</strong> text-area:
%BR%%BR%<img src="%ATTACHURLPATH%/isc1.png" style="wikiautogen"/>%BR%%BR%
   1 Click the <strong>Run Query</strong> button on the <strong>Advanced</strong> tab.
   1 The <strong>Results</strong> sub-tab shown below the Results tab will present the results of executing our SPARQL Query. By default is View -> <strong>Navigator</strong> mode.
   %BR%%BR%<img src="%ATTACHURLPATH%/isc2.png" style="wikiautogen"/>%BR%%BR%
   1 You can change the visualization to:
      * <strong>Raw Triples</strong> mode:
%BR%%BR%<img src="%ATTACHURLPATH%/isc3.png" style="wikiautogen"/>%BR%%BR%
      * <strong>Grid View</strong> mode:
%BR%%BR%<img src="%ATTACHURLPATH%/isc4.png" style="wikiautogen"/>%BR%%BR%
      * <strong>SVG Graph</strong> mode:
%BR%%BR%<img src="%ATTACHURLPATH%/isc5.png" style="wikiautogen"/>%BR%%BR%
         * <strong>Equal distances</strong> drop-down menu offers 
<strong>Equal distances</strong> (default) or <strong>All nodes at once</strong>.
%BR%%BR%<img src="%ATTACHURLPATH%/isc6.png" style="wikiautogen"/>%BR%%BR%
         * <strong>Random</strong> drop-down menu, active only when <strong>"All nodes at once"</strong> is chosen, offers nodes positioning of <strong>Random</strong> (default) or <strong>Circle</strong>.
%BR%%BR%<img src="%ATTACHURLPATH%/isc7.png" style="wikiautogen"/>%BR%%BR%
         * <strong>Show all nodes</strong> drop-down menu lets you limit the displayed nodes by their distance from the selected node, from 1 (default) to 4; for example, <strong>Selected up to distance 3</strong>.
%BR%%BR%<img src="%ATTACHURLPATH%/isc8.png" style="wikiautogen"/>%BR%%BR%
         * <strong>Medium distance</strong> drop-down menu adjusts distances between nodes, making depiction clearer or more overlapped.  Options are 
<strong>Medium distance</strong> (default), <strong>Close distance</strong>, and <strong>Far distance</strong>.
%BR%%BR%<img src="%ATTACHURLPATH%/isc9.png" style="wikiautogen"/>%BR%%BR%
         * <strong>Planar</strong> drop-down menu adjusts model shape between <strong>Planar</strong> (default) and <strong>Pseudo-spherical</strong>.
%BR%%BR%<img src="%ATTACHURLPATH%/isc10.png" style="wikiautogen"/>%BR%%BR%
         * <strong>Labels only on one element</strong> drop-down menu determines which nodes are labeled -- <strong>Labels only on one element</strong> (default), 
<strong>Up to distance from 1 to 4</strong>, or <strong>Labels on all elements</strong>.
%BR%%BR%<img src="%ATTACHURLPATH%/isc11.png" style="wikiautogen"/>%BR%%BR%
      * <strong>Images</strong> mode.
      * <strong>Google Maps v3</strong> mode:
   1 You can view your SPARQL Query with type "CONSTRUCT" as a Graph model by clicking the "Load Query to QBE" button.
%BR%%BR%<img src="%ATTACHURLPATH%/isc12.png" style="wikiautogen"/>%BR%%BR%

---+++References
---++++ODS SPARQL Queries
   * [[http://virtuoso.openlinksw.com/wiki/main/Main/ODSSIOCRef][ODS SIOC Reference]]
   * [[http://virtuoso.openlinksw.com/wiki/main/Main/ODSFOAFRef][ODS FOAF Reference]]
   * [[http://virtuoso.openlinksw.com/wiki/main/Main/ODSSKOSRef][ODS SKOS Reference]]
   * [[http://virtuoso.openlinksw.com/wiki/main/Main/ODSAtomOWLRef][ODS Atom OWL Reference]]
   * [[http://virtuoso.openlinksw.com/wiki/main/Main/VOSODSSparqlSamples][ODS SIOC Query Tutorial]]
   * [[http://virtuoso.openlinksw.com/wiki/main/Main/WordPressSIOCRef][WordPress SIOC Reference]]
   * [[http://virtuoso.openlinksw.com/wiki/main/Main/MediaWikiSIOCRef][MedaWiki SIOC Reference]]
   * [[http://virtuoso.openlinksw.com/wiki/main/Main/PHPBBSIOCRef][PHPBB SIOC Reference]]

---++++ODS Applications SPARQL Queries
|*ODS Application Name*|*SIOC Reference*|*SPARQL Query Using Atom OWL Ontology*|*SPARQL Query Using SKOS Ontology*|*SPARQL Query Using FOAF Ontology*|
|<strong>Weblog</strong>|[[http://virtuoso.openlinksw.com/wiki/main/Main/SIOCRefBlog][SIOCRefBlog]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSAtomOWLRefExampleBlog][ODS-Weblog Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSSKOSRefExampleBlog][ODS-Weblog Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSFOAFRefExampleBlog][ODS-Weblog Data Query]]|
|<strong>Briefcase</strong>|[[http://virtuoso.openlinksw.com/wiki/main/Main/SIOCRefBriefcase][SIOCRefBriefcase]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSAtomOWLRefExampleBriefcase][ODS-Briefcase Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSSKOSRefExampleBriefcase][ODS-Briefcase Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSFOAFRefExampleBriefcase][ODS-Briefcase Data Query]]|
|<strong>Feed Manager</strong>|[[http://virtuoso.openlinksw.com/wiki/main/Main/SIOCRefFeeds][SIOCRefFeeds]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSAtomOWLRefExampleFeeds][ODS-Feed-Manager Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSSKOSRefExampleFeeds][ODS-Feed-Manager Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSFOAFRefExampleFeeds][ODS-Feed-Manager Data Query]]|
|<strong>Wiki</strong>|[[http://virtuoso.openlinksw.com/wiki/main/Main/SIOCRefWiki][SIOCRefWiki]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSAtomOWLRefExampleWiki][ODS-Wiki Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSSKOSRefExampleWiki][ODS-Wiki Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSFOAFRefExampleWiki][ODS-Wiki Data Query]]|
|<strong>Calendar</strong>|[[http://virtuoso.openlinksw.com/wiki/main/Main/SIOCRefCalendar][SIOCRefCalendar]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSAtomOWLRefExampleCalendar][ODS-Calendar Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSSKOSRefExampleCalendar][ODS-Calendar Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSFOAFRefExampleCalendar][ODS-Calendar Data Query]]|
|<strong>Bookmark Manager</strong>|[[http://virtuoso.openlinksw.com/wiki/main/Main/SIOCRefBookmark][SIOCRefBookmark]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSAtomOWLRefExampleBookmarks][ODS-Bookmark-Manager Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSSKOSRefExampleBookmarks][ODS-Bookmark-Manager Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSFOAFRefExampleBookmarks][ODS-Bookmark-Manager Data Query]]|
|<strong>Gallery</strong>|[[http://virtuoso.openlinksw.com/wiki/main/Main/SIOCRefGallery][SIOCRefGallery]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSAtomOWLRefExampleGallery][ODS-Gallery Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSSKOSRefExampleGallery][ODS-Gallery Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSFOAFRefExampleGallery][ODS-Gallery Data Query]]|
|<strong>Polls</strong>|[[http://virtuoso.openlinksw.com/wiki/main/Main/SIOCRefPolls][SIOCRefPolls]]|-|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSSKOSRefExamplePolls][ODS-Polls Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSFOAFRefExamplePolls][ODS-Polls Data Query]]|
|<strong>Addressbook</strong>|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSAddressBookRef][ODSAddressBookRef]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSAtomOWLRefExampleAddressbook][ODS-Addressbook Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSSKOSRefExampleAddressBook][ODS-Addressbook Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSFOAFRefExampleAddressBook][ODS-Addressbook Data Query]]|
|<strong>Discussions</strong>|[[http://virtuoso.openlinksw.com/wiki/main/Main/SIOCRefDiscussions][SIOCRefDiscussions]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSAtomOWLRefExampleDiscussions][ODSAtomOWLRefExampleDiscussions]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSSKOSRefExampleDiscussion][ODS-Discussions Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSFOAFRefExampleDiscussion][ODS-Discussions Data Query]]|
|<strong>Community</strong>|[[http://virtuoso.openlinksw.com/wiki/main/Main/SIOCRefCommunity][SIOCRefCommunity]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSAtomOWLRefExampleCommunity][ODS-Community Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSSKOSRefExampleCommunity][ODS-Community Data Query]]|[[http://virtuoso.openlinksw.com/wiki/main/Main/ODSFOAFRefExampleCommunity][ODS-Community Data Query]]|

---++++Other Virtuoso SPARQL Queries
   * [[http://virtuoso.openlinksw.com/wiki/main/Main/SIOCRefTutorial][Query Virtuoso Tutorials using SPARQL]]
   * [[http://virtuoso.openlinksw.com/wiki/main/Main/SIOCRefDocs][Query Virtuoso Documentation using SPARQL]]


---+++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]]
   * [[InteractiveSparqlQueryBuilderBasicTutorial][Basic iSPARQL Tutorial]]
   * [[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 CategoryDocumentation CategoryTutorial