CN116148384A - Domestic LIMS and domestic HPLC data sharing method - Google Patents
Domestic LIMS and domestic HPLC data sharing method Download PDFInfo
- Publication number
- CN116148384A CN116148384A CN202310016598.2A CN202310016598A CN116148384A CN 116148384 A CN116148384 A CN 116148384A CN 202310016598 A CN202310016598 A CN 202310016598A CN 116148384 A CN116148384 A CN 116148384A
- Authority
- CN
- China
- Prior art keywords
- lims
- hplc
- data
- domestic
- information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G01—MEASURING; TESTING
- G01N—INVESTIGATING OR ANALYSING MATERIALS BY DETERMINING THEIR CHEMICAL OR PHYSICAL PROPERTIES
- G01N30/00—Investigating or analysing materials by separation into components using adsorption, absorption or similar phenomena or using ion-exchange, e.g. chromatography or field flow fractionation
- G01N30/02—Column chromatography
-
- G—PHYSICS
- G01—MEASURING; TESTING
- G01N—INVESTIGATING OR ANALYSING MATERIALS BY DETERMINING THEIR CHEMICAL OR PHYSICAL PROPERTIES
- G01N30/00—Investigating or analysing materials by separation into components using adsorption, absorption or similar phenomena or using ion-exchange, e.g. chromatography or field flow fractionation
- G01N30/02—Column chromatography
- G01N30/86—Signal analysis
- G01N30/8651—Recording, data aquisition, archiving and storage
- G01N30/8655—Details of data formats
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/02—Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]
Landscapes
- Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Life Sciences & Earth Sciences (AREA)
- Chemical & Material Sciences (AREA)
- Analytical Chemistry (AREA)
- Biochemistry (AREA)
- General Health & Medical Sciences (AREA)
- General Physics & Mathematics (AREA)
- Immunology (AREA)
- Pathology (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Description
技术领域technical field
本发明涉及一种国产LIMS与国产HPLC数据共享方法,属于数据共享技术领域。The invention relates to a domestic LIMS and domestic HPLC data sharing method, belonging to the technical field of data sharing.
背景技术Background technique
实验室信息管理系统(LIMS)是检验检测实验室主流信息化管理平台,仪器数据采集是保证检验结果可靠性、可溯源性的重要技术。高效液相色谱(HPLC)是检验检测实验室常见的分离分析仪器,其检测结果包括结构化数据以及基于结构化数据生成的色谱检测报告。Laboratory Information Management System (LIMS) is the mainstream information management platform for inspection and testing laboratories. Instrument data collection is an important technology to ensure the reliability and traceability of inspection results. High-performance liquid chromatography (HPLC) is a common separation and analysis instrument in inspection and testing laboratories. Its test results include structured data and chromatographic test reports generated based on structured data.
目前进口液相色谱工作站只提供色谱检测报告,不提供结构化数据,国产LIMS只能通过解析程序将PDF格式的色谱检测报告,解析为结构化数据,然后再用于国产LIMS的电子原始记录(ELN)。国产液相色谱工作站存在同样的问题,不提供结构化数据,只提供色谱检测报告,国产LIMS亦不能与其实现底层数据对接,与进口仪器的区别在于,国产HPLC供应商愿意配合开放底层数据接口,提供结构化数据。At present, imported liquid chromatography workstations only provide chromatographic test reports and do not provide structured data. Domestic LIMS can only parse the chromatographic test report in PDF format into structured data through the analysis program, and then use it for electronic original records of domestic LIMS ( ELN). Domestic liquid chromatography workstations have the same problem. They do not provide structured data, but only chromatographic test reports. Domestic LIMS cannot realize the underlying data connection with it. The difference from imported instruments is that domestic HPLC suppliers are willing to cooperate with open underlying data interfaces. Provide structured data.
PDF格式色谱检测报告,在解析的过程中,容易出现解析错误,且对于整个数据流转过程来说,从HPLC结构化数据→色谱检测报告→PDF解析→结构化数据ELN应用,实质上人为增加了PDF生成与解析的过程,既浪费了资源、降低了效率,还易于产生错误,这也是实践工作中LIMS运维的主要故障来源。Chromatography test report in PDF format is prone to analysis errors during the analysis process, and for the entire data transfer process, from HPLC structured data → chromatogram test report → PDF analysis → structured data ELN application, in essence, artificially increased The process of PDF generation and parsing not only wastes resources, reduces efficiency, but is also prone to errors, which is also the main source of failures in LIMS operation and maintenance in practice.
HPLC-LIMS底层结构化数据直接对接,避免了PDF色谱检测报告生成与解析带来的弊端,但为了符合检验检测行业多年以来的惯例或技术标准要求,本方法在实现结构化数据直接对接的同时,PDF色谱检测报告仍然作为LIMS附件进行非结构化数据的传递。The direct docking of the underlying structured data of HPLC-LIMS avoids the disadvantages caused by the generation and analysis of the PDF chromatographic test report. , the PDF chromatographic test report is still used as a LIMS attachment for unstructured data delivery.
发明内容Contents of the invention
本发明目的是提供了一种国产LIMS与国产HPLC数据共享方法,能够实现信息的共享、数据的可追溯,避免了数据解析易于出错的弊端。The purpose of the present invention is to provide a domestic LIMS and domestic HPLC data sharing method, which can realize information sharing and data traceability, and avoid the disadvantages of error-prone data analysis.
本发明为实现上述目的,通过以下技术方案实现:In order to achieve the above object, the present invention is achieved through the following technical solutions:
一种国产LIMS与国产HPLC数据共享方法,包括以下步骤:A domestic LIMS and domestic HPLC data sharing method, comprising the following steps:
S1. LIMS的检品信息生成:S1. LIMS inspection information generation:
实验人员登陆LIMS,点选液相推送、选择样品、检验项目信息,存入待推送检品信息库;The experimenter logs in to LIMS, clicks on the liquid phase push, selects the sample, and the inspection item information, and saves it in the inspection product information database to be pushed;
S2. LIMS的检品信息推送:S2. LIMS inspection information push:
实验人员登陆LIMS,选择待推送检品,点选仪器后,待推送检品信息从LIMS向指定HPLC传送;The experimenter logs in to LIMS, selects the test product to be pushed, and after clicking on the instrument, the information of the test product to be pushed is sent from LIMS to the designated HPLC;
S3. HPLC的检测信息接收:S3. HPLC detection information reception:
实验人员登陆HPLC,将LIMS推送样品信息,点选入待进样检品库;The experimenter logs in to the HPLC, pushes the sample information to the LIMS, and clicks to enter the library of samples to be imported;
S4.HPLC的检测结果生成:The detection result of S4.HPLC is generated:
实验人员登陆HPLC,点选待进样检品开始进样,进样完毕,将结果自动存储到数据存储库;The experimenter logs in to the HPLC, clicks on the sample to be injected and starts to inject the sample. After the sample is injected, the result is automatically stored in the data repository;
S5.HPLC的检测结果推送:S5.HPLC test result push:
实验人员登陆HPLC,将HPLC存储库底层数据处理生成报告,将结构化数据及报告按预设格式,由HPLC传送到LIMS;The experimenters log in to the HPLC, process the underlying data of the HPLC repository to generate a report, and transmit the structured data and report to the LIMS from the HPLC according to the preset format;
S6.LIMS的检测结果接收应用:S6.LIMS test result receiving application:
实验人员登陆LIMS,选择样品,选择HPLC推送结构化数据及色谱检测报告,合成ELN并生成检验报告,自此整个对接过程结束。The experimenter logs into LIMS, selects the sample, selects HPLC to push the structured data and chromatographic test report, synthesizes ELN and generates the test report, and the whole docking process ends from then on.
所述国产LIMS与国产HPLC数据共享方法优选方案,HPLC存储库数据包括系统适用性试验数据、平行实验数据、样品检测数据、标准曲线数据,以上数据为结构性数据;以及色谱检测报告等非结构化数据。The preferred scheme of the domestic LIMS and domestic HPLC data sharing method, the HPLC repository data includes system suitability test data, parallel experiment data, sample detection data, standard curve data, the above data are structural data; and non-structural data such as chromatographic detection reports data.
所述国产LIMS与国产HPLC数据共享方法优选方案,LIMS用户端、HPLC工作站分别通过楼层交换机、核心交换机与LIMS应用服务器连接,并通过HPLC的IP地址锁定通讯。In the preferred scheme of the domestic LIMS and domestic HPLC data sharing method, the LIMS client and HPLC workstation are respectively connected to the LIMS application server through the floor switch and the core switch, and lock the communication through the IP address of the HPLC.
本发明的优点在于:The advantages of the present invention are:
1.与应用解析软件对PDF解析后应用数据比较,底层结构化数据的自动传输,不会出现解析误差,能够溯源,更符合合规性要求。1. Compared with the application data after PDF analysis by application analysis software, the automatic transmission of the underlying structured data will not cause analysis errors, can be traced back, and is more in line with compliance requirements.
2.与采用仪器出厂编号关联相比,采用仪器局域网ID匹配仪器,通过LIMS仪器管理模块事前维护仪器局域网ID与楼层交换机写死策略,通讯方式相当于专线,不会出现传输错误。2. Compared with the association of the factory number of the instrument, the instrument LAN ID is used to match the instrument, and the instrument LAN ID and the floor switch are maintained in advance through the LIMS instrument management module. The communication method is equivalent to a dedicated line, and there will be no transmission errors.
ID匹配仪器为本方法独创,适用于多台仪器存在同一网络时的仪器定位。对于楼层交换机来讲,常规的配置策略是自动匹配,只要是主机位中1~255未被占用,都可以选择,写死策略是指把某个仪器人为指定主机位中的某个数字。将多台仪器对应的ID等静态数据事前维护入LIMS仪器管理模块,便可以将仪器与ID关联,在LIMS中选择某台仪器时,自动匹配该台仪器关联的ID,从而实现与仪器的专线通讯,不会出现通讯不畅的现象。ID matching instrument is the original method of this method, which is suitable for instrument positioning when multiple instruments exist in the same network. For floor switches, the conventional configuration strategy is automatic matching, as long as 1 to 255 in the host position is not occupied, it can be selected. The hard-coded strategy refers to artificially specifying a certain number in the host position for a certain instrument. Maintain static data such as IDs corresponding to multiple instruments into the LIMS instrument management module in advance, and then you can associate the instrument with the ID. When you select an instrument in LIMS, it will automatically match the ID associated with the instrument, thereby realizing a dedicated line with the instrument Communication, there will be no poor communication.
LIMS与仪器的通讯,先后尝试过使用仪器出厂编号、仪器序列号、检品编号、院内仪器编号等作为唯一性标识进行连接,要么无法实现、要么不稳定,最后尝试采用ID绑定仪器,既可以建立连接、又稳定。The communication between LIMS and instruments has tried to use the instrument factory number, instrument serial number, inspection product number, hospital instrument number, etc. A connection can be established and is stable.
3. 结构化数据以及作为附件的PDF色谱检测报告,都实现了数据共享,ELN合成方便快捷,不用重复录入数据,提高了工作效率,降低了服务器负担与数据冗余。3. Both the structured data and the PDF chromatographic test report as an attachment have realized data sharing. The ELN synthesis is convenient and fast, and there is no need to repeatedly enter data, which improves work efficiency and reduces server burden and data redundancy.
附图说明Description of drawings
附图用来提供对本发明的进一步理解,并且构成说明书的一部分,与本发明的实施例一起用于解释本发明,并不构成对本发明的限制。The accompanying drawings are used to provide a further understanding of the present invention, and constitute a part of the description, and are used together with the embodiments of the present invention to explain the present invention, and do not constitute a limitation to the present invention.
图1为本发明LIMS用户端与HPLC工作站通信示意图。Fig. 1 is a schematic diagram of the communication between the LIMS client and the HPLC workstation of the present invention.
具体实施方式Detailed ways
下面将结合本发明实施例中的附图,对本发明实施例中的技术方案进行清楚、完整地描述,显然,所描述的实施例仅仅是本发明一部分实施例,而不是全部的实施例。基于本发明中的实施例,本领域普通技术人员在没有做出创造性劳动前提下所获得的所有其他实施例,都属于本发明保护的范围。The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.
本发明将LIMS与HPLC的底层数据互联整个过程分解为检品信息生成、接收,检测结果生成、推送与接收,检验结果生成等6部分,实现了信息的共享、数据的可追溯,避免了数据解析易于出错的弊端。The present invention decomposes the whole process of LIMS and HPLC underlying data interconnection into 6 parts, including inspection information generation and reception, inspection result generation, push and reception, and inspection result generation, so as to realize information sharing and data traceability, and avoid data Parse error-prone drawbacks.
一种国产LIMS与国产HPLC数据共享方法,包括以下步骤:A domestic LIMS and domestic HPLC data sharing method, comprising the following steps:
S1. LIMS的检品信息生成:S1. LIMS inspection information generation:
实验人员登陆LIMS,将选液相推送、选择样品和选择检验项目信息存入待推送检品信息库,该步骤支持样品、检验项目的单选与多选;The experimenters log in to LIMS, and store the information of liquid phase push, sample selection and test item selection in the information database of test items to be pushed. This step supports single and multiple selection of samples and test items;
S2. LIMS的检品信息推送:S2. LIMS inspection information push:
实验人员登陆LIMS,将待推送检品信息、选样品和选仪器信息从LIMS向HPLC的传送,该步骤支持样品的单选与多选,包含检验项目信息;The experimenter logs in to LIMS, and transmits information about the product to be pushed, sample selection and instrument selection from LIMS to HPLC. This step supports single-selection and multiple-selection of samples, including inspection item information;
S3. HPLC的检测信息接收:S3. HPLC detection information reception:
实验人员登陆HPLC,将样品信息输入待进样检品库,实验人员使用自己的账号、密码,只能选择自己的LIMS账号、密码发送信息,且该步骤支持单选与多选;The experimenter logs in to the HPLC and enters the sample information into the sample library to be imported. The experimenter uses his own account number and password, and can only choose his own LIMS account number and password to send information, and this step supports single selection and multiple selection;
S4.HPLC的检测结果生成:The detection result of S4.HPLC is generated:
实验人员登陆HPLC,进样完毕,将结果自动存储到数据存储库,数据存储库数据包括系统适用性试验数据、平行实验数据、样品检测数据、标准曲线数据,以上数据为结构性数据;The experimenters log in to the HPLC, and after the sample injection is completed, the results are automatically stored in the data repository. The data in the data repository includes system suitability test data, parallel experiment data, sample detection data, and standard curve data. The above data is structural data;
S5.HPLC的检测结果推送:S5.HPLC test result push:
实验人员登陆HPLC,将数据存储库底层数据处理生成报告,将检验结果信息由HPLC传送到LIMS,系统适用性试验数据、平行实验数据、样品检测数据、标准曲线数据等结构化数据自动存入ELN对应位置,色谱检测报告作为附件存储到检品附件库,支持合成到ELN;The experimenters log in to the HPLC, process the underlying data of the data repository to generate a report, and transmit the inspection result information from the HPLC to the LIMS, and the system suitability test data, parallel experiment data, sample detection data, standard curve data and other structured data are automatically stored in the ELN In the corresponding position, the chromatographic test report is stored as an attachment in the inspection product attachment library, and it supports synthesis to ELN;
S6.LIMS的检测结果接收应用:S6.LIMS test result receiving application:
实验人员登陆LIMS,选择样品、合成电子实验记录本ELN并生成检验报告,自此整个对接过程结束。The experimenter logs into LIMS, selects samples, synthesizes the electronic experiment record book ELN, and generates an inspection report. Since then, the whole docking process is over.
本实施例中,HPLC工作站运行在仪器电脑,LIMS运行在核心机房服务器,实验人员通过办公室电脑(办公电脑)登陆LIMS用户端,通过仪器电脑登陆HPLC工作站,LIMS用户端、HPLC工作站分别通过楼层交换机、核心交换机与LIMS应用服务器连接。In this embodiment, the HPLC workstation runs on the instrument computer, and the LIMS runs on the server in the core computer room. Experimenters log in to the LIMS client through the office computer (office computer), log in to the HPLC workstation through the instrument computer, and the LIMS client and HPLC workstation respectively through the floor switch. , The core switch is connected to the LIMS application server.
最后应说明的是:以上所述仅为本发明的优选实施例而已,并不用于限制本发明,尽管参照前述实施例对本发明进行了详细的说明,对于本领域的技术人员来说,其依然可以对前述各实施例所记载的技术方案进行修改,或者对其中部分技术特征进行等同替换。凡在本发明的精神和原则之内,所作的任何修改、等同替换、改进等,均应包含在本发明的保护范围之内。Finally, it should be noted that: the above is only a preferred embodiment of the present invention, and is not intended to limit the present invention. Although the present invention has been described in detail with reference to the foregoing embodiments, for those skilled in the art, it still The technical solutions recorded in the foregoing embodiments may be modified, or some technical features thereof may be equivalently replaced. Any modifications, equivalent replacements, improvements, etc. made within the spirit and principles of the present invention shall be included within the protection scope of the present invention.
Claims (3)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202310016598.2A CN116148384A (en) | 2023-01-06 | 2023-01-06 | Domestic LIMS and domestic HPLC data sharing method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202310016598.2A CN116148384A (en) | 2023-01-06 | 2023-01-06 | Domestic LIMS and domestic HPLC data sharing method |
Publications (1)
Publication Number | Publication Date |
---|---|
CN116148384A true CN116148384A (en) | 2023-05-23 |
Family
ID=86352099
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202310016598.2A Pending CN116148384A (en) | 2023-01-06 | 2023-01-06 | Domestic LIMS and domestic HPLC data sharing method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN116148384A (en) |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20130303409A1 (en) * | 2010-12-17 | 2013-11-14 | Hoffmann-La Roche Inc. | Automatically controlling a plurality of devices of a separation and detection process for quantitative sample analysis |
CN105741216A (en) * | 2016-02-06 | 2016-07-06 | 福州宏泰分析技术有限公司 | Intelligent food quality security supervision system |
CN106443032A (en) * | 2016-09-30 | 2017-02-22 | 内蒙古蒙牛乳业(集团)股份有限公司 | Data acquisition method and device |
CN110347644A (en) * | 2019-06-19 | 2019-10-18 | 象山县食品检验检测中心 | A kind of with no paper inspection and detection system and its operating method |
CN111696623A (en) * | 2020-05-28 | 2020-09-22 | 上海药明康德新药开发有限公司 | Laboratory information management system based on DNA coding compound library |
CN112509708A (en) * | 2019-09-16 | 2021-03-16 | 新疆维吾尔药业有限责任公司 | Information management system of Uygur medicine detection laboratory |
-
2023
- 2023-01-06 CN CN202310016598.2A patent/CN116148384A/en active Pending
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20130303409A1 (en) * | 2010-12-17 | 2013-11-14 | Hoffmann-La Roche Inc. | Automatically controlling a plurality of devices of a separation and detection process for quantitative sample analysis |
CN105741216A (en) * | 2016-02-06 | 2016-07-06 | 福州宏泰分析技术有限公司 | Intelligent food quality security supervision system |
CN106443032A (en) * | 2016-09-30 | 2017-02-22 | 内蒙古蒙牛乳业(集团)股份有限公司 | Data acquisition method and device |
CN110347644A (en) * | 2019-06-19 | 2019-10-18 | 象山县食品检验检测中心 | A kind of with no paper inspection and detection system and its operating method |
CN112509708A (en) * | 2019-09-16 | 2021-03-16 | 新疆维吾尔药业有限责任公司 | Information management system of Uygur medicine detection laboratory |
CN111696623A (en) * | 2020-05-28 | 2020-09-22 | 上海药明康德新药开发有限公司 | Laboratory information management system based on DNA coding compound library |
Non-Patent Citations (2)
Title |
---|
李珺婵: ""药品实验室自动化及无纸化检测的设计与实现"", 《中国优秀硕士学位论文全文数据库》, 15 February 2017 (2017-02-15), pages 15 - 26 * |
黄晓凤;王会波;李长青;: "LIMS与检测仪器接口技术实现数据自动化采集", 医学信息, no. 03, 1 February 2020 (2020-02-01) * |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
WO2020155778A1 (en) | Interface automation test method, test apparatus, test device and storage medium | |
CN113760948B (en) | Data query method and device | |
US8701092B1 (en) | System and method for testing applications | |
US7958188B2 (en) | Transaction-initiated batch processing | |
US20060173873A1 (en) | System and method for providing access to databases via directories and other hierarchical structures and interfaces | |
CN113206763A (en) | Simulation test system and method suitable for Internet of things management platform | |
WO2016165421A1 (en) | Method and apparatus for converting different interface protocol messages | |
WO2010127551A1 (en) | Adaptiing method, adapter and adapter system for network service communication | |
CN100388690C (en) | Automatic testing system and method for command of command line interface of data communication apparatus | |
US10747588B2 (en) | Method for updating instance-based message maps using metadata | |
CN113836014A (en) | An interface testing method, device, electronic device and storage medium | |
CN113760730A (en) | Automatic testing method and device | |
CN114816499A (en) | A kind of electronic resource sharing method, device and storage medium | |
CN113901117A (en) | Multi-source test data leading processing method | |
CN111857932A (en) | A web filling method for operation and maintenance audit system based on puppeteer | |
CN116148384A (en) | Domestic LIMS and domestic HPLC data sharing method | |
CN106445824A (en) | Interface comprehensiveness management system based on character | |
CN110162476A (en) | Test method and device | |
CN111241044B (en) | Methods, devices, equipment and readable storage media for building heterogeneous databases | |
WO2024060926A1 (en) | Constraint file import method and apparatus, device, and storage medium | |
CN115391287A (en) | File import method, system, storage medium and electronic system | |
CN100389627C (en) | Testing equipment of short message interface | |
CN118900282B (en) | A big data support method, system, computer and storage medium | |
CN116360869A (en) | Dual-system switching method and device, storage medium and electronic equipment | |
CN118747157A (en) | Service test processing method and device |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination |