PostgreSQL PostGis vs' XQuery GeoExtensions

1
PostgreSQL PostGisvs.XQuery Geo-Extensions

• Jashing_at_iis2006/05/05

2
PostgreSQL PostGis previous work

• http//tsm.iis.sinica.edu.tw/jashing/w3p/maps.php

3
XQuery Geo-Extensions

• http//tsm.iis.sinica.edu.tw/jashing/w3p/gmlsvg/m
  aps.php

This does not work IF the GML doc. is huge (over
200MB) in size. (see http//www.iis.sincia.edu.tw
/jashing/prefiltering/)
4
XQuery Geo-Extensions XML Prefiltering
Geo-Plugin

• No prototype yet

5

• PostgreSQL PostGis Storage Indexing
  Query GeoOPs
• Storage Indexing Query GeoOPs GML XML
  Prefiltering Geo-Plugin XQuery
  Geo-Extensions

6
Performance Analysis

• Working on
• Transforming DXF into GML (my junior classmate)
• Some experiments have been done (see
  http//www.iis.sincia.edu.tw/jashing/prefiltering
  /)
• Experiment design
• Running time comparison among above approaches

7
Issues

• How do we benefit from adopting GML data model?
• proposing novel query models that take account of
  feature classes?
• proposing new functions (GeoOps) for our
  GML-based online GIS?
• or just for fun?
• Does this work contribute to W3P?
• Performance issues