<!DOCTYPE article PUBLIC "-//NLM//DTD JATS (Z39.96) Journal Archiving and Interchange DTD v1.0 20120330//EN" "JATS-archivearticle1.dtd">
<article xmlns:xlink="http://www.w3.org/1999/xlink">
  <front>
    <journal-meta />
    <article-meta>
      <title-group>
        <article-title>Visual Queries over Scholarly Data and other Linked Data Endpoints1</article-title>
      </title-group>
      <contrib-group>
        <contrib contrib-type="author">
          <string-name>Kārlis Čerāns</string-name>
          <xref ref-type="aff" rid="aff0">0</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Lelde Lāce</string-name>
          <xref ref-type="aff" rid="aff0">0</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Aiga Romāne</string-name>
          <xref ref-type="aff" rid="aff0">0</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Jūlija Ovčiņņikova</string-name>
          <xref ref-type="aff" rid="aff0">0</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Sergejs Kozlovičs</string-name>
          <xref ref-type="aff" rid="aff0">0</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Mikus Grasmanis</string-name>
          <xref ref-type="aff" rid="aff0">0</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Jūlija Hodakovska</string-name>
          <xref ref-type="aff" rid="aff0">0</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Artūrs Sproģis</string-name>
          <xref ref-type="aff" rid="aff0">0</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Agris Šostaks</string-name>
          <xref ref-type="aff" rid="aff0">0</xref>
        </contrib>
        <aff id="aff0">
          <label>0</label>
          <institution>Institute of Mathematics and Computer Science, University of</institution>
          <country country="LV">Latvia</country>
        </aff>
      </contrib-group>
      <abstract>
        <p>We demonstrate the option to use the schema-based visual query tool ViziQuer over realistic Linked Data endpoints, with examples over the Semantic Web conference-related Scholarly Data. We present the pipeline of enabling visual query creation over a SPARQL endpoint and ready-to-use data schemas over existing public Linked data endpoints, available in the ViziQuer Schema store. Visual query composition (cf. [1], [2], [3], [4], [5]) along with facet-based ([6], [7]) and controlled natural language-based ([8]) approaches offers a promising avenue to enable end-user involvement in query composition over RDF/SPARQL data (cf. [1]). The recent version of ViziQuer notation ([5], [9]), implemented in a web-based tool3 [10], allows for visual presentation of rich instance level and aggregate queries, involving data expressions, as well as query nesting, with expressive power approaching that of the full SPARQL 1.1 [11]. Meanwhile, the currently available examples of the ViziQuer notation and tool usage are largely related to in-house RDF data stores, not the publicly available Linked data sets that would be one of its primary usage targets. We shall report in this paper and present in the demonstration:  Visual query notation and tool usage examples over a public Linked Data endpoint of Scholarly data4 [12];  The pipeline of enabling visual query creation over a SPARQL endpoint, including a novel easy-to-use data schema extractor implementation;  Ready-to-use data schemas over existing public Linked data endpoints, available in the ViziQuer Schema store (within the ViziQuer tool page).</p>
      </abstract>
      <kwd-group>
        <kwd>Visual query tool</kwd>
        <kwd>RDF data</kwd>
        <kwd>SPARQL</kwd>
        <kwd>Linked Data</kwd>
      </kwd-group>
    </article-meta>
  </front>
  <body>
    <sec id="sec-1">
      <title>Introduction</title>
    </sec>
    <sec id="sec-2">
      <title>Scholarly Query Examples</title>
      <p>
        The visual queries are defined and constructed in the context of a data schema listing
the available classes and properties and their connectivity, as well as matching the entity
short names to their full IRIs. We present a few examples here based on the data schema
of Scholarly Data [
        <xref ref-type="bibr" rid="ref12">12</xref>
        ] (the schema can be downloaded from the ViziQuer Schema
store).
      </p>
      <p>
        Each query is a connected graph with one main query node (orange round rectangle).
The linked nodes correspond either to joined classes or to nested queries (if the link
starts with a black bullet). The ViziQuer notation is explained in detail in [
        <xref ref-type="bibr" rid="ref5">5</xref>
        ], [
        <xref ref-type="bibr" rid="ref9">9</xref>
        ], and
