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 2018/12/17 14:41:22 UTC
svn commit: r1037843 - in /websites/staging/jena/trunk/content: ./
documentation/csv/csv.html
Author: buildbot
Date: Mon Dec 17 14:41:22 2018
New Revision: 1037843
Log:
Staging update by buildbot for jena
Added:
websites/staging/jena/trunk/content/documentation/csv/csv.html
Modified:
websites/staging/jena/trunk/content/ (props changed)
Propchange: websites/staging/jena/trunk/content/
------------------------------------------------------------------------------
--- cms:source-revision (original)
+++ cms:source-revision Mon Dec 17 14:41:22 2018
@@ -1 +1 @@
-1849098
+1849099
Added: websites/staging/jena/trunk/content/documentation/csv/csv.html
==============================================================================
--- websites/staging/jena/trunk/content/documentation/csv/csv.html (added)
+++ websites/staging/jena/trunk/content/documentation/csv/csv.html Mon Dec 17 14:41:22 2018
@@ -0,0 +1,251 @@
+<!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.2.4.min.js"
+ integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44="
+ crossorigin="anonymous"></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>
+
+ <script src="/js/improve.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/rdfconnection/">RDF Connection - SPARQL API</a></li>
+ <li><a href="/documentation/hadoop/index.html">Elephas - tools for RDF on Hadoop</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/fuseki2/index.html">Fuseki</a></li>
+ <li><a href="/documentation/permissions/index.html">Permissions</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>
+ <li><a href="/documentation/extras/index.html">Extras</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/fuseki2/">Fuseki</a></li>
+ <li><a href="/documentation/javadoc/elephas/">Elephas</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/permissions/">Permissions</a></li>
+ <li><a href="/documentation/javadoc/jdbc/">JDBC</a></li>
+ <li><a href="/documentation/javadoc/">All Javadoc</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>
+
+ <li id="edit"><a href="javascript:improveThisPage(location.href);" title="Improve this Page (Use username anonymous and empty password)"><span class="glyphicon glyphicon-pencil"></span> Improve this Page</a></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>
+ <style type="text/css">
+/* The following code is added by mdx_elementid.py
+ It was originally lifted from http://subversion.apache.org/style/site.css */
+/*
+ * Hide class="elementid-permalink", except when an enclosing heading
+ * has the :hover property.
+ */
+.headerlink, .elementid-permalink {
+ visibility: hidden;
+}
+h2:hover > .headerlink, h3:hover > .headerlink, h1:hover > .headerlink, h6:hover > .headerlink, h4:hover > .headerlink, h5:hover > .headerlink, dt:hover > .elementid-permalink { visibility: visible }</style>
+<hr />
+<blockquote>
+<p>This page covers the jena-csv module which has been retired.
+The last release of Jena with this module is Jena 3.9.0.
+See <a href="https://github.com/apache/jena/tree/master/jena-csv">jena-csv/README.md</a>.
+This is the original documentation.</p>
+</blockquote>
+<hr />
+<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>
+
+
+<p>What's more, we make some room for future extension through <code>PropertyTable</code>.
+The <a href="design.html">architecture</a> is designed to be able to accommodate any table-like data sources, such as relational databases, Microsoft Excel, etc.</p>
+<h2 id="documentation">Documentation<a class="headerlink" href="#documentation" title="Permanent link">¶</a></h2>
+<ul>
+<li><a href="get_started.html">Get Started</a></li>
+<li><a href="design.html">Design</a></li>
+<li><a href="implementation.html">Implementation</a></li>
+</ul>
+ </div>
+</div>
+
+</div><!--/.container -->
+
+ <footer class="footer">
+ <div class="container">
+ <p>Copyright © 2011–2018 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>
+
+ <!-- for marking links as active in the navbar-menu -->
+ <script type="text/javascript">
+ var link = $('a[href="' + this.location.pathname + '"]');
+ if (link != undefined)
+ link.parents('li,ul').addClass('active');
+ </script>
+
+</body>
+</html>