Projects/Nepomuk/VirtuosoInternal - Revision history

AnneW: Marked this version for translation

2012-12-13T16:34:55Z

Marked this version for translation

AnneW: Prepare for translation

2012-12-13T16:34:45Z

Prepare for translation

Vishesh: /* List of tables */

2012-12-07T08:53:38Z

‎List of tables

Vishesh at 08:51, 7 December 2012

2012-12-07T08:51:57Z

Vishesh: /* List of tables */

2012-09-21T10:15:43Z

‎List of tables

Vishesh: /* List of tables */ Data type

2012-09-18T09:35:30Z

‎List of tables: Data type

Vishesh: status

2012-09-18T09:33:17Z

status

Vishesh: /* Example */

2012-08-24T13:14:52Z

‎Example

Vishesh: /* sparql_to_sql_text */

2012-08-24T13:14:01Z

‎sparql_to_sql_text

Vishesh: /* sparql_to_sql_text */

2012-08-24T13:13:27Z

‎sparql_to_sql_text

@@ Line 2: / Line 2: @@
 <translate>
-== Connecting directly to virtuoso ==
+== Connecting directly to virtuoso == <!--T:1-->
 Virtuoso ships with an executable called <tt>isql-vt</tt>. 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">
@@ Line 14: / Line 16: @@
 </syntaxhighlight>
-== Running queries directly ==
+== Running queries directly == <!--T:4-->
 If for some reason you want to run queries directly on virtuoso, you'll need to connect to virtuoso via <tt>isql-vt</tt> and then type in the query. From 4.10, we use virtuoso's inbuilt prefix expansion, so you don't need to care about the prefixes.
-=== Example ===
+=== Example === <!--T:6-->
 <syntaxhighlight lang="sql">
 SQL> sparql select ?r ?name where { ?r nco:fullname ?name . };
 </syntaxhighlight>
-== List of tables ==
+== List of tables == <!--T:8-->
 Virtuoso internally uses a relational database to store the triples. It contains the following tables -
 * DB.DBA.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.
 * DB.DBA.RDF_IRI
@@ Line 35: / Line 41: @@
 * DB.DBA.RDF_LANGUAGE
 Read http://docs.openlinksw.com/virtuoso/rdfdatarepresentation.html to properly understand how virtuoso stores the data internally.
 Virtuoso has 2 main types - IRI_ID, which is the data type of the graph, subject and predicate. IRI_ID are of the form "#i25". In order to convert an integer to an IRI_ID, use the '''iri_id_from_num( int )''' function, and the '''iri_id_num( iri_id )''' to convert an IRI_ID to an integer. In order to convert an IRI_ID to its string representation use the following functions '''id_to_iri( iri_id, int )''', and '''iri_to_id( string, int )'''. The second integer option should be 0, unless you want the iri/id to be created if it doesn't exist.
-== Default Indexes ==
+== Default Indexes == <!--T:13-->
-== Common Commands ==
+== Common Commands == <!--T:14-->
 Apart from directly running SQL and SPARQL queries, virtuoso also provides some additional commands, which are listed over here.
