ERA

Download the full-sized PDF of Relational Database Support for Spatio-Temporal DataDownload the full-sized PDF

Analytics

Share

Permanent link (DOI): https://doi.org/10.7939/R3JH3D34C

Download

Export to: EndNote  |  Zotero  |  Mendeley

Communities

This file is in the following communities:

Computing Science, Department of

Collections

This file is in the following collections:

Technical Reports (Computing Science)

Relational Database Support for Spatio-Temporal Data Open Access

Descriptions

Author or creator
Mallett, Daniel
Additional contributors
Subject/Keyword
relational database management systems
relational databases
RDBMS
Type of item
Report
Language
English
Place
Time
Description
Technical report TR04-21. As computing technology evolves, the need to manage very large collections of complex data objects continues to arise. Database systems have been continually adapting to support new data-types, for instance, support for spatial data management is now standard in most Relational Database Management Systems (RDBMSs). With the proliferation of mobile devices capable of accurately reporting their position in time and space, there exists an urgent need to efficiently manage very large databases of moving object data inside a RDBMS. Currently, RDBMS support for such spatio-temporal data is limited and inadequate for non-trivial datasets, and most existing spatio-temporal access methods cannot be readily integrated into a RDBMS. This technical report proposes an approach for spatio-temporal storage, indexing and query support that can be fully integrated within any off-the-shelf RDBMS. A cost model which allows one to fine tune the proposed approach in order to minimize the number of disk accesses at query time is also presented. An implementation of the approach in Oracle 9i is compared with other alternatives to map the problem into a RDBMS. Extensive experiments show that the cost model is reliable and that the proposed approach significantly outperforms other options for managing spatio-temporal data inside a RDBMS.
Date created
2004
DOI
doi:10.7939/R3JH3D34C
License information
Creative Commons Attribution 3.0 Unported
Rights

Citation for previous publication

Source
Link to related item

File Details

Date Uploaded
Date Modified
2014-05-01T00:38:12.640+00:00
Audit Status
Audits have not yet been run on this file.
Characterization
File format: pdf (Portable Document Format)
Mime type: application/pdf
File size: 1351240
Last modified: 2015:10:12 21:02:14-06:00
Filename: TR04-21.pdf
Original checksum: 703cd995547ed288ce0160ff3d4d67fa
Well formed: true
Valid: true
Page count: 68
Activity of users you follow
User Activity Date