This topic provides a summary of the key features and best practices for GanosBase.
Category | Article | Description |
Basic Capability | Best practices for the polymorphic tiered storage feature provided by GanosBase | This polymorphic tiered storage feature integrates Object Storage Service (OSS) and materialized cache technologies. It ensures transparent SQL operations, including insert, delete, update, and query, while potentially reducing storage costs by up to 90%. |
Geometry | Best practices for GanosBase real-time heatmap aggregation queries | Aggregates tens of millions to hundreds of millions of vector objects in seconds. This provides the ability of generating trajectory heatmaps in real-time with dynamic filter conditions. |
Raster | Best practices for importing vector and raster data to GanosBase | Facilitates rapid import of raster vector data on OSS into databases by using FDW. |
Retrieves the spatial and value properties of raster pixels, enabling unified analysis of vector and raster data. | ||
Trajectory | Common GanosBase methods for processing trajectory sampling points | Efficiently processes trajectory data with methods such as denoising, segmentation, resampling, and simplification. |
Graph | Graph analysis based on PolarDB: Quick data import from tables to graphs | Leverages the graph database extension to import hundreds of millions of nodes and edges into a graph database. This helps avoid the query performance issue during edge insertion. |
Creates a Data Transmission Service (DTS) task to transfer data from an external database to a PolarDB for PostgreSQL graph database in real-time. | ||
Leverages graph database capabilities for advanced graph query and analysis. | ||
Grid | GanosBase H3 geospatial grid capabilities and best practices | Leverages Ganos GeomGrid to accelerate aggregate calculation. |
GeoSOT geographic grid model based on GanosBase: UAV path planning | Leverages a path planning algorithm based on Ganos GeomGrid for scenarios such as UAV routing. |