A Perl toolkit for LIMS development

Background  

High throughput laboratory techniques generate huge quantities of scientific data. Laboratory Information Management Systems (LIMS) are a necessary requirement, dealing with sample tracking, data storage and data reporting. Commercial LIMS solutions are available, but these can be both costly and overly complex for the task. The development of bespoke LIMS solutions offers a number of advantages, including the flexibility to fulfil all a laboratory's requirements at a fraction of the price of a commercial system. The programming language Perl is a perfect development solution for LIMS applications because of Perl's powerful but simple to use database and web interaction, it is also well known for enabling rapid application development and deployment, and boasts a very active and helpful developer community. The development of an in house LIMS from scratch however can take considerable time and resources, so programming tools that enable the rapid development of LIMS applications are essential but there are currently no LIMS development tools for Perl.     

生物实验信息管理模块建模技术研究

实验信息管理模块是生物实验室信息管理系统的核心,其设计的好坏直接关系到整个系统建设的成败。针对生物实验室实验流程灵活,数据流网络复杂等特点,研究设计了一套实验信息管理模块的模型,并将研究的模型用于基因测序实验室信息管理系统的开发并取得了成功。实践证明,该模型为实验室信息系统(LIMS)中实验管理模块的开发提供了理论支撑,并且提高了LIMS的开发效率。     

Cost savings through use of the Internet: a case study

Introduction of a LIMS can bring immediate cost-savings and efficiency improvements to a Laboratory. However, peripheral problems can often prevent the full benefits from being realised. For example, in our case, reports generated on paper are subject to postal delays. They are also sent initially to an intermediary, for comments and recommendations to be added (this often means re-typing the report) causing a further delay. Within the Laboratory itself, telephone requests from clients for information on sample progress can consume a considerable amount of staff time. We have addressed both of these problems by use of the Internet. An e-mailing program takes ASCII reports produced from the LIMS and attaches them automatically to e-mail messages. Each can be configured to the specific requirements of the recipient (e.g., the use of encryption, digital signatures, and the document format). World-Wide-Web access to appropriate LIMS databases allows clients to determine progress of samples without involving Laboratory personnel. Read-only access is available to a limited sub-set of data determined by the LIMS manager. Both applications have been created in portable languages, in a way that is suitable for many different environments.     

LIMS in the manufacturing environment

The type of laboratory that implements a LIMS is very important in determining the requirements of the LIMS. This article focuses on the requirements for a manufacturing LIMS. The objectives of a manufacturing laboratory that a LIMS should support are presented. Issues that should be considered in the initial planning stage of implementing a manufacturing LIMS are discussed. Functional requirements for a manufacturing LIMS examined in the article are the ability to: (1) handle various material types, (2) grade products, (3) allow flexibility in test method configuration, (4) handle data limits and variable sets of data. (5) revise and track test methods and specifications, and (6) maintain a customer and/or supplier database.     

WIST: toolkit for rapid, customized LIMS development

Workflow Information Storage Toolkit (WIST) is a set of application programming interfaces and web applications that allow for the rapid development of customized laboratory information management systems (LIMS). WIST provides common LIMS input components, and allows them to be arranged and configured using a flexible language that specifies each component's visual and semantic characteristics. WIST includes a complete set of web applications for adding, editing and viewing data, as well as a powerful setup tool that can build new LIMS modules by analyzing existing database schema. Availability and implementation: WIST is implemented in Perl and may be obtained from http://vimss.sf.net under the BSD license.     

A Laboratory Information Management System (LIMS) for a high throughput genetic platform aimed at candidate gene mutation screening

High throughput mutation screening in an automated environment generates large data sets that have to be organized and stored reliably. Complex multistep workflows require strict process management and careful data tracking. We have developed a Laboratory Information Management Systems (LIMS) tailored to high throughput candidate gene mutation scanning and resequencing that respects these requirements. Designed with a client/server architecture, our system is platform independent and based on open-source tools from the database to the web application development strategy. Flexible, expandable and secure, the LIMS, by communicating with most of the laboratory instruments and robots, tracks samples and laboratory information, capturing data at every step of our automated mutation screening workflow. An important feature of our LIMS is that it enables tracking of information through a laboratory workflow where the process at one step is contingent on results from a previous step. AVAILABILITY: Script for MySQL database table creation and source code of the whole JSP application are freely available on our website: http://www-gcs.iarc.fr/lims/. SUPPLEMENTARY INFORMATION: System server configuration, database structure and additional details on the LIMS and the mutation screening workflow are available on our website: http://www-gcs.iarc.fr/lims/     

Implementation of a configurable laboratory information management system for use in cellular process development and manufacturing

