The FinBase database system consists of a collection of folders and a front- and back-end database. The folders are associated with image and file storage. The back-end database (FinBase.mdb) contains the data tables and the front-end database (FinBase_FE.mdb) contains the collection of forms, macros and reports that function as the primary interface for the user.
The front-end database has been customized using Microsoft Visual Basic for Applications (VBA) to facilitate data entry, storage, and analysis. In addition to the database tools provided by Microsoft Access, FinBase utilizes a third-party ActiveX control to embed image analysis functionality. Many of the tasks associated with image file management and the photo analysis process have been automated.
FinBase expedites the process of matching individuals to catalog entries through the use of a multiple-attribute catalog sorting algorithm. This approach represents a departure from the traditional methodology of partitioning catalogs into categories based on a single predominant dorsal fin feature.
FinBase maintains a catalog in which individuals can possess multiple attributes (e.g., chop, apex, lower fin notch, peduncle scar/notch, etc.), any combination of which can be selected to sort the catalog. This expedites the matching process by allowing analysts to sort the entire catalog based on the similarity of each existing catalog individuals' attributes to those of the newly sighted individual. Images more closely resembling the attributes of the newly sighted individual are located in the beginning of the sorted catalog, resulting in fewer image comparisons required to locate catalog matches. Details regarding the multiple-attribute catalog sorting algorithm can be found in the following reprint: