Lindorm:Overview

GanosBase SQL

GanosBase SQL exposes spatio-temporal capabilities through standard SQL, covering the data processing features of GeoMesa, MongoDB, and Redis in a single interface.

Spatial data types

Points, LineStrings, and polygons — standard OGC geometry objects. See Spatial data types.

SQL syntax

Use standard DDL and DML statements to work with spatio-temporal tables:

• Create a table: CREATE TABLE

• Insert or update data: UPSERT

• Query data: SELECT

For the full syntax reference, see DDL and DML.

Spatio-temporal functions

GanosBase SQL includes PostGIS-compatible functions across four categories:

For the full function reference, see Overview.

Spatio-temporal indexes

GanosBase SQL uses Z-ORDER indexes, which encode spatial or spatio-temporal coordinates as a one-dimensional key. This supports efficient range scans on spatial-only or spatial + time conditions without storing a redundant data replica.

Use a primary key index when the primary lookup pattern is spatial or spatio-temporal:

-- Spatial range queries only
CREATE TABLE gtest(id INT, g GEOMETRY(POINT), name VARCHAR, PRIMARY KEY(Z-ORDER(g),id));

-- Spatial and time range queries
CREATE TABLE gtest(id INT, g GEOMETRY(POINT), name VARCHAR, t LONG, PRIMARY KEY(Z-ORDER(g,t),id));

Use a secondary index to accelerate spatio-temporal queries on non-primary-key columns:

-- Spatial range queries only
CREATE INDEX idx ON gtest (Z-ORDER(g));

-- Spatial and time range queries
CREATE INDEX idx ON gtest (Z-ORDER(g,t));

Secondary indexes in GanosBase SQL eliminate the need for a redundant data replica to support spatio-temporal queries.

Inherited LindormTable features

Because GanosBase is built on LindormTable, GanosBase SQL tables also support cold storage, hot and cold data separation, and dynamic columns. See Developer Guide for details.

GanosBase GeoMesa

GanosBase GeoMesa is a drop-in backend for applications built on open source GeoMesa or GeoServer. It inherits the full GeoMesa feature set and is compatible with GeoTools APIs and ECQL, so you can migrate existing GeoMesa applications to a distributed, scalable backend.

GanosBase for streaming engines

GanosBase for streaming engines adds spatio-temporal capabilities to Apache Flink through standard Flink SQL. It is designed for migrating Flink or Spark streaming pipelines that process location or trajectory data.

Key capabilities:

• All standard Apache Flink streaming computing features

• A large library of PostGIS-compatible spatio-temporal functions

• Trajectory data calculation functions

• Real-time geofence filtering and trajectory aggregation

• In-memory indexes and parallel queries for low-latency performance