You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sis.apache.org by "Mattmann, Chris A (3980)" <ch...@jpl.nasa.gov> on 2015/11/18 01:54:43 UTC
status of ISO 13249
Hey Martin, and Team,
What’s the status of ISO 13249 in SIS? SQL spatial seems very
related to our recent talks about Big Data, etc.
Cheers,
Chris
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Chris Mattmann, Ph.D.
Chief Architect
Instrument Software and Science Data Systems Section (398)
NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA
Office: 168-519, Mailstop: 168-527
Email: chris.a.mattmann@nasa.gov
WWW: http://sunset.usc.edu/~mattmann/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Adjunct Associate Professor, Computer Science Department
University of Southern California, Los Angeles, CA 90089 USA
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Re: status of ISO 13249
Posted by "Mattmann, Chris A (3980)" <ch...@jpl.nasa.gov>.
makes total sense to me thanks Martin
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Chris Mattmann, Ph.D.
Chief Architect
Instrument Software and Science Data Systems Section (398)
NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA
Office: 168-519, Mailstop: 168-527
Email: chris.a.mattmann@nasa.gov
WWW: http://sunset.usc.edu/~mattmann/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Adjunct Associate Professor, Computer Science Department
University of Southern California, Los Angeles, CA 90089 USA
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-----Original Message-----
From: Martin Desruisseaux <ma...@geomatys.com>
Organization: Geomatys
Reply-To: "dev@sis.apache.org" <de...@sis.apache.org>
Date: Wednesday, November 18, 2015 at 6:30 AM
To: "dev@sis.apache.org" <de...@sis.apache.org>
Subject: Re: status of ISO 13249
>Hello Chris
>
>Le 18/11/15 01:54, Mattmann, Chris A (3980) a écrit :
>> What’s the status of ISO 13249 in SIS? SQL spatial seems very
>> related to our recent talks about Big Data, etc.
>
>There is nothing in SIS yet, but I think that Johann explored SQL
>spatial. He is not here today, but I will ask him tomorrow.
>
>My proposal for supporting SQL spatial in SIS would be to first make
>sure that the org.apache.sis.storage.DataStore abstract class provides
>API for functions that we would like to support (current DataStore
>abstract class still an early draft), then - in a separated module -
>provide a SQL parser which will translate the SQL statements into calls
>to the appropriate DataStore methods. That SQL parser should work with
>arbitrary DataStore. We could also use Apache Calcite for freeing us
>from the task of parsing SQL syntax, and maybe use also Apache Drill on
>top of the above.
>
>A possible action plan could be (if Marc agree):
>
> 1. Create a new module (maybe "sis-sql"?)
> 2. Either:
> * Move the JDBC-related classes currently in sis-shapefile to that
> new sis-sql module.
> * or start from scratch new code on top of Apache Calcite in that
> sis-sql module.
> 3. Refactor sis-shapefile to extend org.apache.sis.storage.DataStore
> 4. In sis-sql, replace some calls to Shapefile-specific API by
> DataStore API. We will not replace all method calls now. The
> proposal is just start what we can for now - it may take many months
> before DataStore provides all the API needed.
>
>Martin
>
>
Re: status of ISO 13249
Posted by Martin Desruisseaux <ma...@geomatys.com>.
Hello Chris
Le 18/11/15 01:54, Mattmann, Chris A (3980) a écrit :
> What’s the status of ISO 13249 in SIS? SQL spatial seems very
> related to our recent talks about Big Data, etc.
There is nothing in SIS yet, but I think that Johann explored SQL
spatial. He is not here today, but I will ask him tomorrow.
My proposal for supporting SQL spatial in SIS would be to first make
sure that the org.apache.sis.storage.DataStore abstract class provides
API for functions that we would like to support (current DataStore
abstract class still an early draft), then - in a separated module -
provide a SQL parser which will translate the SQL statements into calls
to the appropriate DataStore methods. That SQL parser should work with
arbitrary DataStore. We could also use Apache Calcite for freeing us
from the task of parsing SQL syntax, and maybe use also Apache Drill on
top of the above.
A possible action plan could be (if Marc agree):
1. Create a new module (maybe "sis-sql"?)
2. Either:
* Move the JDBC-related classes currently in sis-shapefile to that
new sis-sql module.
* or start from scratch new code on top of Apache Calcite in that
sis-sql module.
3. Refactor sis-shapefile to extend org.apache.sis.storage.DataStore
4. In sis-sql, replace some calls to Shapefile-specific API by
DataStore API. We will not replace all method calls now. The
proposal is just start what we can for now - it may take many months
before DataStore provides all the API needed.
Martin