• Topic
  • Discussion
  • OATWikiWeb.InteractiveSparqlQueryBuilderQueryTutorialConstruct(Last) -- Owiki? , 2016-08-19 14:58:44 Edit owiki 2016-08-19 14:58:44

    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 section.

    Enter and execute a query

    Choose a SPARQL query from the 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 ODS FOAF Queries List.

    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 } .
      }
    
    1. Go to http://cname/isparql, for ex. http://id.myopenlink.net/isparql
    2. The iSPARQL initialization window will be shown:



    3. On successful initialization will be presented the iSPARQL Advanced tab open with a default SPARQL query:

      SELECT * WHERE {?s ?p ?o}





    4. Go to QBE tab:



    5. Click the Clear Pane icon on the toolbar to empty the Canvas.







    6. Change the Data Source URI 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



    7. Click the Advanced tab.
    8. Change the Graph value to also be as in our example http://id.myopenlink.net/dataspace and enter (copy-and-paste) the query chosen above into the SPARQL Query text-area:



    9. Click the Run Query button on the Advanced tab.
    10. The Results sub-tab shown below the Results tab will present the results of executing our SPARQL Query. By default is View -> Navigator mode.



    11. You can change the visualization to:
      • Raw Triples mode:



      • Grid View mode:



      • SVG Graph mode:



        • Equal distances drop-down menu offers Equal distances (default) or All nodes at once.



        • Random drop-down menu, active only when "All nodes at once" is chosen, offers nodes positioning of Random (default) or Circle.



        • Show all nodes drop-down menu lets you limit the displayed nodes by their distance from the selected node, from 1 (default) to 4; for example, Selected up to distance 3.



        • Medium distance drop-down menu adjusts distances between nodes, making depiction clearer or more overlapped. Options are Medium distance (default), Close distance, and Far distance.



        • Planar drop-down menu adjusts model shape between Planar (default) and Pseudo-spherical.



        • Labels only on one element drop-down menu determines which nodes are labeled -- Labels only on one element (default), Up to distance from 1 to 4, or Labels on all elements.



      • Images mode.
      • Google Maps v3 mode:
    12. You can view your SPARQL Query with type "CONSTRUCT" as a Graph model by clicking the "Load Query to QBE" button.



    References

    ODS SPARQL Queries

    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
    Weblog SIOCRefBlog ODS-Weblog Data Query ODS-Weblog Data Query ODS-Weblog Data Query
    Briefcase SIOCRefBriefcase ODS-Briefcase Data Query ODS-Briefcase Data Query ODS-Briefcase Data Query
    Feed Manager SIOCRefFeeds ODS-Feed-Manager Data Query ODS-Feed-Manager Data Query ODS-Feed-Manager Data Query
    Wiki SIOCRefWiki ODS-Wiki Data Query ODS-Wiki Data Query ODS-Wiki Data Query
    Calendar SIOCRefCalendar ODS-Calendar Data Query ODS-Calendar Data Query ODS-Calendar Data Query
    Bookmark Manager SIOCRefBookmark ODS-Bookmark-Manager Data Query ODS-Bookmark-Manager Data Query ODS-Bookmark-Manager Data Query
    Gallery SIOCRefGallery ODS-Gallery Data Query ODS-Gallery Data Query ODS-Gallery Data Query
    Addressbook ODSAddressBookRef ODS-Addressbook Data Query ODS-Addressbook Data Query ODS-Addressbook Data Query
    Discussions SIOCRefDiscussions ODSAtomOWLRefExampleDiscussions ODS-Discussions Data Query ODS-Discussions Data Query
    Community SIOCRefCommunity ODS-Community Data Query ODS-Community Data Query ODS-Community Data Query
    Polls SIOCRefPolls - ODS-Polls Data Query ODS-Polls Data Query

    Other Virtuoso SPARQL Queries

    Related