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.
CITATION STYLE
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). Springer Verlag. https://doi.org/10.1007/3-540-46621-5_6
Mendeley helps you to discover research relevant for your work.