the ViziQuer tool page.
6. Find the top 10 situations with
persons publishing most papers at a
single conference. Nested queries can
return more than single-item result sets
projected onto the host query.
7 List the top 20 keywords in
proceeding papers of ISWC series
conferences, together with using paper
counts. The keyword presence is
mandatory, denoted by {+}.
3
      </p>
    </sec>
    <sec id="sec-3">
      <title>Enabling Visual Queries over Linked Data Endpoints</title>
      <p>The visual queries over a data endpoint are created within a context of a ViziQuer
project that requires a pre-loaded data schema and a specified link to the SPARQL endpoint
itself (if the created queries are to be executed from the tool environment).</p>
      <p>The ViziQuer data schema can be either generated from an OWL ontology or
extracted directly from the SPARQL endpoint (via schema-level SPARQL queries) using
an open-source schema extractor service, accompanying the ViziQuer tool. The links
to the service are maintained from the ViziQuer tool home page. The novel schema
extractor implementation is as a JAVA web service, allowing its seamless usage
directly from end-user computers.</p>
      <p>There are public data endpoint schemas, extracted and collected at the ViziQuer
Schema Store, including Scholarly Data, UNESCO5 (SKOS), Social Semantic Web
Thesaurus6 and WikiPathways7. The schemas of resources like DBPedia and WikiData
cannot be currently extracted in their full form due to space considerations.</p>
      <p>It can also be envisaged that the SPARQL endpoint holders may store and maintain
the visual query data schemas, or even the visual project examples along with the
endpoints themselves to enable faster users starting up the work with the endpoint.</p>
      <p>The visual query environment, after the data schema loading, displays the schema to
the end user in the form of a class tree, arranged by the namespaces of the top-level
classes and by the subclass relation; this form has been found suitable for
moderatelysized data schemas (as the ones, listed in the schema store). A double click on the class
tree node adds the main query node with this class into the diagrammatic query pane;
further query elements then can be added in the context of the created query element.</p>
      <p>There are also options for the data schema export in the form of OWL ontology from
the ViziQuer tool, to enable its further analysis or eventual graphic visualization, e.g.,
in the OWLGrEd ontology editor8.
5 http://vocabularies.unesco.org/sparql
6 http://vocabulary.semantic-web.at/PoolParty/sparql/semweb
7 http://sparql.wikipathways.org/
8 http://owlgred.lumii.lv/</p>
    </sec>
    <sec id="sec-4">
      <title>Conclusions</title>
      <p>There is an option to compose visual queries over Linked data endpoints, such as
Scholarly Data, in the ViziQuer tool, so allowing the rich visual query experience over Linked
Data.</p>
      <p>The data schema retrieval as the necessary pre-processing step can be performed by
an open-source schema extractor that can be used either from a public server or run on
an end-user computer. Further development of the schema extraction service to be able
to handle the peculiarities (query execution limits, supported protocols, and SPARQL
subsets) of various SPARQL endpoints, is work in progress.</p>
      <p>Another avenue of further work is creating an interactive graphical visualization of
