Personal tools



Jump to: navigation, search


Title A spatiotemporal extension for dealing with moving objects with extent in Oracle 11g
Author Luís Matos, José Moreira, Alexandre Carvalho
Journal ACM SIGAPP Applied Computing Review
Volume 12
Number 2
Pages 7-17
Month June
Year 2012
DOI 10.1145/2340416.2340417
Group (before 2015) Information Systems and Telematics Laboratory
Indexed by ISI No

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.

Electronic version here

Online here