Welcome to the Database Structure Page of the Harold W. Manter Laboratory of Parasitology. All database structures and relational tables are available for distribution. For Additional Information, Contact the Curator of Parasitology: This email address is being protected from spambots. You need JavaScript enabled to view it.
In the Manter Laboratory of Parasitology, the database named “PARASITE” is running under Microsoft ACCESS and is served to the Web via a single DELL DIMENSION 4400 Workstation with SCSI disks and WIN2000 as the operating system.
The HWML parasite database was the first Parasitology Collection database in use in any museum and was developed here in the Manter Laboratory of Parasitology in 1985.
Running under DOS in R-Base, the system was very stable and useable for many years. The database was transferred to a Windows based system on ACCESS in the fall of 1998. Our database programmers spent less than one month in transferring R-Base database file to ACCESS-97.
Data are entered into the main collection catalog file under the following table entries. The relational links among files are shown
in this screen capture of the HWML "PARASITE" database.
BASIC STRUCTURE OF THE DATABASE "PARASITE"
RUNNING UNDER ACCESS IN THE HWML
|
Parasite Record Entry Table
|
Example Entry
|
|
HWMLCollectionNumber
|
16225
|
|
AccessionNumber
|
P-2000-591
|
|
FieldCollectionNumber
|
N/A
|
|
ParasiteType
|
Digenea
|
|
LifeCycleStage
|
Adult
|
|
Gender
|
Female
|
|
ParasiteScientificName
|
Schistosoma douthitti
|
|
ParasiteSubspecies
|
|
|
HostTaxon
|
Mammalia
|
|
HostAge
|
?
|
|
HostGender
|
Female
|
|
InfectionType
|
Experimental
|
|
HostScientificName
|
Mesocricetus
|
|
HostCommonName
|
Golden Hamster
|
|
HostSubspecies
|
|
|
LocationHost
|
Intestine
|
|
Country
|
USA
|
|
StateProvince
|
CA
|
|
County
|
|
|
GeneralLocality
|
|
|
Latitude
|
|
|
Longitude
|
|
|
HabitatCode
|
|
|
PreservationMethod
|
Formalin
|
|
TypeDesignation
|
None
|
|
NumberInLot
|
1
|
|
ContributorNameCode
|
190
|
|
ContributorName
|
Heyneman, Don
|
|
DCIOption
|
Donor
|
|
ContributorInfo
|
|
|
Notes
|
UCFS Medical School
|
|
LoanStatus
|
|
|
Reference
|
Cort, 1915
|
|
Collector
|
Heyneman, Don
|
|
DateCollected
|
|
|
DateAssigned
|
|
|
PersonIdentified
|
Heyneman, Don
|
|
DateIdentified
|
|
|
|
|
Basic Entry Screen for the Database "PARASITE"
-As data are entered, the data are dumped directly to a temporary database for daily editing and cross-checking of data.
-The temporary database is then appended to the main HWML database.
-At the end of each week, the data are copied from the secure data entry machine to the online database machine, thus the actual working database is never “exposed” or attached to the machine on which the web server is running.
-The entry form is set to be tab-able, hitting tab jumps from one entry line to the next.
Last update: March 4, 2004. Scott L. Gardner, Curator