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: [email protected] 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 <[email protected]> Organization: Geomatys Reply-To: "[email protected]" <[email protected]> Date: Wednesday, November 18, 2015 at 6:30 AM To: "[email protected]" <[email protected]> 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 > >
