Difference between revisions of "Projects/Nepomuk/VirtuosoInternal"

Jump to: navigation, search
(sparql_to_sql_text)
(Connecting directly to virtuoso)
Line 1: Line 1:
 
= Connecting directly to virtuoso =
 
= Connecting directly to virtuoso =
  
via isql
+
Virtuoso ships with an executable called <code>isql-vt</code>. Just running that executable should connect you to virtuoso.
 +
 
 +
If you distribution does not provide the corresponding executable or if it doesn't work for you. Try this script -
 +
<syntaxhighlight lang="bash">
 +
#!/bin/bash
 +
filename=`ps aux | grep virtuoso-t | grep -v grep | sed -e 's/.*\/tmp\///;s/ini.*/ini/'`
 +
port=$(grep ServerPort /tmp/$filename | sed -e 's/.*=//')
 +
exec isql-vt -S $port
 +
</syntaxhighlight>
  
 
= List of tables =
 
= List of tables =

Revision as of 17:44, 8 August 2012

Contents

Connecting directly to virtuoso

Virtuoso ships with an executable called isql-vt. Just running that executable should connect you to virtuoso.

If you distribution does not provide the corresponding executable or if it doesn't work for you. Try this script -

#!/bin/bash
filename=`ps aux | grep virtuoso-t | grep -v grep | sed -e 's/.*\/tmp\///;s/ini.*/ini/'`
port=$(grep ServerPort /tmp/$filename | sed -e 's/.*=//')
exec isql-vt -S $port

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