Skip to main content
Springer Nature Link
Log in

Implementing Conceptual Spatio-temporal Schemas in Object-Relational DBMSs

  • Conference paper
On the Move to Meaningful Internet Systems 2006: OTM 2006 Workshops (OTM 2006)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 4278))

Abstract

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.

An erratum to this chapter can be found at http://dx.doi.org/10.1007/11915072_109.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Similar content being viewed by others

References

  1. Allen, J.F.: Maintaining knowledge about temporal intervals. Communications of the ACM 26(11), 832–843 (1983)

    Article  MATH  Google Scholar 

  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. 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)

    Article  Google Scholar 

  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. 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. 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)

    Chapter  Google Scholar 

  7. Parent, C., Spaccapietra, S., Zimányi, E.: Conceptual Modeling for Traditional and Spatio-Temporal Applications: The MADS Approach. Springer, Heidelberg (2006)

    MATH  Google Scholar 

  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)

    Article  Google Scholar 

  9. Rigaux, P., Scholl, M., Voisard, A.: Introduction to Spatial Databases: Applications to GIS. Morgan Kaufmann, San Francisco (2000)

    Google Scholar 

  10. Tryfona, N., Jensen, C.S.: Conceptual data modeling for spatiotemporal applications. GeoInformatica 3(3), 245–268 (1999)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Computer and Decision Engineering (CoDE), Université Libre de Bruxelles, CP 165/15, 50 av. F.D. Roosevelt, 1050, Brussels, Belgium

    Esteban Zimányi & Mohammed Minout

Authors
  1. Esteban Zimányi
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Mohammed Minout
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. STARLab, Vrije Universiteit Brussel (VUB), Bldg G/10, Pleinlaan 2, 1050, Brussels, Belgium

    Robert Meersman

  2. School of Computer Science and Information Technology, RMIT University, Bld 10.10, 376-392 Swanston Street, 3001, Melbourne, VIC, Australia

    Zahir Tari

  3. Facultad de Informática, Universidad Politécnica de Madrid, Campus de Montegancedo S/N, 28660, Boadilla del Monte, Madrid, Spain

    Pilar Herrero

Rights and permissions

Reprints and permissions

Copyright information

© 2006 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Zimányi, E., Minout, M. (2006). Implementing Conceptual Spatio-temporal Schemas in Object-Relational DBMSs. In: Meersman, R., Tari, Z., Herrero, P. (eds) On the Move to Meaningful Internet Systems 2006: OTM 2006 Workshops. OTM 2006. Lecture Notes in Computer Science, vol 4278. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11915072_71

Download citation

  • DOI: https://doi.org/10.1007/11915072_71

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-48273-4

  • Online ISBN: 978-3-540-48276-5

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics