MongoDB Collections - Learning-Dashboard/LD-learning-dashboard GitHub Wiki

The assessment is stored in a MongoDB dayabase. For each assessed project we have a separated set of collections identified by a suffix in the name, i.e. collection_name.projectID

Strategic Indicators

This index contains the assessment of the strategic indicators.

Name of the index: strategic_indicators.projectID

Attributes:

  • _id (string): ID of the strategic indicator's evaluation.
  • project (string): Project ID.
  • strategic_indicator (string): Identifying the strategic indicator.
  • name (string): Name of the strategic indicator.
  • description (string): Description of the strategic indicator.
  • evaluationDate (string): Date of the evaluation, in format yyyy-MM-dd.
  • datasource (string): Not a relevant field for strategic indicators.
  • value (double): Value of the evaluation.
  • info (string): Relevant information about the evaluation.
  • missing_factors (string []): Factors that influence the strategic indicator but did not have an evaluation when computing this one.
  • dates_mismatch_days (int): Max days of difference between the evaluation of certain factors and the strategic indicator.

Quality Factors

This index contains the assessment of the Quality Factors.

Name of the index: factors.projectID

Attributes:

  • _id (string): ID of the factor's evaluation.
  • project (string): Project ID.
  • factor (string): Identifying the factor.
  • evaluationDate (string): Date of the evaluation, in format yyyy-MM-dd.
  • datasource (string): Datasource of the metrics that compose the factor.
  • name (string): Name of the factor.
  • description (string): Description of the factor.
  • value (double): Value of the evaluation.
  • info (string): Relevant information about the evaluation.
  • indicators (string[]): Strategic indicators that are influenced by this factor.
  • missing_metrics (string []): Metrics that influence the factor but did not have an evaluation when computing this one.
  • dates_mismatch_days (int): Max days of difference between the evaluation of certain metrics and the factor.

Assessed metrics

This index contains the assessment of the metrics.

Name of the index: metrics.projectID

Attributes:

  • _id (string): ID of the metric's evaluation.
  • project (string): Project ID.
  • factor (string): Identifying the metric.
  • evaluationDate (string): Date of the evaluation, in format yyyy-MM-dd.
  • datasource (string): Datasource of the metric (source collection).
  • name (string): Name of the metric.
  • description (string): Description of the metric.
  • value (double): Value of the evaluation.
  • info (string): Relevant information about the evaluation.
  • type (string): Type of the data, which in this case id metrics.
  • factors (string[]): Factors that are influenced by this metric.
  • weights (double []): Weights of influence of the metric to each of the factors.

Relations

This index contains the information about how the assessment has been calculated, which elements and weights has been used in an especific assessment. For example for a certain factor, the index contains one entry per each metric used in its computation and the computation details.

Name of the index: relations.projectID

Attributes:

  • _id (string): ID of the relation's evaluation.
  • evaluationDate (string): Date of the evaluation, in format yyyy-MM-dd.
  • project (string): Project ID.
  • relation (string): Identifying of the relation.
  • sourceId (string): ID of the source element.
  • sourceLabel (string): Category of the source element.
  • sourceType (string): Type of the source element, can be metrics or factors.
  • targetId (string): ID of the target element.
  • targetType (string): Type of the target element, can be factors or indicators.
  • targetValue (string): Value of the target element, as a string.
  • value (double): Value of the relation (sourceValue * weight).
  • weight (double): Weight of the relation.