[udig-devel] Re: UDig and Java feature datafiles (H2 datastore)

[Andrea Aime]

Chris Holmes ha scritto:

> I don't think it should be too bad.  Justin started an H2 datastore, 
> see: http://svn.geotools.org/geotools/trunk/gt/modules/unsupported/h2/
> 
> I believe it's working, but not entirely done.  He can go in to the 
> details of what's needed.
> 
> The only major thing lacking is a spatial index for H2.  That's the only 
> unknown quantity.  I wrote out what it may involve and links to relevant 
> resources at http://docs.codehaus.org/display/GEOS/H2+Spatial+Index  The 
> most interesting is this thread in H2 awhile ago: 
> http://h2database.com/ipowerb/index.php?showtopic=212
> 
> I wouldn't think it would take more than three or four weeks, since most 
> all the pieces are there.  But I could be wrong, as there are unknown 
> qualities, and a lot of pieces to fit together.

Just adding my 2 cents:
http://www.h2database.com/html/features.html#multi_dimensional

Those multi dim indexes could be used to index 4 columns with the
bbox, if indexing the geometry is not possible (I haven't investigated).

Cheers
Andrea