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

Shashi Shekhar, Ranga Raju Vatsavai, Sanjay Chawla, Thomas E. Burk

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

12 Citations (Scopus)

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
Title of host publicationLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
PublisherSpringer Verlag
Pages77-104
Number of pages28
Volume1737
ISBN (Print)3540669310, 9783540669319
DOIs
Publication statusPublished - 1999
Externally publishedYes
EventInternational Workshop on Integrated Spatial Databases: Digital Images and GIS, ISD 1999 - Portland, United States
Duration: 14 Jun 199916 Jun 1999

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume1737
ISSN (Print)03029743
ISSN (Electronic)16113349

Other

OtherInternational Workshop on Integrated Spatial Databases: Digital Images and GIS, ISD 1999
CountryUnited States
CityPortland
Period14/6/9916/6/99

    Fingerprint

Keywords

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

ASJC Scopus subject areas

  • Computer Science(all)
  • Theoretical Computer Science

Cite this

Shekhar, S., Vatsavai, R. R., Chawla, S., & Burk, T. E. (1999). Spatial pictogram enhanced conceptual data models and their translation to logical data models. In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics) (Vol. 1737, 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