This topic describes the release notes of Ganos. Ganos is a spatio-temporal database engine.

Minor version Description
3.2
  • New features:
    • Stream-based images can be returned for new vector pyramids. This accelerates the graphical display of vector data.
    • The JPEG 2000 compression algorithm is introduced. This algorithm is used to compress 16-bit raster data before the data is stored.
    • The ganos_update function is introduced. All the Ganos plug-ins can be upgraded to their latest versions by running the select ganos_update() ; command.
    • The TRAJECTORY data type is introduced:
      • Spatio-temporal indexes that are supported by native Ganos are supported.
      • GiST indexes are supported for trajectories. In addition, six operator families are provided to create GiST indexes in different combinations of dimensions.
      • The BOXND data type is supported. This data type is used to describe the bounding box of a spatio-temporal extent or a storage trajectory.
      • The following new operators are introduced to compare the spatio-temporal relationships between two specified objects from various dimensions: the && operator, the @> operator, and the <@ operator. The && operator is used to check whether the two specified objects intersect. The @> operator is used to check whether the left operand-specified object includes the right operand-specified object. The <@ operator is used to check whether the left operand-specified object is included in the right operand-specified object.
      • The ST_ndIntersects, ST_ndDWithin, ST_ndContains, and ST_ndWithin functions are introduced to process trajectories.
      • New features are introduced to collect statistics of trajectories and to estimate scan costs based on the trajectory statistics.
      • TrajGiST indexes are introduced to provide a better indexing method.
  • Performance optimization:
    • The ST_DWithin function is optimized to query distances at higher performance.
    • The GiST index-based two-phase query optimization method is used to query spatio-temporal extents at higher performance.
    • The mechanism that is used to generate vector pyramids is improved:
      • Source data from all the coordinate systems that provide spatial reference identifiers (SRIDs) is supported. The source data is based on the EPSG:3857 or EPSG:4326 coordinate reference system.
      • The pixelSize parameter is provided to aggregate point data and reduce the number of tiles.
  • Bugs fixed:
    • The bug that causes an improper intersection of trajectories on the t axis is fixed.
    • The bug that causes failures to update rasters in some cases is fixed.
    • The bug that causes binary files to break down is fixed. This error may occur after the binary files are upgraded to later versions.
    • The bug that causes an abnormally large number of tiles at the top layer of a vector pyramid is fixed. This error occurs if the default parameter settings are used to build point data for the vector pyramid.
3.0
  • New features:
    • Network Common Data Form (NetCDF) files that contain subsets are supported. These files can be imported based on specified layer names.
    • The following functions are introduced to query and specify the custom metadata and time series data of a raster file:
      • The ST_MetaItems function is used to query the names of all the custom metadata items of a raster file.
      • The ST_MetaData function is used to query the custom metadata items of a raster file and return JSON-formatted metadata items.
      • The ST_SetMetaData function is used to configure the metadata items of a raster file.
      • The ST_BeginDateTime function is used to query the start time of a raster file.
      • The ST_EndDateTime function is used to obtain the end time of a raster file.
      • The ST_SetBeginDateTime function is used to specify the start time of a raster file.
      • The ST_SetEndDateTime function is used to specify the end time of a raster file.
      • The ST_SetDateTime function is used to specify the start time, end time, and band acquisition time of a raster file.
    • The following functions are introduced to convert a raster into a stream-based image:
      • The ST_AsImage function is used to convert a raster into a stream-based image.
      • The ST_AsPNG function is used to convert a raster into a stream-based image in PNG format.
      • The ST_AsJPEG function is used to convert a raster into a stream-based image in JPEG format.
    • The GEOMGRID data type and the functions that are used to manage this type of data are introduced:
      • The GEOMGRID data type is supported.
      • The ST_AsText function is used to convert data from the GEOMGRID data type into the TEXT data type.
      • The ST_AsGeometry function is used to convert data from the GEOMGRID data type into the GEOMETRY data type.
      • The ST_AsBinary function is used to convert data from the GEOMGRID data type into the BINARY data type.
      • The ST_AsBox function is used to convert data from the GEOMGRID data type into the BOX data type.
      • The ST_AsGrid function is used to convert data from the GEOMETRY data type into the GEOMGRID data type.
      • The ST_GridFromText function is used to convert data from the TEXT data type into the GEOMGRID data type.
      • The ST_GridFromBinary function is used to convert data from the BINARY data type into the GEOMGRID data type.
      • The ST_Intersects function is used to check whether a grid intersects with a geometry.
      • The ST_Contains function is used to check whether a grid includes another grid or a geometry.
      • The ST_Within function is used to check whether a grid is included in another grid or a geometry.
    • The following functions are introduced to support vector pyramids and to display vector pyramids at high speeds:
      • The ST_BuildPyramid function is used to create a vector pyramid.
      • The ST_DeletePyramid function is used to delete a vector pyramid.
      • The ST_Tile function is used to query the tile data of a vector pyramid in MVT format.
  • Bugs fixed:
    • The bug that exhausts memory resources is fixed. This error may occur when you create a pyramid.
    • The bug that prevents Ganos from creating a trajectory point on January 1, 2000 for a moving object is fixed.
    • The bug that causes the ST_Intersection function to return inaccurate sub-trajectories for a moving object in some cases is fixed.
