CN106940693A - Laboratory original record single structure processing method - Google Patents
Laboratory original record single structure processing method Download PDFInfo
- Publication number
- CN106940693A CN106940693A CN201710112424.0A CN201710112424A CN106940693A CN 106940693 A CN106940693 A CN 106940693A CN 201710112424 A CN201710112424 A CN 201710112424A CN 106940693 A CN106940693 A CN 106940693A
- Authority
- CN
- China
- Prior art keywords
- original record
- data
- original
- record list
- label
- 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.)
- Granted
Links
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 kind of laboratory original record single structure processing method, it includes：(1) the abstract public physical model for setting up original record list, including for recording specifically original single original record single mode plate and the item of information for abstract crucial original record list；(2) data element and the data reporting member that generic definition original record list is interacted with tool interface system；(3) label for being adapted to original record single mode plate is created, data interaction is realized by label；(4) by the label defined in original record list, according to the rule of tag definition, parse in the corresponding data elements of data Cun Chudao in label.Globality of the present invention solves the definition of original record list, data source, storage, distributes, reviews problem, realizes the overall process processing of original record list；The manufacture difficulty of original record list is reduced, the producing efficiency of original record list is improved, the productivity of experimentation is improved, so as to improve the detectability of inspection body.
Description
Technical field
Application message is detected the present invention relates to laboratory inspection, more specifically to a kind of laboratory original record
Single structure processing method.
Background technology
Experiment original record refers to carry out in scientific research process in the lab, application experiment, observation, investigation or data
The methods such as analysis, directly record or count the various data formed, word, chart, picture, photo, acoustic image according to actual conditions
Deng firsthand information, it is to carry out during scientific experiment to the direct record of the firsthand information obtained, different times can be used as deep
Enter to carry out the basic data of the subject study.Experiment original record list refers mainly to data therein and writing record data, tests
Personnel calculate according to the record result of original record list by certain specialty, form final laboratory report.The original note of experiment
The data cases of most true most original in the single reflection experiment of record, also cry laboratory " test recording table ", " tables of original record ", " point
New record table ".The form of laboratory original record list is various, with the inspection item number positive correlation in the range of detectability, difference
Inspection body's individual requirement is higher, it is impossible to unified.
In real work, experimenter is typically according to the manual original record list of the actual experiment result of instrument making or again
With the printout form of instrument, survey report, intricate operation and easily error, and unfavorable are separately then worked out according to this again
In the tracing management for carrying out Good Laboratory control.The problem of for existing, there are following two prior arts at present：
(1) the crucial original data record type of project：Project critical data result in directly simple record original record list
The definition of computing formula is supported, professional evaluation work is reduced, the automatic access of report is realized, is set without the list for carrying out extra
Meter." project key original data record type " solve only calculating again with data certainly for the key project result in original record list
Move in laboratory report.
(2) specific program defines type to carry out original record list：Proprietary program(me) module is embedded in application software to support
The form definition of original record single lattice formula, realizes the definition obtained by original record list finding with using." specific program carries out original
Beginning record defines type " to be realized there is provided the definition obtained by finding, but using proprietary program(me), learning curve is precipitous, and being unfavorable for should
With.
Moreover, above two prior art does not all solve the problem of instrument experiment data are got in original list automatically,
Not the problem of not solving a large amount of original single lower experimenter's quick Fabrications of making and use original single.Main cause is not from whole
The need for the every aspect that original record list is related to is considered on body, lack globality, more consider from program angle, and not
It is combined with experimenter's routine work custom, such as：Get used to Excel operations.
The content of the invention
In view of the shortcomings of the prior art, it is an object of the invention to provide a kind of processing of laboratory original record single structureization
Method, realizes checkout procedure tool interface system data acquisition to original record list, from original record list output data to report
Automation process.
To achieve these goals, the technical scheme is that：A kind of laboratory original record single structureization processing side
Method, it includes：(1) the abstract public physical model for setting up original record list, including for recording specific original single original note
Record single mode plate and the item of information for abstract crucial original record list；(2) generic definition original record list is interacted with tool interface system
Data element and data reporting member；(3) label for being adapted to original record single mode plate is created, data interaction is realized by label；(4)
By the label defined in original record list, according to the rule of tag definition, the corresponding numbers of data Cun Chudao in label are parsed
According in member.
As a modification of the present invention, the data element includes instrument testing Item Control data element, instrument and examined respectively
Test result data member and project data member is examined in report.
As a modification of the present invention, the original record single mode plate is the original record single mode based on Excel forms
Plate.
As a modification of the present invention, the parsing label includes two kinds of situations：(1) bookmark name of " H_ " beginning,
System first verifies that whether data are legal, by rear according to resolution rules, carries out data item parsing；(2) label of " U_ " beginning
Title, system need not verify that parsing data item is into User Defined data element.
As a modification of the present invention, the processing to the knowledge content of the original record single mode plate includes：(1) it is basic
Inspection task information write-in original record single mode plate；(2) the assay value of correspondence inspection project is obtained from instrument；(3) protect
Corresponding all critical learning storage is extracted when depositing original record single mode plate into corresponding data model.
Compared with prior art, globality of the present invention solves the definition of original record list, data source, storage, distributes, chases after
Trace back problem, realize the overall process processing of original record list；The manufacture difficulty of original record list is reduced, the system of original record list is improved
Make efficiency, the productivity of experimentation is improved, so as to improve the detectability of inspection body.
Brief description of the drawings
With reference to the accompanying drawings and detailed description, the structure and its Advantageous Effects to the present invention are carried out specifically
It is bright.
Fig. 1 is original record single mode plate composition schematic diagram of the invention.
Embodiment
In order that goal of the invention, technical scheme and its Advantageous Effects of the present invention become apparent from, below in conjunction with accompanying drawing
And embodiment, the present invention will be described in further detail.It should be appreciated that the specific reality described in this specification
Apply mode to explain the present invention, be not intended to limit the present invention.
, it is necessary to which various original record lists, with practice examining business, examine project different specific single during laboratory inspection
According to requiring different.To solve checkout procedure tool interface system data acquisition to original record list, from original record list output data to
The automation process of report to original record list, it is necessary to carry out structuring processing.Original record single structure in laboratory of the present invention
Processing method includes：
1st, the abstract common model for setting up original record list
By (including but is not limited to prevention and control of diseases, environment measuring, environmentally friendly third party's detection, medicine to multiple industries
Examine, agricultural is examined, sea fishery is examined etc.) original record list carry out the analysis of particular content, conclusions, refinement, take out
Several parts：Experimental situation and method information, sample survey information, quality control signing messages (proofer, the person of checking, examination ＆ verification
Person) etc..Referring to Fig. 1, Main physical model (being based on Oracle storehouses) includes two parts：
Original single mode plate --- for recording specific original single mode plate, contain：Template definition, template form are self-defined (i.e.
The corresponding inspection project definition of template)；
Original single actual result --- for abstract crucial original record list item of information, contain：Testing result (main table), inspection
Survey result (detail list), the table value table in original record list, original record list hashed value table, regression equation (main table), recurrence
Equation (thin table).
Wherein, in original record list form specific pattern, by it is abstract, classify, be summarized as following 17 kinds：
The original record list internal form pattern of any of the above specific style drives specific data interaction by specific program.
2nd, generic definition tool interface system data element and data reporting member
By obtaining data to tool interface system Item Control, instrument, the data element of data reporting is defined, and is realized different
Data interaction specification when application and development is realized, be inspection task be sent to instrument, original record list from instrument obtain assay,
Assay is output to report and laid the first stone.
Instrument testing Item Control data element：
Instrument testing result data member：
Project data member is examined in report：
3rd, design template is used as using excel
The characteristics of original record single mode plate based on Excel forms, has：Obtained by finding；It is easy to fusion calculation formula, manages
Examine professional service knowledge；Realize that data interaction is integrated by bookmark.
Create the bookmark rule of a set of suitable original record single mode plate：It is to need system to carry out just with " H_ " title started
Beginning assignment；It is result set definition with " TABLE " title started, system can obtain all cells in active sheet automatically
Value is preserved.(note：System has carried out style setting to TABLE1, TABLE2, TABLE3 ... .TABLE9；Definition space is most
Few two rows！)；It is User Defined title with " U_ " title started.It will not be associated with system business data；With " H_
CHECKRESULT " or the title of " H_SAMPNOS " beginning are the signs of system extracted data, are not allowed with used for other purposes.If
Entry examine, define result row and sample number into spectrum arrange will by it is original set up put middle inspection project order set.Such as：
| Copper | 1 | H_CHECKRESULT1 | H_SAMPNOS1 |
| Iron | 2 | H_CHECKRESULT2 | H_SAMPNOS2 |
| Cadmium | 3 | H_CHECKRESULT3 | H_SAMPNOS3 |
| Zinc | 4 | H_CHECKRESULT4 | H_SAMPNOS4 |
Original record list is specified to examine, check with " H_OPNAME " (identifier), " H_CHECKNAME " (checking people) bookmark
Electronic signature.(note：Set original single using electronic signature in system)
4th, original record list all critical learning is extracted to table, realizes structured storage
By the label defined in original list, according to the rule of tag definition, the data in label are parsed, to corresponding number
According in member.Tag resolution mainly has two kinds：1. whether the bookmark name started with " H_ ", system closes firstly the need of checking data
Method, by rear according to resolution rules, carries out data item parsing.The bookmark name of " 2. U_ " beginning, system need not be verified, be parsed
Data item is into User Defined data original.
The main table of assay：
The thin table of assay：
Assay label list：
Processing to the knowledge content of original record single mode plate includes：Basic inspection task information write-in original record list
Template, the assay value of correspondence inspection project is obtained from instrument, is extracted corresponding key when preserving original record single mode plate and is known
Storage is known into corresponding data model.Specific processing is as follows：(1) according to the sample of selection, detection project, detection method, it is
System can automatically generate the original list of blank.If matching multiple original single mode plates, system may require that the original single mode plate of selection.Generation
Blank it is original singly contain this inspection most information, such as：Sample, project, the method for inspection, test basis, standard limit
Value etc..In the middle of this, we make use of the XML to realize the data communication between operation system and Excel.(2) tool interface system pipe
Work station is managed, Instrumental results data are obtained in real time, and store data into middle database.According to selected by original list sample,
The information such as detection project, obtain instrument detection data from middle database automatically, and generate the XML file of a data interaction, lead to
The rule of definition is crossed, assignment is carried out to the respective labels in original record list.(3) alone two kinds of original record is preserved different
Mode is preserved simultaneously.The first, original record list is stored in the form of a file.It is second, the information in original record list is complete
Portion is parsed, label and tag resolution rule according to defined in original list, by the information analysis in label to corresponding data
In storage model.
The abstract definition of the present invention data model of original record list, is miscellaneous original record list in different industries
There is provided unified standard；The common data elements with instrument and equipment data interaction are defined, are easy to abstract from various different instruments
Between data interaction；The process of original record list making is simplified, the difficulty of original record list making is reduced, weakens original
The technology being related in beginning record manufacturing process, provide the user the platform of self-defined original record list；Pass through Excel modes
Complete to the original single making of complexity with using, the editor of realization " obtained by finding ", preservation, examination ＆ verification, distribution also allow for realizing matter
The process of buret reason is reviewed.In a word, the present invention establishes a kind of structured storage pattern of original record forms data, abstract each row
The data model of industry original record list, realizes editing again for the original record list data storage based on Excel template, realizes experiment
The data access of Report workout.
The announcement and teaching of book according to the above description, those skilled in the art in the invention can also be to above-mentioned embodiment party
Formula carries out appropriate change and modification.Therefore, the invention is not limited in embodiment disclosed and described above, to this
Some modifications and changes of invention should also be as falling into the scope of the claims of the present invention.Although in addition, this specification
In used some specific terms, but these terms are merely for convenience of description, do not constitute any limitation to the present invention.
Claims (5)
1. a kind of laboratory original record single structure processing method, it is characterised in that it includes：
(1) the abstract public physical model for setting up original record list, including for recording specific original single original record single mode
Plate and the item of information for abstract crucial original record list；
(2) data element and the data reporting member that generic definition original record list is interacted with tool interface system；
(3) label for being adapted to original record single mode plate is created, data interaction is realized by label；
(4) by the label defined in original record list, according to the rule of tag definition, Cun Chudao pairs of data in label are parsed
In the data element answered.
2. original record single structure processing method in laboratory according to claim 1, it is characterised in that the data element
Include instrument testing Item Control data element, instrument testing result data member and report respectively and examine project data member.
3. original record single structure processing method in laboratory according to claim 1, it is characterised in that the original note
It is the original record single mode plate based on Excel forms to record single mode plate.
4. original record single structure processing method in laboratory according to claim 1, it is characterised in that the parsing mark
Label include two kinds of situations：(1) bookmark name of " H_ " beginning, system first verifies that whether data are legal, by rear according to parsing
Rule, carries out data item parsing；(2) bookmark name of " U_ " beginning, system need not verify that parsing data item is made by oneself to user
In adopted data element.
5. original record single structure processing method in laboratory according to claim 1, it is characterised in that to described original
The processing of the knowledge content of record template includes：(1) basic inspection task information write-in original record single mode plate；(2) from
Instrument obtains the assay value of correspondence inspection project；(3) when preserving original record single mode plate corresponding all critical learning is extracted to deposit
Store up in corresponding data model.
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 true CN106940693A (en) | 2017-07-11 |
| CN106940693B 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) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107957986A (en) * | 2017-10-19 | 2018-04-24 | 陈伟麟 | Original record intelligent editing method and system are calibrated in a kind of measurement verification |
| 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 |
| CN114492361A (en) * | 2022-04-06 | 2022-05-13 | 普锐斯(北京)科技有限公司 | Laboratory detection data structuring method |
| CN114969657A (en) * | 2022-04-06 | 2022-08-30 | 普锐斯(北京)科技有限公司 | Detection data custom calculation processing method and system |
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 grasping 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 grasping 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 |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107957986A (en) * | 2017-10-19 | 2018-04-24 | 陈伟麟 | Original record intelligent editing method and system are calibrated in a kind of measurement verification |
| 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 |
| CN114492361A (en) * | 2022-04-06 | 2022-05-13 | 普锐斯(北京)科技有限公司 | Laboratory detection data structuring method |
| CN114969657A (en) * | 2022-04-06 | 2022-08-30 | 普锐斯(北京)科技有限公司 | Detection data custom calculation processing method and system |
| CN114969657B (en) * | 2022-04-06 | 2024-06-07 | 普锐斯(北京)科技有限公司 | Custom computing processing method and system for detection data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106940693B (en) | 2020-09-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106940693A (en) | Laboratory original record single structure processing method | |
| CN106556605B (en) | The digitized representation system of bridge Site Detection typical disease | |
| Yang et al. | Toward precision education | |
| Saniee Monfared et al. | Network DEA: an application to analysis of academic performance | |
| Dao et al. | Project complexity assessment and management tool | |
| CN109255998A (en) | A kind of student performance diagnosis lifting system | |
| CN107330237A (en) | A kind of psychological condition appraisal procedure and system | |
| CN103942993A (en) | Self-adaptive online assessment system and method based on IRT | |
| Chai et al. | The dimensions of the learning organization questionnaire (DLOQ) A validation study in the Lebanese context | |
| CN106447560A (en) | Student comprehensive quality assessment system | |
| Aljaloud et al. | A deep learning model to predict Student learning outcomes in LMS using CNN and LSTM | |
| US20170091394A1 (en) | Method and system for managing health care patient record data | |
| Scholz et al. | Evaluating group model building exercises: a method for comparing externalized mental models and group models | |
| Pfleeger et al. | Measurement based process improvement | |
| CN109816260A (en) | Based on psychologic vocational ability evaluation system | |
| Hauschke et al. | Reference implementation for open scientometric indicators (ROSI) | |
| Sieber et al. | Formalizing trust in historical weather data | |
| US6748399B1 (en) | Performance-based expert witnessing | |
| Ganapathy et al. | Factors that discourage knowledge management practices in the Malaysian public sector using Rasch model | |
| CN107945853A (en) | A kind of quality of medical care reporting system based on metadata | |
| Singh et al. | Knowledge management process and innovation in indian nationalised bank | |
| Pesonen et al. | Building data science capabilities into university data warehouse to predict graduation | |
| Temme et al. | Missing Data–Better “Not to Have Them”, but What If You Do?(Part 1) | |
| Ismail et al. | Predictive modelling using Rasch’s person-item map: Intrepreting and assessing in Malaysia manufacturing firms | |
| Cooper et al. | Assessing the quality of repositories of volunteered geographical information |
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 |
Inventor after: Xu Guojiang Inventor after: Zhao Kai Inventor after: Fu Haoming Inventor before: Xu Guojiang |
|
| CB03 | Change of inventor or designer information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |