Storing and querying GML in object-relational databases.

Fubao Zhu,Jihong Guan,Jiaogen Zhou,Shuigeng Zhou

DOI: https://doi.org/10.1145/1183471.1183490

2006-01-01

Abstract:ABSTRACTGML has become the de facto standard for electronic spatial data exchange among the applications of Web and distributed geographic information systems (GISs). As more and more geographical data is presented in GML, it is necessary to develop techniques for managing GML documents in databases. A possible solution is to store GML data into object-relational databases from which the users can retrieve the interested data. In this paper, we propose an approach to map GML schema to object-relational database schema by using GML schema graph, and algorithms for storing / querying valid GML documents into / from the relations generated by the corresponding object-relational schema. Spatial and non-spatial features embedded in GML document are stored in object-oriented relations, and the structures and constrains defined in GML schema are also well preserved. A prototype for GML documents storing and querying based on the proposed method is implemented on the basis of the Oracle/Spatial system. Preliminary experiment results shows that our method is feasible and efficient.