Author: buildbot
Date: Sat Aug 2 19:51:07 2014
New Revision: 918229
Log:
Staging update by buildbot for jena
Added:
websites/staging/jena/trunk/content/documentation/csv/index.html
Modified:
websites/staging/jena/trunk/content/ (props changed)
Propchange: websites/staging/jena/trunk/content/
------------------------------------------------------------------------------
--- cms:source-revision (original)
+++ cms:source-revision Sat Aug 2 19:51:07 2014
@@ -1 +1 @@
-1615357
+1615359
Added: websites/staging/jena/trunk/content/documentation/csv/index.html
==============================================================================
--- websites/staging/jena/trunk/content/documentation/csv/index.html (added)
+++ websites/staging/jena/trunk/content/documentation/csv/index.html Sat Aug 2
19:51:07 2014
@@ -0,0 +1,217 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd";>
+<html>
+<head>
+<!--
+
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE- 2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+
+ <title>Apache Jena - CSV PropertyTable
</title>
+ <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
+ <meta name="viewport" content="width=device-width, initial-scale=1.0">
+
+ <link href="/css/bootstrap.min.css" rel="stylesheet" media="screen">
+ <link href="/css/bootstrap-extension.css" rel="stylesheet" type="text/css">
+ <link href="/css/jena.css" rel="stylesheet" type="text/css">
+ <link rel="shortcut icon" href="/images/favicon.ico" />
+
+ <script src="https://code.jquery.com/jquery-2.0.3.min.js";></script>
+ <script src="/js/jena-navigation.js" type="text/javascript"></script>
+ <script src="/js/bootstrap.min.js" type="text/javascript"></script>
+ <script src="/js/breadcrumbs.js" type="text/javascript"></script>
+
+
+ <!-- Uncomment to enable code coloring <link href="/css/codehilite.css"
rel="stylesheet" type="text/css"> -->
+
+</head>
+
+<body>
+
+
+
+<nav class="navbar navbar-default" role="navigation">
+<div class="container">
+ <div class="navbar-header">
+
+ <button type="button" class="navbar-toggle" data-toggle="collapse"
data-target=".navbar-ex1-collapse">
+ <span class="icon-bar"></span>
+ <span class="icon-bar"></span>
+ <span class="icon-bar"></span>
+ </button>
+ <a class="navbar-brand" href="/index.html">
+ <img class="logo-menu"
src="/images/jena-logo/jena-logo-notext-small.png" alt="jena logo">Apache
Jena</a>
+ </div>
+
+
+
+ <div class="collapse navbar-collapse navbar-ex1-collapse">
+ <ul class="nav navbar-nav">
+
+
+
+ <li id="homepage"><a href="/index.html"><span class="glyphicon
glyphicon-home"></span> Home</a></li>
+ <li id="download"><a href="/download/index.cgi"><span
class="glyphicon glyphicon-download-alt"></span> Download</a></li>
+ <li class="dropdown">
+ <a href="#" class="dropdown-toggle"
data-toggle="dropdown"><span class="glyphicon glyphicon-book"></span> Learn <b
class="caret"></b></a>
+ <ul class="dropdown-menu">
+ <li class="dropdown-header">Tutorials</li>
+ <li><a href="/tutorials/index.html">Overview</a></li>
+ <li><a href="/tutorials/rdf_api.html">RDF core API
tutorial</a></li>
+ <li><a href="/tutorials/sparql.html">SPARQL tutorial</a></li>
+ <li><a
href="/documentation/query/manipulating_sparql_using_arq.html">Manipulating
SPARQL using ARQ</a></li>
+ <li><a href="/tutorials/using_jena_with_eclipse.html">Using
Jena with Eclipse</a></li>
+ <li><a
href="/documentation/notes/index.html">How-To's</a></li>
+ <li class="divider"></li>
+ <li class="dropdown-header">References</li>
+ <li><a href="/documentation/index.html">Overview</a></li>
+ <li><a href="/documentation/javadoc/">Javadoc</a></li>
+ <li><a href="/documentation/rdf/index.html">RDF API</a></li>
+ <li><a href="/documentation/io/">RDF I/O</a></li>
+ <li><a href="/documentation/query/index.html">ARQ
(SPARQL)</a></li>
+ <li><a href="/documentation/query/text-query.html">Text
Search</a></li>
+ <li><a href="/documentation/tdb/index.html">TDB</a></li>
+ <li><a href="/documentation/sdb/index.html">SDB</a></li>
+ <li><a href="/documentation/jdbc/index.html">SPARQL over
JDBC</a></li>
+ <li><a
href="/documentation/security/index.html">Security</a></li>
+ <li><a
href="/documentation/serving_data/index.html">Fuseki</a></li>
+ <li><a
href="/documentation/assembler/index.html">Assembler</a></li>
+ <li><a href="/documentation/ontology/">Ontology API</a></li>
+ <li><a href="/documentation/inference/index.html">Inference
API</a></li>
+ <li><a href="/documentation/tools/index.html">Command-line
tools</a></li>
+ </ul>
+ </li>
+
+ <li class="drop down">
+ <a href="#" class="dropdown-toggle"
data-toggle="dropdown"><span class="glyphicon glyphicon-book"></span> Javadoc
<b class="caret"></b></a>
+ <ul class="dropdown-menu">
+ <li><a href="/documentation/javadoc/jena/">Jena Core</a></li>
+ <li><a href="/documentation/javadoc/arq/">ARQ</a></li>
+ <li><a href="/documentation/javadoc/tdb/">TDB</a></li>
+ <li><a href="/documentation/javadoc/text/">Text
Search</a></li>
+ <li><a href="/documentation/javadoc/spatial/">Spatial
Search</a></li>
+ <li><a
href="/documentation/javadoc/security/">Security</a></li>
+ <li><a href="/documentation/javadoc/jdbc/">JDBC</a></li>
+ <li><a href="/documentation/javadoc/sdb/">SDB</a></li>
+ <li><a href="/documentation/javadoc/fuseki/">Fuseki</a></li>
+ </ul>
+ </li>
+
+ <li id="ask"><a href="/help_and_support/index.html"><span
class="glyphicon glyphicon-question-sign"></span> Ask</a></li>
+
+ <li class="dropdown">
+ <a href="#" class="dropdown-toggle"
data-toggle="dropdown"><span class="glyphicon glyphicon-bullhorn"></span> Get
involved <b class="caret"></b></a>
+ <ul class="dropdown-menu">
+ <li><a
href="/getting_involved/index.html">Contribute</a></li>
+ <li><a
href="/help_and_support/bugs_and_suggestions.html">Report a bug</a></li>
+ <li class="divider"></li>
+ <li class="dropdown-header">Project</li>
+ <li><a href="/about_jena/about.html">About Jena</a></li>
+ <li><a href="/about_jena/roadmap.html">Roadmap</a></li>
+ <li><a
href="/about_jena/architecture.html">Architecture</a></li>
+ <li><a href="/about_jena/team.html">Project team</a></li>
+ <li><a href="/about_jena/contributions.html">Related
projects</a></li>
+ <li class="divider"></li>
+ <li class="dropdown-header">ASF</li>
+ <li><a href="http://www.apache.org/";>Apache Software
Foundation</a></li>
+ <li><a
href="http://www.apache.org/licenses/LICENSE-2.0";>License</a></li>
+ <li><a
href="http://www.apache.org/foundation/thanks.html";>Thanks</a></li>
+ <li><a
href="http://www.apache.org/foundation/sponsorship.html";>Become a
Sponsor</a></li>
+ <li><a
href="http://www.apache.org/security/";>Security</a></li>
+ </ul>
+ </li>
+
+
+ </ul>
+ </div>
+</div>
+</nav>
+
+
+<div class="container">
+ <div class="row">
+ <div class="col-md-12">
+ <div id="breadcrumbs"></div>
+ <h1 class="title">CSV PropertyTable
</h1>
+ <p>This module is about getting CSVs into a form that is amenable to Jena
SPARQL processing, and doing so in a way that is not specific to CSV files.
+It includes getting the right architecture in place for regular table shaped
data, using the core abstraction of PropertyTable.</p>
+<p><em>Illustration</em></p>
+<p>This module involves the basic mapping of CSV to RDF using a fixed
algorithm, including interpreting data as numbers or strings.</p>
+<p>Suppose we have a CSV file located in âfile:///c:/town.csvâ, which has
one header row, two data rows:</p>
+<div class="codehilite"><pre><span class="n">Town</span><span
class="p">,</span><span class="n">Population</span>
+<span class="n">Southton</span><span class="p">,</span>123000
+<span class="n">Northville</span><span class="p">,</span>654000
+</pre></div>
+
+
+<p>As RDF this might be viewable as:</p>
+<div class="codehilite"><pre><span class="p">@</span><span
class="n">prefix</span> <span class="p">:</span> <span
class="o"><</span><span class="n">file</span><span class="p">:</span><span
class="o">///</span><span class="n">c</span><span class="p">:</span><span
class="o">/</span><span class="n">town</span><span class="p">.</span><span
class="n">csv</span>#<span class="o">></span> <span class="p">.</span>
+<span class="p">@</span><span class="n">prefix</span> <span
class="n">csv</span><span class="p">:</span> <span class="o"><</span><span
class="n">http</span><span class="p">:</span><span class="o">//</span><span
class="n">w3c</span><span class="o">/</span><span class="n">future</span><span
class="o">-</span><span class="n">csv</span><span class="o">-</span><span
class="n">vocab</span><span class="o">/></span> <span class="p">.</span>
+<span class="p">[</span> <span class="n">csv</span><span
class="p">:</span><span class="n">row</span> 1 <span class="p">;</span> <span
class="p">:</span><span class="n">Town</span> "<span
class="n">Southton</span>" <span class="p">;</span> <span
class="p">:</span><span class="n">Population</span> â123000â^^<span
class="n">http</span><span class="p">:</span><span class="o">//</span><span
class="n">www</span><span class="p">.</span><span class="n">w3</span><span
class="p">.</span><span class="n">org</span><span class="o">/</span>2001<span
class="o">/</span><span class="n">XMLSchema</span>#<span class="n">int</span>
<span class="p">]</span> <span class="p">.</span>
+<span class="p">[</span> <span class="n">csv</span><span
class="p">:</span><span class="n">row</span> 2 <span class="p">;</span> <span
class="p">:</span><span class="n">Town</span> "<span
class="n">Northville</span>" <span class="p">;</span> <span
class="p">:</span><span class="n">Population</span> â654000â^^<span
class="n">http</span><span class="p">:</span><span class="o">//</span><span
class="n">www</span><span class="p">.</span><span class="n">w3</span><span
class="p">.</span><span class="n">org</span><span class="o">/</span>2001<span
class="o">/</span><span class="n">XMLSchema</span>#<span class="n">int</span>
<span class="p">]</span> <span class="p">.</span>
+</pre></div>
+
+
+<p>or without the bnode abbreviation:</p>
+<div class="codehilite"><pre><span class="p">@</span><span
class="n">prefix</span> <span class="p">:</span> <span
class="o"><</span><span class="n">file</span><span class="p">:</span><span
class="o">///</span><span class="n">c</span><span class="p">:</span><span
class="o">/</span><span class="n">town</span><span class="p">.</span><span
class="n">csv</span>#<span class="o">></span> <span class="p">.</span>
+<span class="p">@</span><span class="n">prefix</span> <span
class="n">csv</span><span class="p">:</span> <span class="o"><</span><span
class="n">http</span><span class="p">:</span><span class="o">//</span><span
class="n">w3c</span><span class="o">/</span><span class="n">future</span><span
class="o">-</span><span class="n">csv</span><span class="o">-</span><span
class="n">vocab</span><span class="o">/></span> <span class="p">.</span>
+<span class="n">_</span><span class="p">:</span><span class="n">b0</span>
<span class="n">csv</span><span class="p">:</span><span class="n">row</span> 1
<span class="p">;</span>
+ <span class="p">:</span><span class="n">Town</span> "<span
class="n">Southton</span>" <span class="p">;</span>
+ <span class="p">:</span><span class="n">Population</span>
â123000â^^<span class="n">http</span><span class="p">:</span><span
class="o">//</span><span class="n">www</span><span class="p">.</span><span
class="n">w3</span><span class="p">.</span><span class="n">org</span><span
class="o">/</span>2001<span class="o">/</span><span
class="n">XMLSchema</span>#<span class="n">int</span> <span class="p">.</span>
+<span class="n">_</span><span class="p">:</span><span class="n">b1</span>
<span class="n">csv</span><span class="p">:</span><span class="n">row</span> 2
<span class="p">;</span>
+ <span class="p">:</span><span class="n">Town</span> "<span
class="n">Northville</span>" <span class="p">;</span>
+ <span class="p">:</span><span class="n">Population</span>
â654000â^^<span class="n">http</span><span class="p">:</span><span
class="o">//</span><span class="n">www</span><span class="p">.</span><span
class="n">w3</span><span class="p">.</span><span class="n">org</span><span
class="o">/</span>2001<span class="o">/</span><span
class="n">XMLSchema</span>#<span class="n">int</span><span class="p">.</span>
+</pre></div>
+
+
+<p>Each row is modeling one "entity" (here, a population observation).
+There is a subject (a blank node) and one predicate-value for each cell of the
row.
+Row numbers are added because it can be important.
+Now the CSV file is viewed as a graph - normal, unmodified SPARQL can be used.
+Multiple CSVs files can be multiple graphs in one dataset to give query across
different data sources.</p>
+<p>We can use the following SPARQL query for âTowns over 500,000 peopleâ
mentioned in the CSV file:</p>
+<div class="codehilite"><pre><span class="n">SELECT</span> ?<span
class="n">townName</span> ?<span class="n">pop</span> <span class="p">{</span>
+ <span class="n">GRAPH</span> <span class="o"><</span><span
class="n">file</span><span class="p">:</span><span class="o">///</span><span
class="n">c</span><span class="p">:</span><span class="o">/</span><span
class="n">town</span><span class="p">.</span><span class="n">csv</span><span
class="o">></span> <span class="p">{</span>
+ ?<span class="n">x</span> <span class="p">:</span><span
class="n">Town</span> ?<span class="n">townName</span> <span class="p">;</span>
+ <span class="p">:</span><span class="n">Popuation</span> ?<span
class="n">pop</span> <span class="p">.</span>
+ <span class="n">FILTER</span><span class="p">(</span>?<span
class="n">pop</span> <span class="o">></span> 500000<span class="p">)</span>
+ <span class="p">}</span>
+<span class="p">}</span>
+</pre></div>
+
+
+<h2 id="get-started">Get Started</h2>
+<h2 id="design">Design</h2>
+<h2 id="implementation">Implementation</h2>
+ </div>
+</div>
+
+</div><!--/.container -->
+
+ <footer class="footer">
+ <div class="container">
+ <p>Copyright © 2011–2014 The Apache Software Foundation,
Licensed under
+ the <a href="http://www.apache.org/licenses/LICENSE-2.0";>Apache
License, Version 2.0</a>.
+ </p>
+ <p>
+ Apache Jena, Jena, the Apache Jena project logo,
+ Apache and the Apache feather logos are trademarks of The Apache
Software Foundation.
+ </p>
+ </div>
+ </footer>
+
+
+</body>
+</html>
