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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Güting, R.H., Böhlen, M.H., Erwig, M., et al.: A Foundation for Representing and Querying Moving Objects. ACM Transactions on Database Systems 25(1), 1–42 (2000)
Koubarakis, M., Sellis, T., Frank, A., et al.: Spatio-Temporal Databases: The CHOROCHRONOS Approach. In: Sellis, T.K., Koubarakis, M., Frank, A., Grumbach, S., Güting, R.H., Jensen, C., Lorentzos, N.A., Manolopoulos, Y., Nardelli, E., Pernici, B., Theodoulidis, B., Tryfona, N., Schek, H.-J., Scholl, M.O. (eds.) Spatio-Temporal Databases. LNCS, vol. 2520, Springer, Heidelberg (2003)
Düntgen, C., Behr, T., Güting, R.H.: BerlinMOD: A Benchmark for Moving Object Databases. The VLDB Journal 18(6), 1335–1368 (2009)
Pelekis, N., Theodoridis, Y.: An Oracle Data Cartridge for Moving Objects, Technical Report, UNIPI-ISL-TR-2007-04, Dept. of Informatics, Univ. of Piraeus (2007)
Jin, P., Yue, L., Gong, Y.: Design and Implementation of a Unified Spatiotemporal Data Model. In: Advances in Spatio-Temporal Analysis. Taylor & Francis, Abington (2007)
Jin, P., Sun, P.: OSTM: a Spatiotemporal Extension to Oracle. In: Proc. of NCM, pp. 575–580. IEEE CS Press, Gyeongju (2008)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Zhao, L., Jin, P., Zhang, X., Zhang, L., Wang, H. (2011). STOC: Extending Oracle to Support Spatiotemporal Data Management. In: Du, X., Fan, W., Wang, J., Peng, Z., Sharaf, M.A. (eds) Web Technologies and Applications. APWeb 2011. Lecture Notes in Computer Science, vol 6612. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-20291-9_43
Download citation
DOI: https://doi.org/10.1007/978-3-642-20291-9_43
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-20290-2
Online ISBN: 978-3-642-20291-9
eBook Packages: Computer ScienceComputer Science (R0)