Background aimsRegulatory requirements for the manufacturing of cell products for clinical investigation require a significant level of record-keeping, starting early in process development and continuing through to the execution and requisite follow-up of patients on clinical trials. Central to record-keeping is the management of documentation related to patients, raw materials, processes, assays and facilities.MethodsTo support these requirements, we evaluated several laboratory information management systems (LIMS), including their cost, flexibility, regulatory compliance, ongoing programming requirements and ability to integrate with laboratory equipment. After selecting a system, we performed a pilot study to develop a user-configurable LIMS for our laboratory in support of our pre-clinical and clinical cell-production activities. We report here on the design and utilization of this system to manage accrual with a healthy blood-donor protocol, as well as manufacturing operations for the production of a master cell bank and several patient-specific stem cell products.ResultsThe system was used successfully to manage blood donor eligibility, recruiting, appointments, billing and serology, and to provide annual accrual reports. Quality management reporting features of the system were used to capture, report and investigate process and equipment deviations that occurred during the production of a master cell bank and patient products.ConclusionsOverall the system has served to support the compliance requirements of process development and phase I/II clinical trial activities for our laboratory and can be easily modified to meet the needs of similar laboratories.     

Detecting overlapping coding sequences in virus genomes

Background

With the advances in DNA sequencer-based technologies, it has become possible to automate several steps of the genotyping process leading to increased throughput. To efficiently handle the large amounts of genotypic data generated and help with quality control, there is a strong need for a software system that can help with the tracking of samples and capture and management of data at different steps of the process. Such systems, while serving to manage the workflow precisely, also encourage good laboratory practice by standardizing protocols, recording and annotating data from every step of the workflow.

Results

A laboratory information management system (LIMS) has been designed and implemented at the International Crops Research Institute for the Semi-Arid Tropics (ICRISAT) that meets the requirements of a moderately high throughput molecular genotyping facility. The application is designed as modules and is simple to learn and use. The application leads the user through each step of the process from starting an experiment to the storing of output data from the genotype detection step with auto-binning of alleles; thus ensuring that every DNA sample is handled in an identical manner and all the necessary data are captured. The application keeps track of DNA samples and generated data. Data entry into the system is through the use of forms for file uploads. The LIMS provides functions to trace back to the electrophoresis gel files or sample source for any genotypic data and for repeating experiments. The LIMS is being presently used for the capture of high throughput SSR (simple-sequence repeat) genotyping data from the legume (chickpea, groundnut and pigeonpea) and cereal (sorghum and millets) crops of importance in the semi-arid tropics.

Conclusion

A laboratory information management system is available that has been found useful in the management of microsatellite genotype data in a moderately high throughput genotyping laboratory. The application with source code is freely available for academic users and can be downloaded fromhttp://www.icrisat.org/gt-bt/lims/lims.asp.     

Laboratory information management system for membrane protein structure initiative--from gene to crystal

Membrane Protein Structure Initiative (MPSI) exploits laboratory competencies to work collaboratively and distribute work among the different sites. This is possible as protein structure determination requires a series of steps, starting with target selection, through cloning, expression, purification, crystallization and finally structure determination. Distributed sites create a unique set of challenges for integrating and passing on information on the progress of targets. This role is played by the Protein Information Management System (PIMS), which is a laboratory information management system (LIMS), serving as a hub for MPSI, allowing collaborative structural proteomics to be carried out in a distributed fashion. It holds key information on the progress of cloning, expression, purification and crystallization of proteins. PIMS is employed to track the status of protein targets and to manage constructs, primers, experiments, protocols, sample locations and their detailed histories: thus playing a key role in MPSI data exchange. It also serves as the centre of a federation of interoperable information resources such as local laboratory information systems and international archival resources, like PDB or NCBI. During the challenging task of PIMS integration, within the MPSI, we discovered a number of prerequisites for successful PIMS integration. In this article we share our experiences and provide invaluable insights into the process of LIMS adaptation. This information should be of interest to partners who are thinking about using LIMS as a data centre for their collaborative efforts.     

Laboratory information management system for membrane protein structure initiative – from gene to crystal

Membrane Protein Structure Initiative (MPSI) exploits laboratory competencies to work collaboratively and distribute work among the different sites. This is possible as protein structure determination requires a series of steps, starting with target selection, through cloning, expression, purification, crystallization and finally structure determination. Distributed sites create a unique set of challenges for integrating and passing on information on the progress of targets. This role is played by the Protein Information Management System (PIMS), which is a laboratory information management system (LIMS), serving as a hub for MPSI, allowing collaborative structural proteomics to be carried out in a distributed fashion. It holds key information on the progress of cloning, expression, purification and crystallization of proteins. PIMS is employed to track the status of protein targets and to manage constructs, primers, experiments, protocols, sample locations and their detailed histories: thus playing a key role in MPSI data exchange. It also serves as the centre of a federation of interoperable information resources such as local laboratory information systems and international archival resources, like PDB or NCBI. During the challenging task of PIMS integration, within the MPSI, we discovered a number of prerequisites for successful PIMS integration. In this article we share our experiences and provide invaluable insights into the process of LIMS adaptation. This information should be of interest to partners who are thinking about using LIMS as a data centre for their collaborative efforts.     

