PASSIM – an open source software system for managing information in biomedical studies
BMC Bioinformatics volume 8, Article number: 52 (2007)
One of the crucial aspects of day-to-day laboratory information management is collection, storage and retrieval of information about research subjects and biomedical samples. An efficient link between sample data and experiment results is absolutely imperative for a successful outcome of a biomedical study. Currently available software solutions are largely limited to large-scale, expensive commercial Laboratory Information Management Systems (LIMS). Acquiring such LIMS indeed can bring laboratory information management to a higher level, but often implies sufficient investment of time, effort and funds, which are not always available. There is a clear need for lightweight open source systems for patient and sample information management.
We present a web-based tool for submission, management and retrieval of sample and research subject data. The system secures confidentiality by separating anonymized sample information from individuals' records. It is simple and generic, and can be customised for various biomedical studies. Information can be both entered and accessed using the same web interface. User groups and their privileges can be defined. The system is open-source and is supplied with an on-line tutorial and necessary documentation. It has proven to be successful in a large international collaborative project.
The presented system closes the gap between the need and the availability of lightweight software solutions for managing information in biomedical studies involving human research subjects.
Recording detailed information on collection, processing and storage of samples is crucial both for efficient reporting on any biomedical study and for subsequent data analysis . Collecting and storing this information in a systematic way is particularly important in the context of high-throughput applications, such as proteomics and genomics technologies. Thus, systems facilitating patient and sample data management are in high demand.
We have developed an open-source software system for recording, storing, and providing access to information on biosamples. This system – P atient a nd S ample S ystem for I nformation M anagement (PASSIM) – allows researchers to track information pertinent to sample collection, processing, location, transportation and storage conditions. PASSIM provides an efficient solution to confidentiality issues by separate storage of non-identifiable sample information and records of research participants. The system is web-based, which means that non-identifiable information is kept on a server and can be securely accessed on-line for queries or new submissions by authorised users via web-browser. PASSIM is simple and generic, and thus can be customized for various types of biological studies.
It is worth noting that several publicly available systems include sample-related information in their data models (MiMiR , MIMAS , ArrayExpress ) in order to deepen the integration of sample and experiment data. These data models work well within specific domains (mostly for microarray analysis), but do not allow for effective analysis, integrating various "-omics" data. In principle it might be possible to generalise one of such systems for other types of high-throughput data, however that would further complicate what is already a complex system. We believe that to make such a system more simple and generic, the module used for storage of experiment metadata and results should be separate from the one for the sample information, though they should be interoperable. To the best of our knowledge very few systems of this type are publicly available, e.g. caTISSUE, Open Infrastructure for Outcomes (OIO) [5–7].
The system we present here is a generic version of a system developed for an international collaborative project – Molecular Phenotyping to Accelerate Genomic Epidemiology (MolPAGE). MolPAGE includes 18 academic institutions, biotechnology and pharmaceutical companies (see ). In this paper we briefly describe the design principles and the functionality of PASSIM and discuss how the biomedical community can benefit from using such a system and learn from our experience.
PASSIM has two main modes:
Data submission – entering and editing the information on samples and individuals;
Data access – browsing and querying this information, and generating reports.
The submission form is concise, many of the parameters can be reused in a vast spectrum of studies, and more specific ones can be modified or added to the form. At the same time, PASSIM also supports the retrieval of the information, thus representing an effective means of communication and data transfer between sample collection sites and experimentalists.
To deal with the conflicting needs of local researchers (who might wish to retain linkage to non-anonymized subject IDs e.g. as part of ongoing studies) whilst avoiding the potential breaches of security associated with making such data available over the web, we adopted a two-tier solution, consisting of two subsystems:
Stand-alone Person Management Tool (PMT), used on-site by the staff collecting the samples [see Additional file 1];
PMT is intended for registering confidential information about the research subjects from whom samples have been taken. As already mentioned, the system assigns a unique anonymous identifier to each individual, which is then used for the individual identification in the Sample DB. Each sample collection site hosts its local copy of the PMT. It is worth noting that keeping identifiable information separately from de-identified information might not be a suitable solution for the studies that require inclusion of identifiable private information into the accessible dataset.
The Sample DB is accessible online through a web-based interface (using the Java Server Pages technology, and the Apache Tomcat servlet container) and contains non-confidential information about samples. It allows registration of samples and aliquots as well as the subsequent tracing of aliquot locations (see Figure 2). The system is built so that it can work with any traditional relational databases; it was tested on Oracle or MySQL DBMS.
Sample management system is designed around three main classes: PERSONS, SAMPLES and ALIQUOTS (see Figure 3).
All descriptions are entered using controlled vocabularies. Relations (such as "parent", "sibling" etc) between persons are modelled with two additional tables RELATIONS and RELATION_TYPES (Figure 3) and allow storage of an arbitrary number of relations for each person. Details on the storage and transport conditions and on the sample state at its reception are shared between samples and aliquots.
In addition to the three main tables, there is a table USERS that contains information about the system users and their access rights. Table 'Users' contains information about all the users who can log into the system. Fields Login name and User password contain the information for logging into the system and should not be empty. Passwords are stored in the database in unencrypted form available to administrator for editing or reminding a forgotten password to a user. There are 4 types of access rights: view-only, access for editing by individual or group users and full access; with an option of editing the administrative tables. For details on the differentiation of the access rights, please see Additional file 1: Table 1. PASSIM is designed for collaborating groups which collect samples in a number of locations and then send them to a different location for analysis. The system allows to register and trace these samples and each group of users has appropriate access to information that is relevant for the group.
Functionality and customisability
Similarly to the object model, web interface design of Sample DB is based on three main pages: "Persons", "Samples" and "Aliquots", where the corresponding information can be entered, edited or deleted. There is an option for batch submission of several aliquots of the same sample or of samples taken from the same subject. The properties of an existing aliquot entry can be transferred and assigned to a newly created aliquot entry. Such "submitter-friendly" design makes the submission process easy as well as decreases the possibility of mistakes coming from retyping the same information. There is also a possibility to edit the same parameter for many aliquots simultaneously, which may help coordinate transportation and storage of samples across locations.
In addition to submission capabilities, the system provides advanced search engine capabilities. The data can be filtered by such properties as date of birth, gender, source, type, disease state, location and storage conditions. For complex queries there is an option of generating a report using a pre-downloaded copy of the Sample Management Database.
Another important feature of PASSIM is that potential values of the parameters specific to aliquots, samples or research subjects can be changed via the same web interface. Thus, the metadata terms (pre-defined vocabularies) can always be adjusted to fit a preferred ontology or controlled vocabulary by users with sufficient access rights. Additional file 2: Table 2 provides more detailed information on what properties for each parameter are editable. A user intending to edit a parameter name would need to have administrator access rights (A0 or A1). Addition of more parameters or metadata terms can be done, but require direct modification of the database as well as some changes in programs.
Such a design makes the system flexible towards developing and changing biological vocabularies. Complete guide to the configuration of access rights and web pages is available at the PASSIM website .
The initial specifications for the system were developed by the MolPAGE Consortium members. The main aim of MolPAGE is to develop methods to support genomic epidemiology: that is the measurement, manipulation and analysis of "omics"-scale data in large-scale epidemiological samples. The specifications defined a limited number of properties and variables for individuals, samples and aliquots, which were to be recorded. The sample collection took place at 4 collection sites across 3 different countries. The Patient management system, installed at the sample collection sites, was populated with the clinical data. Then, a unique identifier was generated for each patient and this identifier was transferred to the Sample database. This anonymous identifier constituted a basis of the sample and aliquot IDs. The centralised Sample management system was used through a secure web-interface by both the submitters of the sample information and by the partners analysing the samples. The access rights were diversified to meet the needs of various groups of users. The work within the MolPAGE Consortium revealed a few areas for further development of the system, among which were generation of reports, batch uploading and batch editing.
As PASSIM has proven to be successful, we implemented a generic version of this system for a broader scientific community to use it in other biomedical projects of a similar nature. Information management support for consistent reporting on biomedical research is the rationale behind the creation of PASSIM. This system can potentially assist in a wide range of studies, in which the results cannot be interpreted accurately without sufficient sample information, such as studies of genetic or plasma biomarkers. LIMS systems are conventionally designed to capture the experimental routine from sample collection to data analysis, and these systems are often not the optimal ones to be used specifically for sample-related data and metadata. PASSIM, on the other hand, is a much lighter software solution than LIMS, designed for capturing, storing and browsing sample-related metadata.
Apart from expanded functionality, the application of PASSIM in the MolPAGE project had another important outcome – an object model, which can serve as a basis for a simple home-made relational database, or as a model for standardized data exchange format.
Standardization of reporting on the results is important in many biomedical studies, for instance in epidemiological studies. It imposes new requirements on day-to-day routine information management , thus calling for an effective means for the capture and retrieval of sample-related data. At the moment, there are a number of initiatives controlling the manner in which an investigator reports on a newly discovered biomarker or a newly developed diagnostic test [11–13]. There are also Clinical Data Interchange Consortium  and Clinical Data Architecture of Health Level Seven program . Should scientific journals endorse the standards for reporting on such studies (similarly to how, for example, it has been done for microarray studies ), the level of details required for related publications would necessitate utilization of LIMS or similar tools for metadata recording in any biomedical research group. Unfortunately, commercial software solutions are expensive and not every lab can afford such a system. We feel that PASSIM or systems that can be derived from our approach can close this gap. In future, we plan to link it to the system for storage of high-throughput experiment data, which is currently under development.
The open-source nature of PASSIM means that, first, it is an affordable solution for data management and, second, more importantly, its source code is available for external inspections and modifications. It can be customized for needs of a particular laboratory. To the best of our knowledge, it is the only open-source system of this kind.
Availability and requirements
The PASSIM system along with supporting information can be obtained on the http://passim.sourceforge.net. The on-line tutorial provides assistance in training of potential users of the system. Installation guide and system information can help set up and customize PASSIM for a particular project.
Both parts of PASSIM – Sample Management Database and Person Management Tool – can be also downloaded from http://bioinf.mii.lu.lv/PASSIM/.
Project name: P atient and S ample S ystem for I nformation M anagement (PASSIM)
Project home page: http://passim.sourceforge.net
Operating system(s): platform independent
Programming language: Java
Other requirements: Tomcat 5.0 or more, JDK 1.4.2 or more, Apache Ant 1.6.5 or more; the supplied version of the system is configured for MySQL, additional jdbc driver is required for different databases.
License: open source, non-restricted
Any restrictions to use by non-academics: no restrictions
Laboratory Information Management Systems
Lyons-Weiler J: Standards of Excellence and Open Questions in Cancer Biomarker Research. Cancer Informatics 2005, 1(1):1–7.
Navarange M, Game L, Fowler D, Wadekar V, Banks H, Cooley N, Rahman F, Hinshelwood J, Broderick P, Causton HC: MiMiR: a comprehensive solution for storage, annotation and exchange of microarray data. BMC Bioinformatics 6: 268. 2005 Nov 9 2005 Nov 9 10.1186/1471-2105-6-268
Hermida L, Schaad O, Demougin P, Descombes P, Primig M: MIMAS: an innovative tool for network-based high density oligonucleotide microarray data management and annotation. BMC Bioinformatics 7: 190. 2006 Apr 5 2006 Apr 5 10.1186/1471-2105-7-190
Parkinson H, Kapushesky M, Shojatalab M, Abeygunawardena N, Coulson R, Farne A, Holloway E, Kolesnykov N, Lilja P, Lukk M, Mani R, Rayner T, Sharma A, William E, Sarkans U, Brazma A: ArrayExpress – a public database of microarray experiments and gene expression profiles. Nucleic Acids Res 2006 Nov 28 2006 Nov 28
Brazma A, Krestyaninova M, Sarkans U: Standards for systems biology. Nat Rev Gen 2006, 7(8):593–605. 10.1038/nrg1922
Bossuyt PM, Reitsma JB, Bruns DE, Gatsonis CA, Glasziou PP, Irwig LM, Lijmer JG, Moher D, Rennie D, de Vet HC, STARD Group: Towards complete and accurate reporting of studies of diagnostic accuracy: the STARD initiative. Fam Pract 2004, 21(1):4–10. 10.1093/fampra/cmh103
McShane LM, Altman DG, Sauerbrei W, Taube SE, Gion M, Clark GM, Statistics Subcommittee of the NCI-EORTC Working Group on Cancer Diagnostics: REporting recommendations for tumor MARKer prognostic studies (REMARK). Nat Clin Pract Urol 2005, 2(8):416–22. 10.1038/ncponc0252
Moher D, Schulz KF, Altman DG: The CONSORT statement: revised recommendations for improving the quality of reports of parallel-group randomised trials. Lancet 357(9263):1191–4. 2001 Apr 14 2001 Apr 14 10.1016/S0140-6736(00)04337-3
Brazma A, Hingamp P, Quackenbush J, Sherlock G, Spellman P, Stoeckert C, Aach J, Ansorge W, Ball CA, Causton HC, Gaasterland T, Glenisson P, Holstege FC, Kim IF, Markowitz V, Matese JC, Parkinson H, Robinson A, Sarkans U, Schulze-Kremer S, Stewart J, Taylor R, Vilo J, Vingron M: Minimum information about a microarray experiment (MIAME)-toward standards for microarray data. Nat Genet 2001, 29(4):365–71. 10.1038/ng1201-365
This work has been funded by the European Commission as a part of the Integrated Project MolPAGE (grant code: LSHG-CT-2004-512066).
JV and KP designed system and DB architecture. MO designed and implemented PMT. PR designed web interface and reports' generation. AZ and EC did Java programming. AB tested the usability of the system. SGN participated in testing, designed the project website and produced the on-line tutorial. MK participated in requirement analysis, wrote the manuscript, and performed technical coordination. MIM and AB did the conceptual design of the system. US participated in conceptual design, performed overall supervision and coordination. All authors read and approved the final manuscript.
Electronic supplementary material
Additional File 1: Standalone Person Management Tool (PMT). PMT is intended for registering confidential information about the research subjects from whom samples have been taken. .zip file contains Windows executable, .xml database file and installation description in a README file. (ZIP 410 KB)
Additional File 2: Sample management database. .zip contains sql version of the database, documentation and the files necessary for the installation of the system. (ZIP 12 MB)
About this article
Cite this article
Viksna, J., Celms, E., Opmanis, M. et al. PASSIM – an open source software system for managing information in biomedical studies. BMC Bioinformatics 8, 52 (2007). https://doi.org/10.1186/1471-2105-8-52