Research On Spatial Database Modeling Methodology Based On UML And Oracle DBMS

As information technology is continuously applied to fields of the transportation, electric power, public security, military, aviation, urban planning, logistics and many other fields related to spatial information, issues like spatial data storage, manage-ment, analysis, etc. need to be resolved. Because of the characteristics of spatial data, such as location, unstructured, multi-representation, spatial relations and so on, the conceptual data model for general applications (such as ER model, EER model, etc.) couldn't satisfy the requirement of conceptual modeling of spatial application systems. In the spatial data modeling aspect, domestic and foreign experts and scholars had proposed a number of spatial conceptual models and their modeling methodologies.Based on analysis and research of the conceptual models and their modeling methodologies which proposed by domestic and foreign experts and scholars, a new spatial conceptual model SUML (Spatial Unified Modeling Language) and its modeling methodology is proposed in this thesis. SUML model defines three modeling dimensions:structural modeling, spatial modeling and multi-representation modeling-in a way that purposely makes the modeling dimensions orthogonal to each other, that is, modeling in one dimension will not effect modeling behavior of another dimension. Structural modeling mainly provides modeling elements and methodology for general data, including modeling for classes, attributes and relationships. Spatial modeling mainly provides modeling elements and methodology for spatial data, including modeling for spatial classes, spatial attributes, spatial relationships and spatial manipulations. Multi-representation modeling mainly provides modeling for multiple representations of objects and spatial relationships.After SUML model was proposed, a modeling tool for SUML model is also implemented in the thesis. Because of the strong modeling capability and extensible mechanism of PowerDesigner modeling tool, which could provide a good support for general data modeling, so based on the functions for PowerDesigner, it could be extended for supporting the modeling elements and its methodology of SUML model through its extensible mechanism. In order to satisfy the requirements of practical applications, the rules of mapping the elements of SUML model to the elements of ORDB model are introduced, and the algorithm of transforming SUML model to ORDB model is also described. Conceptual schema of spatial application fields can be modeled by the extended PowerDesigner modeling tool which also can transform this conceptual schema to physical schema of Oracle 11 g database.