Integrating LIMS with MS Windows programs

PCs with MS-Office products (WORD, EXCEL) are commonly available at every workplace in analytical laboratories. These programs are used for data processing (EXCEL) and reporting (WORD). If a LIMS is available to store information the question often arises, if and how these WINDOWS programs can be integrated into a LIMS environment. The advantages are obvious: (a) the user can still employ his everyday programs; (b) a spreadsheet is often more appropriate for data input and processing than a LIMS; (c) automatic insertion of LIMS data into a Word document can simplify reporting considerably. Nevertheless, few points must be considered: (a) fast direct data access is necessary; (b) data validity must be guaranteed; (c) data are usually not transferred directly into the database but are presented to the LIMS as a file, which has to pass through a checking procedure; (d) GLP validation of all components (LIMS as well as EXCEL) is required. Our solutions. We employ SQL1LIMS from PE installed on an Alpha Vax under OpenVMS. For data input and reporting we developed several EXCEL spreadsheets. To extract data from the LIMS database we used the ODBC mechanism based on ORACLE SQL1NET 2. The ODBC connection is integrated into a visual-basic module of the EXCEL sheet. To ensure data validity we use the ‘LIST of Values’ method. A necessary prerequisite is a download from LIMS of a set of allowed values. Since with analytical data a check against a set of allowed values is often not possible, the amount of values necessary for checks is limited. Plausibility checks can well be performed within an EXCEL spreadsheet. To transfer data to LIMS we employ two mechanisms. A third (stored procedures) is being tested: (a) an NFS connection between a NOVELL-Netware Server and the LIMS—VAX; (b) ORACLE tables on the VAX, into which the data are loaded and then automatically spooled into the respective files. The NFS-connection between the Novell Server (Netware 4.1) and the VAX avoids the necessity for special drivers on the PC. This connection maps a VAX directory onto the PC.     

LIMS — a catalyst for re-engineering

This paper describes how a laboratory information management system (LIMS) can act as a catalyst for re-engineering. Some of the key issues of successful change management are described and the common pitfalls that LIMS projects can fall into are summarised.     

SPINE 2: a system for collaborative structural proteomics within a federated database framework

We present version 2 of the SPINE system for structural proteomics. SPINE is available over the web at http://nesg.org. It serves as the central hub for the Northeast Structural Genomics Consortium, allowing collaborative structural proteomics to be carried out in a distributed fashion. The core of SPINE is a laboratory information management system (LIMS) for key bits of information related to the progress of the consortium in cloning, expressing and purifying proteins and then solving their structures by NMR or X-ray crystallography. Originally, SPINE focused on tracking constructs, but, in its current form, it is able to track target sample tubes and store detailed sample histories. The core database comprises a set of standard relational tables and a data dictionary that form an initial ontology for proteomic properties and provide a framework for large-scale data mining. Moreover, SPINE sits at the center of a federation of interoperable information resources. These can be divided into (i) local resources closely coupled with SPINE that enable it to handle less standardized information (e.g. integrated mailing and publication lists), (ii) other information resources in the NESG consortium that are inter-linked with SPINE (e.g. crystallization LIMS local to particular laboratories) and (iii) international archival resources that SPINE links to and passes on information to (e.g. TargetDB at the PDB).     

Bacteriological risks: detection and tracing

Advances in molecular taxonomy of bacteria have generated many tools allowing identification of any bacteria, whether culturable or not. In addition to taxonomic identification, growing knowledge on pathogenicity mechanisms allows the detection of bacteria with given virulence genes. The problem is in asking the proper questions so that the most appropriate tools can be chosen. Some rapid identification tools (gene amplification, in situ hybridisation) require a starting hypothesis. Other tools (rrs gene amplification and sequencing) can be used without prior hypothesis, but take longer. To face the bioterrorist threat, particular attention should be given to laboratory and strain dispatch (within- and between-laboratory) organisation.     

The epigenetic silencing of LIMS2 in gastric cancer and its inhibitory effect on cell migration

