STOC: extending oracle to support spatiotemporal data management

  • Authors:
  • Lei Zhao;Peiquan Jin;Xiaoxiang Zhang;Lanlan Zhang;Huaishuai Wang

  • Affiliations:
  • School of Computer Science and Technology, University of Science and Technology of China, Hefei, China;School of Computer Science and Technology, University of Science and Technology of China, Hefei, China;School of Computer Science and Technology, University of Science and Technology of China, Hefei, China;School of Computer Science and Technology, University of Science and Technology of China, Hefei, China;School of Computer Science and Technology, University of Science and Technology of China, Hefei, China

  • Venue:
  • APWeb'11 Proceedings of the 13th Asia-Pacific web conference on Web technologies and applications
  • Year:
  • 2011

Quantified Score

Hi-index 0.00

Visualization

Abstract

Previous research on spatiotemporal database were mainly focused on modeling, indexing, and query processing, and little work has be done in the implementation of spatiotemporal database management systems. In this paper, we present an extension of Oracle, named STOC (Spatio-Temporal Object Cartridge), to support spatiotemporal data management in a practical way. The extension is developed as a PL/SQL package and can be integrated into Oracle to offer spatiotemporal data types as well as spatiotemporal operations for various applications. Users are allowed to use standard SQL to access spatiotemporal data and functions. After an overview of the general features of STOC, we discuss the architecture and implementation of STOC. And finally, a case study of STOC's demonstration is presented.