Implementing Conceptual Spatio-temporal Schemas in Object-Relational DBMSs

  • Esteban Zimányi
  • Mohammed Minout
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4278)


Several spatio-temporal conceptual models have been proposed in the literature. Some of these models have associated CASE tools assisting the user from the creation of the conceptual schema until the generation of a physical schema for a target DBMS or GIS. However, such CASE tools only consider the translation of information structures (i.e. attributes). Since current DBMSs or GISs provide limited support for temporal and spatio-temporal information, when translating conceptual schemas it is necessary to automatically generate the functions and procedures allowing to manipulate spatio-temporal information in the target platform. In this paper we describe how to realize this generation in an object-relational DBMSs.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Allen, J.F.: Maintaining knowledge about temporal intervals. Communications of the ACM 26(11), 832–843 (1983)zbMATHCrossRefGoogle Scholar
  2. 2.
    Camossi, E., Bertolotto, M., Bertino, E., Guerrini, G.: A multigranular spatiotemporal data model. In: Proc. of the 11th ACM Int. Symp. on Advances in Geographic Information Systems, ACM GIS 2003, pp. 94–101 (2003)Google Scholar
  3. 3.
    Egenhofer, M.J., Clementini, E., Di Felice, P.: Topological relations between regions with holes. Int. Journal of Geographic Information Systems 8(2), 129–142 (1994)CrossRefGoogle Scholar
  4. 4.
    Khatri, V., Ram, S., Snodgrass, R.T.: ST USM: Bridging the semantic gap with a spatio-temporal conceptual model. TimeCenter Research Report TR-64 (2001)Google Scholar
  5. 5.
    Minout, M., Parent, C., Zimányi, E.: A tool for transforming conceptual schemas of spatio-temporal databases with multiple representations. In: Proc. of the IASTED Int. Conf. on Database Applications, DBA 2004, pp. 1–6 (2004)Google Scholar
  6. 6.
    Zimányi, E., Minout, M.: Preserving Semantics when Transforming Conceptual Spatio-Temporal Schemas. In: Meersman, R., Tari, Z., Herrero, P. (eds.) OTM-WS 2005. LNCS, vol. 3762, pp. 1037–1046. Springer, Heidelberg (2005)CrossRefGoogle Scholar
  7. 7.
    Parent, C., Spaccapietra, S., Zimányi, E.: Conceptual Modeling for Traditional and Spatio-Temporal Applications: The MADS Approach. Springer, Heidelberg (2006)zbMATHGoogle Scholar
  8. 8.
    Price, R., Tryfona, N., Jensen, C.S.: Extended spatio-temporal UML: Motivations, requirements, and constructs. Journal of Database Management 11(4), 14–27 (2000)CrossRefGoogle Scholar
  9. 9.
    Rigaux, P., Scholl, M., Voisard, A.: Introduction to Spatial Databases: Applications to GIS. Morgan Kaufmann, San Francisco (2000)Google Scholar
  10. 10.
    Tryfona, N., Jensen, C.S.: Conceptual data modeling for spatiotemporal applications. GeoInformatica 3(3), 245–268 (1999)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Esteban Zimányi
    • 1
  • Mohammed Minout
    • 1
  1. 1.Department of Computer and Decision Engineering (CoDE)Université Libre de BruxellesBrusselsBelgium

Personalised recommendations