Methodical Spatial Database Design with Topological Polygon Structures

Spatial databases form the foundation for a Spatial Data Infrastructure SDI. For this, a spatial database should be methodically developed to accommodate its role in SDI. It is desirable to have an approach to spatial database development that considers maintenance from the early stage of database design and in a flexible way. Moreover, there is a lack of a mechanism to capture topological relations of spatial objects during the design process. This paper presents an approach that integrates maintenance of topological integrity constraints into the whole spatial database development cycle. The approach is based on the concept of Abstract Data Types. A number of topological classes have been identified and modelling primitives developed for them. Topological integrity constraints are embedded into maintenance functions associated with the topological classes. A semi-automatic transformation process has been developed following the principles of Model Driven Architecture to simplify the design process.

[1]  Shashi Shekhar,et al.  Spatial Pictogram Enhanced Conceptual Data Models and Their Translation to Logical Data Models , 1999, Integrated Spatial Databases.

[2]  Henderik Alex Proper,et al.  Database Schema Transformation and Optimization , 1995, OOER.

[3]  Esperanza Marcos,et al.  A methodological approach for object-relational database design using UML , 2004, Informatik Forschung und Entwicklung.

[4]  Bin Zhou,et al.  Changing Retail Banking Supply-Demand Mismatch: A Tale of Two States , 2010, Int. J. Appl. Geospat. Res..

[5]  Giuseppe Pelagatti,et al.  GeoUML: a Geographic Conceptual Model defined through specialization of ISO TC 211 standards , 2004 .

[6]  Jim Arlow,et al.  Uml and the Unified Process: Practical Object-Oriented Analysis and Design , 2005 .

[7]  Michael R. Blaha,et al.  Object-Oriented Modeling and Design for Database Applications , 1997 .

[8]  Scott W. Ambler.  The Object Primer , 1995 .

[9]  Suzana Dragicevic,et al.  Collaborative Geographic Information Systems , 2017, Encyclopedia of GIS.

[10]  Ivar Jacobson,et al.  The unified modeling language reference manual , 2010 .

[11]  François Pinet,et al.  Using UML and OCL to maintain the consistency of spatial data in environmental information systems , 2007, Environ. Model. Softw..

[12]  Erik G. Hoel,et al.  Building a Robust Relational Implementation of Topology , 2003, SSTD.

[13]  Anneke Kleppe,et al.  The Object Constraint Language: Getting Your Models Ready for MDA , 2003 .

[14]  J. Van Bennekom-Minnema.  The Land Administration Domain Model 'Survey Package' and Model Driven Architecture , 2008 .

[15]  MAX J. EGENHOFER,et al.  Point Set Topological Relations , 1991, Int. J. Geogr. Inf. Sci..

[16]  Michael Batty,et al.  Advanced Spatial Analysis , 2003 .

[17]  Keith Ryden,et al.  OpenGIS ® Implementation Specification for Geographic information - Simple feature access - Part 1:Common architecture , 2005 .

[18]  Wai Yin Mok,et al.  On transformations from UML models to object-relational databases , 2001, Proceedings of the 34th Annual Hawaii International Conference on System Sciences.

[19]  Shashi Shekhar,et al.  Spatial Databases - Accomplishments and Research Needs , 1999, IEEE Trans. Knowl. Data Eng..

[20]  Timothy L. Nyerges,et al.  Design Considerations for an Internet Portal to Support Public Participation in Transportation Improvement Decision Making , 2006 .

[21]  Max J. Egenhofer,et al.  A Formal Definition of Binary Topological Relationships , 1989, FODO.

[22]  Håvard Tveite,et al.  Structural modelling for geographical information systems using icons , 2001, ScanGIS.

[23]  Max J. Egenhofer,et al.  Topological Relations Between Regions with Holes , 1994, Int. J. Geogr. Inf. Sci..

[24]  Stephan Nebiker,et al.  Web-Based Large-Scale 3D-Geovisualisation Using WebGL: The OpenWebGlobe Project , 2012, Int. J. 3 D Inf. Model..

[25]  Agnès Voisard,et al.  Spatial Databases: With Application to GIS , 2001 .

[26]  Wolfgang Reinhardt,et al.  Extending Geographic Data Modeling by Adopting Constraint Decision Table to Specify Spatial Integrity Constraints , 2007, AGILE Conf..

[27]  Ramez Elmasri,et al.  Fundamentals of Database Systems , 1989 .

[28]  Eliseo Clementini,et al.  A Model for Representing Topological Relationships between Complex Geometric Features in Spatial Databases , 1996, Inf. Sci..

[29]  Michael Leitner,et al.  Geographic Information Systems and Public Health: Eliminating Perinatal Disparity , 2005 .

[30]  Gabriel M. Kuper,et al.  Geographic Information Systems , 2000, Constraint Databases.

[31]  Ayça Cangel,et al.  Urban Geospatial Management System , 2013 .

[32]  Jayant Sharma,et al.  Modeling Topological Spatial Relations: Strategies for Query Processing , 1998 .

[33]  Thomas Behr,et al.  Topological relationships between complex spatial objects , 2006, TODS.

[34]  Paul C. Smits,et al.  ISO/TC211: Standardisation of geographic information and geo-informatics , 2002, IEEE International Geoscience and Remote Sensing Symposium.

[35]  David M. Theobald,et al.  Topology revisited: representing spatial relations , 2001, Int. J. Geogr. Inf. Sci..

[36]  David J. Maguire,et al.  Object-oriented data modelling for spatial databases , 1990, Int. J. Geogr. Inf. Sci..

[37]  Shyamanta M. Hazarika,et al.  Qualitative Spatio-Temporal Representation and Reasoning: Trends and Future Directions , 2012 .

[38]  Joaquin Miller,et al.  MDA Guide Version 1.0.1 , 2003 .

[39]  Mirina Grosz,et al.  World Wide Web Consortium , 2010 .

[40]  Nell Dale,et al.  Abstract data types: Specifications, implementations, and applications , 1996 .

[41]  Kevin Loney,et al.  Oracle Database 10g The Complete Reference , 2004 .

[42]  E. Heller.  An international journal. , 1968, Canadian Medical Association journal.