Difference between revisions of "User:Shawndouglas/sandbox/sublevel11"

From LIMSWiki
Jump to navigationJump to search
Tag: Reverted
(Replaced content with "<div class="nonumtoc">__TOC__</div> {{ombox | type = notice | style = width: 960px; | text = This is sublevel11 of my sandbox, where I play with features and...")
Tags: Manual revert Replaced
Line 7: Line 7:


==Sandbox begins below==
==Sandbox begins below==
[[File:Microwave Microsystems Laboratory - 51997578036.jpg|right|250px]]Computers in the laboratory are not a recent phenomenon. The mid-1960s saw laboratory computerization become increasingly popular<ref name="KriegClinical74">{{cite book |chapter=Chapter 30: Clinical Laboratory Computerization |title=Clinical Diagnosis by Laboratory Methods |author=Krieg, A.F. |editor=Davidsohn, I.; Henry, J.B. |publisher=W.B. Saunders Company |pages=1340–58 |year=1974 |isbn=0721629229}}</ref><ref name="FlynnComputer65">{{cite book |chapter=Computer-assisted processing of bio-chemical test data |title=Progress in Medical Computing |author=Flynn, F.V. |editor=Atkins, H.J.B. |publisher=Blackwell Science Ltd |page=46 |year=1965 |isbn=0632001801}}</ref><ref name="WilliamsTheUse64">{{cite journal |title=The Use of Data Processing and Automation in Clinical Pathology |journal=Military Medicine |author=Williams, G.Z. |volume=129 |issue=6 |pages=502–9 |year=1964 |doi=10.1093/milmed/129.6.502}}</ref><ref name="HicksRoutine66">{{cite journal |title=Routine Use of a Small Digital Computer in the Clinical Laboratory |journal=JAMA |author=Hicks, G.P.; Gieschen, M.M.; Slack, W.V. et al. |volume=196 |issue=11 |pages=973–78 |year=1966 |doi=10.1001/jama.1966.03100240107021}}</ref><ref name="StraumfjordElectronic67">{{cite journal |title=Electronic Data Processing System for Clinical Laboratories: A System Used for All Laboratory Sections |journal=American Journal of Clinical Pathology |author=Straumfjord, J.V.; Spraberry, M.N.; Biggs, H.G.; Noto, T.A. |volume=47 |issue=5_ts |pages=661–76 |year=1967 |doi=10.1093/ajcp/47.5_ts.661}}</ref>, though that enthusiasm was often based on the potential of the computers themselves rather than their actual capabilities.<ref name="KriegClinical74" /> Laboratorians imagined potentials such as automatic sample label generation, daily log and report management, instrument interfacing and data processing, results comparisons, and time management tools. However, it would take time for some of those potentials to be realized.<ref name="KriegClinical74" />
In 1970, Temple University's Marion Ball, M.A., an assistant professor in the Department of Medical Physics, conducted a survey of pathology directors in clinical laboratories that were using computers. Asking their opinions about the advantages and disadvantages of computerized systems in the lab, she received responses from directors in 15 U.S. states, as well as from three other countries. Responses included<ref name="BallASurvey70">{{cite journal |title=A Survey of Field Experience in Clinical Laboratory Computerization |journal=Laboratory Medicine |author=Ball, M.J. |volume=1 |issue=11 |pages=25–27, 49–51 |year=1970 |doi=10.1093/labmed/1.11.25}}</ref>:
<blockquote>''The ability to rapidly prepare cumulative records and then to inspect them for possible errors through analysis trends has been proven to be of tremendous advantage in a number of laboratories. We can prevent errors in our analytical systems, but we are not prepared to prevent errors in the collecting of the sample, the mislabeling of the sample, or the accidental use of an incorrect sample. Thus, the ability to inspect data trends presents the only real tool that we currently have to pick out these kinds of errors.'' - Max E. Chilcote, Ph.D, Meyer Memorial Hospital Division</blockquote>
<blockquote>''There is little argument about whether an operating computer system can be an advantage in a laboratory, but the most critical time is the installation and transition from a "manual" to a "computer" oriented laboratory.'' - Robert L. Habig, Duke University Medical Center</blockquote>
Reading about these potentials and opinions today, some 50 years later, we see both clear similarities and definite advances. For example, Habig's statement about transitioning from manual to more automated processes still rings true today: it can be nerve wracking and critical to get the transition right. Conversely, while the systems of decades past weren't able to "prevent errors in the collecting of the sample, the mislabeling of the sample, or the accidental use of an incorrect sample," modern [[laboratory informatics]] systems provide many assurances to sample management in the lab. In many cases, activities such as label generation, reporting, results analysis, [[workflow]] control, test ordering, and broad interoperability are commonplace in modern systems.<ref name="JonesInformatics14">{{cite journal |title=Informatics and the Clinical Laboratory |journal=The Clinical Biochemist Reviews |author=Jones, R.G.; Johnson, O.A.; Batstone, G. |volume=35 |issue=3 |pages=177–92 |year=2014 |pmid=25336763 |pmc=PMC4204239}}</ref> And those systems continue to advance, with [[machine learning]] now finding its way into a few laboratory data management and [[Data analysis|analysis]] workflows.<ref name="BurtonNHS18">{{cite web |url=https://towardsdatascience.com/nhs-laboratories-need-data-science-c93f7983302c |title=NHS Laboratories Need Data Science |author=Burton, R. |work=Towards Data Science |date=19 July 2018 |accessdate=05 May 2023}}</ref><ref name="CuffAugment18">{{cite web |url=https://www.nextplatform.com/2018/06/19/augmenting-pathology-labs-with-big-data-and-machine-learning/ |title=Augmenting Pathology Labs with Big Data and Machine Learning |author=Cuff, J. |work=The Next Platform |date=18 June 2018 |accessdate=05 May 2023}}</ref>
We've come a long way since the 1960s, to a point where the question is no longer "can a computerized system help my manufacturing-based lab?" but rather "how do I choose and implement an informatics system to help my manufacturing-based lab?" As the previous chapter highlighted, a wide variety of standards and regulations further drive the narrative of "not if but when" for informatics systems acquisition. What follows is information to help you with this necessary acquisition, while considering the technology, features, security, cost, implementation, and vendor guarantees that come with such a system.
===3.1 Evaluation and selection===
What exactly is a [[laboratory information management system]] (LIMS) anyway? Do I need one? What options are available and how do I compare them? What about a request for information (RFI), request for proposal (RFP), or request for quotation (RFQ)? These are questions [[laboratory]] professionals typically ponder upon finding themselves charged with the mission of finding software for their food and beverage lab. For many the task can be a daunting proposition.
You may know the workflow-related needs of your laboratory, but perhaps you don't know much about [[Information management|data management]] solutions like LIMS, leaving you intimidated by all the options. You'll first need to gauge your lab's informatics needs in order to determine which products are worth investigating further. Of course your lab's analysis requirements, reporting and data sharing constraints, instrument interfacing needs, [[Barcode|barcoding]] and tracking requirements, quality assurance processes, etc. are very important factors. But these systems vary in numerous ways, and other important factors exist. Price should certainly be considered, although value is ultimately more important than a low price. Other important questions that get asked include:
*Should we purchase software licenses or "rent" the software via a subscription-based model?
*Does the software need to be on-site, or is a [[Software as a service|SaaS]] hosted option more practical?
*Is a modular or complete system better for us?
*What is the best licensing/rental scheme for us? Should we consider site, named user, concurrent user, or workstation licenses?
*Is the company qualified and trustworthy?
*What functionality is available to help our lab not only accomplish workflow tasks but also remain regulatory compliant?
These and other questions are addressed in this chapter.
====3.1.1 Technology considerations====
Your laboratory's [[workflow]], instruments, data management requirements, budget, technological expertise, business goals, and risk tolerances will all play a role in deciding what technology to invest in. The textile testing lab, for example, may depend less on instrument integration than the stability, cycle, and challenge testing lab, with its microbiological workflows. As such, look at your laboratory's short- and long-term goals, budget, workflow, and regulatory requirements to gain a better understanding of what technology will be involved.
First, what are the laboratory's goals? Does the third-party laboratory owner envision a small investment, taking in a slow but steady flow of basic analytical requests, or do they envision expansive growth, expanding into multiple manufacturing-based testing domains? If the lab is starting small but is confidently expecting to grow, technological investments early on may want to take into account future technologies that may shape data management and security processes. Second, what kind of work will the lab be doing, and what regulatory responsibilities will guide hardware and software investment at the lab? If your lab will be conducting extractable and leachable testing, you'll be considering [[chromatography]] and [[spectroscopy]] instruments, as well as requirements for retaining analytical results for regulators. The accredited pharmaceutical manufacturing lab will likely have many more instruments to cover all its testing needs, and its data management system will likely need to be able to interface to U.S. Food and Drug Administration (FDA) systems, or at a minimum report in their specific format. Third, your laboratory's budget is always important. Does the budget allow for on-site hardware and software systems, with the personnel to maintain them? Is it easier to pay up-front or find a vendor willing to work with you on leasing or rental terms? (We talk about other cost considerations a bit later.)
Finally, will the lab have someone on-site or on-call to resolve technology issues, including set-up and maintenance of software systems? If your lab will have little in the way of available tech help locally, you'll want to consider the distribution model you want to use for any installed software, i.e., you may want to consider [[software as a service]] (SaaS). An increasing number of software services are hosted using [[cloud computing]], which when done well is an increasingly reliable option.<ref name="IzrailevskyCloud18">{{cite journal |title=Cloud Reliability |journal=IEEE Cloud Computing |author=Izrailevsky, Y.; Bell, C. |volume=5 |issue=3 |pages=39–44 |year=2018 |doi=10.1109/MCC.2018.032591615}}</ref> Having someone else host the software for you typically means the hosting provider will carry a non-trivial portion of responsibility for technology maintenance and security. Speaking of security, you'll also want to consider the [[cybersecurity]] (addressed later) of not only your software solution but also your overall laboratory operations. Does your organization have a cybersecurity plan already in place, or has the decision to make one been postponed? What extra investment is required to ensure your sensitive data is secure? Remember that how you rank your cybersecurity preparedness and implement a cybersecurity plan will also guide your technology investment decisions.<ref name="DouglasComp20">{{cite web |title=[[LII:Comprehensive Guide to Developing and Implementing a Cybersecurity Plan|''Comprehensive Guide to Developing and Implementing a Cybersecurity Plan'']] |author=Douglas, S.E. |work=LIMSwiki |date=July 2020 |accessdate=05 May 2023}}</ref>
'''3.1.1.1 Laboratory informatics options'''
Keeping the above in mind, what are the common software solutions used within the manufacturing-based laboratory? One of the more commonly discussed options is the LIMS, a laboratory informatics solution designed to assist laboratories with managing testing workflows, data, and other aspects of their operations. The use of LIMS in production facilities and labs is not a new concept.<ref name="HintonLIMSIn95">{{Cite journal |last=Hinton |first=Mary |date=1995-12-01 |title=LIMS in the manufacturing environment |url=https://www.sciencedirect.com/science/article/pii/1381141X9580027Z |journal=Laboratory Automation & Information Management |language=en |volume=31 |issue=2 |pages=109–113 |doi=10.1016/1381-141X(95)80027-Z |issn=1381-141X}}</ref><ref name="HintonLIMS96">{{Cite journal |last=Hinton |first=Mary D. |last2=Hinton |first2=Phillip R. |date=1996 |title=LIMS and chromatographic data acquisition in the manufacturing environment |url=http://www.hindawi.com/journals/jamc/1996/723762/abs/ |journal=Journal of Automatic Chemistry |language=en |volume=18 |issue=5 |pages=169–174 |doi=10.1155/S1463924696000181 |issn=0142-0453 |pmc=PMC2548082 |pmid=18925032}}</ref><ref>{{Cite journal |last=Çağındı |first=Özlem |last2=Ötleş |first2=Semih |date=2004-12 |title=Importance of laboratory information management systems (LIMS) software for food processing factories |journal=Journal of Food Engineering |language=en |volume=65 |issue=4 |pages=565–568 |doi=10.1016/j.jfoodeng.2004.02.021}}</ref> However, little information can be found as to the percentage of today's manufacturing-based laboratories using a LIMS in their workflow. In 2020, Astrix Technology conducted a LIMS market survey, with results being compiled from "137 professionals from a wide variety of industries," with some of those industries being related to manufacturing efforts. Astrix indicated some 77 percent of the surveyed companies reported having a LIMS deployment in their lab, but Astrix didn't break out those deployments by industry, making it difficult to determine what percentage of manufacturing-related companies had a LIMS deployment in 2020.<ref name="AstrixLIMS21">{{cite web |url=https://astrixinc.com/wp-content/uploads/2021/03/Astrix-2020-LIMS-Market-Research-Report.pdf |format=PDT |title=2020 LIMS Market Research Survey Report |publisher=Astrix Technology, LLC |date=March 2021 |accessdate=05 May 2023}}</ref>
That said, professional discussions about manufacturers and their LIMS use would seem to indicate the importance of an information management system being high in order to remain competitive in tighter economies.<ref name="PTOLIMS22">{{cite web |url=https://www.pharmatechoutlook.com/news/lims-add-competitive-advantage-to-cdmos-nwid-2386.html |title=LIMS Add Competitive Advantage to CDMOs |author=Pharma Tech Outlook |work=Pharma Tech Outlook |date=02 September 2022 |accessdate=05 May 2023}}</ref><ref name="AbazeriHowDoes22">{{cite web |url=https://blogs.sw.siemens.com/consumer-products-retail/2022/11/10/how-does-using-an-integrated-laboratory-information-management-system-lims-improve-food-beverage-manufacturing-quality/ |title=How does using an integrated laboratory information management system (LIMS) improve food & beverage manufacturing quality? |author=Abazeri, L. |work-Siemens Blogs |publisher=Siemens |date=10 November 2022 |accessdate=05 May 2023}}</ref><ref name="F&SBigData21">{{cite web |url=https://www.marketresearch.com/Frost-Sullivan-v383/Big-Data-Analytics-Artificial-Intelligence-14233934/ |title=Big Data Analytics and Artificial Intelligence are Driving the Global LIMS Market |author=Frost & Sullivan |work=MarketResearch.com |date=February 2021 |accessdate=05 May 2023}}</ref> When also taking into consideration the importance of integrating instrumentation and produced data in a manufacturing and testing environment<ref>{{Cite book |last=Scholten |first=Bianca |date=2007 |title=The road to integration: a guide to applying the ISA-95 standard in manufacturing |url=https://books.google.com/books?id=-UQ0knDacZsC&pg=PA189&dq=manufacturing+system+integration+%22LIMS%22&hl=en&newbks=1&newbks_redir=0&sa=X&ved=2ahUKEwjTuuO0sNz-AhXHlWoFHfj9A1EQ6AF6BAgCEAI#v=onepage&q=manufacturing%20system%20integration%20%22LIMS%22&f=false |chapter=Chapter 4: Applying ISA-95 to Vertical Integration |publisher=ISA |place=Research Triangle Park NC |pages=167–93 |isbn=978-0-9792343-8-5}}</ref><ref name="SmithInteg19">{{cite web |url=https://foodsafetytech.com/feature_article/integrated-informatics-optimizing-food-quality-and-safety-by-building-regulatory-compliance-into-the-supply-chain/ |title=Integrated Informatics: Optimizing Food Quality and Safety by Building Regulatory Compliance into the Supply Chain |author=Smith, K. |work=Food Safety Tech |date=02 July 2019 |accessdate=05 May 2023}}</ref><ref name="SiemensProcess22">{{cite web |url=https://assets.new.siemens.com/siemens/assets/api/uuid:ca5438d3-5b52-4b41-aae0-aaaa3685484e/pibr-00021-0820-food-bev-portrait.pdf |format=PDF |title=Food & Beverage Process Automation and Instrumentation |publisher=Siemens Industry, Inc |date=2022 |accessdate=05 May 2023}}</ref>, a LIMS or other informatics solution appears to be increasingly critical to eliminating manual processes, improving sample management, increasing productivity, and improving regulatory conformance.<ref name="Astrix2020LIMS">{{cite web |url=https://astrixinc.com/wp-content/uploads/2021/03/Astrix-2020-LIMS-Market-Research-Report.pdf |format=PDF |title=Astrix 2020 LIMS Market Research Survey Report |publisher=Astrix Technology, LLC |date=March 2021 |accessdate=05 May 2023}}</ref> This, of course, lends to the manufacturing lab's focus on safety, quality, and compliance.
A LIMS can improve laboratory workflows and workloads while enhancing safety, quality, and compliance in a number of ways. A fragmented mix of paper-based and electronic information sources can be a detriment to the traceability of or rapid accessibility to manufacturing ingredients, additives, quality control samples, standard operating procedures (SOPs), environmental monitoring data, chain of custody data, and other vital aspects of the production of goods. A well-implemented LIMS can reduce the silos of information and data, while at the same time make that information and data more secure and readily accessible. Producers of pharmaceuticals and other goods are increasingly adding automation, and as such, a LIMS is able to better integrate and support digital data and information management while improving the adaptability and flexibility of workflows.<ref name="CardosoFromBench23">{{cite web |url=https://www.mckinsey.com/industries/life-sciences/our-insights/from-bench-to-bedside-transforming-r-and-d-labs-through-automation |title=From bench to bedside: Transforming R&D labs through automation |author=Cardoso, R.; Kinscher, K.; Ruof, T. et al. |work=McKinsey & Company |date=08 March 2023 |accessdate=05 May 2023}}</ref> Given the regulatory demands for providing rapid proof of traceable product movement and relevant quality control data, the LIMS can also act as the central integrator and audit trail for that information.<ref name="SmithInteg19" /><ref name="McDermottHowDig18">{{cite web |url=https://foodsafetytech.com/column/how-digital-solutions-support-supply-chain-transparency-and-traceability/ |title=How Digital Solutions Support Supply Chain Transparency and Traceability |author=McDermott, P. |work=Food Safety Tech |date=31 July 2018 |accessdate=05 May 2023}}</ref><ref name="EvansTheDig19">{{cite web |url=https://foodsafetytech.com/feature_article/the-digital-transformation-of-global-food-security/ |title=The Digital Transformation of Global Food Security |author=Evans, K. |work=Food Safety Tech |date=15 November 2019 |accessdate=05 May 2023}}</ref> Because the LIMS improves traceability—including through its automated interfaces with instruments and other data systems—real-time monitoring of supply chain issues, quality control data, instrument use, and more is further enabled, particularly when paired with configurable dashboards and alert mechanisms. By extension, manufacturers can more rapidly act on insights gained from those real-time dashboards.<ref name="SmithInteg19" /> This also means that the lab conducting analyses for the manufacturer can react more rapidly to issues that compromise compliance when certified to, e.g., the [[ISO 17025|ISO/IEC 17025]] standard.<ref name="ApteIsYour20" /><ref name="PaszkoHow15">{{cite web |url=https://foodsafetytech.com/feature_article/how-lims-facilitates-iso-17025-certification-in-food-testing-labs/ |title=How LIMS Facilitates ISO 17025 Certification in Food Testing Labs |author=Paszko, C. |work=Food Safety Tech |date=26 October 2015 |accessdate=05 May 2023}}</ref> Finally, many modern LIMS tailored to a manufacturing-based industry come pre-configured out of the box with analytical and quality control workflow support tools that can be further optimized to a lab's unique workflow.<ref name="IngallsHowAdv20">{{cite web |url=https://foodsafetytech.com/feature_article/how-advanced-lims-brings-control-consistency-and-compliance-to-food-safety/ |title=How Advanced LIMS Brings Control, Consistency and Compliance to Food Safety |author=Ingalls, E. |work=Food Safety Tech |date=06 August 2020 |accessdate=05 May 2023}}</ref>
However, the LIMS is not the sole information management solution for manufacturers and the laboratories they use; they may also use a software-based [[quality management system]] (QMS) or [[manufacturing execution system]] (MES) in their operations. (We'll briefly discuss them more in section 3.2.1.) Software-based information management solutions are being marketed to manufacturing-based labs in ways other than as a LIMS. Some vendors have taken to marketing the somewhat related [[laboratory execution system]] (LES), which tends to focus more on laboratory test method execution at the process level while integrating other R&D functionalities found in, for example, [[electronic laboratory notebook]]s (ELNs).<ref name="iVentionLES">{{cite web |url=https://hs.iles.cloud/en/food-and-beverages-lab-execution |title=iLES Food & Beverages Lab Execution |publisher=iVention BV |accessdate=05 May 2023}}</ref><ref name="LVSHowLIMS20">{{cite web |url=https://www.news-medical.net/whitepaper/20200416/How-LIMS-can-Improve-your-Food-and-Beverage-Testing-Lab.aspx |title=How LIMS can Improve your Food and Beverage Testing Lab |author=LabVantage Solutions |work=News Medical |date=16 April 2020 |accessdate=05 May 2023}}</ref> Some software vendors incorporate [[artificial intelligence]] (AI) and [[machine learning]] (ML) mechanisms into their LIMS-like manufacturing labortatory software and package it differently, e.g., as a "materials informatics platform"<ref name="MZMaterials">{{cite web |url=https://www.materials.zone/blog/materials-informatics-platform-vs-lims |title=Materials Informatics Platform vs. LIMS |publisher=Materials.Zone Ltd |accessdate=05 May 2023}}</ref> or an "applied sciences platform."<ref name="ACIMakeBetter">{{cite web |url=https://www.alchemy.cloud/products/lab-platform |title=Make better products faster |publisher=Alchemy Cloud, Inc |accessdate=05 May 2023}}</ref> This platform approach to software is arguably growing as a trend<ref name="ZhuProducts16">{{cite web |url=https://hbr.org/2016/04/products-to-platforms-making-the-leap |title=Products to Platforms: Making the Leap |author=Zhu, F.; Furr, N. |work=Harvard Business Review |pages=72–8 |date=April 2016 |accessdate=05 May 2023}}</ref>, so these laboratory informatics platforms may have utility in specific manufacturing-based labs. In comparison, some LIMS may or may not address these and other requirements; this functionality will be discussed further in the next subsection.
====3.1.2 Features and functions====
Given the above, it's clear LIMS adoption and use is important to the continued success of manufacturing-based labs. However, in most cases, a generic LIMS won't do; it's imperative the lab find a solution that meets all or most of its workflow requirements. This more often than not requires a configurable solution that enables trained users to quickly make the changes they need, if those changes make sense within the overall data structure of the LIMS. It also requires a solution that has been thoughtfully developed and continues to be carefully maintained to address the ever-shifting standard- and regulation-based requirements of the manufacturing-based laboratory. The following examines both the base features and specialty requirements of a manufacturing LIMS.
'''3.1.2.1 Base features'''
What follows is a list of system functionality important to most any manufacturing-based laboratory, with a majority of that functionality found in many vendor software solutions.<ref name="SmithInteg19">{{cite web |url=https://foodsafetytech.com/feature_article/integrated-informatics-optimizing-food-quality-and-safety-by-building-regulatory-compliance-into-the-supply-chain/ |title=Integrated Informatics: Optimizing Food Quality and Safety by Building Regulatory Compliance into the Supply Chain |author=Smith, K. |work=Food Safety Tech |date=02 July 2019 |accessdate=05 May 2023}}</ref><ref name="ApteIsYour20">{{cite web |url=https://foodsafetytech.com/column/is-your-food-testing-lab-prepping-for-an-iso-iec-17025-audit/ |title=Is Your Food Testing Lab Prepping for an ISO/IEC 17025 Audit? |author=Apte, A. |work=Food Safety Tech |date=20 October 2020 |accessdate=05 May 2023}}</ref><ref name="McDermottHowDig18">{{cite web |url=https://foodsafetytech.com/column/how-digital-solutions-support-supply-chain-transparency-and-traceability/ |title=How Digital Solutions Support Supply Chain Transparency and Traceability |author=McDermott, P. |work=Food Safety Tech |date=31 July 2018 |accessdate=05 May 2023}}</ref><ref name="IngallsHowAdv20">{{cite web |url=https://foodsafetytech.com/feature_article/how-advanced-lims-brings-control-consistency-and-compliance-to-food-safety/ |title=How Advanced LIMS Brings Control, Consistency and Compliance to Food Safety |author=Ingalls, E. |work=Food Safety Tech |date=06 August 2020 |accessdate=05 May 2023}}</ref><ref name="iVentionLES">{{cite web |url=https://hs.iles.cloud/en/food-and-beverages-lab-execution |title=iLES Food & Beverages Lab Execution |publisher=iVention BV |accessdate=05 May 2023}}</ref><ref name="TNMWhatAre22">{{cite web |url=https://www.technetmagazine.com/what-are-the-features-of-lims/ |title=What Are the Features of LIMS? |author=Tech Net Magazine |work=Tech Net Magazine |date=27 September 2022 |accessdate=05 May 2023}}</ref><ref name="ISRoleOfLab">{{cite web |url=https://insightssuccess.com/role-of-laboratory-information-management-system-in-manufacturing-sectors/ |title=Role of Laboratory Information Management System in Manufacturing Sectors |work=Insights Success |accessdate=05 May 2023}}</ref><ref name="StarlimsManuf21">{{cite web |url=https://www.starlims.com/wp-content/uploads/general-manufacturing-lims-spec-document.pdf |format=PDF |title=STARLIMS General Manufacturing and Consumer Products Manufacturing Industries LIMS Specification Document |publisher=STARLIMS Corporation |date=June 2021 |accessdate=05 May 2023}}</ref><ref name="GoldbergBeni19">{{cite web |url=https://blog.labtag.com/the-benefits-of-using-a-laboratory-information-management-system-lims/ |title=Benefits of a Laboratory Information Management System |author=Goldberg, A. |work=Labtag Blog |date=27 June 2019 |accessdate=05 May 2023}}</ref><ref name="RoshaLIMS05">{{cite web |url=https://citeseerx.ist.psu.edu/document?repid=rep1&type=pdf&doi=5a4bc0e7d8421cb10b2740934964f44efb478bc1 |title=LIMS: An Informatics Tool for Pharmaceutical Industries (A White Paper) |author=Rosha, V. |publisher=Satyam Computer Services Ltd |date=2005 |accessdate=05 May 2023}}</ref><ref name="ThurstonAchiev13">{{cite journal |url=http://www.thermoscientific.es/content/dam/tfs/ATG/CMD/CMD%20Documents/Third-Party%20Papers/Laboratory%20Information%20Management%20Systems%20(LIMS)/D22087~.pdf |format=PDF |title=Achieving Success in Chemical Manufacturing: How a Laboratory Information Management System (LIMS) Ensures Flexibility in the Lab |author=Thurston, C. |journal=American Laboratory |volume=45 |issue=1 |pages=1–3 |date=January 2013 |accessdate=05 May 2023}}</ref><ref name="RussomImplem12">{{Cite journal |last=Russom |first=Diana |last2=Ahmed |first2=Amira |last3=Gonzalez |first3=Nancy |last4=Alvarnas |first4=Joseph |last5=Digiusto |first5=David |date=2012-01 |title=Implementation of a configurable laboratory information management system for use in cellular process development and manufacturing |url=https://linkinghub.elsevier.com/retrieve/pii/S1465324912706205 |journal=Cytotherapy |language=en |volume=14 |issue=1 |pages=114–121 |doi=10.3109/14653249.2011.619007}}</ref><ref name="FamiliLab22">{{Citation |last=Famili |first=Parsa |last2=Cleary |first2=Susan |date=2022-03-09 |editor-last=Huynh‐Ba |editor-first=Kim |title=Laboratory Information Management System (LIMS) and Electronic Data |url=https://onlinelibrary.wiley.com/doi/10.1002/9781119680475.ch10 |work=Analytical Testing for the Pharmaceutical GMP Laboratory |language=en |edition=1 |publisher=Wiley |pages=345–373 |doi=10.1002/9781119680475.ch10 |isbn=978-1-119-12091-9}}</ref><ref name="GuoCloud20">{{Citation |last=Guo |first=Pei |last2=Peterson |first2=Raymond |last3=Paukstelis |first3=Paul |last4=Wang |first4=Jianwu |date=2020 |editor-last=Yang |editor-first=Hui |editor2-last=Qiu |editor2-first=Robin |editor3-last=Chen |editor3-first=Weiwei |title=Cloud-Based Life Sciences Manufacturing System: Integrated Experiment Management and Data Analysis via Amazon Web Services |url=http://link.springer.com/10.1007/978-3-030-30967-1_14 |work=Smart Service Systems, Operations Management, and Analytics |language=en |publisher=Springer International Publishing |place=Cham |pages=149–159 |doi=10.1007/978-3-030-30967-1_14 |isbn=978-3-030-30966-4}}</ref><ref name="StarlimsFood22">{{cite web |url=https://www.starlims.com/wp-content/uploads/food-and-bev-lims-spec-document.pdf |format=PDF |title=STARLIMS Food and Beverage Industry LIMS Specification Document |publisher=STARLIMS Corporation |date=November 2021 |accessdate=05 May 2023}}</ref><ref name=":0">{{Citation |last=Boyar |first=Kyle |last2=Pham |first2=Andrew |last3=Swantek |first3=Shannon |last4=Ward |first4=Gary |last5=Herman |first5=Gary |date=2021 |editor-last=Opie |editor-first=Shaun R. |title=Laboratory Information Management Systems (LIMS) |url=http://link.springer.com/10.1007/978-3-030-62716-4_7 |work=Cannabis Laboratory Fundamentals |language=en |publisher=Springer International Publishing |place=Cham |pages=131–151 |doi=10.1007/978-3-030-62716-4_7 |isbn=978-3-030-62715-7 |accessdate=2023-05-03}}</ref>
'''''Test, sample and result management'''''
*Sample log-in and management, with support for unique IDs
*Sample batching
*[[Barcode]] and RFID support
*End-to-end sample and inventory tracking
*Pre-defined and configurable industry-specific test and method management, including for bacteria (i.e., microbiology), heavy metals (i.e., chemistry), drug residues (i.e., pharmaceutical chemistry), and other substances
*Pre-defined and configurable industry-specific workflows
*Configurable screens and data fields
*Specification management
*Test, sampling, instrument, etc. scheduling and assignment
*Test requesting
*Data import and export
*Robust query tools
*Analytical tools, including [[data visualization]], statistical analysis, and [[data mining]] tools
*Document and image management
*Version control
*Project management
*Method and protocol management
*Investigation management
*Facility and sampling site management
*Storage management and monitoring
*Contractor lab and outsourcing support
'''''Quality, security, and compliance'''''
*[[Quality assurance]] / [[quality control]] mechanisms
*Mechanisms for compliance with ISO/IEC 17025 and HACCP, including support for critical control point (CCP) specifications and limits
*Result, method, protocol, batch, and material validation, review, and release
*Data validation
*Trend and control charting for statistical analysis and measurement of uncertainty
*User qualification, performance, and training management
*[[Audit trail]]s and [[chain of custody]] support
*Configurable and granular role-based security
*Configurable system access and use (i.e., authentication requirements, account usage rules, account locking, etc.)
*[[Electronic signature]] support
*Data [[encryption]] and secure communication protocols
*Archiving and [[Data retention|retention]] of data and information
*Configurable data [[backup]]s
*Status updates and alerts
*Environmental monitoring support
*Incident and non-conformance notification, tracking, and management
'''''Operations management and reporting'''''
*Configurable dashboards for monitoring, by product, process, facility, etc.
*Customizable rich-text reporting, with multiple supported output formats
*Custom and industry-specific reporting, including certificates of analysis (CoAs)
*Industry-compliant labeling
*Email integration
*Instrument interfacing and data management
*Third-party software interfacing (e.g., LES, scientific data management system [SDMS], other database)
*Data import, export, and archiving
*Instrument calibration and maintenance tracking
*Inventory and material management
*Supplier/vendor/customer management
*Integrated (or online) system help
'''3.1.2.2 Specialty features'''
As noted previously, some software vendors are addressing manufacturing-based laboratories' needs beyond basic organizational LIMS functionality with their specialty solutions. A standard LIMS tailored for various manufacturing industries may already contribute to some of these wider organizational functions, as well as more advanced laboratory workflow requirements, but many may not, or may vary in what additional functionality they provide. In that regard, a LIMS vendor may also include specialized functionality that goes beyond the basic and addresses specialized activities of the manufacturer and its laboratories<ref name="iVentionLES" /><ref name="StarlimsManuf21" /><ref name="RoshaLIMS05" /><ref name="RussomImplem12" /><ref name="FamiliLab22" /><ref name="StarlimsFood22" /><ref name="Douglas">{{Cite web |last=Douglas, S.E. |date=May 2022 |title=17. Production management |work=LIMSpec 2022 R2 |url=https://www.limswiki.org/index.php?title=LII:LIMSpec/Specialty_Laboratory_Functions#17._Production_management |publisher=LIMSwiki.org |accessdate=05 May 2023}}</ref><ref>{{Cite journal |last=Jayashree |first=B |last2=Reddy |first2=Praveen T |last3=Leeladevi |first3=Y |last4=Crouch |first4=Jonathan H |last5=Mahalakshmi |first5=V |last6=Buhariwalla |first6=Hutokshi K |last7=Eshwar |first7=Ke |last8=Mace |first8=Emma |last9=Folksterma |first9=Rolf |last10=Senthilvel |first10=S |last11=Varshney |first11=Rajeev K |date=2006-12 |title=Laboratory Information Management Software for genotyping workflows: applications in high throughput crop genotyping |journal=BMC Bioinformatics |language=en |volume=7 |issue=1 |pages=383 |doi=10.1186/1471-2105-7-383 |issn=1471-2105 |pmc=PMC1559653 |pmid=16914063}}</ref>:
*'''Manage stability studies''': From the pharmaceutical industry to the food and beverage industry, stability studies are an important specialty activity. These studies require careful statistical analysis, predictive modeling, sensory analysis, quantitative descriptive testing, discrimination testing, microbiology testing, and more. This translates to a need for a wide variety of analytical and visualization tools, as well as LIMS support for a wide variety of test methods and limits. A robust LIMS should have these abilities, but not all do.
*'''Manage recipes and formulations, as well as master and batch production records''': This functionality is more in the domain of the LES or manufacturing execution system (MES). However, a few LIMS vendors may extend their LIMS to provide these features. Given the Hazard Analysis and Critical Control Points (HACCP) rules of the food and beverage industry, as well as other master and batch record requirements for other regulated industries like the pharmaceutical industry, manufacturing labs testing batches and manufacturing materials may appreciate support in this regard.
*'''Support molecular biology workflows''': Molecular biology is an important tool in improving foods and beverages, ensuring the safety of pharmaceuticals, and meeting cannabis product testing requirements of state governments. However, not all LIMS are ideally equipped to handle related workflow aspects such as nucleic acid extraction, protein and cell isolation, and genotyping. A lab using such techniques may have to do extra due diligence in finding a manufacturing LIMS that also supports these workflow tasks.
*'''Take advantage of ELN functionality''':  Given the level of R&D to be found in manufacturing facilities, the ELN is a familiar companion to other informatics systems. A few LIMS vendors may have a built-in ELN with their LIMS or offer an ELN that comes readily integrated with the LIMS. Some elements of ELN functionality may even be found in a few solutions. At a minimum—and nodded to in the base functionality above—the LIMS should support ELN functionality through its ability to effectively connect to a third-party ELN.
*'''Develop regulatory-driven safety plans''': The HACCP quality control method is recommended or required for food and testing labs and is an influence on ISO/IEC 17025, which applies to many other manufacturing labs. Some LIMS vendors have recognized this and integrated support for building HACCP steps into laboratory workflows. In some cases this may be as sophisticated as allowing the user to diagram HACCP in their lab or facility as a visualization tool.
*'''Generate schedules for environmental monitoring/testing in the facility/lab''': While a LIMS can help assign and schedule a variety of laboratory tasks, broader organizational goals of testing the production environment on a scheduled, reportable basis may not be so straightforward, particularly without facility and sampling site management functionality that allows for highlighting specific test points in the facility. Even offsite or randomized testing may not be fully supported by a generic LIMS, requiring a LIMS flexible enough to compensate for the need for broader scheduled and randomized testing and retesting.
*'''Improve reaction time to non-conformances''': Many LIMS will have some basic form of non-conformance and incident management tools, but the robustness and extensibility of that functionality may be lacking. Can it send an SMS or email to the appropriate supplier in real-time when a pre-defined set of circumstances concerning that supplier's ingredients occurs? Can it re-prioritize or pause other related activities that are scheduled due to the identified non-conformance or incident? This is a useful area of functionality for the potential LIMS buyer to confirm with a vendor.
*'''Improve audit readiness and reporting''': A LIMS worth its weight will have a robust audit trail, to be sure. But can your LIMS help you audit your suppliers? Can it capture internal audit data on-demand and directly from the facility floor via mobile-friendly forms? Can HACCP- and audit-related data be flagged as such to make retrieval more efficient for audit purposes? These and other considerations may be important to a manufacturing facility, and not all LIMS for manufacturers can provide that functionality.
====3.1.3 Cybersecurity considerations====
[[File:Measuring cybersecurity.png|right|700px]]From law firms<ref name="SobowaleLaw17">{{cite web |url=http://www.abajournal.com/magazine/article/managing_cybersecurity_risk/ |title=Law firms must manage cybersecurity risks |author=Sobowale, J. |work=ABA Journal |publisher=American Bar Association |date=01 March 2017 |accessdate=05 May 2023}}</ref> to automotive manufacturers<ref name="WatneyAddress17">{{cite web |url=https://www.rstreet.org/wp-content/uploads/2018/04/118-1.pdf |format=PDF |title=Addressing new challenges in automotive cybersecurity |author=Watney, C.; Draffin, C. |work=R Street Policy Study No. 118 |publisher=R Street Institute |date=November 2017 |accessdate=05 May 2023}}</ref>, the need to address cybersecurity is increasingly apparent. In 2018, the Center for Strategic & International Studies estimated that cybercrime causes close to $600 billion in damages to the global economy every year<ref name="LewisEcon18">{{cite web |url=https://www.csis.org/analysis/economic-impact-cybercrime |title=Economic Impact of Cybercrime |author=Lewis, J.A. |publisher=Center for Strategic & International Studies |date=21 February 2018 |accessdate=05 May 2023}}</ref>, though due to underreporting of crimes, that number may be much higher. That number also likely doesn't take into account lost business, fines, litigation, and intangible losses<ref name="SBDCC_BlogCost17">{{cite web |url=https://www.virginiasbdc.org/blog-cost-of-cyber-crime-to-small-businesses/ |archiveurl=https://web.archive.org/web/20200705061737/https://www.virginiasbdc.org/blog-cost-of-cyber-crime-to-small-businesses/ |title=BLOG: Cost of Cyber Crime to Small Businesses |work=Virginia SBDC Blog |publisher=Virginia SBDC |date=30 May 2017 |archivedate=05 July 2020 |accessdate=05 May 2023}}</ref> In the end, businesses of all sizes average about $200,000 in losses due to a cybersecurity incident<ref name="HiscoxHiscox19&quot;">{{cite web |url=https://www.hiscox.com/documents/2019-Hiscox-Cyber-Readiness-Report.pdf |format=PDF |title=Hiscox Cyber Readiness Report 2019 |publisher=Hiscox Ltd |date=April 2019 |accessdate=05 May 2023}}</ref>, and nearly 60 percent of small and midsize businesses go bankrupt within six months because of it.<ref name="Galvin60_18">{{cite web |url=https://www.inc.com/joe-galvin/60-percent-of-small-businesses-fold-within-6-months-of-a-cyber-attack-heres-how-to-protect-yourself.html |title=60 Percent of Small Businesses Fold Within 6 Months of a Cyber Attack. Here's How to Protect Yourself |author=Galvin, J. |work=Inc.com |date=07 May 2018 |accessdate=05 May 2023}}</ref>
Manufacturing-based laboratories are no exception, regardless of business size. Even tiny labs whose primary digital footprint is a WordPress website advertising their lab are at risk, as hackers could still spread malware, steal user data, add the website to a bot network, hack the site for the learning experience, or even hack it just for fun.<ref name="GrimaTop19">{{cite web |url=https://www.wpwhitesecurity.com/why-malicious-hacker-target-wordpress/ |title=Top reasons why WordPress websites get hacked (and how you can stop it) |author=Grima, M. |publisher=WP White Security |date=15 June 2022 |accessdate=05 May 2023}}</ref><ref name="MoenWhatHack16">{{cite web |url=https://www.wordfence.com/blog/2016/04/hackers-compromised-wordpress-sites/ |title=What Hackers Do With Compromised WordPress Sites |author=Moen, D. |work=Wordfence Blog |publisher=Defiant, Inc |date=19 April 2016 |accessdate=05 May 2023}}</ref><ref name="TalalevWebsite19">{{cite web |url=https://patchstack.com/articles/website-hacking-statistics/ |title=Website Hacking Statistics You Should Know in 2022 |author=Talaleve, A. |publisher=Patchstack |date=22 February 2022 |accessdate=05 May 2023}}</ref> Even more importantly are those labs performing digital data management tasks that handle sensitive proprietary manufacturer data, requiring additional cybersecurity considerations.
A manufacturer and its associated laboratories can integrate cybersecurity thinking into its laboratory informatics product selection in several ways. First, the organization should have a cybersecurity plan in place, or if not, it should be on the radar. This is a good resource to tap into in regards to deciding what cybersecurity considerations should be made for the software. Can the software help your organization meet your cybersecurity goals? What regulatory requirements for your lab are or are not covered by the software?<ref name="DouglasComp20" /> Another tool to consider—which may have been used in any prior cybersecurity planning efforts—is a cybersecurity framework. Many, but not all, cybersecurity frameworks include a catalog of security controls. Each control is "a safeguard or countermeasure prescribed for an information system or an organization designed to protect the confidentiality, integrity, and availability of its information and to meet a set of defined security requirements."<ref name="NISTSecurity19">{{cite web |url=https://csrc.nist.gov/glossary/term/security_control |title=security control |work=Computer Security Resource Center |publisher=National Institute of Standards and Technology |date=2019 |accessdate=05 May 2023}}</ref> These controls give the implementing organization a concrete set of configurable goals to apply to their overall cybersecurity strategy. Other frameworks may be less oriented to security controls and more program-based or risk-based. Choosing the best frameworks will likely depend on multiple factors, including the organization's industry type, the amount of technical expertise within the organization, the budget, the organizational goals, the amount of buy-in from key organizational stakeholders, and those stakeholders' preferred approach.<ref name="DouglasComp20" />
Finally, having an organizational cybersecurity plan that incorporates one or more cybersecurity frameworks gives the laboratory ample opportunity to apply stated goals and chosen security controls to the evaluation and selection process for its informatics software. In particular, a user requirements specification (URS) that incorporates cybersecurity considerations will certainly help a laboratory with meeting regulatory requirements while also protecting its data systems. A USR that is pre-built with cybersecurity controls in mind—such as [[Book:LIMSpec 2022 R2|LIMSpec]], discussed later—makes the evaluation process even easier.
====3.1.4 Regulatory compliance considerations====
Without a doubt, it's vital that manufacturing-based laboratories operate within the bounds of a regulatory atmosphere, not only to better ensure the best consumer satisfaction outcomes but also to ensure the quality of analytical results, the safety of end users, and the promise of maintaining traceability across the manufacturing and distribution chain. Maintaining regulatory compliance requires deliberate approaches to developing and enforcing processes and procedures, quality training, consistent communication, and knowledgeable personnel. It also requires a top-down appreciation and commitment to a culture of quality. From ISO/TS 22002-1:2009 ''Prerequisite programmes on food safety — Part 1: Food manufacturing'' and ISO 10993-1:2018 ''Biological evaluation of medical devices — Part 1: Evaluation and testing within a risk management process'' to 21 CFR Part 175 and 176 (concerning the materials used to package food) and current good manufacturing practice (cGMP), laboratories have much to consider in regards to what standards and regulations impact them.
That said, consider approaching the question of regulatory compliance from the standpoint of adopting standards. Consider first that the risks and consequences of performing a task poorly drives regulation and, more preferably<ref name="CiocoiuTheRole10">{{cite book |chapter=Chapter 1. The Role of Standardization in Improving the Effectiveness of Integrated Risk Management |title=Advances in Risk Management |author=Ciocoui, C.N.; Dobrea, R.C. |editor=Nota, G. |publisher=IntechOpen |year=2010 |isbn=9789535159469 |doi=10.5772/9893}}</ref><ref name="JPMorganData18">{{cite web |url=https://www.jpmorganchase.com/content/dam/jpmc/jpmorgan-chase-and-co/documents/call-to-action.pdf |format=PDF |title=Data Standardization: A Call to Action |publisher=JPMorgan Chase & Co |date=May 2018 |accessdate=05 May 2023}}</ref>, standardization, which in turn moves the "goalposts" of quality and security among organizations. In the case of regulations, those organization that get caught not conforming to the necessary regulations tend to suffer negative consequences, providing some incentive for them to improve organizational processes and procedures.
One of the downsides of regulations is that they can at times be "imprecise" or "disconnected"<ref name="JPMorganData18" /> from what actually occurs within the organization and its information systems. Rather than focusing heavily on regulatory conformance, well-designed standards may, when adopted, provide a clearer path of opportunity for organizations to improve their operational culture and outcomes, particularly since standards are usually developed with a broader consensus of interested individuals with expertise in a given field.<ref name="CiocoiuTheRole10" /> In turn, the organizations that adopt well-designed standards likely have a better chance of conforming to the regulations they must, and they'll likely have more interest in maintaining and improving the goalposts of quality and security in the lab.
Additionally, reputable software developers of laboratory informatics software will not only adopt their own industry standards for software development but also understand the standards and regulations that affect manufacturing-based laboratories. In turn, the developed software should meet regulations and standards, help the laboratory comply with its regulations and standards, and be of reliably good quality.
If you're a potential buyer of a laboratory informatics solution, it may be that you know a bit about your laboratory's workflow and a few of the regulations and standards that influence how that workflow is conducted, but you're not entirely informed about all the regulations and standards that affect your lab. Turning to a URS such as LIMSpec—which was developed around laboratory regulations and standards—and reviewing the various statements contained within may be necessary to help further inform you. Additionally, as you investigate various informatics options, you can then use the requirements in the URS as a base for your laboratory's own requirements list. Using the categories and their subdivisions, you can then add those requirements that are unique to your laboratory and industry that are not sufficiently covered by the base URS. As you review the various options available to you and narrow down your search, your own list of requirements can be used as both as a personal checklist and as a requirements list you hand over to the vendor you query. And since your URS is based off the standards and regulations affecting your lab, you can feel more confident in your acquisition and its integration into your laboratory workflow.
====3.1.5 System flexibility====
Before selecting a solution, your laboratory should also have internal discussions about how diversified its offered services are, as well as what the future may bring to the lab. If, for example, your lab is currently configured for microbiological testing, does your existing laboratory informatics system—or the ones you may be considering—have the flexibility to add other types of testing, protocols, and workflows? Will you be doing the footwork to add them, or will the vendor of your system support you in that effort? If you're a start-up, will your lab be focusing solely on a specific type of testing and expand into other types of analytical work later, or will your test menu need to be much broader right from the start? In most of these cases, you'll desire a LIMS that is flexible enough to allow for not only running the specific tests you need now, but also sufficiently expandable for any future testing services your lab may conduct in the mid- and long-term. Having the ability to create and customize [[Sample (material)|sample]] registration screens, test protocols, labels, reports, specification limit sets, measurement units, and substrates/matrices while being able to interface with practically most any instrument and software system required will go a long way towards making your expanding test menu and workflows integrates as smoothly as possible.
Such a system will typically be marketed as being highly user-configurable, giving labs a relatively painless means to adapt to rapid changes in test volume and type over time. However, once you've internally addressed current and anticipated future growth, your lab will want to learn what explicitly makes any given vendor's system user-configurable. How easy is it to configure the system to new tests? Add custom reports? What knowledge or skills will be required of your lab in order to make the necessary changes, i.e., will your staff require programming skills, or are the administrator and advanced user functions robust enough to make changes without hard-coding? These and other such questions should be fully addressed by the vendor in order to set your mind at ease towards a system's stated flexibility. Ultimately, you want the system to be flexible enough to change with the laboratory—and industry—itself, while minimizing overall costs and reducing the time required to make any necessary modifications.
====3.1.6 Cost considerations====
[[File:Lies-pound-yen-euro-dollar.png|right|300px]]First, you'll want to be clear on what will be included in the sales agreement. Whether through an estimate or statement of work (SOW), it is important it includes exactly what is expected, being as specific as possible, since this will be the entire contractual obligation for both you the buyer and them the vendor. Note that line items may differ slightly from system to system, according to what features and functions are included by default with each vendor's solution and which, if any, are additional. Also keep in mind that any hourly amount in the the estimate or SOW is usually a best estimate; however, if sufficient attention to detailed requirements has been given, then it should be quite accurate, and in fact the final cost may even be below the quoted cost if you prioritize your own obligations so that the vendor's hours are used sparingly and efficiently.
The estimate or SOW should optimally include:
*licensing or subscription rates;
*required core items to meet federal, state, and local regulations;
*additional optional items and totals; and
*required services (implementation, maintenance and support, optional add-ons).
There are two primary ways to price a laboratory informatics solution: a one-time license fee or a subscription rate ([[Cloud computing|cloud-hosted]] SaaS). If you have your own dedicated IT department and staff, you may prefer the former (although many system administrators are just as happy to let it be hosted elsewhere rather than add to their workload). Otherwise, a SaaS subscription may well be the better and more cost-effective way to go (since the primary IT cost is simply internet access). This item will be part of your up-front cost and, in the case of subscription, it will also figure into your first year and ongoing costs; otherwise only associated maintenance, support, and warranty (MSW) will figure in. Typically, your first year's subscription costs will be due at signing. More often, the vendor may require three months or even the first year up front, so be prepared to factor that into up-front costs. However, it still is almost always less expensive at the outset (and over time, if you factor in IT costs and annual MSW) than paying for a license fee.
In addition to the two types of software pricing, there are also sub-types. Generally these are based on the number of users (or, in some cases, "nodes," which are simply any entities that access the informatics system, including other systems, instruments, etc.). How these are counted can vary.
*Named users: This method bases pricing on the actual individual users of the system, even if they only log in sporadically. Users may not use each other's logins (this is a no-no regardless of pricing structure, for good laboratory practice and other regulatory reasons).
*Concurrent users: This bases pricing on the maximum number of users who will be logged in at any given time. You can define an unlimited number of named users in the system, each with their own login credentials. However, only the number of concurrent users specified in the license or subscription may be logged in at any one time. For example, you may have 10 staff, but due to work processes, shifts, etc., only up to six might ever be logged in simultaneously. Whereas this would require a named user license for 10, it would only require a concurrent user license for six.
*Unlimited users: In the case of very large labs (typically 30 to 50 and up), the license or subscription may simply be a flat fee that allows any number of users.
The line items in the estimate or SOW should reflect these nuances, as well as whether the listed costs are monthly or annual (for subscription services), hourly (typically for support and training), or a fixed one-time cost. Additionally, be cautious with fixed costs, as they typically represent one of two possible scenarios:
#Final fixed cost: In this case, the cost has been figured by the vendor so as to cover their worst-case hourly labor total. If a line item (e.g., an interface) is not "worst case," then you are overpaying.
#"Expandable" fixed cost: This is as bad as final fixed cost, and maybe even worse because it's almost a case of "bait-and-switch," popping up as a surprise. The initial "fixed cost" number is low, and additional hourly services are needed to actually deliver the item. This will have been provided for somewhere in the small print.
The bottom line is that everything in a laboratory informatics solution is really either licensing or hourly services. Just be careful if they are portrayed as anything else.
It is important to be clear which category each line item falls under when figuring costs: up-front (due upon signing), annual, or ongoing (e.g., SaaS subscription). It is useful to clearly lay out each and compute initial costs, as well as first-year and subsequent years' costs. For example, your initial obligation may be as little as your first year's subscription plus the first 40 hours of services. Different vendors have different policies, however, and you may be required to pay for your first full year's subscription and all services, or some other combination. Normally, though, any instrument interface or other service charges aren't due until they are implemented, which may be a few weeks or even a month down the road. This may depend on your budget, complexity of the SOW, and urgency. Your first year's expenses will include everything, including initial license fees; all setup and training; any interfaces and additional configurations or customization; and first annual MSW. (If this isn't included in the SaaS subscription, then it usually commences on full system delivery). Afterwards, your subscription and MSW will be the only ongoing expenses (included as one in this example), unless you choose to have additional interfaces or other services performed at any time.
===3.2 Implementation===
If you've ever worked through a system implementation process with a vendor, it was hopefully a smooth process. However, there are plenty of horror stories out there, highlighting the need of the laboratory to discuss in detail how a potential vendor will handle installation, validation, and training for the informatics solution. Does the vendor truly understand the industry and your needs? Does the vendor assign a project manager who will work with you, from planning to go-live and beyond? Can they offer you references of other labs who have gone through implementation so you can compare notes with those labs? How much attention does the potential vendor give to related issues such as data integrity of migrated data? Do they have the means to properly handle your legacy data? And are they able to work with your schedule, even if it means implementing software at off-peak work hours?<ref name="Wagner7Soft19">{{cite web |url=https://blog.walkme.com/7-software-implementation-challenges/ |title=7 Software Implementation Challenges and How to Solve Them |author=Wagner, M. |work=WalkMe Blog |publisher=WalkMe Ltd |date=10 October 2019 |accessdate=05 May 2023}}</ref><ref name="MuraBullet18">{{cite web |url=https://www.userlane.com/software-implementation-plan/ |archiveurl=https://web.archive.org/web/20210418093657/https://www.userlane.com/software-implementation-plan/ |title=Bullet-Proof Software Implementation Plan: Challenges and Tactics |author=Mura, A. |work=Userlane Digital Adoption Blog |publisher=Userlane GmbH |date=12 July 2018 |archivedate=18 April 2021 |accessdate=05 May 2023}}</ref>
As you finally get down to the ultimate decision on which vendor to work with, you may wish to start setting up an implementation checklist as part of your early project planning. Do you receive a help desk account as part of the implementation process, and if so, what information is included? If not, you'll need to keep track of specific details such as business associate agreement (BAA), sales agreement, scope documents, welcome letters, documentation, and approved staff who can utilize the vendor's support. You'll likely need to share other configuration details with the vendor, including time zone requirements, DNS and URL requirements, up-time monitors, and administrative account requirements. Finally, you'll want to ensure you and the vendor are on the same page concerning any additional customization, integration, and system validation requirements, ensuring the roll-out period is pain-free and efficient.
====3.2.1 Internal and external integrations====
Manufacturing-based labs acquire data management software for many reasons, including improving accuracy, saving time, increasing productivity, and adding capabilities. One way of doing all of those activities is to integrate or interface the manufacturer's systems, databases, and instruments so that human error is greatly reduced or eliminated, workflows are automated and sped up, and each component's capabilities are brought into play in the most efficient and effective ways possible. In the world of manufacturing, choosing what gets integrated makes for a challenging decision, however, given the other systems that may be at work in the organization. Other systems that may used in the manufacturing enterprise include:
*manufacturing execution systems (MES)
*quality management systems (QMS)
*[[Enterprise resource planning|enterprise resource planning systems]] (ERP)
*[[SCADA|supervisory control and data acquisition systems]] (SCADA)
*statistical process control systems (SPC)
*product life cycle management systems (PLM)
*distributed control systems (DCS)
These systems all have their strengths within the manufacturing enterprise but typically lack functionality necessary for laboratory processes. Not all systems need to be integrated with a laboratory system like a LIMS, but some may benefit, for example with the MES and QMS.<ref name=":0" /><ref name="McDonaldKey23">{{cite web |url=https://www.thermofisher.com/blog/connectedlab/key-differences-between-mes-and-lims-in-battery-qa/ |title=Key differences between MES and LIMS in battery QA |author=McDonald, J. |work=The Connected Lab |publisher=Thermo Fisher Scientific |date=05 April 2023 |accessdate=05 May 2023}}</ref><ref name="BecksImplem21">{{cite web |url=https://purl.utwente.nl/essays/87515 |title=Implementation of MES at Small EMS Providers |author=Becks, M.B. |publisher=University of Twente |date=2021 |accessdate=05 May 2023}}</ref><ref name="SIAutomate23">{{cite web |url=https://soft-industry.com/blog/lims-in-mes/ |title=Automate Production Even More: Laboratory Management Information Systems (LIMS) in Manufacturing Execution System (MES) |work=Soft Industry Blog |publisher=Soft Industry |date=21 February 2023}}</ref> As such, you'll want to inquire with the vendor about its solution's hardware and software integration capabilities. Is it designed to interface with every laboratory instrument or software that can output any readable electronic file? Or are integrations limited to certain instruments and systems? How does it connect, i.e., what protocols does the software depend on to connect with other systems? Does the system allow a user to map their own file imports and exports? Can system processes be set to detect new instances of file outputs at regular intervals? Ask these and other questions to make sure the vendor clearly describes what internal and external integrations are supported with their application.
In many cases, a vendor's LIMS solution will have instrument integration capability built into the software, but occasionally such interfaces are separate from the main software. Today's instrument interfaces are generally built on standardized communication protocols such as RS-232, RS-422, IEEE-488 (GPIB), USB, Ethernet, and more.<ref name="WilliamsComp">{{cite web |url=https://newton.ex.ac.uk/teaching/CDHW/Interfaces/ |title=Computer Interfaces for Instrumentation Systems |author=Williams, C.D.H. |publisher=University of Exeter |accessdate=05 May 2023}}</ref> The LIMS that can support such instrument integrations is increasingly vital to the manufacturing-based laboratory. Manufacturing labs may also want their laboratory informatics solution to be able to communicate with other software and databases. This is often done using [[application programming interface]]s (APIs) that depend on web services implementation protocols such as REST and SOAP.<ref name="MonusSOAP19">{{cite web |url=https://raygun.com/blog/soap-vs-rest-vs-json/ |title=SOAP vs REST vs JSON - a 2023 comparison |author=Monus, A. |work=Raygun |date=17 October 2022 |accessdate=05 May 2023}}</ref><ref name="LVAQuick18">{{cite web |url=https://www.labvantage.com/a-quick-guide-to-lims-web-services/ |title=A Quick Guide to LIMS Web Services |author=LabVantage Solutions |publisher=LabVantage Solutions, Inc |date=07 January 2018 |accessdate=05 May 2023}}</ref><ref name="GrandOneTool19">{{cite journal |title=One tool to find them all: A case of data integration and querying in a distributed LIMS platform |journal=Database |author=Grand, A.; Geda, E.; Mignone, A. et al. |volume=2019 |page=baz004 |year=2019 |doi=10.1093/database/baz004}}</ref> These messaging protocols actually allow for the creation of an API that receives communication requests and sends responses between two software systems. A more practical example is wanting your laboratory informatics solution to communicate with an [[enterprise resource planning]] (ERP) application. Perhaps the ERP system needs to create sample batches within the informatics solution, and when testing is done, have the results returned to the ERP. APIs and communication protocols make this happen.<ref name="LVAQuick18" />
===3.3 MSW, updates, and other contracted services===
[[File:Warranty (267038) - The Noun Project.svg|left|200px]]The MSW offered with the vendor's solution is almost as important as the solution itself. The laboratory informatics solution you acquire is more than than the software you operate: it's mission-critical and deserves having a reliable and responsive team with the necessary resources to ensure it remains operational. Downtime can negatively affect both immediate customer satisfaction and your reputation. As such, it's imperative you ask the vendor about the details of its MSW, making sure you understand what is and isn't covered, as well as how much it will cost. Cost-wise, industry norms are anywhere from 15% to 25% of either the license fee or total contract, levied annually to provide this coverage.<ref name="ScavoHigh05">{{cite web |url=https://www.computereconomics.com/article.cfm?id=1033 |archiveurl=https://web.archive.org/web/20221115005436/https://www.computereconomics.com/article.cfm?id=1033 |title=High Software Maintenance Fees and What to Do About Them |author=Scavo, F. |work=Computer Economics |date=08 February 2005 |archivedate=15 November 2022 |accessdate=05 May 2023}}</ref> Alternatively, it may simply be included with your subscription. The MSW will include a specified number of support and maintenance hours or guarantees. The actual warranty should be unlimited for as long as the MSW or subscription is kept current.
Maintenance includes any and all work necessary to keep your system working as designed. It should include updates, patches, or fixes, and most if not all upgrades. (Note, however, a major upgrade to a totally new edition may not be covered, but it may come at a negotiable, significantly lower cost.<ref name="Gordon-ByrneMaint14">{{cite web |url=http://www.ittoday.info/ITPerformanceImprovement/Articles/2014-08GordonByrne2.html |archiveurl=https://web.archive.org/web/20210505220938/http://www.ittoday.info/ITPerformanceImprovement/Articles/2014-08GordonByrne2.html |title=Maintenance in the Digital World |author=Gordon-Byrne, G. |work=IT Performance Improvement |publisher=Taylor & Francis, LLC |date=2014 |archivedate=05 May 2021 |accessdate=05 May 2023}}</ref>) The support aspect of MSW generally consists of a specified number of hours dedicated more to helping you with the operation of the system rather than "fixing" anything. Support includes guidance on training, password or login support, and more. Finally, with any professional application you also expect to have a warranty. The warranty should cover anything that doesn't work that otherwise should for the designated period of time.<ref name="Gordon-ByrneMaint14" /> That includes any standard features and functions, as well as any additional ones that were delivered and signed off on, and any other work performed by the vendor or its representatives. However, a typical warranty does not cover anything that was working fine, but upon being manipulated in a way beyond normal operation the functionality ceased. In these cases, you'll probably have to pay to get it fixed.
Beyond the MSW, additional updates and services related to the system may also be required. No matter how well it is pre-configured, any professional laboratory informatics solution will require some amount of standard setup to reflect your particular lab. This includes adding lab branding and demographics for reports and certificates; entering users, their roles, and access permissions; adding and/or modifying tests and workflows; renaming fields; adding or hiding fields; setting up a web portal; and implementing interfaces. Equally indispensable is proper training for both users and administrators. And of course you may later find that you would like additional features or functions. These and other services may prove particularly useful to the laboratory with little in the way of IT and systems expertise. As such, the vendor may provide one or more of the following as a billable service for the laboratory:
*initial implementation meeting (e.g., initial planning, identify delta, set schedule)
*project management
*requirements gathering and documentation
*initial setup
*user and administrator training
*configuration and customization
*interface development and implementation
*custom screen and field development
*custom functionality development
*custom reports and labels
*custom triggers and alerts
*validation or acceptance testing (to a third-party standard or certification, or to agreed manufacturer specs)
===3.4 How a user requirements specification fits into the entire process (LIMSpec)===
Merriam-Webster defines a "specification" as "a detailed precise presentation of something or of a plan or proposal for something."<ref name="MWSpec">{{cite web |url=https://www.merriam-webster.com/dictionary/specification |title=specification |work=Merriam-Webster |publisher=Merriam-Webster, Inc |accessdate=05 May 2023}}</ref> In other words, an existing or theoretical product, concept, or idea is presented in detail for a particular audience. In a broad sense, detailing the specifics about a project, concept, or idea to others is just common sense. This applies just as well to the world of software development, where a software requirements specification is essential for preventing the second most commonly cited reason for project failure: poor requirements management.<ref name="BiegRequire14">{{cite web |url=https://www.pmi.org/-/media/pmi/documents/public/pdf/learning/thought-leadership/pulse/requirements-management.pdf |format=PDF |title=Introduction |work=Requirements Management: A Core Competency for Project and Program Success |author=Bieg, D.P. |publisher=Project Management Institute |page=3 |date=August 2014 |accessdate=05 May 2023}}</ref>
In fact, the ISO/IEC/IEEE 29148:2018 standard (a conglomeration of what was formerly IEEE 830 and other standards) is in place to help specify "the required processes implemented in the engineering activities that result in requirements for systems and software products" and provide guidelines for how to apply those requirements.<ref name="ISO29148">{{cite web |url=https://www.iso.org/standard/72089.html |title=ISO/IEC/IEEE 29148:2018 |publisher=International Organization for Standardization |date=November 2018 |accessdate=05 May 2023}}</ref> The standard describes the characteristics that make up quality software requirement development, including aspects such as<ref name="SeibertHowDoYou11">{{cite web |url=https://hubtechinsider.wordpress.com/2011/07/28/how-do-you-write-software-requirements-what-are-software-requirements-what-is-a-software-requirement/ |title=How do you write software requirements? What are software requirements? What is a software requirement? |work=HubTechInsider |author=Seibert, P. |date=28 July 2011 |accessdate=05 May 2023}}</ref>:
*correctly describing system behavior;
*effectively removing ambiguity from the language used;
*completely covering the system behavior and features;
*accurately prioritizing and ranking the requirements; and
*unequivocally ensuring the requirements are testable, modifiable, and traceable.
A requirement typically comes in the form of a statement that begins with "the system/user/vendor shall/should ..." and focuses on a provided service, reaction to input, or expected behavior in a given situation. The statement may be abstract (high-level) or specific and detailed to a precise function. The statement may also be of a functional nature, describing functionality or services in detail, or of a non-functional nature, describing the constraints of a given functionality or service and how it's rendered. An example of a functional software requirement could be "the user shall be able to query either all of the initial set of databases or select a subset from it." This statement describes specific functionality the system should have. On the other hand, a non-functional requirement, for example, may state "the system's query tool shall conform to the ABC 123-2014 standard." The statement describes a constraint placed upon the system's query functionality.
This is where a requirements specification shines, not only for the software developer but also for those acquiring the software. A set of development requirements, compiled in the form of a software requirements specification, can serve to strengthen the software development process. For those acquiring the software, a set of user requirements, compiled in the form of a URS, can be used for the selection and acquisition of software or a service.<ref name="MemonSoftware10">{{cite web |url=https://www.cs.umd.edu/~atif/Teaching/Spring2010/Slides/3.pdf |format=PDF |title=Software Requirements: Descriptions and specifications of a system |author=Memon, A. |publisher=University of Maryland |date=Spring 2010 |accessdate=05 May 2023}}</ref><ref name="SchmittUser18">{{cite journal |title=User Requirements Specifications–How Difficult Can It Be? |journal=Pharmaceutical Technology |author=Schmitt, S. |volume=42 |issue=11 |page=58 |year=2018 |url=https://www.pharmtech.com/view/user-requirements-specifications-how-difficult-can-it-be-0 |accessdate=05 May 2023}}</ref> In the case of the URS, the acquiring business can approach this several ways. The simple way would be to essentially take the vendor at the word in regards to what they say their system can and can't do, agreeing formally to their description and taking responsibility that it will cover all the applicable regulations required by your business. However, this method isn't comprehensive and leaves the business open to not being able to fully meet its goals.<ref name="SchmittUser18" />
The other method has the URS be specific to your business' needs. The process is more work but leaves less to chance.<ref name="SchmittUser18" /> Developing your own URS isn't always straightforward. Often times, the developed document turns into a mix of "wishlist" requirements from potential and active clients, as well as regulation-mandated requirements. The wishlist items aren't necessarily ignored by developers, but the URS should in fact clearly prioritize requirements as "nice to have" or "essential to system operation," or something in between.<ref name="AasemAnalysis10">{{cite journal |title=Analysis and optimization of software requirements prioritization techniques |author=Aasem, M.; Ramzan, M.; Jaffar, A. |journal=Proceedings from the 2010 International Conference on Information and Emerging Technologies |pages=1–6 |year=2010 |doi=10.1109/ICIET.2010.5625687}}</ref><ref name="Hirsch10Steps13">{{cite web |url=https://www.phase2technology.com/blog/successful-requirements-gathering |title=10 Steps To Successful Requirements Gathering |author=Hirsch, J. |publisher=Phase2 Technology, LLC |date=22 November 2013 |accessdate=05 May 2023}}</ref><ref name="BurrissSoftware07">{{cite web |url=http://sce2.umkc.edu/BIT/burrise/pl/requirements/ |archiveurl=https://web.archive.org/web/20190925003040/http://sce2.umkc.edu/BIT/burrise/pl/requirements/ |title=Requirements Specification |work=CS451R, University of Missouri–Kansas City |author=Burris, E. |publisher=University of Missouri–Kansas City |date=2007 |archivedate=25 September 2019 |accessdate=05 May 2023}}</ref> Whatever the URS looks like in the end, it's ultimately up to the vendor to be able to demonstrate how the software does and does not meet its requirements.
In the latter half of this guide, you'll be given an opportunity to see an example of a URS for the manufacturing industry in the form of LIMSpec, an evolving set of software requirements specifications for laboratory informatics systems. Built from requirements found in [[ASTM E1578|ASTM E1578-18]] ''Standard Guide for Laboratory Informatics'', as well as dozens of other standards and regulations, we will use LIMSpec to demonstrate how a URS can be put to use, while also showing you how an informatics system can help you laboratory better meet regulatory requirements.
==References==
{{Reflist|colwidth=30em}}

Revision as of 22:20, 16 May 2023

Sandbox begins below