A spatiotemporal extension for dealing with moving objects with extent in Oracle 11g

  • Authors:
  • Luís Matos;José Moreira;Alexandre Carvalho

  • Affiliations:
  • University of Aveiro, Aveiro, Portugal;University of Aveiro, Aveiro, Portugal;University of Porto, Porto, Portugal

  • Venue:
  • ACM SIGAPP Applied Computing Review
  • Year:
  • 2012

Quantified Score

Hi-index 0.00

Visualization

Abstract

This paper deals with the design and implementation of a data model and operations for dealing with continuously changing spatial data in Oracle 11g object-relational DBMS. The data model relies on abstract data types but we introduce modifications to the internal structure of the spatiotemporal data representations proposed in the literature, to reduce storage requirements and to enable the reuse of data during the execution of queries. We show how to implement spatiotemporal operations relying on the spatial functions released by the underlying DBMS and how to use the alternative data representations to reduce the volume of temporary data created in the evaluation of spatiotemporal operations. We also demonstrate how to use the proposed data types and operations for storage and manipulation of moving objects data using SQL. Finally, we discuss on the advantages and disadvantages of the proposed solutions.