the data schema within the query tool to ease the end user query creation experience
further.</p>
    </sec>
  </body>
  <back>
    <ref-list>
      <ref id="ref1">
        <mixed-citation>
          1.
          <string-name>
            <surname>Soylu</surname>
            ,
            <given-names>A.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Giese</surname>
            ,
            <given-names>M.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Jimenez-Ruiz</surname>
            ,
            <given-names>E.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Vega-Gorgojo</surname>
          </string-name>
          , G..,
          <string-name>
            <surname>Horrocks</surname>
            ,
            <given-names>I.</given-names>
          </string-name>
          :
          <article-title>Experiencing OptiqueVQS: A Multi-paradigm and Ontology-based Visual Query System for End Users</article-title>
          .
          <source>Universal Access in the Information Society, March</source>
          <year>2016</year>
          , Volume
          <volume>15</volume>
          , Issue 1, pp
          <fpage>129</fpage>
          -
          <lpage>152</lpage>
          .
        </mixed-citation>
      </ref>
      <ref id="ref2">
        <mixed-citation>
          2.
          <string-name>
            <surname>Zviedris</surname>
            ,
            <given-names>M.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Barzdins</surname>
          </string-name>
          , G.:
          <article-title>ViziQuer: A Tool to Explore and Query SPARQL Endpoints</article-title>
          .
          <source>In: The Semantic Web: Research and Applications</source>
          ,
          <string-name>
            <surname>LNCS</surname>
          </string-name>
          , Volume
          <volume>6644</volume>
          , pp.
          <fpage>441</fpage>
          -
          <lpage>445</lpage>
          , (
          <year>2011</year>
          )
        </mixed-citation>
      </ref>
      <ref id="ref3">
        <mixed-citation>
          3.
          <string-name>
            <surname>Kapourani</surname>
            ,
            <given-names>B.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Fotopoulou</surname>
            ,
            <given-names>E.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Papaspyros</surname>
            ,
            <given-names>D.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Zafeiropoulos</surname>
            ,
            <given-names>A.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Mouzakitis</surname>
            ,
            <given-names>S.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Koussouris</surname>
            ,
            <given-names>S.</given-names>
          </string-name>
          :
          <string-name>
            <surname>Propelling SMEs Business Intelligence</surname>
          </string-name>
          <article-title>Through Linked Data Production and Consumption</article-title>
          , In OTM 2015 Workshops pp
          <fpage>107</fpage>
          -
          <lpage>116</lpage>
          ,
          <year>2015</year>
          .
        </mixed-citation>
      </ref>
      <ref id="ref4">
        <mixed-citation>
          4.
          <string-name>
            <surname>Haag</surname>
            ,
            <given-names>F.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Lohmann</surname>
            ,
            <given-names>S.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Siek</surname>
            ,
            <given-names>S.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Ertl</surname>
          </string-name>
          , T.:
          <article-title>QueryVOWL: Visual Composition of SPARQL Queries</article-title>
          . In: The Semantic Web:
          <article-title>ESWC 2015 Satellite Events</article-title>
          .
          <source>LNCS</source>
          , Vol.
          <volume>9341</volume>
          , pp.
          <fpage>62</fpage>
          -
          <lpage>66</lpage>
          . Springer, (
          <year>2015</year>
          ), http://vowl.visualdataweb.org/queryvowl/
        </mixed-citation>
      </ref>
      <ref id="ref5">
        <mixed-citation>
          5.
          <string-name>
            <surname>Čerāns</surname>
            ,
            <given-names>K.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Bārzdiņš</surname>
            ,
            <given-names>J.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Šostaks</surname>
            ,
            <given-names>A.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Ovčiņņikova</surname>
            ,
            <given-names>J.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Lāce</surname>
            ,
            <given-names>L.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Grasmanis</surname>
            ,
            <given-names>M.</given-names>
          </string-name>
          and
          <string-name>
            <surname>Sproģis</surname>
            ,
            <given-names>A.</given-names>
          </string-name>
          :
          <article-title>Extended UML Class Diagram Constructs for Visual SPARQL Queries in ViziQuer/</article-title>
          web In Voila!
          <year>2017</year>
          , CEUR Workshop Proceedings, Vol.
          <year>1947</year>
          , (
          <year>2017</year>
          ) pp.
          <fpage>87</fpage>
          -
          <lpage>98</lpage>
          .
        </mixed-citation>
      </ref>
      <ref id="ref6">
        <mixed-citation>
          6.
          <string-name>
            <surname>Vega-Gorgojo</surname>
            ,
            <given-names>G.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Giese</surname>
            ,
            <given-names>M.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Heggestoyl</surname>
            ,
            <given-names>S.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Soylu</surname>
            ,
            <given-names>A.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Waaler</surname>
            ,
            <given-names>A.</given-names>
          </string-name>
          :
          <article-title>PepeSearch: Semantic Data for the Masses</article-title>
          .
          <source>In: PLoS ONE 11(3): e0151573. doi: 10.1371/journal.pone.0151573</source>
          ,
          <year>2016</year>
          . http://dx.doi.org/10.1371/journal.pone.0151573
        </mixed-citation>
      </ref>
      <ref id="ref7">
        <mixed-citation>
          7.
          <string-name>
            <surname>Khalili</surname>
            ,
            <given-names>A.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Meroño-Peñuela</surname>
            ,
            <given-names>A.</given-names>
          </string-name>
          :
          <string-name>
            <surname>WYSIWYQ --- What You See Is What You</surname>
          </string-name>
          <article-title>Query</article-title>
          . In Voila!
          <year>2017</year>
          ,
          <string-name>
            <surname>CEUR</surname>
          </string-name>
          , Vol.
          <year>1947</year>
          , (
          <year>2017</year>
          ) pp.
          <fpage>123</fpage>
          -
          <lpage>130</lpage>
          . http://ceur-ws.
          <source>org/</source>
          Vol-1947/paper11.pdf
        </mixed-citation>
      </ref>
      <ref id="ref8">
        <mixed-citation>
          8.
          <string-name>
            <surname>Ferré</surname>
            ,
            <given-names>S.</given-names>
          </string-name>
          : Sparklis:
          <article-title>An expressive query builder for SPARQL endpoints with guidance in natural language</article-title>
          ,
          <source>Semantic Web</source>
          ,
          <year>2017</year>
          , Vol
          <volume>8</volume>
          , pp
          <fpage>405</fpage>
          -
          <lpage>418</lpage>
        </mixed-citation>
      </ref>
      <ref id="ref9">
        <mixed-citation>
          9.
          <string-name>
            <surname>Čerāns</surname>
            ,
            <given-names>K.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Šostaks</surname>
            ,
            <given-names>A.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Bojārs</surname>
            ,
            <given-names>U.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Bārzdiņš</surname>
            ,
            <given-names>J.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Ovčiņņikova</surname>
            ,
            <given-names>J.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Lāce</surname>
            ,
            <given-names>L.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Grasmanis</surname>
            ,
            <given-names>M.</given-names>
          </string-name>
          and
          <string-name>
            <surname>Sproģis</surname>
            ,
            <given-names>A.</given-names>
          </string-name>
          ,
          <article-title>ViziQuer: A Visual Notation for RDF Data Analysis Queries</article-title>
          .
          <source>In Research Conference on Metadata and Semantics Research</source>
          . Springer CCIS, Vol.
          <volume>846</volume>
          , pp.
          <fpage>50</fpage>
          -
          <lpage>62</lpage>
          ,
          <year>2018</year>
        </mixed-citation>
      </ref>
      <ref id="ref10">
        <mixed-citation>
          10.
          <string-name>
            <surname>Čerāns</surname>
            ,
            <given-names>K.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Šostaks</surname>
            ,
            <given-names>A.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Bojārs</surname>
            ,
            <given-names>U.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Ovčiņņikova</surname>
            ,
            <given-names>J.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Lāce</surname>
            ,
            <given-names>L.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Grasmanis</surname>
            ,
            <given-names>M.</given-names>
          </string-name>
          <string-name>
            <surname>Romāne</surname>
            ,
            <given-names>A.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Sproģis</surname>
            ,
            <given-names>A.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Bārzdiņš</surname>
            ,
            <given-names>J.</given-names>
          </string-name>
          <article-title>ViziQuer: A Web-Based Tool for Visual Diagrammatic Queries Over RDF Data</article-title>
          . In:
          <article-title>ESWC 2018 Satellite Events</article-title>
          .
          <source>LNCS</source>
          , vol
          <volume>11155</volume>
          , pp.
          <fpage>158</fpage>
          -
          <lpage>163</lpage>
          ,
          <year>2018</year>
          .
        </mixed-citation>
      </ref>
      <ref id="ref11">
        <mixed-citation>
          11.
          <article-title>SPARQL 1.1 Query Language</article-title>
          .
          <source>W3C Recommendation 21 March</source>
          <year>2013</year>
          , http://www.w3.org/TR/2013/REC-sparql11
          <string-name>
            <surname>-</surname>
          </string-name>
          query-20130321/
        </mixed-citation>
      </ref>
      <ref id="ref12">
        <mixed-citation>
          12.
          <string-name>
            <given-names>A. L.</given-names>
            <surname>Gentile</surname>
          </string-name>
          and
          <string-name>
            <given-names>A. G.</given-names>
            <surname>Nuzzolese.</surname>
          </string-name>
          cLODg - Conference Linked Open Data Generator.
          <source>In ISWC 2015 Posters &amp; Demonstrations Track, CEUR-WS.org</source>
          , Vol.
          <volume>1486</volume>
          ,
          <year>2015</year>
          .
        </mixed-citation>
      </ref>
    </ref-list>
  </back>
</article>