We require each sample processed and analysed in our labs to be allocated a unique and short lab identifier for the practicality of labelling vessels during wet chemical processing, and due to the space limitations of the mass spectrometry software when entering sample identifiers for analysis. Furthermore, having all relevant sample information entered during allocation of the lab identifier, the database can be later interrogated according to any specific field, or combination of fields and parameters. This is important for both recording sample throughput details, as well as retrospectively tracking sample information as required.
We would envisage the new database to have the capacity to allocate five digit identifiers (2 alphas then 3 numerals, ie. AA000). Our current system comprises a user interface program that allocates lab numbers as information is entered via a series of drop-drown boxes, radio buttons, and text fields, which is all stored separately in a Microsoft Access database file. This enables users to freely collect numbers, add information, and even interrogate the database, but without directly accessing the database file itself hence ensuring its integrity. A similar configuration of data fields as well as the separation of the user interface system from data storage would be envisaged.