You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@jena.apache.org by bu...@apache.org on 2011/10/26 14:30:40 UTC
svn commit: r797494 - in
/websites/staging/jena/trunk/content/jena/documentation/sdb: commands.html
configuration.html javaapi.html loading_data.html loading_performance.html
query_performance.html sdb.html store_description.html
Author: buildbot
Date: Wed Oct 26 12:30:40 2011
New Revision: 797494
Log:
Staging update by buildbot
Modified:
websites/staging/jena/trunk/content/jena/documentation/sdb/commands.html
websites/staging/jena/trunk/content/jena/documentation/sdb/configuration.html
websites/staging/jena/trunk/content/jena/documentation/sdb/javaapi.html
websites/staging/jena/trunk/content/jena/documentation/sdb/loading_data.html
websites/staging/jena/trunk/content/jena/documentation/sdb/loading_performance.html
websites/staging/jena/trunk/content/jena/documentation/sdb/query_performance.html
websites/staging/jena/trunk/content/jena/documentation/sdb/sdb.html
websites/staging/jena/trunk/content/jena/documentation/sdb/store_description.html
Modified: websites/staging/jena/trunk/content/jena/documentation/sdb/commands.html
==============================================================================
--- websites/staging/jena/trunk/content/jena/documentation/sdb/commands.html (original)
+++ websites/staging/jena/trunk/content/jena/documentation/sdb/commands.html Wed Oct 26 12:30:40 2011
@@ -154,26 +154,26 @@
create an SDB store, load data into it and to issue queries.</p>
<h2 id="contents">Contents</h2>
<ul>
-<li><a href="#Scripts">Scripts</a><ul>
-<li><a href="#Script_set_up">Script set up</a></li>
-<li><a href="#Argument_Structure">Argument Structure</a></li>
+<li><a href="#scripts">Scripts</a><ul>
+<li><a href="#script_set_up">Script set up</a></li>
+<li><a href="#argument_structure">Argument Structure</a></li>
</ul>
</li>
<li>
-<p><a href="#Store_Description">Store Description</a></p>
+<p><a href="#store_description">Store Description</a></p>
<ul>
-<li><a href="#Modifying_the_Store_Description">Modifying the Store Description</a></li>
-<li><a href="#Logging_and_Monitoring">Logging and Monitoring</a></li>
+<li><a href="#modifying_the_store_description">Modifying the Store Description</a></li>
+<li><a href="#logging_and_monitoring">Logging and Monitoring</a></li>
</ul>
</li>
<li>
-<p><a href="#SDB_Commands">SDB Commands</a></p>
+<p><a href="#sdb_commands">SDB Commands</a></p>
<ul>
-<li><a href="#Database_creation">Database creation</a></li>
-<li><a href="#Loading_data">Loading data</a></li>
-<li><a href="#Query">Query</a></li>
-<li><a href="#Testing">Testing</a></li>
-<li><a href="#Other">Other</a></li>
+<li><a href="#database_creation">Database creation</a></li>
+<li><a href="#loading_data">Loading data</a></li>
+<li><a href="#query">Query</a></li>
+<li><a href="#testing">Testing</a></li>
+<li><a href="#other">Other</a></li>
</ul>
</li>
</ul>
Modified: websites/staging/jena/trunk/content/jena/documentation/sdb/configuration.html
==============================================================================
--- websites/staging/jena/trunk/content/jena/documentation/sdb/configuration.html (original)
+++ websites/staging/jena/trunk/content/jena/documentation/sdb/configuration.html Wed Oct 26 12:30:40 2011
@@ -156,11 +156,11 @@ storage, which is controlled by
<a href="store_description.html" title="SDB/Store Description">store descriptions</a>.</p>
<h2 id="contents">Contents</h2>
<ul>
-<li><a href="#Setting_Options">Setting Options</a></li>
-<li><a href="#Current_Options">Current Options</a><ul>
-<li><a href="#Queries_over_all_Named_Graphs">Queries over all Named Graphs</a></li>
-<li><a href="#Streaming_over_JDBC">Streaming over JDBC</a></li>
-<li><a href="#Annotated_SQL">Annotated SQL</a></li>
+<li><a href="#setting_options">Setting Options</a></li>
+<li><a href="#current_options">Current Options</a><ul>
+<li><a href="#queries_over_all_named_graphs">Queries over all Named Graphs</a></li>
+<li><a href="#streaming_over_jdbc">Streaming over JDBC</a></li>
+<li><a href="#annotated_sql">Annotated SQL</a></li>
</ul>
</li>
</ul>
Modified: websites/staging/jena/trunk/content/jena/documentation/sdb/javaapi.html
==============================================================================
--- websites/staging/jena/trunk/content/jena/documentation/sdb/javaapi.html (original)
+++ websites/staging/jena/trunk/content/jena/documentation/sdb/javaapi.html Wed Oct 26 12:30:40 2011
@@ -154,18 +154,18 @@
<p>Code examples are in <code>src-examples/</code> in the SDB distribution.</p>
<h2 id="contents">Contents</h2>
<ul>
-<li><a href="#Concepts">Concepts</a></li>
-<li><a href="#Obtaining_the_Store">Obtaining the Store</a><ul>
-<li><a href="#From_a_configuration_file">From a configuration file</a></li>
-<li><a href="#In_Java_code">In Java code</a></li>
-<li><a href="#Database_User_and_Password">Database User and Password</a></li>
+<li><a href="#concepts">Concepts</a></li>
+<li><a href="#obtaining_the_store">Obtaining the Store</a><ul>
+<li><a href="#from_a_configuration_file">From a configuration file</a></li>
+<li><a href="#in_Java_code">In Java code</a></li>
+<li><a href="#database_user_and_password">Database User and Password</a></li>
</ul>
</li>
-<li><a href="#Connection_Management">Connection Management</a></li>
-<li><a href="#Formatting_or_Emptying_the_Store">Formatting or Emptying the Store</a></li>
-<li><a href="#Loading_data">Loading data</a></li>
-<li><a href="#Executing_Queries">Executing Queries</a></li>
-<li><a href="#Using_the_Jena_Model_API_with_SDB">Using the Jena Model API with SDB</a></li>
+<li><a href="#connection_management">Connection Management</a></li>
+<li><a href="#formatting_or_emptying_the_store">Formatting or Emptying the Store</a></li>
+<li><a href="#loading_data">Loading data</a></li>
+<li><a href="#executing_queries">Executing Queries</a></li>
+<li><a href="#using_the_jena_model_api_with_sdb">Using the Jena Model API with SDB</a></li>
</ul>
<h2 id="concepts">Concepts</h2>
<ul>
Modified: websites/staging/jena/trunk/content/jena/documentation/sdb/loading_data.html
==============================================================================
--- websites/staging/jena/trunk/content/jena/documentation/sdb/loading_data.html (original)
+++ websites/staging/jena/trunk/content/jena/documentation/sdb/loading_data.html Wed Oct 26 12:30:40 2011
@@ -249,7 +249,7 @@ new items by <code>LEFT JOIN</code> new
filtering <code>WHERE (existing item feature) IS NULL</code>. Specifically,
for the triple hash case (where no id lookups are needed):</p>
<div class="codehilite"><pre><span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">Triples</span>
-<span class="n">SELECT</span> <span class="n">DISTINCT</span> <span class="n">NTrip</span><span class="o">.</span><span class="n">s</span><span class="p">,</span> <span class="n">NTrip</span><span class="o">.</span><span class="n">p</span><span class="p">,</span> <span class="n">NTrip</span><span class="o">.</span><span class="n">o</span> <span class="o">--</span> <span class="n">DISTINCT</span> <span class="n">because</span> <span class="k">new</span> <span class="n">nodes</span> <span class="n">may</span> <span class="n">contain</span> <span class="n">duplicates</span> <span class="p">(</span><span class="ow">not</span> <span class="n">so</span> <span class="k">for</span> <span class="n">nodes</span><span class="p">)</span>
+<span class="n">SELECT</span> <span class="n">DISTINCT</span> <span class="n">NTrip</span><span class="o">.</span><span class="n">s</span><span class="p">,</span> <span class="n">NTrip</span><span class="o">.</span><span class="n">p</span><span class="p">,</span> <span class="n">NTrip</span><span class="o">.</span><span class="n">o</span> <span class="o">--</span> <span class="n">DISTINCT</span> <span class="n">because</span> <span class="k">new</span> <span class="n">triples</span> <span class="n">may</span> <span class="n">contain</span> <span class="n">duplicates</span> <span class="p">(</span><span class="ow">not</span> <span class="n">so</span> <span class="k">for</span> <span class="n">nodes</span><span class="p">)</span>
<span class="n">NTrip</span> <span class="n">LEFT</span> <span class="n">JOIN</span> <span class="n">Triples</span> <span class="n">ON</span> <span class="p">(</span><span class="n">NTrip</span><span class="o">.</span><span class="n">s</span><span class="o">=</span><span class="n">Triples</span><span class="o">.</span><span class="n">s</span> <span class="n">AND</span> <span class="n">NTrip</span><span class="o">.</span><span class="n">p</span><span class="o">=</span><span class="n">Triples</span><span class="o">.</span><span class="n">p</span> <span class="n">AND</span> <span class="n">NTrip</span><span class="o">.</span><span class="n">o</span><span class="o">=</span><span class="n">Triples</span><span class="o">.</span><span class="n">o</span><span class="p">)</span>
<span class="n">WHERE</span> <span class="n">Triples</span><span class="o">.</span><span class="n">s</span> <span class="n">IS</span> <span class="n">NULL</span> <span class="n">OR</span> <span class="n">Triples</span><span class="o">.</span><span class="n">p</span> <span class="n">IS</span> <span class="n">NULL</span> <span class="n">OR</span> <span class="n">Triples</span><span class="o">.</span><span class="n">o</span> <span class="n">IS</span> <span class="n">NULL</span>
</pre></div>
Modified: websites/staging/jena/trunk/content/jena/documentation/sdb/loading_performance.html
==============================================================================
--- websites/staging/jena/trunk/content/jena/documentation/sdb/loading_performance.html (original)
+++ websites/staging/jena/trunk/content/jena/documentation/sdb/loading_performance.html Wed Oct 26 12:30:40 2011
@@ -151,21 +151,21 @@
<div id="content">
<h1 class="title">SDB Loading performance</h1>
<ul>
-<li><a href="#Introduction">Introduction</a></li>
-<li><a href="#The_Databases_and_Hardware">The Databases and Hardware</a><ul>
-<li><a href="#Hardware">Hardware</a></li>
-<li><a href="#Windows_setup">Windows setup</a></li>
-<li><a href="#Linux_setup">Linux setup</a></li>
+<li><a href="#introduction">Introduction</a></li>
+<li><a href="#the_databases_and_hardware">The Databases and Hardware</a><ul>
+<li><a href="#hardware">Hardware</a></li>
+<li><a href="#windows_setup">Windows setup</a></li>
+<li><a href="#linux_setup">Linux setup</a></li>
</ul>
</li>
-<li><a href="#The_Dataset_and_Queries">The Dataset and Queries</a><ul>
-<li><a href="#LUBM">LUBM</a></li>
+<li><a href="#the_dataset_and_queries">The Dataset and Queries</a><ul>
+<li><a href="#lubm">LUBM</a></li>
<li><a href="#dbpedia">dbpedia</a></li>
</ul>
</li>
-<li><a href="#Loading">Loading</a></li>
-<li><a href="#Results">Results</a></li>
-<li><a href="#Uniprot_700m_loading:_Tuning_Helps">Uniprot 700m loading: Tuning Helps</a></li>
+<li><a href="#loading">Loading</a></li>
+<li><a href="#results">Results</a></li>
+<li><a href="#uniprot_700m_loading:_tuning_helps">Uniprot 700m loading: Tuning Helps</a></li>
</ul>
<h2 id="introduction">Introduction</h2>
<p>Performance reporting is an area prone to misinterpretation, and
Modified: websites/staging/jena/trunk/content/jena/documentation/sdb/query_performance.html
==============================================================================
--- websites/staging/jena/trunk/content/jena/documentation/sdb/query_performance.html (original)
+++ websites/staging/jena/trunk/content/jena/documentation/sdb/query_performance.html Wed Oct 26 12:30:40 2011
@@ -168,10 +168,10 @@ used), as well as the queries themselves
the execution costs.</p>
<h2 id="contents">Contents</h2>
<ul>
-<li><a href="#Setup">Setup</a></li>
-<li><a href="#LUBM_Query_1">LUBM Query 1</a></li>
-<li><a href="#LUBM_Query_2">LUBM Query 2</a></li>
-<li><a href="#Summary">Summary</a></li>
+<li><a href="#setup">Setup</a></li>
+<li><a href="#lubm_query_1">LUBM Query 1</a></li>
+<li><a href="#lubm_query_2">LUBM Query 2</a></li>
+<li><a href="#summary">Summary</a></li>
</ul>
<h2 id="setup">Setup</h2>
<p><a href="loading_performance.html#The_Databases_and_Hardware" title="SDB/Loading performance">Database and hardware setup</a>
Modified: websites/staging/jena/trunk/content/jena/documentation/sdb/sdb.html
==============================================================================
--- websites/staging/jena/trunk/content/jena/documentation/sdb/sdb.html (original)
+++ websites/staging/jena/trunk/content/jena/documentation/sdb/sdb.html Wed Oct 26 12:30:40 2011
@@ -159,12 +159,12 @@ supported, both Open Source and propriet
line scripts and via the Jena API.</p>
<h2 id="contents">Contents</h2>
<ul>
-<li><a href="#Downloads">Downloads</a></li>
-<li><a href="#Documentation">Documentation</a></li>
-<li><a href="#Subversion">Subversion</a></li>
-<li><a href="#Support">Support</a></li>
-<li><a href="#Details">Details</a></li>
-<li><a href="#Database_Notes">Database Notes</a></li>
+<li><a href="#downloads">Downloads</a></li>
+<li><a href="#documentation">Documentation</a></li>
+<li><a href="#subversion">Subversion</a></li>
+<li><a href="#support">Support</a></li>
+<li><a href="#details">Details</a></li>
+<li><a href="#database_Notes">Database Notes</a></li>
</ul>
<h2 id="downloads">Downloads</h2>
<p>SDB is distributed from the Apache Jena project.</p>
@@ -192,7 +192,6 @@ at Apache.</p>
<ul>
<li><a href="loading_data.html">Loading data</a></li>
<li><a href="loading_performance.html">Loading performance</a></li>
-<li><a href="query.html">Query</a></li>
<li><a href="query_performance.html">Query performance</a></li>
</ul>
<h2 id="database_notes">Database Notes</h2>
Modified: websites/staging/jena/trunk/content/jena/documentation/sdb/store_description.html
==============================================================================
--- websites/staging/jena/trunk/content/jena/documentation/sdb/store_description.html (original)
+++ websites/staging/jena/trunk/content/jena/documentation/sdb/store_description.html Wed Oct 26 12:30:40 2011
@@ -164,12 +164,12 @@ database can be created on a per-request
in J2EE application servers.</p>
<h2 id="contents">Contents</h2>
<ul>
-<li><a href="#Store_Descriptions">Store Descriptions</a></li>
-<li><a href="#SDB_Connections">SDB Connections</a></li>
-<li><a href="#Example">Example</a></li>
-<li><a href="#Vocabulary">Vocabulary</a><ul>
-<li><a href="#Store">Store</a></li>
-<li><a href="#Connection">Connection</a></li>
+<li><a href="#store_descriptions">Store Descriptions</a></li>
+<li><a href="#sdb_connections">SDB Connections</a></li>
+<li><a href="#example">Example</a></li>
+<li><a href="#vocabulary">Vocabulary</a><ul>
+<li><a href="#store">Store</a></li>
+<li><a href="#connection">Connection</a></li>
</ul>
</li>
</ul>
@@ -228,30 +228,32 @@ choosing the store type.</p>
<p><code>engine</code>
~ Set the MySQL engine type (MySQL only).</p>
<h3 id="connection">Connection</h3>
-<p><code>sdbType</code>
- ~ The type of the database (e.g. "oracle", "MSSQLServerExpress",
- "postgresql", "mysql"). Controls both creating the JDBC URL, if not
- given explicitly, and the store type.</p>
-<p><code>sdbName</code>
- ~ Name used by the database service to select a database. Oracle
- SID.</p>
-<p><code>sdbHost</code>
- ~ Host name for the database server. Include <em>:port</em> to change
- the port from the default for the database.</p>
-<p><code>sdbUser</code>
-<code>sdbPassword</code>
- ~ Database user name and password. The environment variables
- <code>SDB_USER</code> and <code>SDB_PASSWORD</code> are a better way to pass in the user
- and password because they are not then written into store
- description files. In Java programs, the system properties
- <code>jena.db.user</code> and <code>jena.db.password</code> can be used.</p>
-<p><code>driver</code>
- ~ The JDBC driver class name. Normally, the system looks up the
- <code>sdbType</code> to find the driver. Setting this property overrides that
- choice.</p>
-<p><code>jdbcURL</code>
- ~ If necessary, the JDBC URL can be set explicitly, not
- constructed by SDB. The <code>sdbType</code> is still needed.</p>
+<dl>
+<dt><code>sdbType</code></dt>
+<dd>The type of the database (e.g. "oracle", "MSSQLServerExpress",
+"postgresql", "mysql"). Controls both creating the JDBC URL, if not
+given explicitly, and the store type.</dd>
+<dt><code>sdbName</code></dt>
+<dd>Name used by the database service to select a database. Oracle
+SID.</dd>
+<dt><code>sdbHost</code></dt>
+<dd>Host name for the database server. Include <em>:port</em> to change
+the port from the default for the database.</dd>
+<dt><code>sdbUser</code></dt>
+<dt><code>sdbPassword</code></dt>
+<dd>Database user name and password. The environment variables
+<code>SDB_USER</code> and <code>SDB_PASSWORD</code> are a better way to pass in the user
+and password because they are not then written into store
+description files. In Java programs, the system properties
+<code>jena.db.user</code> and <code>jena.db.password</code> can be used.</dd>
+<dt><code>driver</code></dt>
+<dd>The JDBC driver class name. Normally, the system looks up the
+<code>sdbType</code> to find the driver. Setting this property overrides that
+choice.</dd>
+<dt><code>jdbcURL</code></dt>
+<dd>If necessary, the JDBC URL can be set explicitly, not
+constructed by SDB. The <code>sdbType</code> is still needed.</dd>
+</dl>
</div>
<div id="footer">