LOG Databases

 

Return to Index

LOG Data File

The LOG data file is a Microsoft Access database that holds information relating to the current status of the forest estate. Different types of data are divided by tables within the database. For example, the Area table contains the initial areas of aggregate forest stands divided by their type and age. A FOLPI Yields data file contains the predicted harvest volume of logs of various types and ages. The LOG Data File contains all the information that is contained in the .dat files used with FOLPI.

The only time that the information in the LOG data file is changed within LOG is when new .dat files are loaded into it. However, it is not necessary for .dat files to be used to update the file. As LOG Data Files are Access databases, editing the information either manually or through another program is possible.

A small segment of the LOG data file is shown to the right. This information is part of the area data. As can be seen, it is in a very readable format.

LOG Problem File

The LOG problem file is a Microsoft Access database that holds the user defined specifications about the problem, as well as the results after the problem is solved. The information in the database can easily be viewed in Microsoft Access by simply opening the problem file in Access and looking in the relevant table.

Temporary Databases

Temporary databases have the same name as the names selected from the original files but have "temp" appended to the end of the name. They hold the most recent information about the model. If for some reason an error occurs, the temporary files will hold much of the information about the problem and data before the fault. This information can then be recovered by opening these temporary files as you would an existing problem file.  When LOG ends, the temporary files are deleted.

 

Compacting

When a database has been accessed a number of times, it can become inefficient both in terms of size and lookup speed. It is possible to compact and repair a Database within Microsoft Access. Simply open Microsoft Access and open the the appropriate .mdb file. Select the Tools menu, Database Utilities, Compact and Repair Database as shown below.

 

 

NEXT