LIMS is an Oracle database that stores science data gathered from the JOIDES Resolution as well as from the Gulf Coast Repository (GCR). It is built around a sample-based hierarchy, meaning that all data are referenced to specific samples. The production databases include SHIP and SHORE instances of LIMS. RTIF is a test database used to ensure applications are ready for the production environment.
An ancillary Oracle database handles file assets, such as uploaded images or Excel spreadsheets. This additional database is known as the “Asset Manager,” or ASMAN database.
Figure 1. LIMS Database Structure.
The LIME program can be used to edit data in the SAMPLE and TEST tables. In this document, references to the database tables are upper case (e.g., SAMPLE), whereas references to data in these tables are lowercase (e.g., sample).