Difference between revisions of "Projects/Nepomuk/VirtuosoInternal"

Jump to: navigation, search
(List of tables)
(sparql_to_sql_text)
Line 16: Line 16:
 
== status ==
 
== status ==
 
== sparql_to_sql_text ==
 
== sparql_to_sql_text ==
 +
 +
The sparql_to_sql_text() function can be used to convert a SPARQL query directly to the SQL it would be executed as.
 +
 +
<syntaxhighlight lang="sql">
 +
varchar sparql_to_sql_text
 +
( in squery varchar );
 +
</syntaxhighlight>
 +
 +
 +
It's very useful in debugging why many sparql queries are taking so long.
 +
 +
http://docs.openlinksw.com/virtuoso/fn_sparql_to_sql_text.html

Revision as of 17:09, 8 August 2012

Contents

Connecting directly to virtuoso

via isql

List of tables

is a relational database and what not

All the tables in Virtuoso start with the DB.DBA. prefix.

  • RDF_QUAD -- The main table which contains all the statements. It contains four rows "S", "P", "O" and "G" for the subject, predicate, object and graph.

Default Indexes

Common Commands

status

sparql_to_sql_text

The sparql_to_sql_text() function can be used to convert a SPARQL query directly to the SQL it would be executed as.

VARCHAR sparql_to_sql_text
( IN squery VARCHAR );


It's very useful in debugging why many sparql queries are taking so long.

http://docs.openlinksw.com/virtuoso/fn_sparql_to_sql_text.html


KDE® and the K Desktop Environment® logo are registered trademarks of KDE e.V.Legal