Abstract
In this paper, we present an extension of Oracle, named STOC (Spatio-Temporal Object Cartridge), to support spatio-temporal data management in a practical way. The extension is developed as a PL/SQL package and can be integrated into Oracle to offer spatio-temporal data types as well as spatio-temporal operations for various applications. Users are allowed to use standard SQL to access spatio-temporal 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 is presented, which shows that STOC is effective to represent and query spatio-temporal data on the basis of Oracle.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Sistla, P., Wolfson, O., et al.: Modeling and Querying Moving Objects. In: ICDE, Birmingham, UK (1997)
Bohlen, M., Jensen, C., Skjellaug, B.: Spatio-Temporal Database Support for Legacy. In: 1998 ACM Symposium on Applied Computing, Georgia (1998)
Erwig, M., Güting, R.H., et al.: Spatio-Temporal Data Types: An Approach to Modeling and Querying Moving Objects in Databases. GeoInformatica 3(3), 265–291 (1999)
Güting, R.H., Bohlen, M.H., et al.: A foundation for representing and quering moving objects. ACM Transactions Database Systems 25(1), 1–42 (2000)
Pfoser, D., Jensen, C.S., Theodoridis, Y.: Novel Approaches to the Indexing of Moving Object Trajectories. In: Proceedings of VLDB (2000)
Benetis, R., Jensen, C.S., et al.: Nearest neighbor and reverse nearest neighbor queries for moving objects. In: IDEAS, pp. 44–53 (2002)
Lema, J.A.C., Forlizzi, L., et al.: Algorithms for moving objects databases. The Computer Journal 46(6), 680–712 (2003)
Oracle Corp. Oracle Spatial User’s Guide and Reference, http://www.oracle.com/technology/products/spatial/spatial_doc_index.html
SQL Server Spatial Data, http://www.microsoft.com/sqlserver/2008/en/us/spatial-data.aspx
PostGIS, http://postgis.refractions.net/
Forlizzi, L., Güting, R.H., et al.: A Data Model and Data Structures for Moving Objects Databases. In: SIGMOD, pp. 319–330 (2000)
Allen, J.F.: Maintaining knowledge about temporal intervals. Communication of ACM 26, 832–843 (1983)
Egenhofer, M., Franzosa, R.: Point-Set Topological Spatial Relations. International Journal of Geographical Information Systems 5(2), 161–174 (1991)
Düntgen, C., Behr, T., Güting, R.H.: BerlinMOD: a benchmark for moving object databases. VLDB J. 18(6), 1335–1368 (2009)
Wolfson, O., Sistla, P., et al.: DOMINO: Databases for Moving Objects Tracking. In: SIGMOD, Philadelphia, PA, pp. 547–549 (1999)
Torp, K., Jensen, C.S., Bohlen, M.H.: Layered Implementation of Temporal DBMSs-Concepts and Techniques. In: DASFAA, Melbourne, Australia, pp. 371–380 (1997)
Torp, K., Jensen, C.S., Snodgrass, R.T.: Stratum Approaches to Temporal DBMS Implementation. In: IDEAS, Cardiff, Wales, pp. 4–13 (1998)
Informix Corp. Informix Timeseries DataBlade Module User’s Guide, Version 3.1 (1997)
Informix Corp. Informix Geodetic DataBlade Module User’s Guide, Version 2.1 (1997)
Güting, R.H., de Almeida, et al.: Secondo: Anextensible DBMS platform for research prototyping and teaching. In: ICDE, pp. 1115–1116 (2005)
Ooi, B.C., Huang, Z., et al.: Adapting Relational Database Engine to Accommodate Moving Objects in SpADE. In: ICDE, Istanbul, pp. 1505–1506 (2007)
Pelekis, N., Frentzos, E., Giatrakos, N., Theodoridis, Y.: HERMES:Aggregative LBS via a trajectory DB engine. In: ISIGMOD, pp. 1255–1258 (2008)
Cudre-Mauroux, P., Wu, E., Madden, S.: TrajStore: An Adaptive Storage System for Very Large Trajectory Data Sets. In: ICDE (2010)
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, L., Wang, H., Lin, S. (2011). Developing an Oracle-Based Spatio-Temporal Information Management System. In: Xu, J., Yu, G., Zhou, S., Unland, R. (eds) Database Systems for Adanced Applications. DASFAA 2011. Lecture Notes in Computer Science, vol 6637. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-20244-5_16
Download citation
DOI: https://doi.org/10.1007/978-3-642-20244-5_16
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-20243-8
Online ISBN: 978-3-642-20244-5
eBook Packages: Computer ScienceComputer Science (R0)