TEMPORARY "SIMULATION" TABLES
The system creates these tables for each run, and writes the results of simulation to these tables. At the end of the run, the content of the temporary tables is inserted in the main tables (which are indexed). This is done as a single database transaction, and in a single operation. This allows the database to optimise the recreation of the index.
|
|
| CW: | temporary storage for the additional weather calculation |
| GW: | temporary storage for the grid weather calculation |
| CY: | temporary storage for the crop yield calculation |