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