2.9
  • New features:
    • The Cloud Optimized GeoTIFF (COG) format is supported. The pyramid data that is stored in COG files can be read.
    • The ST_AddZ function is introduced to add the z coordinate to a geometry based on the raster pixel value.
    • The following functions are introduced to enhance the capabilities that are used to obtain the spatial extents of rasters based on pyramid layers:
      • The ST_Extent function is used to query the spatial extent of a raster and return a box.
      • The ST_Envelope function is used to query the spatial extent of a raster and return a geometry.
      • The ST_ConvexHull function is used to query the spatial extent of a raster and return a geometry.
      • The ST_Height function is used to query the pixel height of a raster.
      • The ST_Width function is used to query the pixel width of a raster.
      • The ST_XMin function is used to obtain the minimum value of a raster on the x axis.
      • The ST_YMin function is used to obtain the minimum value of a raster on the y axis.
      • The ST_XMax function is used to obtain the maximum value of a raster on the x axis.
      • The ST_YMax function is used to obtain the maximum value of a raster on the y axis.
  • Bugs fixed:
    • The bug that limits the performance of Ganos is fixed. This error occurs if Ganos splits external raster data into chunks by using the 1 × n chunking model. After this bug is fixed, you can customize the size per chunk.
    • The bug that causes the ST_Values function to return linear objects whose coordinates on some axes do not follow the sorting rules is fixed.
    • The bug that causes the ST_BestPyramidLevel function to return negative values in some cases is fixed.
    • The bug that causes the ST_BuildPyramid function to repeatedly build a pyramid in some cases is fixed.
    • The bug that causes failures to clear chunk tables in a timely manner is fixed. This error occurs if you truncate raster tables.
    • The bug that causes failures to call the ST_ExportTo function on the CreateOption property in some cases is fixed.
    • The bug that causes failures to call the ST_ClearChunks function is fixed. This error occurs if the name of the table on which the function is called contains both uppercase and lowercase letters.
    • The bug that causes failures to create an overview for an external pyramid in some cases is fixed.
    • The bug that causes failures to create an internal pyramid for a raster that has an external pyramid is fixed.
    • The bug that causes inaccurate statistics of rasters is fixed. This error occurs if the rasters contain NaN values.
2.8
  • New features:
    • The following functions are introduced to enhance the capabilities that are used to access the metadata of a raster:
      • The ST_XMin function is used to query the minimum value of a raster on the x axis.
      • The ST_YMin function is used to query the minimum value of a raster on the y axis.
      • The ST_XMax function is used to query the maximum value of a raster on the x axis.
      • The ST_YMax function is used to query the maximum value of a raster on the y axis.
      • The ST_ChunkHeight function is used to query the chunk height of a raster.
      • The ST_ChunkWidth function is used to query the chunk width of a raster.
      • The ST_ChunkBands function is used to query the number of bands based on which the data of a raster is split into chunks.
    • The ST_SrFromEsriWkt function is introduced to convert a spatial reference string from the Esri format into the OGC format.
    • The Zstandard (Zstd) and Snappy compression algorithms are introduced to compress raster data.
    • The copy of point cloud files in binary format is supported.
    • The PROJ_LIB and GDAL_DATA environment variables can be configured, and the related data can be deployed.
  • Bugs fixed:
    • The bug that causes a database breakdown due to an invalid Alibaba Cloud Object Storage Service (OSS) path is fixed.
    • The bug that causes inconsistencies between the imported SRIDs and original SRIDs of some rasters is fixed.
2.7
  • New features:
    • The following MD5 functions are introduced to manage spatial rasters, such as checking data consistency and removing duplication:
      • The ST_MD5Sum function is used to query the MD5 value of a raster.
      • The ST_SetMD5Sum function is used to set the MD5 value of a raster.
    • The following functions are introduced to authenticate the spatial rasters that are stored in OSS buckets:
      • The ST_AKId function is used to query the AccessKey ID of a raster that is stored in an OSS bucket.
      • The ST_SetAccessKey function is used to set the AccessKey ID and AccessKey secret of a raster that is stored in an OSS bucket.
      • The ST_SetAKId function is used to set the AccessKey ID of a raster that is stored in an OSS bucket.
      • The ST_SetAKSecret function is used to set the AcessKey secret of a raster that is stored in an OSS bucket.
    • The following functions are introduced to manage the metadata of a spatial raster:
      • The ST_ScaleX function is used to query the pixel width of a raster on the x axis of the spatial reference system.
      • The ST_ScaleY function is used to query the pixel width of a raster on the y axis of the spatial reference system.
      • The ST_SetScale function is used to query the pixel width of a raster in the spatial reference system.
      • The ST_SkewX function is used to query the skew of a raster on the x axis of the spatial reference system.
      • The ST_SkewY function is used to query the skew of a raster on the y axis of the spatial reference system.
      • The ST_SetSkew function is used to set the skew of a raster in the spatial reference system.
      • The ST_UpperLeftX function is used to query the x coordinate of a raster in the upper-left corner of the spatial reference system.
      • The ST_UpperLeftY function is used to query the y coordinate of a raster in the upper-left corner of the spatial reference system.
      • The ST_SetUpperLeft function is used to query the coordinate of a raster in the upper-left corner of the spatial reference system.
      • The ST_PixelWidth function is used to query the pixel width of a raster in the spatial reference system.
      • The ST_PixelHeight function is used to query the pixel height of a raster in the spatial reference system.
  • Bug fixed:

    The bug that causes failures to upgrade extensions due to aggregate functions is fixed.

2.6
  • New feature:

    The ST_Clip function is introduced to support clipping based on pixel coordinates.

  • Bugs fixed:
    • The bug that causes an invalid name of the ST_NearestApproachDistance function is fixed.
    • The bug that causes the ST_MosaicFrom function to break down in some cases is fixed.