Storing and querying GML in object-relational databases

  • Authors:
  • Fubao Zhu;Jihong Guan;Jiaogen Zhou;Shuigeng Zhou

  • Affiliations:
  • Wuhan University, Wuhan, China;Tongji University, Shanghai, China;Wuhan University, Wuhan, China;Fudan University, Shanghai, China

  • Venue:
  • GIS '06 Proceedings of the 14th annual ACM international symposium on Advances in geographic information systems
  • Year:
  • 2006

Quantified Score

Hi-index 0.00

Visualization

Abstract

GML 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.