Management schema tables

This set of tables contains information about the configuration of the current Sidra instance and some generic information required by the Sidra Manager -the Sidra Management Web UI-.

Configuration table

This table is used to store any kind of generic configuration parameters in a key-value pair format.

Column Description
ConfigurationKey Key of the configuration parameter
ConfigurationValue Value of the configuration parameter
LastConfigurationValue Previous value of the configuration parameter
LastUpdate Date of the latest update of the configuration parameter

AzureRegion table

This table contains the information about the location of the Azure Data Centres. It is used by the Sidra Manager to draw in a world map the location of the Data Storage Units.

Column Description
Id AzureRegion identifier
Region Region name, e.g. "East US"
RegionId Region identifier, e.g. "eastus"
Location Location, e.g. "Virginia"
Longitude Longitude of the location
Latitude Latitude of the location

This table contains static data like this fragment of the table:

management-location-rows

Service table

Additionally, to the standard features that Sidra provides, there are more services that can be added to a Sidra instance. This table contains information about all the services of the Sidra platform and which ones are installed in the current instance of Sidra.

Column Description
Id Service identifier
Name Name of the service, e.g. "Management Web UI"
Description Description of the service, e.g. "Web interfaces for Sidra management"
Version Version of the service
IsInstalled Flag if the service is installed in the current Sidra instance
InstallationDate Date of the installation of the service
ExtendedProperties Additional properties of the service

Model table

Sidra includes the capability of serving machine learning models. This table is used to store the information about those models.

Column Description
Id Model identifier
Name Name of the model
Description Model description with the functionality or the notes of the model

ModelVersion table

This table stores additional information about the machine learning models for versioning purposes.

Column Description
Id ModelVersion identifier
IdModel Model identifier
VersionNumber Version number of the model
Notes ModelVersion notes
RunId Run id of the model trained
Enabled ModelVersion is enabled or not
LastTrained Date of the last training
DeploymentName Name of the deploymente for this version
EndPoint Model endpoint of deployment
Status Identifier of the status of deployment
ExperimentId MLflow Experiment identifier
ImageName Name of the docker image for this version
Metrics Metrics of the trained model

These are the values for the Status of a ModelVersion:

Identifier Status Description
0 Error There was a problem during the deployment of this model
1 ModelRegistered The model information has been persisted on database but the docker image has not been created yet
2 ImageCreated A docker image for the model has been created but it has not been deployed
3 Deploying There is an ongoing deployment process for the model
4 Deployed The model is deployed