Add/update/archive datasets Search for datasets Manage locations (i.e. file path) Basic stats (Count of datasets)
The current implementation uses Postgres 9.5, with JSONB support.
The metadata_types are used to create database indexes into the JSONB dataset documents.
Currently the index stores spatial regions for the data, but indexes it on a ranges of latitudes and longitudes.
A database with support for spatial objects, such as the PostGIS extension for Postgres, could improve the efficiency (and simplicity of implementation) of spatial queries.
We don’t currently store the spatial and temporal extents of a product.
To calculate this in the database requires scanning the entire dataset table to get min and max extent values. More commonly, to do this in Python, every dataset record is retrieved which is a very memory and CPU intensive operation.
This is an important feature for apps such as datacube-ows and cubedash that need to know the entire bounds for sensibly displaying the user interface.
Syncing the index across systems (e.g. from NCI to an external system) requires a standard interface. There are issues using Postgres tools that require locking tables, etc, that need to be investigated.
There is no standard way to access the Index from remote systems. Directly using the database exposes implementation specifics. We could possibly use an existing protocol, such as: