Software Open Access

Maritime Data Processing in Relational Databases

ETIENNE, Laurent; RAY, Cyril; CAMOSSI, Elena; IPHAR, Clément


DCAT Export

<?xml version='1.0' encoding='utf-8'?>
<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:adms="http://www.w3.org/ns/adms#" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:dct="http://purl.org/dc/terms/" xmlns:dctype="http://purl.org/dc/dcmitype/" xmlns:dcat="http://www.w3.org/ns/dcat#" xmlns:duv="http://www.w3.org/ns/duv#" xmlns:foaf="http://xmlns.com/foaf/0.1/" xmlns:frapo="http://purl.org/cerif/frapo/" xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#" xmlns:gsp="http://www.opengis.net/ont/geosparql#" xmlns:locn="http://www.w3.org/ns/locn#" xmlns:org="http://www.w3.org/ns/org#" xmlns:owl="http://www.w3.org/2002/07/owl#" xmlns:prov="http://www.w3.org/ns/prov#" xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#" xmlns:schema="http://schema.org/" xmlns:skos="http://www.w3.org/2004/02/skos/core#" xmlns:vcard="http://www.w3.org/2006/vcard/ns#" xmlns:wdrs="http://www.w3.org/2007/05/powder-s#">
  <rdf:Description rdf:about="https://doi.org/10.5281/zenodo.3930660">
    <rdf:type rdf:resource="http://www.w3.org/ns/dcat#Dataset"/>
    <dct:type rdf:resource="http://purl.org/dc/dcmitype/Software"/>
    <dct:identifier rdf:datatype="http://www.w3.org/2001/XMLSchema#anyURI">https://doi.org/10.5281/zenodo.3930660</dct:identifier>
    <foaf:page rdf:resource="https://doi.org/10.5281/zenodo.3930660"/>
    <dct:creator>
      <rdf:Description>
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <foaf:name>ETIENNE, Laurent</foaf:name>
        <foaf:givenName>Laurent</foaf:givenName>
        <foaf:familyName>ETIENNE</foaf:familyName>
        <org:memberOf>
          <foaf:Organization>
            <foaf:name>LabISEN, France</foaf:name>
          </foaf:Organization>
        </org:memberOf>
      </rdf:Description>
    </dct:creator>
    <dct:creator>
      <rdf:Description rdf:about="http://orcid.org/0000-0001-6070-3005">
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <dct:identifier rdf:datatype="http://www.w3.org/2001/XMLSchema#string">0000-0001-6070-3005</dct:identifier>
        <foaf:name>RAY, Cyril</foaf:name>
        <foaf:givenName>Cyril</foaf:givenName>
        <foaf:familyName>RAY</foaf:familyName>
        <org:memberOf>
          <foaf:Organization>
            <foaf:name>Naval Academy Research Institute, France</foaf:name>
          </foaf:Organization>
        </org:memberOf>
      </rdf:Description>
    </dct:creator>
    <dct:creator>
      <rdf:Description>
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <foaf:name>CAMOSSI, Elena</foaf:name>
        <foaf:givenName>Elena</foaf:givenName>
        <foaf:familyName>CAMOSSI</foaf:familyName>
        <org:memberOf>
          <foaf:Organization>
            <foaf:name>NATO STO Centre for Maritime Research and Experimentation, Italy</foaf:name>
          </foaf:Organization>
        </org:memberOf>
      </rdf:Description>
    </dct:creator>
    <dct:creator>
      <rdf:Description>
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <foaf:name>IPHAR, Clément</foaf:name>
        <foaf:givenName>Clément</foaf:givenName>
        <foaf:familyName>IPHAR</foaf:familyName>
        <org:memberOf>
          <foaf:Organization>
            <foaf:name>NATO STO Centre for Maritime Research and Experimentation, Italy</foaf:name>
          </foaf:Organization>
        </org:memberOf>
      </rdf:Description>
    </dct:creator>
    <dct:title>Maritime Data Processing in Relational Databases</dct:title>
    <dct:publisher>
      <foaf:Agent>
        <foaf:name>Zenodo</foaf:name>
      </foaf:Agent>
    </dct:publisher>
    <dct:issued rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2020</dct:issued>
    <dcat:keyword>SQL</dcat:keyword>
    <dcat:keyword>Maritime informatics</dcat:keyword>
    <dcat:keyword>Relational database</dcat:keyword>
    <dcat:keyword>Automatic Identification System</dcat:keyword>
    <dct:issued rdf:datatype="http://www.w3.org/2001/XMLSchema#date">2020-07-05</dct:issued>
    <dct:language rdf:resource="http://publications.europa.eu/resource/authority/language/ENG"/>
    <owl:sameAs rdf:resource="https://zenodo.org/record/3930660"/>
    <adms:identifier>
      <adms:Identifier>
        <skos:notation rdf:datatype="http://www.w3.org/2001/XMLSchema#anyURI">https://zenodo.org/record/3930660</skos:notation>
        <adms:schemeAgency>url</adms:schemeAgency>
      </adms:Identifier>
    </adms:identifier>
    <dct:relation rdf:resource="https://doi.org/10.5281/zenodo.1167594"/>
    <foaf:page rdf:resource="https://doi.org/10.1016/j.dib.2019.104141"/>
    <dct:isVersionOf rdf:resource="https://doi.org/10.5281/zenodo.3930659"/>
    <owl:versionInfo>1.0</owl:versionInfo>
    <dct:description>&lt;p&gt;Maritime data processing research has long used spatio-temporal relational databases. This model suits well the requirements of off-line applications dealing with average-size and known in advance geographic data that can be represented in tabular form. This set of SQL queries has been prepared for the book Maritime Informatics. It aims to help students and teachers explore off-line maritime data processing in relational databases and provides a step-by-step guide to build a maritime database for investigating maritime traffic and vessel behaviour. Examples and exercises of the book chapter are proposed to build a maritime database using the data available in the open, heterogeneous and integrated dataset also available on Zenodo (10.5281/zenodo.1167595). The dataset exemplifies the variety of data that are available as of today for monitoring the activities at sea, mainly the Automatic Identification System (AIS), which is openly broadcast and provides worldwide information on the maritime traffic. All the examples and the exercises refer to the syntax of the widespread relational database management system PostgreSQL and its spatial extension PostGIS, an established and standard-based combination for spatial data representation and querying. Along the chapter, through exercises, the reader is guided to handle the various spatio-temporal features offered by the database management system, that include spatial and temporal data types, indexes, queries and functions, and eventually to investigate, incrementally, behaviours of vessels at sea and the state of the maritime traffic.&lt;/p&gt; &lt;p&gt;&amp;nbsp;&lt;/p&gt;</dct:description>
    <dct:accessRights rdf:resource="http://publications.europa.eu/resource/authority/access-right/PUBLIC"/>
    <dct:accessRights>
      <dct:RightsStatement rdf:about="info:eu-repo/semantics/openAccess">
        <rdfs:label>Open Access</rdfs:label>
      </dct:RightsStatement>
    </dct:accessRights>
    <dcat:distribution>
      <dcat:Distribution>
        <dct:license rdf:resource="https://creativecommons.org/licenses/by/4.0/legalcode"/>
        <dcat:accessURL rdf:resource="https://doi.org/10.5281/zenodo.3930660"/>
      </dcat:Distribution>
    </dcat:distribution>
    <dcat:distribution>
      <dcat:Distribution>
        <dcat:accessURL rdf:resource="https://doi.org/10.5281/zenodo.3930660">https://doi.org/10.5281/zenodo.3930660</dcat:accessURL>
        <dcat:byteSize>336707</dcat:byteSize>
        <dcat:downloadURL rdf:resource="https://zenodo.org/record/3930660/files/Maritime Informatics Database Model.png">https://zenodo.org/record/3930660/files/Maritime Informatics Database Model.png</dcat:downloadURL>
        <dcat:mediaType>image/png</dcat:mediaType>
      </dcat:Distribution>
    </dcat:distribution>
    <dcat:distribution>
      <dcat:Distribution>
        <dcat:accessURL rdf:resource="https://doi.org/10.5281/zenodo.3930660">https://doi.org/10.5281/zenodo.3930660</dcat:accessURL>
        <dcat:byteSize>36592</dcat:byteSize>
        <dcat:downloadURL rdf:resource="https://zenodo.org/record/3930660/files/Maritime_Informatics_SQL_Queries.sql">https://zenodo.org/record/3930660/files/Maritime_Informatics_SQL_Queries.sql</dcat:downloadURL>
        <dcat:mediaType>application/sql</dcat:mediaType>
      </dcat:Distribution>
    </dcat:distribution>
  </rdf:Description>
</rdf:RDF>
517
212
views
downloads
All versions This version
Views 517517
Downloads 212212
Data volume 42.3 MB42.3 MB
Unique views 416416
Unique downloads 155155

Share

Cite as