CN106940693B - Single structure processing method for laboratory original record - Google Patents
Single structure processing method for laboratory original record Download PDFInfo
- Publication number
- CN106940693B CN106940693B CN201710112424.0A CN201710112424A CN106940693B CN 106940693 B CN106940693 B CN 106940693B CN 201710112424 A CN201710112424 A CN 201710112424A CN 106940693 B CN106940693 B CN 106940693B
- Authority
- CN
- China
- Prior art keywords
- original record
- data
- record list
- label
- original
- 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.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/103—Formatting, i.e. changing of presentation of documents
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a single structurization processing method for laboratory original records, which comprises the following steps: (1) abstract establishing a public physical model of an original record list, wherein the public physical model comprises an original record list template used for recording a concrete original record list and an information item used for abstracting a key original record list; (2) the data element and the report data element which are interacted between the original record list and the instrument interface are defined universally; (3) creating a label suitable for an original record form template, and realizing data interaction through the label; (4) and analyzing the data in the label and storing the data in the label into a corresponding data element according to the rule defined by the label through the label defined in the original record list. The invention integrally solves the problems of definition, data source, storage, distribution and tracing of the original record list and realizes the whole process processing of the original record list; the manufacturing difficulty of the original record list is reduced, the manufacturing efficiency of the original record list is improved, the productivity in the experimental process is improved, and therefore the inspection capability of an inspection mechanism is improved.
Description
Technical Field
The invention relates to informatization of laboratory test and detection application, in particular to a single structurization processing method for laboratory original records.
Background
The original record of experiment refers to the original data such as various data, characters, charts, pictures, photos, sound images and the like which are directly recorded or statistically formed according to actual conditions by applying methods such as experiment, observation, investigation or data analysis and the like in the process of scientific research in a laboratory, is the direct record of the obtained original data in the process of scientific experiment, and can be used as basic data for deeply performing the research of the subject at different periods. The experiment original record sheet mainly refers to data and character record data, and an experimenter forms a final experiment report through certain professional calculation according to the record result of the original record sheet. The original record of the experiment reflects the most real and original data condition in the experiment, also called "test record table", "original record table" and "analysis record table" in the laboratory. The formats of the original record lists in the laboratory are various, the original record lists are positively correlated with the number of the inspection items in the detection capability range, and the individual requirements of different inspection institutions are high and cannot be unified.
In actual work, an experimenter generally makes a manual original record list according to an actual experiment result of the instrument or reuses a printout form of the instrument, and then additionally compiles an inspection report according to the manual original record list, so that the operation is complicated, mistakes are easy to make, and the retrospective management of laboratory quality control is not facilitated. To solve the existing problems, there are two prior arts:
(1) project key raw data record type: the method has the advantages that the key data result of the project in the original record list is directly and simply recorded to support the definition of a calculation formula, so that the professional calculation work is reduced, the automatic access of the report is realized, and the additional form design is not needed. The 'project key original data record type' only solves the recalculation of key project results in an original record list and the automatic data transfer into an experimental report.
(2) Specific procedures to perform the original documentary definitional: a special program module is embedded in application software to support form definition of an original record list format, and definition and use of what the original record list sees are achieved. The definition of the original record list by the specific program provides the definition of the obtained result, but the learning curve is steep by adopting the special program implementation and is not beneficial to the application.
Moreover, neither of the above two prior arts solves the problem that the experimental data of the instrument automatically acquires the original list, and does not solve the problem that the experimenter rapidly makes and uses the original list under the condition of making a large number of original lists. The main reasons are that the needs of the various layers involved in the original documentary are not considered as a whole, the lack of integrity, more from a procedural point of view and not combined with the routine working habits of the experimenters, such as: is used to Excel operation.
Disclosure of Invention
Aiming at the defects of the prior art, the invention aims to provide a structured processing method of a laboratory original record list, which realizes the automatic process of acquiring interface data of a test process instrument into the original record list and outputting data from the original record list to a report.
In order to achieve the purpose, the technical scheme of the invention is as follows: a single structuring method for laboratory original records comprises the following steps: (1) abstract establishing a public physical model of an original record list, wherein the public physical model comprises an original record list template used for recording a concrete original record list and an information item used for abstracting a key original record list; (2) the data element and the report data element which are interacted between the original record list and the instrument interface are defined universally; (3) creating a label suitable for an original record form template, and realizing data interaction through the label; (4) and analyzing the data in the label and storing the data in the label into a corresponding data element according to the rule defined by the label through the label defined in the original record list.
As an improvement of the present invention, the data elements include an instrument check item comparison data element, an instrument check result data element, and a report check item data element, respectively.
As an improvement of the present invention, the original record form template is an original record form template based on an Excel format.
As an improvement of the present invention, the parsing tag includes two cases: (1) the system firstly verifies whether the data is legal or not according to the label name at the beginning of 'H _', and then analyzes the data item according to the analysis rule after the data is passed; (2) the tag name at the beginning of "U _", the system does not need to verify, and the data item is parsed into the user-defined data element.
As an improvement of the present invention, the processing of the knowledge content of the original record form template comprises: (1) writing basic inspection task information into an original record form template; (2) acquiring a test result value of a corresponding test item from the instrument; (3) and extracting corresponding key knowledge and storing the key knowledge into a corresponding data model when the original record list template is stored.
Compared with the prior art, the method integrally solves the problems of definition, data source, storage, distribution and tracing of the original record list, and realizes the whole-process processing of the original record list; the manufacturing difficulty of the original record list is reduced, the manufacturing efficiency of the original record list is improved, the productivity in the experimental process is improved, and therefore the inspection capability of an inspection mechanism is improved.
Drawings
The structure and advantageous effects of the present invention will be described in detail with reference to the accompanying drawings and the detailed description.
FIG. 1 is a schematic diagram of the composition of a single original recording board of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantageous technical effects of the present invention clearer, the present invention is described in further detail below with reference to the accompanying drawings and the detailed description. It should be understood that the detailed description and specific examples, while indicating the preferred embodiment of the invention, are intended for purposes of illustration only and are not intended to limit the scope of the invention.
In the laboratory inspection process, various original documentations are required, and the requirements of the specific documents are different according to different actual inspection businesses and inspection projects. In order to solve the problem of the automation process from the acquisition of interface data of an instrument to an original record list in the inspection process and the output of data from the original record list to a report, the original record list needs to be subjected to structured processing. The single structuring processing method of the laboratory original record comprises the following steps:
1. common model for abstract creation of raw notes
The method comprises the following steps of analyzing, summarizing and abstracting the concrete contents of original record sheets of a plurality of industries (including but not limited to disease prevention and control, environment detection, environment-friendly third-party detection, drug inspection, agricultural inspection, marine fishery inspection and the like): experimental environment and method information, sample inspection information, quality control signature information (examiner, rechecker, reviewer), etc. Referring to FIG. 1, the main physical model (based on Oracle library) includes two parts:
original single template-used for recording specific original single template, comprising: template definition and template form self-definition (namely, the definition of a check item corresponding to the template);
original document actual result-original document information item for abstract key, containing: the detection result (main table), the detection result (detail table), the table value table in the original record list, the hash value table of the original record list, the regression equation (main table) and the regression equation (detail table).
The specific styles of the tables in the original record list are abstracted, classified and summarized into the following seventeen types:
the original recording sheet internal form styles of the specific styles are driven by specific programs to interact with specific data.
2. Universal definition instrument interface data element and report data element
The data interaction specification in the implementation of different application development is realized by defining the data elements of instrument interface project contrast, instrument acquisition data and report data, and a foundation is laid for sending an inspection task to an instrument, acquiring an inspection result from the instrument by an original record list and outputting the inspection result to a report.
Instrumentation check item comparison data element:
instrument test result data element:
report check item data elements:
3. adopting excel as a design template
The original record form template based on the Excel format has the characteristics that: what is seen is the result; the calculation formula is convenient to fuse, and professional business knowledge is managed and checked; and realizing data interactive integration through bookmarks.
Creating a set of bookmark rules suitable for the original record form template: the names beginning with "H _" require the system to make initial assignments; the name beginning with "TABLE" is the result set definition, and the system will automatically obtain the values of all cells in the current TABLE for saving. (Note: the system has stylized the TABLE1, TABLE2, TABLE3 …, TABLE 9; the space defines a minimum of two rows!); names beginning with "U _" are user-defined names. The data can not be associated with the system service data; the names beginning with "H _ check k result" or "H _ SAMPNOS" are indications that the system is extracting data and not allowed to be used for other purposes. In the case of a multi-item test, the definition result column and the sample number column are arranged in the order of the test items in the original single setup. Such as:
| copper (Cu) | 1 | H_CHECKRESULT1 | H_SAMPNOS1 |
| Iron | 2 | H_CHECKRESULT2 | H_SAMPNOS2 |
| Cadmium (Cd) | 3 | H_CHECKRESULT3 | H_SAMPNOS3 |
| |
4 | H_CHECKRESULT4 | H_SAMPNOS4 |
The electronic signature of original record list check and review is designated by 'H _ OPNAME' (checker) 'H _ CHECKNAME' (reviewer) bookmark. (Note: setting original Single use electronic signature in System)
4. Extracting the key knowledge list of the original record list to realize the structured storage
And analyzing the data in the label to the corresponding data element according to the label defined by the label in the original list and the rule defined by the label. There are two main types of label resolution: 1. with the tag name beginning with "H _", the system first needs to verify whether the data is legitimate, and then performs data item parsing according to the parsing rule after passing. The tag name at the beginning of 'U _', the system does not need verification, and the data item is analyzed to the user-defined data source.
The main table of the test results:
detailed table of test results:
test results label table:
the processing of the knowledge content of the original documentary template includes: and writing basic inspection task information into the original record form template, acquiring an inspection result value of a corresponding inspection item from the instrument, extracting corresponding key knowledge when the original record form template is stored, and storing the key knowledge into a corresponding data model. The specific treatment is as follows: (1) according to the selected sample, the detection item and the detection method, the system can automatically generate a blank original list. If multiple original single templates are matched, the system may require selection of the original single template. The generated blank original sheet contains most of the information of the test, such as: samples, items, test methods, test bases, standard limits, and the like. In the middle, the data communication between the business system and the Excel is realized by utilizing XML. (2) And the instrument interface management workstation acquires instrument detection result data in real time and stores the data in the intermediate library. Automatically acquiring instrument detection data from the intermediate library according to information such as a selected sample, a detection project and the like on the original record list, generating an XML file of data interaction, and assigning values to corresponding tags in the original record list through defined rules. (3) The original record sheet is stored in two different ways. First, the original record sheet is stored in the form of a file. And secondly, analyzing all the information in the original record list, and analyzing the information in the label to a corresponding data storage model according to the label and a label analysis rule defined in the original record list.
The invention defines the data model of the original record list in an abstract way, and provides a uniform standard for various original record lists in different industries; common data elements for data interaction with instrument equipment are defined, so that data interaction between the abstract and various different instruments is facilitated; the method simplifies the process of making the original record list, reduces the difficulty of making the original record list, weakens the technology involved in the process of making the original record list, and provides a platform for customizing the original record list for a user; the complex original list is manufactured and used in an Excel mode, so that editing, storing, auditing and distributing of 'what you see what you get' are realized, and the process tracing of quality management is facilitated. In a word, the invention establishes a structured storage mode of the original record list data, abstracts the data model of the original record list of each industry, realizes the reediting of the original record list storage data based on the Excel template, and realizes the data access of the experiment report compilation.
Appropriate changes and modifications to the embodiments described above will become apparent to those skilled in the art from the disclosure and teachings of the foregoing description. Therefore, the present invention is not limited to the specific embodiments disclosed and described above, and some modifications and variations of the present invention should fall within the scope of the claims of the present invention. Furthermore, although specific terms are employed herein, they are used in a generic and descriptive sense only and not for purposes of limitation.
Claims (3)
1. A method for structuring a laboratory raw record, comprising:
(1) abstract establishing a public physical model of an original record list, wherein the public physical model comprises an original record list template used for recording a concrete original record list and an information item used for abstracting a key original record list; the original record list template comprises template definition and template table customization, and the information items comprise a detection result main table, a detection result detail table, a table value table in the original record list, an original record list hash value table, a regression equation main table and a regression equation detail table;
(2) the data element and the report data element which are interacted between the original record list and the instrument interface are defined universally; wherein the data elements include an instrument test item comparison data element, an instrument test result data element, and a report test item data element, respectively;
(3) creating a label suitable for an original record form template, and realizing data interaction through the label;
(4) analyzing the data in the label and storing the data in the label into a corresponding data element according to the label defined by the original record list and the rule defined by the label;
wherein the processing of the knowledge content of the original documentary template comprises: writing basic inspection task information into an original record form template; acquiring a test result value of a corresponding test item from the instrument; and extracting corresponding key knowledge and storing the key knowledge into a corresponding data model when the original record list template is stored.
2. The method of claim 1, wherein the raw record simplex template is an Excel format-based raw record simplex template.
3. The method of claim 1, wherein the parsing tag includes two cases: (1) the system firstly verifies whether the data is legal or not according to the label name at the beginning of' H _ and analyzes the data item according to the analysis rule after the data is passed; (2) the tag name at the beginning of "U _ is not verified by the system, and the data item is parsed into the user-defined data element.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710112424.0A CN106940693B (en) | 2017-02-28 | 2017-02-28 | Single structure processing method for laboratory original record |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710112424.0A CN106940693B (en) | 2017-02-28 | 2017-02-28 | Single structure processing method for laboratory original record |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106940693A CN106940693A (en) | 2017-07-11 |
| CN106940693B true CN106940693B (en) | 2020-09-01 |
Family
ID=59469265
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710112424.0A Active CN106940693B (en) | 2017-02-28 | 2017-02-28 | Single structure processing method for laboratory original record |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106940693B (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107944236A (en) * | 2017-10-19 | 2018-04-20 | 陈伟麟 | A kind of checking method and auditing system of measurement verification calibration original record certificate |
| CN110717322A (en) * | 2019-10-10 | 2020-01-21 | 湖南舞龙软件开发有限公司 | Universal generation method for quality monitoring analysis original record table |
| CN112632949A (en) * | 2020-12-30 | 2021-04-09 | 甘肃省商业科技研究所有限公司 | Method for realizing on-line original record input by adopting on-line document |
| CN113343657A (en) * | 2021-04-30 | 2021-09-03 | 青海省药品检验检测院 | Automatic processing and report generating system for cosmetic inspection data |
| CN114969657B (en) * | 2022-04-06 | 2024-06-07 | 普锐斯(北京)科技有限公司 | Custom computing processing method and system for detection data |
| CN114492361A (en) * | 2022-04-06 | 2022-05-13 | 普锐斯(北京)科技有限公司 | Laboratory detection data structuring method |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101625694A (en) * | 2009-08-17 | 2010-01-13 | 中国科学院地理科学与资源研究所 | Method and system for storing various standard geological metadata |
| CN101714132A (en) * | 2009-11-13 | 2010-05-26 | 山东浪潮齐鲁软件产业股份有限公司 | Method for automatically generating batch release abstracts in vaccine production |
| CN102043769A (en) * | 2010-12-27 | 2011-05-04 | 畅捷通软件有限公司 | Method and device for editing documents |
| CN103279863A (en) * | 2013-06-08 | 2013-09-04 | 北京创腾科技有限公司 | Automatic generation method and system of report file |
| CN104731941A (en) * | 2015-03-31 | 2015-06-24 | 浪潮集团有限公司 | Method for capturing data from unstructured financial report based on XBRL technology |
| CN104731889A (en) * | 2015-03-13 | 2015-06-24 | 河海大学 | Query result size estimation method |
| CN105488019A (en) * | 2015-11-30 | 2016-04-13 | 云南电网有限责任公司电力科学研究院 | Power quality monitoring device testing report automatic generation method |
| CN105956724A (en) * | 2016-01-21 | 2016-09-21 | 内蒙古蒙牛乳业（集团）股份有限公司 | Informatization management method and device for examination of original record |
| CN106302776A (en) * | 2016-08-24 | 2017-01-04 | 杨朝钰 | A kind of cloud platform processing continuous data and method |
-
2017
- 2017-02-28 CN CN201710112424.0A patent/CN106940693B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101625694A (en) * | 2009-08-17 | 2010-01-13 | 中国科学院地理科学与资源研究所 | Method and system for storing various standard geological metadata |
| CN101714132A (en) * | 2009-11-13 | 2010-05-26 | 山东浪潮齐鲁软件产业股份有限公司 | Method for automatically generating batch release abstracts in vaccine production |
| CN102043769A (en) * | 2010-12-27 | 2011-05-04 | 畅捷通软件有限公司 | Method and device for editing documents |
| CN103279863A (en) * | 2013-06-08 | 2013-09-04 | 北京创腾科技有限公司 | Automatic generation method and system of report file |
| CN104731889A (en) * | 2015-03-13 | 2015-06-24 | 河海大学 | Query result size estimation method |
| CN104731941A (en) * | 2015-03-31 | 2015-06-24 | 浪潮集团有限公司 | Method for capturing data from unstructured financial report based on XBRL technology |
| CN105488019A (en) * | 2015-11-30 | 2016-04-13 | 云南电网有限责任公司电力科学研究院 | Power quality monitoring device testing report automatic generation method |
| CN105956724A (en) * | 2016-01-21 | 2016-09-21 | 内蒙古蒙牛乳业（集团）股份有限公司 | Informatization management method and device for examination of original record |
| CN106302776A (en) * | 2016-08-24 | 2017-01-04 | 杨朝钰 | A kind of cloud platform processing continuous data and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106940693A (en) | 2017-07-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106940693B (en) | Single structure processing method for laboratory original record | |
| CN109359028B (en) | Code quality monitoring method, device, computer equipment and storage medium | |
| US20200042560A1 (en) | Automatically generating a website specific to an industry | |
| US10380231B2 (en) | System and method for dynamic organization of information sets | |
| Samuel et al. | Understanding experiments and research practices for reproducibility: an exploratory study | |
| MX2007011598A (en) | Determining fields for presentable files and extensible markup language schemas for bibliographies and citations. | |
| CN103136173A (en) | Method converting mass word or excel format form documents into webpages | |
| CN102959578A (en) | Forensic system and forensic method, and forensic program | |
| Stamatatos et al. | Plagiarism and authorship analysis: introduction to the special issue | |
| US10146881B2 (en) | Scalable processing of heterogeneous user-generated content | |
| CN116719784A (en) | Device for elastically clustering and combining and reading multiple OFD format files | |
| Bergiante et al. | Bibliometric study of the relationship between business model and air transport | |
| CN110704635B (en) | Method and device for converting triplet data in knowledge graph | |
| Rasmussen | Social Science Metadata and the Foundations of the DDI | |
| Mokhnacheva | Document types indexed in WoS and Scopus: similarities, differences, and their significance in the analysis of publication activity | |
| CN102479072B (en) | Multi-header report generating method, device and terminal | |
| CN115828856A (en) | Test paper generation method, device, equipment and storage medium | |
| CN112668282B (en) | Method and system for converting format of equipment procedure document | |
| LeBeau et al. | Reproducible analyses in education research | |
| Vardigan et al. | Documenting survey data across the life cycle | |
| CN112417295A (en) | Education cloud information pushing method, storage medium and system | |
| Medeiros et al. | The dynamics of multidisciplinary research networks-mining a public repository of scientists CVs | |
| CN113688607B (en) | Portrait updating method and device for online document authors | |
| Roubert et al. | Putting the Lab in the Lab Book: Supporting Coordination in Large, Multi–site Research | |
| CN112434239B (en) | Configuration information determination method, page display method, device, equipment and storage medium |
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 | ||
| CB03 | Change of inventor or designer information | ||
| CB03 | Change of inventor or designer information |
Inventor after: Xu Guojiang Inventor after: Zhao Kai Inventor after: Fu Haoming Inventor before: Xu Guojiang |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |