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

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

doi:10.1007/3-540-46621-5_6

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 proceeding › Conference contribution

14 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 language	English (US)
Title of host publication	Integrated Spatial Databases
Subtitle of host publication	Digital Images and GIS - International Workshop ISD 1999, Selected Papers
Editors	Peggy Agouris, Anthony Stefanidis
Publisher	Springer Verlag
Pages	77-104
Number of pages	28
ISBN (Print)	3540669310, 9783540669319
DOIs	https://doi.org/10.1007/3-540-46621-5_6
State	Published - 1999
Event	International Workshop on Integrated Spatial Databases: Digital Images and GIS, ISD 1999 - Portland, United States Duration: Jun 14 1999 → Jun 16 1999

Publication series

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

Other

Other	International Workshop on Integrated Spatial Databases: Digital Images and GIS, ISD 1999
Country/Territory	United States
City	Portland
Period	6/14/99 → 6/16/99

Bibliographical note

Publisher Copyright:
© Springer-Verlag Berlin Heidelberg 1999.

Keywords

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

Publisher link

10.1007/3-540-46621-5_6

Find It

Find It at U of M Libraries

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

Spatial pictogram enhanced conceptual data models and their translation to logical data models. / Shekhar, Shashi; Vatsavai, Ranga Raju; Chawla, Sanjay et al.
Integrated Spatial Databases: Digital Images and GIS - International Workshop ISD 1999, Selected Papers. ed. / Peggy Agouris; Anthony Stefanidis. 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 proceeding › Conference contribution

Shekhar, S, Vatsavai, RR, 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. 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, 6/14/99. https://doi.org/10.1007/3-540-46621-5_6

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

Shekhar, Shashi ; Vatsavai, Ranga Raju ; Chawla, Sanjay et al. / Spatial pictogram enhanced conceptual data models and their translation to logical data models. Integrated Spatial Databases: Digital Images and GIS - International Workshop ISD 1999, Selected Papers. editor / Peggy Agouris ; Anthony Stefanidis. Springer Verlag, 1999. pp. 77-104 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).

@inproceedings{a6cb4b21ae8a4610a78439c438d24b62,

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, SQL3, Spatial databases, Syntax directed translation, UML",

author = "Shashi Shekhar and Vatsavai, {Ranga Raju} and Sanjay Chawla and Tom Burk",

note = "Publisher Copyright: {\textcopyright} Springer-Verlag Berlin Heidelberg 1999.; International Workshop on Integrated Spatial Databases: Digital Images and GIS, ISD 1999 ; Conference date: 14-06-1999 Through 16-06-1999",

year = "1999",

doi = "10.1007/3-540-46621-5_6",

language = "English (US)",

isbn = "3540669310",

series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",

publisher = "Springer Verlag",

pages = "77--104",

editor = "Peggy Agouris and Anthony Stefanidis",

booktitle = "Integrated Spatial Databases",

}

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, Tom

N1 - Publisher Copyright: © Springer-Verlag Berlin Heidelberg 1999.

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 - SQL3

KW - Spatial databases

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

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

SP - 77

EP - 104

BT - Integrated Spatial Databases

A2 - Agouris, Peggy

A2 - Stefanidis, Anthony

PB - Springer Verlag

T2 - International Workshop on Integrated Spatial Databases: Digital Images and GIS, ISD 1999

Y2 - 14 June 1999 through 16 June 1999

ER -

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

Abstract

Publication series

Other

Bibliographical note

Keywords

Publisher link

Find It

Other files and links

Fingerprint

Cite this