jena-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From build...@apache.org
Subject svn commit: r918229 - in /websites/staging/jena/trunk/content: ./ documentation/csv/index.html
Date Sat, 02 Aug 2014 19:51:07 GMT
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">&lt;</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">&gt;</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">&lt;</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">/&gt;</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> &quot;<span class="n">Southton</span>&quot;
<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> &quot;<span class="n">Northville</span>&quot;
<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">&lt;</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">&gt;</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">&lt;</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">/&gt;</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> &quot;<span
class="n">Southton</span>&quot; <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> &quot;<span
class="n">Northville</span>&quot; <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">&lt;</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">&gt;</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">&gt;</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 &copy; 2011&ndash;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>



Mime
View raw message