Lindorm Ganos is a native extension of the Lindorm wide table engine (LindormTable). By using Lindorm Ganos, you can efficiently store, query, and analyze spatio-temporal data based on Lindorm wide tables. This topic describes Lindorm Ganos provided by LindormTable
Background information
Large amounts of spatio-temporal trajectory data is generated in various scenarios, such as travelling, Internet of Vehicles (IoV), Internet of Things (IoT), autonomous driving, logistics, and the geographic information system (GIS). Users need to use the spatio-temporal trajectory data to query spatio-temporal ranges, determine geofences, or perform data mining. For example, users can use spatio-temporal trajectory data to query the vehicles that have passed through an area within a specified period of time, monitor whether a vehicle deviates from the planned route in real time, or query all vehicles that are 500 meters around the current location.
Lindorm Ganos acts the similar role as the PostGIS extender in PostgreSQL and the geographic range query feature in MongoDB. Lindorm Ganos supports standard geometry objects and provides spatio-temporal indexes for efficient queries on spatio-temporal data. In addition, Lindorm Ganos can provide high throughput and scalability with low storage costs. Therefore, Lindorm Ganos is a cost-effective solution for you to process spatio-temporal trajectory data.
Supported interfaces
Category | Lindorm Ganos SQL | Lindorm Ganos GeoMesa |
---|---|---|
Supported interfaces | Standard SQL interfaces | GeoTools APIs or ECQL interfaces |
Features |
| Inherits the features of open source GeoMesa. |
Performance | Lindorm Ganos SQL is superior to open source GeoMesa in performance because Lindorm Ganos SQL adopts a variety of technologies such as query rewrite, parallel queries, shards, and optimized spatial approximation algorithms. | Lindorm Ganos GeoMesa is superior to open source GeoMesa and HBase in performance. |
Orientation | Lindorm Ganos SQL is applicable to applications that use SQL interfaces such as PostGIS or the spatial-temporal features of GeoMesa, MongoDB, and Redis. | Lindorm Ganos GeoMesa is applicable to applications that use open source GeoMesa. |
Lindorm Ganos SQL
Features
Feature | Description |
---|---|
Standard spatial data types such as points, line strings, and polygons | Lindorm Ganos SQL supports point, LineString, and polygon objects. For more information, see Spatial data types. |
Standard SQL syntax |
For more information about the SQL syntax supported by Lindorm Ganos SQL, see DDL and DML. |
Common spatio-temporal functions |
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.
|
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.
Note You do not need to create a redundant replica for spatio-temporal data because Lindorm Ganos SQL supports spatio-temporal secondary indexes. |
Features provided by LindormTable |
For more information about the features provided by LindormTable, see Developer Guide. |
Scenarios
Scenario | Example |
---|---|
The storage and query of trajectory data |
|
Real-time geofencing |
|
Location-based services | Search for the information about restaurants five kilometers around the current location. |
Lindorm Ganos GeoMesa
Lindorm Ganos GeoMesa is compatible with open source ecosystems such as GeoMesa and GeoServer and can be used to store, query, analyze, and mine spatial or spatio-temporal data. For more information, see Overview