STOC: Extending Oracle to Support Spatiotemporal Data Management

Lei Zhao,Peiquan Jin,Xiaoxiang Zhang,Lanlan Zhang,Huaishuai Wang
DOI: https://doi.org/10.1007/978-3-642-20291-9_43
2011-01-01
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.
What problem does this paper attempt to address?