BlueM.Opt output files: Difference between revisions

From BlueM
Jump to navigation Jump to search
(update for BlueM.Opt v2.1.0)
 
(19 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Ergebnisdatenbank==
{{BlueM.Opt_nav}}
Zu Anfang jeder Optimierung wird eine leere Ergebnisdatenbank (<code>EVO_BM\EVO.mdb</code>) in das Arbeitsverzeichnis des BM kopiert. Falls diese schon vorhanden ist, wird gefragt, ob sie überschrieben werden soll.
<div style="float:right; margin:0 0 5px 5px;">__TOC__</div>
==Result database==
The result database is a Microsoft Access database containing the fitness values ("'''QWerte'''"), the constraint values ("'''Constraints'''") and the optimization parameterts ("'''OptParameter'''") of each simulation carried out during the optimization process.  


Die Ergebnisdatenbank enthält die Qualitätswerte ("'''Qwerte'''") und die zugehörigen Optimierungsparameter ("'''OptParameter'''") jeder Simulation, die während der Optimierung ausgeführt wurde. Die Abfrage "'''Optimierungsergebnis'''" verknüpft die Qualitätswerte mit den zugehörigen Optimierungsparametern in einer Tabelle.
The result database is stored in the directory containing the dataset with following filename: <br/>
<code><datasetname>.BlueM.Opt.<timestamp>.mdb</code><br/>
where<br/>
:<code><datasetname></code> is the name of the dataset
:<code><timestamp></code> is the timestamp when the optimization was started in format YYYYMMddHHmm


[[Kategorie:EVO]]
=== Loading ===
You can load an existing result database for the purposes of visualizing and analyzing the results.
# Set ''App'', ''Dataset'' and ''Method''. These have to correspond to the settings used to produce the result database.
# Click on ''Result - load result DB''
It is currently not possible to continue an optimization run using a loaded result database as the starting point.
 
=== Structure ===
[[File:ErgebnisDB_Tables.png|thumb|300px|Tables]]
The result database contains several tables:
* '''Sim''': The simulations that were performed (IDs only)
* '''QWerte''': Objective function values
* '''OptParameter''': Optimization parameter values
* '''Constraints''': Constraint values
* '''SekPop''': The pareto-front at each generation.
 
All tables can be linked using the common column <code>'''Sim_ID'''</code>.
 
[[File:ErgebnisDB_Queries.png|thumb|300px|Queries]]
Some queries are already predefined:
 
e.g. '''OptimierungsErgebnis_PES (nur letzte SekPop)''' gives you the parameter values, objective function values, and constraint values for all members of the last computed pareto front (i.e. the final result).
 
;Note: The result database does not contain the model parameter values as defined in the [[MOD-file]]!
 
[[Category:BlueM.Opt output files]]

Latest revision as of 03:57, 24 January 2023

EVO.png BlueM.Opt | Usage | Development

Result database

The result database is a Microsoft Access database containing the fitness values ("QWerte"), the constraint values ("Constraints") and the optimization parameterts ("OptParameter") of each simulation carried out during the optimization process.

The result database is stored in the directory containing the dataset with following filename:
<datasetname>.BlueM.Opt.<timestamp>.mdb
where

<datasetname> is the name of the dataset
<timestamp> is the timestamp when the optimization was started in format YYYYMMddHHmm

Loading

You can load an existing result database for the purposes of visualizing and analyzing the results.

  1. Set App, Dataset and Method. These have to correspond to the settings used to produce the result database.
  2. Click on Result - load result DB

It is currently not possible to continue an optimization run using a loaded result database as the starting point.

Structure

Tables

The result database contains several tables:

  • Sim: The simulations that were performed (IDs only)
  • QWerte: Objective function values
  • OptParameter: Optimization parameter values
  • Constraints: Constraint values
  • SekPop: The pareto-front at each generation.

All tables can be linked using the common column Sim_ID.

Queries

Some queries are already predefined:

e.g. OptimierungsErgebnis_PES (nur letzte SekPop) gives you the parameter values, objective function values, and constraint values for all members of the last computed pareto front (i.e. the final result).

Note
The result database does not contain the model parameter values as defined in the MOD-file!