Modeling Geospatial Databases with Plug-Ins for Visual Languages: A Pragmatic Approach and the Impacts of 16 Years of Research and Experimentations on Perceptory

  • Yvan Bédard
  • Suzie Larrivée
  • Marie-Josée Proulx
  • Martin Nadeau
Part of the Lecture Notes in Computer Science book series (LNCS, volume 3289)


Modeling geospatial databases for GIS applications has always posed several challenges for system analysts, developers and their clients. Numerous improvements to modeling formalisms have been proposed by the research community over the last 15 years, most remaining within academia. This paper presents generic extensions (called Plug-Ins for Visual Languages or PVL) to facilitate spatial and temporal modeling of databases. For the first time, we explain its intrinsic relationship with an extended repository and how it has been influenced by pragmatic lessons learned from real life projects. We describe how we use PVLs with UML and how 16 years of fundamental research, diverse experimentations and feedbacks from users over the world shaped our approach. The final section presents Perceptory, a free repository-based UML+ PVL CASE developed to improve geospatial database modeling.


Object Class Spatial Database Digital Terrain Model Multiple Representation Database Modeling 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Ambler, S.: Agile Model-Driven Development with UML 2.0. Wiley & Sons, NY (2004)CrossRefGoogle Scholar
  2. 2.
    Bédard, Y., Proulx, M.J.: Perceptory Web Site (2004),
  3. 3.
    Bédard, Y., Proulx, M.J., Larrivée, S., Bernier, E.: Modeling Multiple Representation into Spatial Datawarehouses: A UML-based Approach. In: ISPRS WG IV/3, Ottawa, July 8-12 (2002)Google Scholar
  4. 4.
    Bédard, Y.: Visual Modelling of Spatial Database towards Spatial PVL and UML. Geomatica 53(2), 169–185 (1999)Google Scholar
  5. 5.
    Bédard, Y., Caron, C., Maamar, Z., Moulin, B., Vallière, D.: Adapting Data Model for the Design of Spatio-Temporal Database. Comp. Env. and Urban Systems 20(l), 19–41 (1996)CrossRefGoogle Scholar
  6. 6.
    Bédard, Y., Pageau, J., Caron, C.: Spatial Data Modeling: The Modul-R Formalism and CASE Technology. In: ISPRS Symposium, Washington, August 1-14 (1992)Google Scholar
  7. 7.
    Bédard, Y., Paquette, F.: Extending entity/relationship formalism for spatial information systems. In: AUTO-CARTO 9, Baltimore, April 2-7, pp. 818–827 (1989)Google Scholar
  8. 8.
    Bédard, Y., Larrivée, S.: Développement des systèmes d’information à référence spatiale: vers l’utilisation d’ateliers de génie logiciel. CISM Journal ACSGC 46(4), 423–433 (1992)Google Scholar
  9. 9.
    Boehm, B., Turner, R.: Balancing Agility & Discipline, p. 304. Addison-Wesley, NY (2004)Google Scholar
  10. 10.
    Brodeur, J., Bédard, Y., Proulx, M.J.: Modelling Geospatial Application Database using UML-based Repositories Aligned with International Standards in Geomatics. In: ACMGIS, Washington DC, November 10-11, pp. 36–46 (2000)Google Scholar
  11. 11.
    Clementini, E., Di Felice, P., Van Oosterom, P.: A small set of formal topological relationship suitable for end users interaction. In: Third symposium on Large Spatial Database, Singapore, vol. (692), pp. 277–295. Springer, NY (1993)Google Scholar
  12. 12.
    Cockburn, A.: Agile Software Development, p. 278. Addison-Wesley, NY (2002)Google Scholar
  13. 13.
    Egenhofer, M., Herring, J.: Categorizing Binary Topological Relations Between Regions, Lines, and Points in Geographic Databases, Tech. Report, University of Maine, p. 28 (1990)Google Scholar
  14. 14.
    Filho, J.L., Iochpe, C.: Specifying analysis patterns for geographic databases on the basis of a conceptual framework. ACMGIS 7, 7–13 (1999)Google Scholar
  15. 15.
    Filho, J.L., Iochpe, C.: Um Estudo sobre Modelos Conceituais de Dados para Projeto de Bancos de Dados Geográficos. Revista IP-Informática Pública 1(2), 37–90 (1999)Google Scholar
  16. 16.
    Fowler, M.: UML 2.0, p. 165. Campus Press (2004)Google Scholar
  17. 17.
    Hadzilacos, T., Tryfona, N.: An Extended Entity-Relationship Model for Geographic Applications. SIGMOD Record 26(3) (1997)Google Scholar
  18. 18.
    Highsmith, J.: Agile Software Development Ecosystems, p. 448. Addison-Wesley, Reading (2002)Google Scholar
  19. 19.
    ISO/TC211 19110, Geographic information: Methodology for feature cataloguing (2004) Google Scholar
  20. 20.
    ISO/TC211, 19115, Geographic information: Metadata, p. 140 (2003)Google Scholar
  21. 21.
    Kosters, G., Pagel, B., Six, H.: GIS-Application Development with GeoOOA. IJGIS 11(4), 307–335 (1997)Google Scholar
  22. 22.
    Larman, C.: Agile & Iterative Development, p. 342. Addison-Wesley, Reading (2004)Google Scholar
  23. 23.
    Naiburg, E., Maksimchuk, R.: UML for Database Design, p. 300. Addison-Wesley, Reading (2001)Google Scholar
  24. 24.
    Normand, P.: Modélisation des contraintes d’intégrité spatiale: théorie et exemples d’application, Ms. Degree, Dept. Geomatics Sciences, University Laval (1999)Google Scholar
  25. 25.
    Parent, C., Spaccapietra, S., Zimanyi, E., Donini, P.: Modeling Spatial Data in the MADS Conceptual Model. In: Int. Symp. on Spatial Data Handling, Vancouver, pp. 138–150 (1998)Google Scholar
  26. 26.
    Parent, C., Spaccapietra, S., Zimanyi, E.: Spatio-Temporal Conceptual Models: Data Structures + Space + Time. In: 7th ACMGIS, GIS 1999, Kansas City, pp. 26–33 (1999)Google Scholar
  27. 27.
    Shekhar, S., Vatsavai, R.R., Chawla, S., Burk, T.E.: Spatial Pictogram Enhanced Conceptual Data Models and Their Translation to Logical Data Models. In: Agouris, P., Stefanidis, A. (eds.) ISD 1999. LNCS, vol. 1737, pp. 77–104. Springer, Heidelberg (1999)CrossRefGoogle Scholar
  28. 28.
    Shekhar, S., Chawla, S.: Spatial Databases A Tour, p. 262. Prentice Hall, Englewood Cliffs (2003)Google Scholar
  29. 29.
    Tryfona, N., Price, R., Jensen, C.S.: Conceptual Models for Spatio-temporal Applications. In: Spatio-Temporal Databases: The CHOROCHRONOS Approach 2003, pp. 79–116 (2003)Google Scholar
  30. 30.
    Priebe, T., Pernul, G.: Metadaten-gestützer Data-Warehouse-Entwurf mit ADAPTed UML. In: 5th Int.Tagung Wirtschaftsinformatik (WI 2001), September 19-21, Germany (2001)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2004

Authors and Affiliations

  • Yvan Bédard
    • 1
  • Suzie Larrivée
    • 1
  • Marie-Josée Proulx
    • 1
  • Martin Nadeau
    • 1
  1. 1.Centre for Research in Geomatics, Dept of Geomatics SciencesLaval UniversityQuebec CityCanada

Personalised recommendations