db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Todd Williams <twilliams...@yahoo.com>
Subject Re: Derby GiST Indexing
Date Thu, 10 Nov 2005 01:58:16 GMT

What lead me down this path was an email I found this
in the October 2004 mail archives for derby-dev.  See

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
> Certainly nothing on the features page suggests
> 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.


Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla -



    * Unnamed text/plain

--- Rick Hillegas <Richard.Hillegas@Sun.COM> wrote:

> Hi Todd,
> I'm not aware of anything in the current Derby
> engine which supports 
> Postgres-GiST plugins. The current engine does not
> support user-created 
> indexing schemes. Do you have any more information
> about who may have 
> been working on this?
> Thanks,
> -Rick
> Todd Williams wrote:
> >I heard that someone managed to write a GiST
> >implementation for Derby but have not been able to
> >find any information out about it.  I am
> particularly
> >interested in the 'pluggable' indexing API of Derby
> >and any examples (like the GiST implementation) of
> >someone using it.  What I want to do is use the
> >Derby-GiST project or something similiar to show me
> >how I can plug in my own indexing algorithm to
> Derby,
> >
> >Thanks in advance,
> >-Todd 
> >
> >
> >-Todd Williams
> >
> >"Any sufficiently advanced [software] bug is
> indistinguishable from a feature." - Kulawiec, Rich
> >
> >
> >		
> >__________________________________ 
> >Yahoo! FareChase: Search multiple travel sites in
> one click.
> >http://farechase.yahoo.com
> >  
> >

-Todd Williams

"Any sufficiently advanced [software] bug is indistinguishable from a feature." - Kulawiec,

Yahoo! Mail - PC Magazine Editors' Choice 2005 

View raw message