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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Yavan Bedard. Visual modeling of spatial databases: Towards spatial pvl and uml. GeoInformatica, June, 1999.
G. Booch. Object Oriented Analysis and Design. Benjamin Cummins, 1992.
G. Booch, J. Rumbaugh, and I. Jacobson. The Unified Modeling Language User Guide. Object Technology Series, Addison-Wesley, 1999.
P.P.S. Chen. The entity-relationship model ― towards a unified view of data. ACM Trans. Database Systems, 1(1):9–36, 1976.
Open GIS Consortium. Opengis simple features specification for sql,. URL: http://www.opengis.org/public/abstract.html, 1998.
Oracle Corporation. Oracle spatial. URL: http://www.oracle.com/database/options/spatial/index.html, 1999.
Helen Couclelis. People manipulate objects (but cultivate fields): Beyond the raster-vector debate in gis. In Theories and Methods of Spatio-Temporal Reasoning in Geographic Space, volume 639. Springer-Verlag, LNCS, 1992.
O. Cunther and W. Riekert. The design of godot: An object-oriented geographical information system. IEEE Data Engineering Bulletin, 16(3), 1993.
Vassilis Delis, Thanasis Hadzilacos, and Nectaria Tryfona. An introduction to layer algebra. In Advances in GIS Research: Proceedings of the sixth International Symposium on Spatial Data Handling. Taylor and Francis, 1994.
D.J. Dewitt, N. Karba, J. Luo, and J.M. Patel. Client server paradise. In In Proceedings of the 20th Int. Conference on Very Large Databases, 1994.
R. Elmasiri and S.B. Navathe. Fundamentals of Database Systems. Benjamin/Cummins, 1994.
ESRI. Spatial database engine. http://www.esri.com/base/products/sde/sde.htm.
R.H. Guting. An introduction to spatial database systems. VLDB J., Special issue on Spatial Database Systems, 3(4):357–399, 1993.
R.H. Guting. Graphdb: Modeling and querying graphs in databases. In In Proceedings of the Int. Conference on Very Large Databases, 1994.
Thanasis Hadzilacos and Nactaria Tryfona. A model for expressing topological integrity constraints in geographic databases. In Theories and Methods of Spatio-Temporal Reasoning in Geographic Space, volume 639. Springer-Verlag, LNCS, 1992.
Thanasis Hadzilacos and Nactaria Tryfona. An extended entity-relationship model for geographic applications. ACM SIGMOD Record, 26(3), 1997.
J.R. Herring. Tigris: A data model for an object-oriented geographic information system. Computers and Geosciences, 18(4):443-, 1992.
Levine John R, Tony Mason, and Doug Brown. Lex and Yacc. O’Reilly And Associates, 1992.
G. Kosters, B. Pagel, and H.W. Six. Object-oriented requirements engineering for gis applications. In In Proceedings of the ACM Intl. Conference on Geographical Information Systems, 1995.
N. Adam and A. Gangopadhyay. Database issues in Geographical Information Systems. Kluwer Academics, 1997.
S.B. Navathe. Evolution of data modeling for databases. Commun. ACM, 9(35):112–123, 1992.
J. Rumbaugh, W. Blaha, and Premerlani. Object Oriented Modeling and Design. Prentice Hall, 1991.
S. Shekhar, S. Chawla, S. Ravada, A. Fetterer, X. Liu, and C. t. Lu. Spatial databases-accomplishments and research needs. IEEE Trans. Knowledge and Data Eng.,, 11(1), 1999.
S. Shekhar and S. Chawla. Spatial databases: Concepts, implementaton and trends. Prentice Hall, 2000 (Expected).
S. Shekhar, M. Coyle, D.-R. Liu, B. Goyal, and S. Sarkar. Data models in geographic information systems. Commun. ACM, 40(4):103–111, 1997.
N. Tryfona and T. Hadzilacos. Geographic applications development: Models and tools for the conceptual level. In In Proceedings of the ACM Intl. Conference on Geographical Information Systems, 1995.
Jeffrey D. Ullman and Jennifer Widom. A First Course in Database Systems. Prentice Hall, 1997.
M.F. Worboys. Object-oriented approaches to geo-referenced information. Intl. Journal of Geographical Information Systems, 8(4), 1994.
M.F. Worboys, H.M. Hearnshaw, and D. Maguire. Object-oriented data modeling for spatial databases. Intl. Journal of Geographical Information Systems, 4:369–383, 1990.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1999 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Shekhar, S., Raju Vatsavai, R., Chawla, S., Burk, T.E. (1999). Spatial Pictogram Enhanced Conceptual Data Models and Their Translation to Logical Data Models. In: Agouris, P., Stefanidis, A. (eds) Integrated Spatial Databases. ISD 1999. Lecture Notes in Computer Science, vol 1737. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-46621-5_6
Download citation
DOI: https://doi.org/10.1007/3-540-46621-5_6
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-66931-9
Online ISBN: 978-3-540-46621-5
eBook Packages: Springer Book Archive