Lindorm:Overview

Category

SQL interfaces

GeoMesa interfaces

Streaming engine interfaces

Supported interfaces

Standard SQL interfaces

GeoTools APIs or ECQL interfaces

Standard Flink SQL interfaces

Features

• Provides the spatio-temporal data processing features of GeoMesa, MongoDB, and Redis.

• Provides functions that are compatible with PostGIS.

• Provides functions used to calculate trajectory data.

Inherits the features of open source GeoMesa.

• Provides all streaming computing features of Apache Flink.

• Provides a large number of PostGIS-compatible spatio-temporal functions.

• Provides functions used to calculate trajectory data.

• Supports real-time geofence filtering and trajectory aggregation.

Performance

Lindorm GanosBase SQL is superior to open source GeoMesa in performance because Lindorm GanosBase SQL adopts a variety of technologies such as query rewrite, parallel queries, shards, and optimized spatial approximation algorithms.

Lindorm GanosBase GeoMesa is superior to open source GeoMesa and HBase in performance.

Lindorm GanosBase for streaming engines offers excellent query performance by providing technologies such as in-memory indexes and parallel queries.

Orientation

Lindorm GanosBase SQL is applicable to applications that use SQL interfaces such as PostGIS or the spatial-temporal features of GeoMesa, MongoDB, and Redis.

Lindorm GanosBase GeoMesa is applicable to applications that use open source GeoMesa.

Lindorm GanosBase for streaming engines is applicable to the migration of spatio-temporal applications that use streaming engines such as Flink and Spark.

Feature

Description

Standard spatial data types such as points, line strings, and polygons

Lindorm GanosBase SQL supports point, LineString, and polygon objects. For more information, see Spatial data types.

Standard SQL syntax

• Syntax used to create a spatio-temporal table: CREATE TABLE.

• Syntax used to insert spatio-temporal data: UPSERT.

• Syntax used to query spatio-temporal data: SELECT.

For more information about the SQL syntax supported by Lindorm GanosBase SQL, see DDL and DML.

Common spatio-temporal functions

• Access functions: ST_X.

• Functions for spatial relationships: ST_Contains and ST_Intersects.

• Data processing functions: ST_Buffer.

• Measurement functions: ST_Length.

For more information about other spatio-temporal functions, see Overview.

Spatio-temporal primary key index

Spatio-temporal primary key indexes can be used to accelerate spatio-temporal queries in which only spatial ranges or spatial and time ranges are specified as conditions.

• Specify only spatial ranges as conditions in a query:

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

• Specify spatial and time ranges as conditions in a query:

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

Spatio-temporal secondary index

Spatio-temporal secondary indexes can be used to accelerate spatio-temporal queries in which only spatial ranges or spatial and time ranges are specified as conditions.

• Specify only spatial ranges as conditions in a query:

  CREATE INDEX idx ON gtest (Z-ORDER(g));

• Specify spatial and time ranges as conditions in a query:

  CREATE INDEX idx ON gtest (Z-ORDER(g,t));

Features provided by LindormTable

• Cold storage

• Hot and cold data separation

• Dynamic columns

For more information about the features provided by LindormTable, see Developer Guide.

Scenario

Example

The storage and query of trajectory data

• Query the trajectory of an object in the specified spatial range within the last 24 hours.

• Compress and store large amounts of historical trajectory data to reduce storage costs.

Geographic grid aggregation

• Aggregate trajectory points and filter queries based on H3 grids and the specified precision.

• Count the number of vehicles in different regions and display the data in heatmaps.

Real-time geofencing

• Monitor whether the location of a vehicle deviates from the specified range and raise alarms in real time.

• Determine prices and services in ride hailing based on the spatial grid to which the boarding location belongs.

Location-based services

Search for the information about restaurants five kilometers around the current location.