Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Received-SPF: pass (hermes.apache.org: local policy includes SPF record at
 spf.trusted-forwarder.org)
Message-ID: <4166EC6B.1080804@debrunners.com>
Date: Fri, 08 Oct 2004 12:37:15 -0700
From: Daniel John Debrunner <djd@debrunners.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
 rv:1.4.1) Gecko/20031008
MIME-Version: 1.0
To: derby-dev <derby-dev@db.apache.org>
CC: Eric@barrodale.com
Subject: Re: GiST indexes anyone?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> From: Eric Davies <Eric@barrodale.com>

> Barrodale Computing Services are rather excited by the  open sourcing of
> Cloudscape (Derby).
> Specifically, we are interested in exploiting/augmenting Cloudscape's
> spatial capabilities. We have implemented spatial datatypes and
indexes for
> the Informix and postgreSQL in the past. But if we understand correctly,
> Cloudscape does not currently support spatial types nor indexing
strategies.
> Certainly nothing on the features page suggests this.
>
> That being said, we heard rumours of a GiST "experiment" underway in
> Cloudscape.  If the GiST code could be made available, this would greatly
> facilitate the development, ultimately, of spatial indexes, including but
> not necessarily limited to R-tree indexes.  With a proper spatial index,
> Cloudscape could be applied to a much more interesting set of problems,
> particularly in areas related to GIS.

Yes, some prototype GiST code exists for Derby/Cloudscape. The access
layer of the Derby store does support pluggable indexing, at the code
level. The GiST code is at this level, I think it was only ever used at
that level, with some unit tests. That is it was not exposed up to the
SQL layer in any way. The code may prove to be useful or it may just be
an example for starting afresh. I will work on getting it out of IBM and
onto the Derby site.

I do think standard spatial data support for Derby is an excellent goal,
following the SQL/MM and/or OGC standards.

Dan.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFBZuxrIv0S4qsbfuQRAk60AKCLJJrHZGB7VYc2EZwYMb31OjL+HQCgjdhx
S5pQtvcAd/Bs+Z6EOh3OGRY=
=7m1a
-----END PGP SIGNATURE-----