Analytical databases LIMS

Among analytical databases, there are also systems for organizing laboratory work, for exchanging information, and for communicating within a company. They are termed laboratory information and management systems (LIMS). 

Sample test data are either manually entered into the system or captured from analytical instmments coimected to the LIMS. The system performs any necessary calculations and compares the result to the appropriate specification stored in the database. If the comparison indicates the material is in conformance, the system can automatically provide an approval. Otherwise, the LIMS can alert lab supervision to the nonconforming sample analysis. 

For the analytical chemist, databases are an essential resource when carrying out their day-to-day activities in product identification. All the major spectroscopic techniques have large databases associated with them, these are used to compare spectra derived from unknown chemicals etc. and so the whole process of product identification is made faster. These are dealt with using a laboratory information management system (LIMS) (see Section B, 2.9.1). 

Current procedures emphasise the importance of storing the laboratory recorded data ( raw data ) and the XRFS analyses are now direcdy transferred via a Laboratory Information Management System (LIMS) to data tables in the BGS corporate geochemistry database. Conditioned data is loaded to different data tables and importantly every analyte result has an accompanying qualifier field that can be provided to the user to explain any data quality issues. 

Databases are used widely in commercial applications and have become the foundation of modern data processing. Various bibliographic, financial and chemical reference databases are perhaps the most familiar to scientists at this time. However, the proliferation of Laboratory Information Management Systems (LIMS) makes analytical laboratory databases accessible to most laboratory personnel. Such databases store analytical data and scientific information from which a variety of documents and reports are generated. 

A database can be described as a collection of inter-related data organized into records and connected by known (set) relationships. Typically, a database is organized around a function such as personnel, manufacturing, etc. A LIMS database is organized around the analytical and research laboratory. Good database design involves several well established principles (1)... 

VAX LIMS DMDB. The key to good database design is the definition of records and the set relationships between them. The VAX DMDB schema (Bachman diagram) is shown in Figure 4. The diagram shows the major records (boxes) in the database and the relationship (arrows) between the records (sets). The records and their fields are determined by the nature of the data encountered in an analytical laboratory... 

A batch record, as stored in the database, is represented by a collection of different data on the actual production procedure and the current production enviromnent. Back in 1994, at the point of decision, the data available electronically were stored in several databases. Database update was time-consuming and difficult data analysis even needed different program interfaces. Therefore, the database for the new system had to be a central, uniform database for the whole production plant.The bill of material is fed from ERP as well as general planning. LIMS is another interface for the input of analytical data that is important in the calculation of correction factors for the content of API. 

The LIMS system is mostly empty when bought. Not a single measurement unit is normally included, nor are there any analytical methods. The system has many built-in functionality to make sure that the data in the database is consistent. It also has engines to take care of updates of status when data is changed. 

Following connection of the analytical equipment to the core LIMS, formal verification of data values within the core LIMS database, screen displays and reports may be performed. The vehicle for this testing will be the second stage OQ Protocol. 

Maintenance of the LIMS validation status requires a suitable infrastructure to be in place. This infrastructure will consist of a LIMS manager and appropriate SOPs. The LIMS manager will be responsible for controlling any changes to the LIMS interface, analytical equipment interfaces, LAN/WAN architecture, LIMS functionality and the data held within the database. 

Test results and the corresponding raw data must be maintained in an organized and legally defensible form. The use of notebooks (paper or electronic) or other dociunent controlled form is required. Most modem analytical laboratories have some form of laboratory information management system (LIMS) or database system to systematically collect and store the results of the stability... 

Laboratory information management system (LIMS) A computerized database that allows the tracking of samples, their various attributes and their analytical test data. Using appropriate software, the data can be manipulated to facilitate the development process, for example, to predict shelf life. 

A LIMS is a database management system designed especially for the tasks of a laboratory. Such a system can store a lot of data (not only about samples) and give information about the data. In addition to data related to the samples and orders, one can create files on, for example, all laboratory workers, holiday lists, analytical instruments (inventory), all relevant telephone numbers and postal and e-mail addresses, the stock of chemicals in use and in store, the stock of equipment, and books and other literature. As all these files create a requirement for storage capacity and performance, if information is searched for it is perhaps better to use a PC for this purpose. Nearly all the performance of the LIMS computer (server) is needed for the LIMS and should not be used for other activities. Only if there is a powerful computer for the LIMS could the mentioned files be stored in the frame of the LIMS database. 

Many standard testing laboratories run analyses to determine whether a material is within manufactur ing specification limits. The manufacturing process and analysis method usually define these limits. Most LIMS provide a mechanism for these specifications to be stored or retrieved and compared to the resuits. The specifications are often stored in a database con trolled by the clients of the analytical laboratory. Materials that are within specifications can be auto matically released. Those that are not can be flagged or operators can be automatically notified regarding the test results. 

---