Each AnyLogic model now has a built-in fully integrated database to read input data and write simulation output. Export the database with the model, it is as portable and cross-platform as the model itself.
With the new database, you can:
Database can contain tables and views. Both tables and views can be grouped into groups of tables.
You can easily import the database into your AnyLogic project from external database or spreadsheet. Alternatively, you can create empty database tables and enter data manually.
Size
– The label displays the size of the database on disk.
Create or import a table... – Click this link to create a new database table, or import data into the DB from the external database.
Back up database... * – Click this link to create a backup copy of the database. AnyLogic saves the backup copy in TAR.GZ file format. Having backed up the database, you will be able to revert all changes in the database you are working with, by restoring the backed up database (see the property below).
Restore database... * – Click this link to restore the database from the backup file. Restoring the database you replace your current database with the reserve copy you have previously created using the Backup database command (see above). The restored database gets reverted to the state it was when you backed it up.
Delete database
* – Click this link to completely delete the database. This will automatically disable the Compact on model close
option.
Compact on model close
* – If selected, on the database shutdown the DB data will be saved
onto the disk in optimized way, saving the disk space. However, if the
database is huge, shutdowns in COMPACT mode will take the significant
time. If the option is not selected, data is saved as is, which
produces quick DB shutdowns, but does not care about the DB size on the
disk. This option automatically becomes enabled and unresponsive to
further actions, if you switch on the logging in the Log model execution
parameter. The same goes for any old model if it has logging enabled or
any logs saved to the database. You can find more information on how
COMPACT mode works in the HyperSQL User Guide.
* - The option is available only if the database is not empty.
This properties section is visible if this database contains tables that were
imported
from an external database. You can set up the data synchronization and
update data in the imported tables after making some modifications in
the external database.
Autoupdate imported tables on model startup – If selected, data in all imported tables will be automatically updated from the external database on each startup of this model.
Update tables data – Click this link to update data in all imported tables from the external database.
Input data sources
– Contains a list of paths to all external sources of data for the
imported AnyLogic database tables. If the source file is located
outside of the model folder, an absolute path is displayed. If the file
is located in the model folder, only the name of the file is displayed.
Export settings
- Here you can specify the Excel file where you want to export your DB
data and select the DB tables (and logs if logging is enabled) for
export.
Export tables to Excel
- Click this link to export data to the specified Excel file.
Export tables at the end of model execution
- Select this option if you want data to be automatically exported when model execution is finished.
Export to
- This field displays the path to the Excel file you have specified for data export.
Log model execution
– If selected, the model execution will be
logged. Enabling this option automatically enables the Compact on model close
option.
Delete log – Click this link to delete the current model execution log.