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

Pictogram
Conceptual Model
Data Model
Data structures
Spatial Data
Diagram
Data Modeling
Spatial Modeling
Spatial Database
Geographic Information Systems
Query languages
Spatial Model
Query Language
Grammar
Indexing
Geographic information systems
Tables
Relationships
Operator

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

Spatial pictogram enhanced conceptual data models and their translation to logical data models. / Shekhar, Shashi; Vatsavai, Ranga Raju; Chawla, Sanjay; Burk, Thomas E.

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 1737 Springer Verlag, 1999. p. 77-104 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 1737).

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

Shekhar, S, Vatsavai, RR, Chawla, S & Burk, TE 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, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), vol. 1737, Springer Verlag, pp. 77-104, International Workshop on Integrated Spatial Databases: Digital Images and GIS, ISD 1999, Portland, United States, 14/6/99. https://doi.org/10.1007/3-540-46621-5_6
Shekhar S, Vatsavai RR, Chawla S, Burk TE. 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. Springer Verlag. 1999. p. 77-104. (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)). https://doi.org/10.1007/3-540-46621-5_6
Shekhar, Shashi ; Vatsavai, Ranga Raju ; Chawla, Sanjay ; Burk, Thomas E. / Spatial pictogram enhanced conceptual data models and their translation to logical data models. Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 1737 Springer Verlag, 1999. pp. 77-104 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).
@inproceedings{16661a72dc2843328d13ab36bad95661,
title = "Spatial pictogram enhanced conceptual data models and their translation to logical data models",
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.",
keywords = "Entity-relationship diagrams, OGIS, Pictograms, Spatial databases, SQL3, Syntax directed translation, UML",
author = "Shashi Shekhar and Vatsavai, {Ranga Raju} and Sanjay Chawla and Burk, {Thomas E.}",
year = "1999",
doi = "10.1007/3-540-46621-5_6",
language = "English",
isbn = "3540669310",
volume = "1737",
series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",
publisher = "Springer Verlag",
pages = "77--104",
booktitle = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",

}

TY - GEN

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

AU - Shekhar, Shashi

AU - Vatsavai, Ranga Raju

AU - Chawla, Sanjay

AU - Burk, Thomas E.

PY - 1999

Y1 - 1999

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

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

KW - Entity-relationship diagrams

KW - OGIS

KW - Pictograms

KW - Spatial databases

KW - SQL3

KW - Syntax directed translation

KW - UML

UR - http://www.scopus.com/inward/record.url?scp=84958974802&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84958974802&partnerID=8YFLogxK

U2 - 10.1007/3-540-46621-5_6

DO - 10.1007/3-540-46621-5_6

M3 - Conference contribution

AN - SCOPUS:84958974802

SN - 3540669310

SN - 9783540669319

VL - 1737

T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

SP - 77

EP - 104

BT - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

PB - Springer Verlag

ER -