Hands-on with Hermes@Oracle MOD

Abstract

Moving Object Database (MOD) engines enable us to process, manage and analyze mobility data. One of the already presented systems that satisfy these requirements is the Hermes MOD engine. Hermes provides MOD functionality to OpenGIS-compatible state-of-the-art Object-Relational DBMS. Currently, Hermes comes in two implementations; the first operates on top of Oracle DBMS (denoted as Hermes@Oracle) and the second operates on top of PostgreSQL (denoted as Hermes@Postgres). In Chap. 5, we studied the collection of abstract data types (ADT) and their corresponding operations of the Hermes@Oracle, which were defined, developed and provided as a data cartridge extending Oracle’s SQL query language with MOD semantics. The present chapter contains a detailed description of a hands-on experience over a dataset of synthetic trajectories (produced by the Hermoupolis generator) moving in Attiki, Greece. The methodology that we will follow is the one presented in Chap. 1, Fig. 1.6. There are several sample queries as well as analytical and mining procedures running over the Attiki dataset and showing Hermes@Oracle API in action. Regarding installation guidelines for Hermes, as well as the specific dataset used in the current hands-on, and the Hermoupolis generator for producing datasets with different properties, the interested reader is referred to Hermes@Oracle homepage.