Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 50574 invoked from network); 3 Sep 2004 18:32:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 3 Sep 2004 18:32:50 -0000 Received: (qmail 7770 invoked by uid 500); 3 Sep 2004 18:32:50 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 7712 invoked by uid 500); 3 Sep 2004 18:32:49 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: List-Id: "Derby Discussion" Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 7692 invoked by uid 99); 3 Sep 2004 18:32:49 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from [142.104.12.69] (HELO marilyn.barrodale.com) (142.104.12.69) by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 03 Sep 2004 11:32:48 -0700 Received: from daisy.barrodale.com (daisy.barrodale.com [142.104.250.2]) by marilyn.barrodale.com (8.11.6/8.11.6) with ESMTP id i83I4ZT11309; Fri, 3 Sep 2004 11:04:35 -0700 Message-Id: <6.1.0.6.0.20040903104946.09275078@marilyn.barrodale.com> X-Sender: Eric@marilyn.barrodale.com X-Mailer: QUALCOMM Windows Eudora Version 6.1.0.6 Date: Fri, 03 Sep 2004 11:28:01 -0700 To: derby-user@db.apache.org From: Eric Davies Subject: GiST indexes anyone? Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N 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.