Maritime Data Processing in Relational Databases
hal.structure.identifier | Knowledge Learning and Information Modelling [LABISEN-KLAIM] | |
dc.contributor.author | ETIENNE, Laurent | |
hal.structure.identifier | Institut de Recherche de l'Ecole Navale [IRENAV] | |
dc.contributor.author | RAY, Cyril | |
hal.structure.identifier | Centre for Maritime Research and Experimentation - Science and Technology Organisation [CMRE - STO] | |
dc.contributor.author | CAMOSSI, Elena | |
hal.structure.identifier | Centre for Maritime Research and Experimentation - Science and Technology Organisation [CMRE - STO] | |
dc.contributor.author | IPHAR, Clément | |
dc.date.accessioned | 2021-05-14T09:31:15Z | |
dc.date.available | 2021-05-14T09:31:15Z | |
dc.date.issued | 2021-02-09 | |
dc.identifier.uri | https://oskar-bordeaux.fr/handle/20.500.12278/75873 | |
dc.description.abstractEn | 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 chapter explores off-line maritime data processing in such relational databases and provides a step-by-step guide to build a maritime database for investigating maritime traffic and vessel behaviour. Along the chapter, examples and exercises are proposed to build a maritime database using the data available in the open, heterogeneous, integrated dataset for maritime intelligence, surveillance, and reconnaissance that is described in [41]. The dataset exemplifies the variety of data that are nowadays available 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, which are an established and standard-based combination for spatial data representation and querying. Along the chapter, the reader is guided to experience the spatio-temporal features offered by the database management system, including spatial and temporal data types, indexes, queries and functions, to incrementally investigate vessel behaviours and the resulting maritime traffic. | |
dc.language.iso | en | |
dc.publisher | Springer International Publishing | |
dc.publisher.location | Cham | |
dc.source.title | Guide to Maritime Informatics | |
dc.title.en | Maritime Data Processing in Relational Databases | |
dc.type | Chapitre d'ouvrage | |
dc.identifier.doi | 10.1007/978-3-030-61852-0_3 | |
dc.subject.hal | Informatique [cs]/Modélisation et simulation | |
dc.subject.hal | Physique [physics]/Physique [physics]/Analyse de données, Statistiques et Probabilités [physics.data-an] | |
dc.subject.hal | Informatique [cs]/Base de données [cs.DB] | |
bordeaux.page | 73-118 | |
bordeaux.hal.laboratories | Institut de Mécanique et d’Ingénierie de Bordeaux (I2M) - UMR 5295 | * |
bordeaux.institution | Université de Bordeaux | |
bordeaux.institution | Bordeaux INP | |
bordeaux.institution | CNRS | |
bordeaux.institution | INRAE | |
bordeaux.institution | Arts et Métiers | |
hal.identifier | hal-03137050 | |
hal.version | 1 | |
hal.origin.link | https://hal.archives-ouvertes.fr//hal-03137050v1 | |
bordeaux.COinS | ctx_ver=Z39.88-2004&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.btitle=Guide%20to%20Maritime%20Informatics&rft.date=2021-02-09&rft.spage=73-118&rft.epage=73-118&rft.au=ETIENNE,%20Laurent&RAY,%20Cyril&CAMOSSI,%20Elena&IPHAR,%20Cl%C3%A9ment&rft.genre=unknown |
Fichier(s) constituant ce document
Fichiers | Taille | Format | Vue |
---|---|---|---|
Il n'y a pas de fichiers associés à ce document. |