View source for Journal:AdLIMS: A customized open source software that allows bridging clinical and basic molecular research studies

{{lowercase title}}
{{Infobox journal article
|name         = 
|image        = 
|alt          = <!-- Alternative text for images -->
|caption      = 
|title_full   = adLIMS: A customized open source software that allows bridging clinical and basic molecular research studies
|journal      = ''BMC Bioinformatics''
|authors      = Calabria, Andrea; Spinozzi, Giulio; Benedicenti, Fabrizio; Tenderini, Erika; Montini, Eugenio
|affiliations = San Raffaele Telethon Institute for Gene Therapy; University of Milano-Bicocca
|contact      = Email: montini.eugenio@hsr.it
|editors      = 
|pub_year     = 2015
|vol_iss      = '''16''' (Suppl 9)
|pages        = S5
|doi          = [http://doi.org/10.1186/1471-2105-16-S9-S5 10.1186/1471-2105-16-S9-S5]
|issn         = 1471-2105
|license      = [http://creativecommons.org/licenses/by/4.0 Creative Commons Attribution 4.0 International]
|website      = [http://www.biomedcentral.com/1471-2105/16/S9/S5 http://www.biomedcentral.com/1471-2105/16/S9/S5]
|download     = [http://www.biomedcentral.com/content/pdf/1471-2105-16-S9-S5.pdf http://www.biomedcentral.com/content/pdf/1471-2105-16-S9-S5.pdf] (PDF)
}}
{{ombox	
| type      = content	
| style    = width: 500px;	
| text      = This article should not be considered complete until this message box has been removed. This is a work in progress.	
}}
==Abstract==
'''Background:''' Many biological laboratories that deal with genomic samples are facing the problem of sample tracking, both for pure [[laboratory]] management and for efficiency. Our laboratory exploits PCR techniques and Next Generation Sequencing (NGS) methods to perform high-throughput integration site monitoring in different clinical trials and scientific projects. Because of the huge amount of samples that we process every year, which result in hundreds of millions of sequencing reads, we need to standardize data management and tracking systems, building up a scalable and flexible structure with web-based interfaces, which are usually called [[Laboratory information management system|Laboratory Information Management System]] (LIMS).

'''Methods:''' We started collecting end-users' requirements, composed of desired functionalities of the system and Graphical User Interfaces (GUI), and then we evaluated available tools that could address our requirements, spanning from pure LIMS to Content Management Systems (CMS) up to enterprise information systems. Our analysis identified [[ADempiere]] ERP, an open source Enterprise Resource Planning written in Java J2EE, as the best software that also natively implements some highly desirable technological advances, such as the high usability and modularity that grants high use-case flexibility and software scalability for custom solutions.

'''Results:''' We extended and customized ADempiere ERP to fulfil LIMS requirements and we developed adLIMS. It has been validated by our end-users verifying functionalities and GUIs through test cases for PCRs samples and pre-sequencing data and it is currently in use in our laboratories. adLIMS implements authorization and authentication policies, allowing multiple users management and roles definition that enables specific permissions, operations and data views to each user. For example, adLIMS allows creating sample sheets from stored data using available exporting operations. This simplicity and process standardization may avoid manual errors and [[information]] backtracking, features that are not granted using track recording on files or spreadsheets.

'''Conclusions:''' adLIMS aims to combine sample tracking and data reporting features with higher accessibility and usability of GUIs, thus allowing time to be saved on doing repetitive laboratory tasks, and reducing errors with respect to manual data collection methods. Moreover, adLIMS implements automated data entry, exploiting sample data multiplexing and parallel/transactional processing. adLIMS is natively extensible to cope with [[laboratory automation]] through platform-dependent API interfaces, and could be extended to genomic facilities due to the ERP functionalities.

'''Keywords:''' LIMS; Open Source Software; Information Systems; ADempiere ERP; Sample Tracking

==Background==
In many biological laboratories, sample tracking is an outstanding issue and often represents a bottleneck for the correct handling and interpretation of experimental data. This issue is becoming particularly critical when automation and high-throughput technologies are introduced in the laboratory practice. Our laboratory performs high-throughput characterization of vector-genomic integration sites in the context of gene therapy applications based on the delivery of therapeutic genes by viral vectors that stably integrate into the genome of targeted cells, as well as gene therapy preclinical models and insertional mutagenesis research projects.<ref name="RanzaniLenti14">{{cite journal |title=Lentiviral vector-based insertional mutagenesis identifies genes involved in the resistance to targeted anticancer therapies |journal=Molecular Therapy |author=Ranzani, M.; Annunziato, S.; Calabria, A.; Brasca, S.; Benedicenti, F.; Gallina, P.; Naldini, L.; Montini, E. |volume=22 |issue=12 |pages=2056-2068 |year=2014 |doi=10.1038/mt.2014.174 |pmid=25195596 |pmc=PMC4429698}}</ref><ref name="AiutiLenti13">{{cite journal |title=Lentiviral hematopoietic stem cell gene therapy in patients with Wiskott-Aldrich syndrome |journal=Science |author=Aiuti, A.; Biasco, L.; Scaramuzza, S.; Ferrua, F.; Cicalese, M.P.; Baricordi, C. et al. |volume=341 |issue=6148 |pages=1233151 |year=2013 |doi=10.1126/science.1233151 |pmid=23845947 |pmc=PMC4375961}}</ref><ref name="BiffiLenti13">{{cite journal |title=Lentiviral hematopoietic stem cell gene therapy benefits metachromatic leukodystrophy |journal=Science |author=Biffi, A.; Montini, E.; Lorioli, L.; Cesani, M.; Fumagalli, F.; Plati, T. et al. |volume=341 |issue=6148 |pages=1233158 |year=2013 |doi=10.1126/science.1233158 |pmid=23845948}}</ref><ref name="AiutiMulti07">{{cite journal |title=Multilineage hematopoietic reconstitution without clonal selection in ADA-SCID patients treated with stem cell gene therapy |journal=Journal of Clinical Investigation |author=Aiuti, A.; Cassani, B.; Andolfi, G.; Mirolo, M.; Biasco, L.; Recchia, A. et al. |volume=117 |issue=8 |pages=2233-40 |year=2007 |doi=10.1172/JCI31666 |pmid=17671653 |pmc=PMC1934603}}</ref><ref name="BraunGene14">{{cite journal |title=Gene therapy for Wiskott-Aldrich syndrome: Long-term efficacy and genotoxicity |journal=Science Translational Medicine |author=Braun, C.J.; Boztug, K.; Paruzynski, A.; Witzel, M.; Schwarzer, A.; Rothe, M. et al. |volume=6 |issue=227 |pages=227–33 |year=2014 |doi=10.1126/scitranslmed.3007280 |pmid=24622513}}</ref><ref name="DeichmannVector07">{{cite journal |title=Vector integration is nonrandom and clustered and influences the fate of lymphopoiesis in SCID-X1 gene therapy |journal=Journal of Clinical Investigation |author=Deichmann, A.; Hacein-Bey-Abina, S.; Schmidt, M.; Garrigue, A.; Brugman, M.H.; Hu, J.; Glimm, H.; Gyapay, G.; Prum, B.; Fraser, C.C. et al. |volume=117 |issue=8 |pages=2225–2232 |year=2007 |doi=10.1172/JCI31659 |pmid=17671652 |pmc=PMC1934585}}</ref><ref name="OttCorrect06">{{cite journal |title=Correction of X-linked chronic granulomatous disease by gene therapy, augmented by insertional activation of MDS1-EVI1, PRDM16 or SETBP1 |journal=Nature Medicine |author=Ott, M.G; Schmidt, M.; Schwarzwaelder, K.; Stein, S.; Siler, U.; Koehl, U. et al. |volume=12 |issue=4 |pages=401-409 |year=2006 |doi=10.1038/nm1393 |pmid=16582916}}</ref><ref name="SchwarzwaelderGamma07">{{cite journal |title=Gammaretrovirus-mediated correction of SCID-X1 is associated with skewed vector integration site distribution in vivo |journal=Journal of Clinical Investigation |author=Schwarzwaelder, K.; Howe, S.J.; Schmidt, M.; Brugman, M.H.; Deichmann, A.; Glimm, H. et al. |volume=117 |issue=8 |pages=2241-9 |year=2007 |doi=10.1172/JCI31661 |pmid=17671654 |pmc=PMC1934556}}</ref><ref name="SteinGeno10">{{cite journal |title=Genomic instability and myelodysplasia with monosomy 7 consequent to EVI1 activation after gene therapy for chronic granulomatous disease |journal=Nature Medicine |author=Stein, S.; Ott, M.G.; Schultze-Strasser, S.; Jauch, A.; Burwinkel, B.; Kinner, A. et al. |volume=16 |issue=2 |pages=198-204 |year=2010 |doi=10.1038/nm.2088 |pmid=20098431}}</ref> Vector integration sites are retrieved and mapped in the genome through a combination of Polymerase Chain Reaction (PCR)-based techniques<ref name="SchmidtHigh07">{{cite journal |title=High-resolution insertion-site analysis by linear amplification-mediated PCR (LAM-PCR) |journal=Nature Methods |author=Schmidt, M.; Schwarzwaelder, K.; Bartholomae, C.; Zaoui, K.; Ball, C.; Pilz, I. |volume=4 |issue=12 |pages=1051-1057 |year=2007 |doi=10.1038/nmeth1103 |pmid=18049469}}</ref>, next generation sequencing (NGS) and [[bioinformatics]] analyses.<ref name="CalabriaVISPA14">{{cite journal |title=VISPA: A computational pipeline for the identification and analysis of genomic vector integration sites |journal=Genome Medicine |author=Calabria, A.; Leo, S.; Benedicenti, F.; Cesana, D.; Spinozzi, G.; Orsini, M. et al. |volume=6 |issue=9 |pages=67 |year=2014 |doi=10.1186/s13073-014-0067-5 |pmid=25342980 |pmc=PMC4169225}}</ref> We process and analyze around 2000 samples/year resulting in hundreds of millions of sequencing reads. Despite the fact that adopting robotic automation for sample manipulation in our laboratory has provided many advantages in terms of manual error-reduction and data production scalability, drawbacks related to sample information volume and tracking are still present. These reasons prompted us to develop a Laboratory Information Management System (LIMS)<ref name="PrasadTrends12">{{cite journal |title=Trends in laboratory information management system |journal=Chemometrics and Intelligent Laboratory Systems |author=Prasad, P.J.; Bodhe, G.L. |volume=118 |pages=187–192 |year=2012 |doi=10.1016/j.chemolab.2012.07.001}}</ref> for sample tracking on a scalable and flexible infrastructure with an easily accessible and web-based interface. LIMS is a type of information system implemented as a software utility specifically designed to improve the data acquisition and sample monitoring along laboratory workflows, and supporting sample reporting. An information system is a combination of information technologies developed to grant business processes efficiency and monitoring. Extended IS are the Enterprise Resource Planning (ERP) solutions<ref name="SohEnt00">{{cite journal |title=Enterprise resource planning: Cultural fits and misfits: Is ERP a universal solution? |journal=Communications of the ACM |author=Soh, C.; Kien, S.S.; Tay-Yap, J. |volume=43 |issue=4 |pages=47-51 |year=April 2000 |doi=10.1145/332051.332070}}</ref> that integrate the standard information system features with accounting and administrative operations for performance monitoring through dashboards and data mining tools.

In this work we describe our LIMS, developed on an existing open source ERP framework that natively implements all technological functionalities, as software customization and parameterization. After a brief introduction of the ERP framework with the motivation of the specific choice, we will describe in details our implementation with custom use cases and scenarios derived from our laboratory requirements and experience. 

==References==
{{Reflist|colwidth=30em}}

==Notes==
This presentation is faithful to the original, with only a few minor changes to presentation. In some cases important information was missing from the references, and that information was added. 

<!--Place all category tags here-->
[[Category:LIMSwiki journal articles (all)‎]]
[[Category:LIMSwiki journal articles on bioinformatics‎‎]]
[[Category:LIMSwiki journal articles on software‎]]