Projects/Nepomuk/SparqlQueries: Difference between revisions

From KDE TechBase
(Marked this version for translation)
(Removed page from translation)
 
Line 1: Line 1:
<languages />
<translate>


__TOC__
__TOC__
== Running Sparql Queries == <!--T:1-->
== Running Sparql Queries ==


<!--T:2-->
Depending on the needs of your application you may need to directly run sparql queries.
Depending on the needs of your application you may need to directly run sparql queries.


<!--T:3-->
'''Nepomuk''' uses one main [http://soprano.sourceforge.net/apidox/stable/classSoprano_1_1Model.html Soprano model] which is accessed through the [http://api.kde.org/4.x-api/kdelibs-apidocs/nepomuk-core/html/classNepomuk_1_1ResourceManager.html ResourceManager]:
'''Nepomuk''' uses one main [http://soprano.sourceforge.net/apidox/stable/classSoprano_1_1Model.html Soprano model] which is accessed through the [http://api.kde.org/4.x-api/kdelibs-apidocs/nepomuk-core/html/classNepomuk_1_1ResourceManager.html ResourceManager]:


<!--T:4-->
<syntaxhighlight lang="cpp-qt">
<syntaxhighlight lang="cpp-qt">
     Soprano::Model* model = Nepomuk::ResourceManager::instance()->mainModel();
     Soprano::Model* model = Nepomuk::ResourceManager::instance()->mainModel();
Line 17: Line 12:




<!--T:5-->
The queries can be run via this model -
The queries can be run via this model -
<syntaxhighlight lang="cpp-qt">
<syntaxhighlight lang="cpp-qt">
Line 24: Line 18:
     Soprano::QueryResultIterator it = model->executeQuery( query, Soprano::Query::QueryLanguageSparql );
     Soprano::QueryResultIterator it = model->executeQuery( query, Soprano::Query::QueryLanguageSparql );


     <!--T:6-->
     while( it.next() ) {
while( it.next() ) {
         kDebug() << it["r"].uri();
         kDebug() << it["r"].uri();
     }
     }
Line 31: Line 24:




=== Sparql Prefixes === <!--T:7-->
=== Sparql Prefixes ===


<!--T:8-->
When writing SPARQL queries, according to the standard one needs to prepend the queries with the prefixes that have been used. For example -  
When writing SPARQL queries, according to the standard one needs to prepend the queries with the prefixes that have been used. For example -  
<syntaxhighlight lang="text">
<syntaxhighlight lang="text">
Line 40: Line 32:
</syntaxhighlight>
</syntaxhighlight>


<!--T:9-->
When running queries in Nepomuk, you do not need to explicitly add the prefix. The prefix will automatically be added by the storage service. In the future we will try to make virtuoso automatically understand all prefixes.
When running queries in Nepomuk, you do not need to explicitly add the prefix. The prefix will automatically be added by the storage service. In the future we will try to make virtuoso automatically understand all prefixes.


=== Full Text Indexing === <!--T:10-->
=== Full Text Indexing ===


<!--T:11-->
'''Nepomuk''' depends on [http://soprano.sourceforge.net/apidox/trunk/soprano_backend_virtuoso.html Virtuoso] for data storage. '''Virtuoso''' brings a lot of nice [http://docs.openlinksw.com/virtuoso/rdfsparql.html#sparqlextensions extensions to SPARQL]. Most importantly the full text search which is used through the artificial ''bif:contains'' property.  
'''Nepomuk''' depends on [http://soprano.sourceforge.net/apidox/trunk/soprano_backend_virtuoso.html Virtuoso] for data storage. '''Virtuoso''' brings a lot of nice [http://docs.openlinksw.com/virtuoso/rdfsparql.html#sparqlextensions extensions to SPARQL]. Most importantly the full text search which is used through the artificial ''bif:contains'' property.  


<!--T:12-->
This allows to combine graph queries with full text queries in a nice way:
This allows to combine graph queries with full text queries in a nice way:


<!--T:13-->
<syntaxhighlight lang="text">
<syntaxhighlight lang="text">
select ?r where { ?r nao:prefLabel ?label .
select ?r where { ?r nao:prefLabel ?label .
Line 57: Line 45:
</syntaxhighlight>
</syntaxhighlight>


<!--T:14-->
The query above will find any resources that contain ''nepomuk'' in their label.
The query above will find any resources that contain ''nepomuk'' in their label.


<!--T:15-->
Of course wildcards are supported, too. However, be aware that when using wildcards the expression itself needs to be enclosed in quotes as follows:
Of course wildcards are supported, too. However, be aware that when using wildcards the expression itself needs to be enclosed in quotes as follows:


<!--T:16-->
<syntaxhighlight lang="text">
<syntaxhighlight lang="text">
select ?r where { ?r nao:prefLabel ?label .
select ?r where { ?r nao:prefLabel ?label .
Line 69: Line 54:
</syntaxhighlight>
</syntaxhighlight>


<!--T:17-->
Please note the virtuoso '''requires a minimum of 4 leading characters''' in order to use wildcards.
Please note the virtuoso '''requires a minimum of 4 leading characters''' in order to use wildcards.


<!--T:18-->
[[Category:Documentation]]
[[Category:Documentation]]
[[Category:Development]]
[[Category:Development]]
[[Category:Tutorials]]
[[Category:Tutorials]]
</translate>

Latest revision as of 12:35, 9 February 2018

Running Sparql Queries

Depending on the needs of your application you may need to directly run sparql queries.

Nepomuk uses one main Soprano model which is accessed through the ResourceManager:

    Soprano::Model* model = Nepomuk::ResourceManager::instance()->mainModel();


The queries can be run via this model -

    QString query = QString::fromLatin1("select ?r where { ?r a nco:Contact . }");
    Soprano::Model* model = Nepomuk2::ResourceManager::instance()->mainModel();
    Soprano::QueryResultIterator it = model->executeQuery( query, Soprano::Query::QueryLanguageSparql );

    while( it.next() ) {
        kDebug() << it["r"].uri();
    }


Sparql Prefixes

When writing SPARQL queries, according to the standard one needs to prepend the queries with the prefixes that have been used. For example -

PREFIX nco: <http://www.semanticdesktop.org/ontologies/2007/03/22/nco#> .
select ?r ?name where { ?r a nco:Contact . ?r nco:fullname ?name . }

When running queries in Nepomuk, you do not need to explicitly add the prefix. The prefix will automatically be added by the storage service. In the future we will try to make virtuoso automatically understand all prefixes.

Full Text Indexing

Nepomuk depends on Virtuoso for data storage. Virtuoso brings a lot of nice extensions to SPARQL. Most importantly the full text search which is used through the artificial bif:contains property.

This allows to combine graph queries with full text queries in a nice way:

select ?r where { ?r nao:prefLabel ?label .
                  ?label bif:contains 'nepomuk' . }

The query above will find any resources that contain nepomuk in their label.

Of course wildcards are supported, too. However, be aware that when using wildcards the expression itself needs to be enclosed in quotes as follows:

select ?r where { ?r nao:prefLabel ?label .
                  ?label bif:contains "'nepomuk*'" . }

Please note the virtuoso requires a minimum of 4 leading characters in order to use wildcards.