-=== status ===
+=== status === <!--T:16-->
 The [http://docs.openlinksw.com/virtuoso/fn_status.html status()] function can be used to return the current running queries on virtuoso.
-=== sparql_to_sql_text ===
+=== sparql_to_sql_text === <!--T:17-->
 The [http://docs.openlinksw.com/virtuoso/fn_sparql_to_sql_text.html 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
@@ Line 59: / Line 70: @@
 Example -
 <syntaxhighlight lang="sql">
@@ Line 66: / Line 78: @@
 _______________________________________________________________________________
 SELECT __id2i ( "s_1_0-t0"."S" ) AS "r",
    __ro2sq ( "s_1_0-t0"."O" ) AS "name"
@@ Line 72: / Line 85: @@
 OPTION (QUIETCAST)
 Rows. -- 1 msec.
 </syntaxhighlight>
 It's very useful in debugging why many sparql queries are taking so long.
 [[Category:Documentation]]
 [[Category:Development]]
 [[Category:Tutorials]]
 </translate>

@@ Line 1: / Line 1: @@
-= Connecting directly to virtuoso =
+<languages />
-Virtuoso ships with an executable called <code>isql-vt</code>. Just running that executable should connect you to virtuoso.
+== Connecting directly to virtuoso ==
 If you distribution does not provide the corresponding executable or if it doesn't work for you. Try this script -
@@ Line 11: / Line 14: @@
 </syntaxhighlight>
-= Running queries directly =
+== Running queries directly ==
 If for some reason you want to run queries directly on virtuoso, you'll need to connect to virtuoso via <tt>isql-vt</tt> and then type in the query. From 4.10, we use virtuoso's inbuilt prefix expansion, so you don't need to care about the prefixes.
 === Example ===
 <syntaxhighlight lang="sql">
 SQL> sparql select ?r ?name where { ?r nco:fullname ?name . };
 </syntaxhighlight>
-= List of tables =
+== List of tables ==
 Virtuoso internally uses a relational database to store the triples. It contains the following tables -
@@ Line 34: / Line 39: @@
 Virtuoso has 2 main types - IRI_ID, which is the data type of the graph, subject and predicate. IRI_ID are of the form "#i25". In order to convert an integer to an IRI_ID, use the '''iri_id_from_num( int )''' function, and the '''iri_id_num( iri_id )''' to convert an IRI_ID to an integer. In order to convert an IRI_ID to its string representation use the following functions '''id_to_iri( iri_id, int )''', and '''iri_to_id( string, int )'''. The second integer option should be 0, unless you want the iri/id to be created if it doesn't exist.
-= Default Indexes =
+== Default Indexes ==
 Apart from directly running SQL and SPARQL queries, virtuoso also provides some additional commands, which are listed over here.
-== status ==
+=== status ===
 The [http://docs.openlinksw.com/virtuoso/fn_status.html status()] function can be used to return the current running queries on virtuoso.
-== sparql_to_sql_text ==
+=== sparql_to_sql_text ===
 The [http://docs.openlinksw.com/virtuoso/fn_sparql_to_sql_text.html sparql_to_sql_text()] function can be used to convert a SPARQL query directly to the SQL it would be executed as.
@@ Line 71: / Line 77: @@
 It's very useful in debugging why many sparql queries are taking so long.

@@ Line 32: / Line 32: @@
 Read http://docs.openlinksw.com/virtuoso/rdfdatarepresentation.html to properly understand how virtuoso stores the data internally.
-Virtuoso has 2 main types - IRI_ID, which is the data type of the graph, subject and predicate. IRI_ID are of the form "#i25". In order to convert an integer to an IRI_ID, use the "iri_id_from_num( int )" function, and the "iri_id_num( iri_id )" to convert an IRI_ID to an integer. In order to convert an IRI_ID to its string representation use the following functions "id_to_iri( iri_id, int )", and "iri_to_id( string, int )". The second integer option should be 0, unless you want the iri/id to be created if it doesn't exist.
+Virtuoso has 2 main types - IRI_ID, which is the data type of the graph, subject and predicate. IRI_ID are of the form "#i25". In order to convert an integer to an IRI_ID, use the '''iri_id_from_num( int )''' function, and the '''iri_id_num( iri_id )''' to convert an IRI_ID to an integer. In order to convert an IRI_ID to its string representation use the following functions '''id_to_iri( iri_id, int )''', and '''iri_to_id( string, int )'''. The second integer option should be 0, unless you want the iri/id to be created if it doesn't exist.
 = Default Indexes =

@@ Line 12: / Line 12: @@
 = Running queries directly =
-If for some reason you want to run queries directly on virtuoso, you'll need to connect to virtuoso via <tt>isql-vt</tt> and then type in the query. Make sure the query has the required prefixes and starts with the keyword <tt>sparql</tt> if it is a sparql query.
+If for some reason you want to run queries directly on virtuoso, you'll need to connect to virtuoso via <tt>isql-vt</tt> and then type in the query. From 4.10, we use virtuoso's inbuilt prefix expansion, so you don't need to care about the prefixes.
-−
-I've attached a list of common prefixes for convenience -
-<syntaxhighlight lang="text">
-prefix nao: <http://www.semanticdesktop.org/ontologies/2007/08/15/nao#>
-prefix nfo: <http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#>
-prefix nie: <http://www.semanticdesktop.org/ontologies/2007/01/19/nie#>
-prefix ncal: <http://www.semanticdesktop.org/ontologies/2007/04/02/ncal#>
-prefix nco: <http://www.semanticdesktop.org/ontologies/2007/03/22/nco#>
-prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
-prefix pimo: <http://www.semanticdesktop.org/ontologies/2007/11/01/pimo#>
-prefix nmo: <http://www.semanticdesktop.org/ontologies/2007/03/22/nmo#>
-prefix nmm: <http://www.semanticdesktop.org/ontologies/2009/02/19/nmm#>
-prefix nrl: <http://www.semanticdesktop.org/ontologies/2007/08/15/nrl#>
-prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
-prefix xsd: <http://www.w3.org/2001/XMLSchema#>
-</syntaxhighlight>
 === Example ===
 <syntaxhighlight lang="sql">
-SQL> sparql prefix nco: <http://www.semanticdesktop.org/ontologies/2007/03/22/nco#> select ?r ?name where { ?r nco:fullname ?name . };
+SQL> sparql select ?r ?name where { ?r nco:fullname ?name . };
 </syntaxhighlight>
 = List of tables =
-All the tables in Virtuoso start with the <code>DB.DBA.</code> prefix.
+Virtuoso internally uses a relational database to store the triples. It contains the following tables -
-* 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.
+* DB.DBA.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.
-* RDF_DATATYPE - Contains all the literal data types which are stored.
+* DB.DBA.RDF_IRI
-* RDF_PREFIX
+* DB.DBA.RDF_DATATYPE - Contains all the literal data types which are stored.
-* RDF_OBJ
+* DB.DBA.RDF_PREFIX
-* RDF_LANGUAGE
+* DB.DBA.RDF_OBJ
 Read http://docs.openlinksw.com/virtuoso/rdfdatarepresentation.html to properly understand how virtuoso stores the data internally.
 = Default Indexes =

@@ Line 42: / Line 42: @@
 * 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.
 * RDF_DATATYPE - Contains all the literal data types which are stored.
 = Default Indexes =

← Older revision		Revision as of 09:33, 18 September 2012
Line 49:		Line 49:

	== status ==		== status ==
		+	The [http://docs.openlinksw.com/virtuoso/fn_status.html status()] function can be used to return the current running queries on virtuoso.
		+
		+
	== sparql_to_sql_text ==		== sparql_to_sql_text ==