Developing an Oracle-Based Spatio-Temporal Information Management System

  • Lei Zhao
  • Peiquan Jin
  • Lanlan Zhang
  • Huaishuai Wang
  • Sheng Lin
Part of the Lecture Notes in Computer Science book series (LNCS, volume 6637)


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.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Sistla, P., Wolfson, O., et al.: Modeling and Querying Moving Objects. In: ICDE, Birmingham, UK (1997)Google Scholar
  2. 2.
    Bohlen, M., Jensen, C., Skjellaug, B.: Spatio-Temporal Database Support for Legacy. In: 1998 ACM Symposium on Applied Computing, Georgia (1998)Google Scholar
  3. 3.
    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)CrossRefGoogle Scholar
  4. 4.
    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)CrossRefGoogle Scholar
  5. 5.
    Pfoser, D., Jensen, C.S., Theodoridis, Y.: Novel Approaches to the Indexing of Moving Object Trajectories. In: Proceedings of VLDB (2000)Google Scholar
  6. 6.
    Benetis, R., Jensen, C.S., et al.: Nearest neighbor and reverse nearest neighbor queries for moving objects. In: IDEAS, pp. 44–53 (2002)Google Scholar
  7. 7.
    Lema, J.A.C., Forlizzi, L., et al.: Algorithms for moving objects databases. The Computer Journal 46(6), 680–712 (2003)CrossRefzbMATHGoogle Scholar
  8. 8.
    Oracle Corp. Oracle Spatial User’s Guide and Reference,
  9. 9.
  10. 10.
  11. 11.
    Forlizzi, L., Güting, R.H., et al.: A Data Model and Data Structures for Moving Objects Databases. In: SIGMOD, pp. 319–330 (2000)Google Scholar
  12. 12.
    Allen, J.F.: Maintaining knowledge about temporal intervals. Communication of ACM 26, 832–843 (1983)CrossRefzbMATHGoogle Scholar
  13. 13.
    Egenhofer, M., Franzosa, R.: Point-Set Topological Spatial Relations. International Journal of Geographical Information Systems 5(2), 161–174 (1991)CrossRefGoogle Scholar
  14. 14.
    Düntgen, C., Behr, T., Güting, R.H.: BerlinMOD: a benchmark for moving object databases. VLDB J. 18(6), 1335–1368 (2009)CrossRefGoogle Scholar
  15. 15.
    Wolfson, O., Sistla, P., et al.: DOMINO: Databases for Moving Objects Tracking. In: SIGMOD, Philadelphia, PA, pp. 547–549 (1999)Google Scholar
  16. 16.
    Torp, K., Jensen, C.S., Bohlen, M.H.: Layered Implementation of Temporal DBMSs-Concepts and Techniques. In: DASFAA, Melbourne, Australia, pp. 371–380 (1997)Google Scholar
  17. 17.
    Torp, K., Jensen, C.S., Snodgrass, R.T.: Stratum Approaches to Temporal DBMS Implementation. In: IDEAS, Cardiff, Wales, pp. 4–13 (1998)Google Scholar
  18. 18.
    Informix Corp. Informix Timeseries DataBlade Module User’s Guide, Version 3.1 (1997)Google Scholar
  19. 19.
    Informix Corp. Informix Geodetic DataBlade Module User’s Guide, Version 2.1 (1997)Google Scholar
  20. 20.
    Güting, R.H., de Almeida, et al.: Secondo: Anextensible DBMS platform for research prototyping and teaching. In: ICDE, pp. 1115–1116 (2005)Google Scholar
  21. 21.
    Ooi, B.C., Huang, Z., et al.: Adapting Relational Database Engine to Accommodate Moving Objects in SpADE. In: ICDE, Istanbul, pp. 1505–1506 (2007)Google Scholar
  22. 22.
    Pelekis, N., Frentzos, E., Giatrakos, N., Theodoridis, Y.: HERMES:Aggregative LBS via a trajectory DB engine. In: ISIGMOD, pp. 1255–1258 (2008)Google Scholar
  23. 23.
    Cudre-Mauroux, P., Wu, E., Madden, S.: TrajStore: An Adaptive Storage System for Very Large Trajectory Data Sets. In: ICDE (2010)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2011

Authors and Affiliations

  • Lei Zhao
    • 1
  • Peiquan Jin
    • 1
  • Lanlan Zhang
    • 1
  • Huaishuai Wang
    • 1
  • Sheng Lin
    • 1
  1. 1.School of Computer Science and TechnologyUniversity of Science and Technology of ChinaHefeiChina

Personalised recommendations