Recent finding has shown that LIMS2 (also known as PINCH2) functions as a natural regulator of the LIMS1-ILK-parvin complex formation and is associated with cell spreading and migration via integrins at focal adhesions. Here, we report for the first time the epigenetic silencing of LIMS2 in gastric tumors. Downregulation of LIMS2 was detected in 91% (10 of 11) of gastric cancer cell lines by real-time quantitative RT-PCR and 80% (8 of 10) of the LIMS2-downregulated cell lines were associated with CpG island hypermethylation at a 5'-upstream region of LIMS2. Furthermore, LIMS2 was restored in its non-expressing cell lines after treatment with 5-Aza-dC and/or trichostatin A. Loss of expression of LIMS2 was also detected in 53% (51 of 96) of primary gastric tumors. This decrease in expression level significantly correlated with an increase of the CpG island hypermethylation. In addition, the methylation status in any normal-appearing gastric tissues was gradually increased in an age-dependent manner, suggesting that the positive methylation in normal-appearing gastric mucosa can be due to 'field cancerization effect' as an early event in gastric carcinogenesis. Moreover, the transient transfection of LIMS2-siRNA significantly stimulated cell migration in gastric cancer cells but had no effects on cell growth. These results suggest that the frequent inactivation of LIMS2 by epigenetic alteration in gastric cancer may be important in tumor progression events, such as invasion and metastasis. Thus, LIMS2 may be useful as a molecular biomarker and a therapeutic target by increasing its expression and activity in gastric cancer.     

Development of an open source laboratory information management system for 2-D gel electrophoresis-based proteomics workflow

Background  

In the post-genome era, most research scientists working in the field of proteomics are confronted with difficulties in management of large volumes of data, which they are required to keep in formats suitable for subsequent data mining. Therefore, a well-developed open source laboratory information management system (LIMS) should be available for their proteomics research studies.     

Recording information on protein complexes in an information management system

The Protein Information Management System (PiMS) is a laboratory information management system (LIMS) designed for use with the production of proteins in a research environment. The software is distributed under the CCP4 licence, and so is available free of charge to academic laboratories. Like most LIMS, the underlying PiMS data model originally had no support for protein-protein complexes. To support the SPINE2-Complexes project the developers have extended PiMS to meet these requirements. The modifications to PiMS, described here, include data model changes, additional protocols, some user interface changes and functionality to detect when an experiment may have formed a complex. Example data are shown for the production of a crystal of a protein complex. Integration with SPINE2-Complexes Target Tracker application is also described.     

MASTR-MS: a web-based collaborative laboratory information management system (LIMS) for metabolomics

Background

An increasing number of research laboratories and core analytical facilities around the world are developing high throughput metabolomic analytical and data processing pipelines that are capable of handling hundreds to thousands of individual samples per year, often over multiple projects, collaborations and sample types. At present, there are no Laboratory Information Management Systems (LIMS) that are specifically tailored for metabolomics laboratories that are capable of tracking samples and associated metadata from the beginning to the end of an experiment, including data processing and archiving, and which are also suitable for use in large institutional core facilities or multi-laboratory consortia as well as single laboratory environments.

Results

Here we present MASTR-MS, a downloadable and installable LIMS solution that can be deployed either within a single laboratory or used to link workflows across a multisite network. It comprises a Node Management System that can be used to link and manage projects across one or multiple collaborating laboratories; a User Management System which defines different user groups and privileges of users; a Quote Management System where client quotes are managed; a Project Management System in which metadata is stored and all aspects of project management, including experimental setup, sample tracking and instrument analysis, are defined, and a Data Management System that allows the automatic capture and storage of raw and processed data from the analytical instruments to the LIMS.

Conclusion

MASTR-MS is a comprehensive LIMS solution specifically designed for metabolomics. It captures the entire lifecycle of a sample starting from project and experiment design to sample analysis, data capture and storage. It acts as an electronic notebook, facilitating project management within a single laboratory or a multi-node collaborative environment. This software is being developed in close consultation with members of the metabolomics research community. It is freely available under the GNU GPL v3 licence and can be accessed from, https://muccg.github.io/mastr-ms/.

     

LIMS — beyond CSV: a strategy for LIMS data quality assurance

Computer system validation of a LIMS is often confused with the ongoing task of entering and quality-assuring the material, instrument, specification, method, calculation, and study data required for laboratory sample and results management. A practical approach to LIMS template data quality assurance includes preparation of one or more standard operating procedures for entry and quality assurance of material specifications, test limits, secondary calculation formulae, and other analytical laboratory testing information.     

Space Station Freedom: a unique laboratory for gravitational biology research

The advent of Space Station Freedom (SSF) will provide a permanent laboratory in space with unparalleled opportunities to perform biological research. As with any spacecraft there will also be limitations. It is our intent to describe this space laboratory and present a picture of how scientists will conduct research in this unique environment we call space. SSF is an international venture which will continue to serve as a model for other peaceful international efforts. It is hoped that as the human race moves out from this planet back to the moon and then on to Mars that SSF can serve as a successful example of how things can and should be done.