Spatial pictogram enhanced conceptual data models and their translation to logical data models

Shashi Shekhar, Ranga Raju Vatsavai, Sanjay Chawla, Tom Burk

Research output: Chapter in Book/Report/Conference proceedingConference contribution

12 Scopus citations

Abstract

The successful development of any geographic information system project needs the careful design and implementation of spatial databases via conceptual and logical data-modeling. This involves understanding the underlying spatial data model, spatial data types and operators, spatial query languages and spatial indexing techniques. Conventional entity-relationship diagrams have limitations for conceptual spatial data-modeling, since they get cluttered with numerous spatial relationships. In addition the logical data model gets cluttered with redundant tables representing materialization of the M:N spatial relationships. In this paper we present an extension to ER diagrams using pictograms for entities and as well as relationships. This approach effectively reduces the cluttering, as spatial relationships will become implicit. We have provided a complete grammar using “yacc” like syntax to translate the pictogram-extended ER diagram into a SQL3-level logical data model using OGIS-standard spatial data types.

Original languageEnglish (US)
Title of host publicationIntegrated Spatial Databases
Subtitle of host publicationDigital Images and GIS - International Workshop ISD 1999, Selected Papers
EditorsPeggy Agouris, Anthony Stefanidis
PublisherSpringer Verlag
Pages77-104
Number of pages28
ISBN (Print)3540669310, 9783540669319
DOIs
StatePublished - Jan 1 1999
EventInternational Workshop on Integrated Spatial Databases: Digital Images and GIS, ISD 1999 - Portland, United States
Duration: Jun 14 1999Jun 16 1999

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume1737
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349

Other

OtherInternational Workshop on Integrated Spatial Databases: Digital Images and GIS, ISD 1999
CountryUnited States
CityPortland
Period6/14/996/16/99

Keywords

  • Entity-relationship diagrams
  • OGIS
  • Pictograms
  • SQL3
  • Spatial databases
  • Syntax directed translation
  • UML

Fingerprint Dive into the research topics of 'Spatial pictogram enhanced conceptual data models and their translation to logical data models'. Together they form a unique fingerprint.

  • Cite this

    Shekhar, S., Vatsavai, R. R., Chawla, S., & Burk, T. (1999). Spatial pictogram enhanced conceptual data models and their translation to logical data models. In P. Agouris, & A. Stefanidis (Eds.), Integrated Spatial Databases: Digital Images and GIS - International Workshop ISD 1999, Selected Papers (pp. 77-104). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 1737). Springer Verlag. https://doi.org/10.1007/3-540-46621-5_6