CN106777128A - The data collecting system and collecting method of a kind of inspection project - Google Patents
The data collecting system and collecting method of a kind of inspection project Download PDFInfo
- Publication number
- CN106777128A CN106777128A CN201611170124.XA CN201611170124A CN106777128A CN 106777128 A CN106777128 A CN 106777128A CN 201611170124 A CN201611170124 A CN 201611170124A CN 106777128 A CN106777128 A CN 106777128A
- Authority
- CN
- China
- Prior art keywords
- data
- standard
- structural
- product
- inspection project
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- General Engineering & Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides the data collecting system and collecting method of a kind of inspection project, it is intended to solve existing standard and be not directly applicable laboratory information system, it is impossible to which automatic benchmarking's standard is chosen and determined, using artificial cumbersome problem.A kind of data collecting system of inspection project, including service data acquisition module, business datum conversion module and business datum interface module.The present invention can be directly invoked based on the structural relation in normative document between product, standard sum term mesh, collection relevant information and sealed storage data formation standard test project bag, standard test project bag by laboratory information system；Solve existing standard and be not directly applicable laboratory information system, it is impossible to which automatic benchmarking's standard is chosen and determined, using artificial cumbersome problem.Improve the degree of accuracy and the detection efficiency of detection.
Description
Technical field
The present invention relates to the inquiry field of national standard file, more particularly to a kind of inspection project data collecting system and
Collecting method.
Background technology
In practice examining quarantine, the detection foundation of any one product is standard.Country is related to food security
The standard of aspect has more than 5000, and all the form of electronic text is published, propagates and utilizes.
For all kinds of manufacturing enterprises and quality inspection organization, standard/electronization standard be benchmark, with reference to or guide, inspection man
It is essential in work, but it can not directly apply to the information system in instrument and equipment and laboratory, for example：ERP system,
PDM systems, LIMS systems etc..
Case is done by melamine event, when such event occurs in the market, inspection body enters for milk (product)
Inspection in terms of row melamine (project/inspection project), and method (code), instrument and equipment etc. can be related to during real work,
Namely usually said " man-machine material method ring is surveyed " various aspects, final data needs to enter laboratory information system, calculates knot
Fruit is worth, and finally provides survey report.The information system in instrument and equipment and laboratory is all unable to automatic identification standard, and checks item
Mesh hides border in different standards, this exactly electronization standard insurmountable problem at present.
The groundwork unit of inspection work is accompanied by the inspection project of product, checks the target level of product quality in field
(method standard) is numerous, is caused considerable trouble in the selection, determination in standard (method), even the professional people of professional inspection department
Member, for being applicable of standard, the selection of related check instrument and equipment, selection of standard specimen etc., sometimes also can Problems, especially
When being new product or inspection type generation.
The content of the invention
The invention provides the data collecting system and collecting method of a kind of inspection project, it is intended to solve existing mark
Standard is not directly applicable laboratory information system, it is impossible to which automatic benchmarking's standard is chosen and determined, number using manpower comparing
Tired problem.
In order to solve the above technical problems, the present invention is achieved through the following technical solutions：
A kind of data collecting system of inspection project, including service data acquisition module, business datum conversion module and industry
Business data interface module.
Service data acquisition module, based on the structural relation in normative document between product, standard sum term mesh, for gathering
Structural data；Structural relation between product, standard sum term mesh includes the structural relation of n between product and standard to n, and
1 pair of structural relation of n between standard and inspection project.
Business datum conversion module, the field of data base system is needed for preparing in structural data；And will configure
The field storage of structural data is arrived in bivariate table relevant database.
Business datum interface module is for encapsulating the data in bivariate table relevant database and defeated to information system
Go out data.
Service data acquisition module is based in normative document the structural relation collection structuring between product, standard sum term mesh
Data；And convert and store in bivariate table relevant database by business datum conversion module；Then business datum is passed through
Interface module encapsulation of data, the data of encapsulation are a standard test project that directly can be called by information system
Bag；Standard test project bag is on the basis of standard, deep parsing and fractionation to be carried out to standard, stores into structuring
Data, to check project to be formed as core.Project of standard development bag can be by machine and information system institute in a kind of general form
Recognize and call.Standard test project bag mainly include project of standard development bag and inspection project details, project of standard development bag include product,
Standard sum term mesh；Inspection project details include personnel, instrument and equipment, reagent, the method for inspection and test atmosphere.
Laboratory need to obtain CNAS certifications, and CNAS certifications are related to product, standard sum term mesh, and thus launch to laboratory energy
The certification of power, decides whether to authorize related credentials, and this is the basis of labs inspection work.
Further, service data acquisition module includes that collection rule sets submodule and collection sub-module stored；Collection rule
Submodule is then set based on the structural relation in normative document between product, standard sum term mesh, for setting service data acquisition
Rule；Collection sub-module stored is regular according to the service data acquisition for setting, for gathering the structural data in normative document.
Further, business datum conversion module includes data conversion configuration submodule and data transformant module；Data turn
Change configuration submodule and the field that data base system is needed in structural data is prepared according to the field label of standard in normative document；Number
The field storage of the structural data for being used to have configured according to conversion submodule is arrived in bivariate table relevant database.
Further, normative document is XML file.It is convenient that data in normative document are identified and gathered.
Further, information system includes ERP system, PDM systems and LIMS systems.Information system
Further, business datum interface module includes the api interface for link information system.
A kind of collecting method of inspection project, comprises the following steps successively：
A, based on the structural relation in normative document between product, standard sum term mesh, service data acquisition rule is set；Produce
Structural relation between product, standard sum term mesh includes the structural relation of n between product and standard to n, and standard and inspection item
1 pair of structural relation of n between mesh.
B, the service data acquisition rule according to setting, for gathering the structural data in normative document.
The field of data base system is needed in C, the field label preparation structural data according to standard in normative document.
D, the field storage of the structural data that will have been configured are arrived in bivariate table relevant database.
Data in E, encapsulation bivariate table relevant database.
Compared with prior art it is an advantage of the invention that：
The present invention is gathered relevant information and is encapsulated based on the structural relation in normative document between product, standard sum term mesh
Data storage forms standard test project bag, and standard test project bag can be directly invoked by laboratory information system；Solve
Existing standard is not directly applicable laboratory information system, it is impossible to which automatic benchmarking's standard chosen and determined, uses
Artificial cumbersome problem.Improve the degree of accuracy and the detection efficiency of detection.
Collection rule is set by User Defined, data is parsed from standard, gathered data changes into structural data,
Directly invoked for laboratory information system.
Specific embodiment
In the description of the invention, unless otherwise clearly defined and limited, term " installation ", " connected ", " connection ",
Terms such as " fixations " should be interpreted broadly, for example, it may be fixedly connected, or be detachably connected, or integrally；Can be with
It is to mechanically connect, or electrically connect；Can be directly connected to, or be indirectly connected to by intermediary, Ke Yishi
The connection of two element internals or two interaction relationships of element.For those of ordinary skills, can be with root
Understand above-mentioned term concrete meaning in the present invention according to concrete condition.
A kind of data collecting system of inspection project, including service data acquisition module, business datum conversion module and industry
Business data interface module.
Service data acquisition module, based on the structural relation in normative document between product, standard sum term mesh, for gathering
Structural data；Structural relation between product, standard sum term mesh includes the structural relation of n between product and standard to n, and
1 pair of structural relation of n between standard and inspection project.Service data acquisition module includes that collection rule sets submodule and collection
Sub-module stored；Collection rule sets submodule based on the structural relation in normative document between product, standard sum term mesh, is used for
Service data acquisition rule is set；Collection sub-module stored is literary for gathering standard according to the service data acquisition rule for setting
Structural data in part.Normative document is XML file.
Business datum conversion module, the field of data base system is needed for preparing in structural data；And will configure
The field storage of structural data is arrived in bivariate table relevant database.Business datum conversion module includes data conversion configuration
Module and data transformant module；Data conversion configuration submodule prepares structuring according to the field label of standard in normative document
The field of data base system is needed in data；The field that data conversion submodule is used for the structural data that will have been configured is stored to two
In dimension table relevant database.
Business datum interface module is for encapsulating the data in bivariate table relevant database and defeated to information system
The data gone out after encapsulation.Business datum interface module includes the api interface for link information system.Information system includes
ERP system, PDM systems and LIMS systems.Data after encapsulation can be directly invoked by information system by api interface.
A kind of collecting method of inspection project, comprises the following steps successively：
A, based on the structural relation in normative document between product, standard sum term mesh, service data acquisition rule is set；Produce
Structural relation between product, standard sum term mesh includes the structural relation of n between product and standard to n, and standard and inspection item
1 pair of structural relation of n between mesh.
Specifically, when collection rule sets submodule setting service data acquisition rule, with XML file configuration collection rule
Then；Wherein, collection rule sets relevant information and includes：Title, name of product, inspection project name, personnel, instrument set
Standby, reagent, the method for inspection, environment, standard value, structured relations (parent, sub- level relation).
B, structural data collection normative document in regular according to the service data acquisition for setting.
Specifically, collection sub-module stored gathers out the value needed product-standard-project from the XML file of standard more,
Acquiescence collection title, name of product, inspection project name, personnel, instrument and equipment, reagent, the method for inspection, environment, standard
Value and structured relations (parent, sub- level relation), user can also be according to the self-defined collection rule of actually detected project.
Collection rule must be first carried out submodule is set, after being provided with, just normative document is acquired.
The field of data base system is needed in C, the field label preparation structural data according to standard in normative document.
Specifically, data conversion configuration submodule allocating default list includes：Title, name of product, inspection project
Title, personnel, instrument and equipment, reagent, the method for inspection, environment, standard value and structured relations (parent, sub- level relation).If
The field of data base system need not be newly increased, then converts default fields, it is not necessary to which reset Configuration Data conversion configuration submodule.
D, the field storage of the structural data that will have been configured are arrived in bivariate table relevant database.
Data transformant module list acquiescence includes：Title, name of product, inspection project name, personnel, instrument set
The information such as standby, reagent, the method for inspection, environment, standard value, structured relations (parent, sub- level relation), are stored as the two of database
Dimension table data, data base system.
Data in E, encapsulation bivariate table relevant database.
Specifically, being packaged using business datum interface module, information system can be by business datum interface mould
Block calls the inspection project of structural data.
In work is checked, the inspection to certain product is related to product, standard and inspection project.From logical relation therebetween
, there is corresponding relations of the n to n in angle analysis, and between standard and inspection project be 1 couple of n between product and standard.Product, mark
Association between accurate and inspection project constitute one check work needed for most basic feature.Come from the angle of data relationship
See, be at this level the corresponding relation of structuring, i.e. structural relation.
Specific embodiment of the invention is the foregoing is only, but technical characteristic of the invention is not limited thereto, Ren Heben
The technical staff in field in the field of the invention, all cover among the scope of the claims of the invention by the change or modification made.
Claims (7)
1. a kind of data collecting system of inspection project, it is characterized in that：Including service data acquisition module, business datum conversion mould
Block and business datum interface module；
Service data acquisition module, based on the structural relation in normative document between product, standard sum term mesh, for gathering structure
Change data；Structural relation between product, standard sum term mesh includes the structural relation of n between product and standard to n, and standard
1 pair of structural relation of n and inspection project between；
Business datum conversion module, the field of data base system is needed for preparing in structural data；And the structure that will have been configured
The field storage for changing data is arrived in bivariate table relevant database；
Business datum interface module, seals for encapsulating the data in bivariate table relevant database, and being exported to information system
Data after dress.
2. the data collecting system of a kind of inspection project according to claim 1, it is characterized in that：
Service data acquisition module includes that collection rule sets submodule and collection sub-module stored；Collection rule sets submodule
Based on the structural relation in normative document between product, standard sum term mesh, for setting service data acquisition rule；Collection storage
Submodule is regular according to the service data acquisition for setting, for gathering the structural data in normative document.
3. the data collecting system of a kind of inspection project according to claim 1 and 2, it is characterized in that：
Business datum conversion module includes data conversion configuration submodule and data transformant module；Data conversion configuration submodule
Field label according to standard in normative document prepares the field that data base system is needed in structural data；Data convert submodule
The field storage of the structural data for that will configure is arrived in bivariate table relevant database.
4. the data collecting system of a kind of inspection project according to claim 3, it is characterized in that：Normative document is XML texts
Part.
5. the data collecting system of a kind of inspection project according to claim 1, it is characterized in that：Information system includes
ERP system, PDM systems and LIMS systems.
6. the data collecting system of a kind of inspection project according to claim 1, it is characterized in that：Business datum interface module
Including the api interface for link information system.
7. a kind of use claim 1 to 6 any inspection project data collecting system collecting method, its feature
It is：Comprise the following steps successively：
A, based on the structural relation in normative document between product, standard sum term mesh, service data acquisition rule is set；Product,
Structural relation between standard sum term mesh includes the structural relation of n between product and standard to n, and standard and inspection project it
Between 1 pair of structural relation of n；
B, structural data collection normative document in regular according to the service data acquisition for setting；
The field of data base system is needed in C, the field label preparation structural data according to standard in normative document；
D, the field storage of the structural data that will have been configured are arrived in bivariate table relevant database；
Data in E, encapsulation bivariate table relevant database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611170124.XA CN106777128A (en) | 2016-12-16 | 2016-12-16 | The data collecting system and collecting method of a kind of inspection project |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611170124.XA CN106777128A (en) | 2016-12-16 | 2016-12-16 | The data collecting system and collecting method of a kind of inspection project |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106777128A true CN106777128A (en) | 2017-05-31 |
Family
ID=58892323
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611170124.XA Pending CN106777128A (en) | 2016-12-16 | 2016-12-16 | The data collecting system and collecting method of a kind of inspection project |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106777128A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108399154A (en) * | 2017-12-28 | 2018-08-14 | 北京金科汇智科技有限公司 | Engineering test data collecting system |
| CN110400033A (en) * | 2018-08-27 | 2019-11-01 | 上海纵坤信息技术有限公司 | Detection task distribution system and Detection task distribution method |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130297374A1 (en) * | 2009-10-12 | 2013-11-07 | Patrick D. Abbott | Targeted Equipment Monitoring System and Method for Optimizing Equipment Reliability |
| CN103676712A (en) * | 2013-11-22 | 2014-03-26 | 广东招润投资发展有限公司 | Intelligent control system and intelligent control method for test quality of medical clinical laboratory |
| CN103838796A (en) * | 2012-11-27 | 2014-06-04 | 大连灵动科技发展有限公司 | Webpage structured information extraction method |
| CN104091236A (en) * | 2014-07-08 | 2014-10-08 | 张海瑞 | Network-based management method for chemical product quality analysis and inspection |
| CN104573977A (en) * | 2015-01-24 | 2015-04-29 | 武钢集团昆明钢铁股份有限公司 | Quality data management system and method |
| CN105376314A (en) * | 2015-11-18 | 2016-03-02 | 深圳市博安达信息技术股份有限公司 | Method and device for extracting environmental monitoring and analyzing data into LIMS |
| CN106203786A (en) * | 2016-06-27 | 2016-12-07 | 温冬梅 | Medical laboratory's automatic assembly line indoor method of quality control and control system thereof |
-
2016
- 2016-12-16 CN CN201611170124.XA patent/CN106777128A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130297374A1 (en) * | 2009-10-12 | 2013-11-07 | Patrick D. Abbott | Targeted Equipment Monitoring System and Method for Optimizing Equipment Reliability |
| CN103838796A (en) * | 2012-11-27 | 2014-06-04 | 大连灵动科技发展有限公司 | Webpage structured information extraction method |
| CN103676712A (en) * | 2013-11-22 | 2014-03-26 | 广东招润投资发展有限公司 | Intelligent control system and intelligent control method for test quality of medical clinical laboratory |
| CN104091236A (en) * | 2014-07-08 | 2014-10-08 | 张海瑞 | Network-based management method for chemical product quality analysis and inspection |
| CN104573977A (en) * | 2015-01-24 | 2015-04-29 | 武钢集团昆明钢铁股份有限公司 | Quality data management system and method |
| CN105376314A (en) * | 2015-11-18 | 2016-03-02 | 深圳市博安达信息技术股份有限公司 | Method and device for extracting environmental monitoring and analyzing data into LIMS |
| CN106203786A (en) * | 2016-06-27 | 2016-12-07 | 温冬梅 | Medical laboratory's automatic assembly line indoor method of quality control and control system thereof |
Non-Patent Citations (3)
| Title |
|---|
| 季英凯: "省级疾控机构实验室信息系统的设计与实现", 《中国优秀硕士学位论文全文数据库》 * |
| 张兴哲等: "实验室信息管理系统在药品检验领域中的应用实践", 《中国药业》 * |
| 董代: "基于汽车生产过程的质量管理控制", 《电子质量》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108399154A (en) * | 2017-12-28 | 2018-08-14 | 北京金科汇智科技有限公司 | Engineering test data collecting system |
| CN110400033A (en) * | 2018-08-27 | 2019-11-01 | 上海纵坤信息技术有限公司 | Detection task distribution system and Detection task distribution method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Harrison et al. | An evaluation of the MOOD set of object-oriented software metrics | |
| WO2022094934A1 (en) | Site location-based system and method for management of engineering quality acceptance | |
| CN107423211A (en) | A kind of SDNS interfaces automatization test system and method | |
| CN106649100A (en) | Automatic test method and system | |
| CN109242439A (en) | Feature extraction recognition methods based on substation equipment associated data | |
| CN106227892A (en) | A kind of intellectual analysis database table relation generates the method and device of E R figure | |
| CN105138752B (en) | Intelligent substation SCD file land parcel change trace differentiation compares and methods of exhibiting | |
| CN105373472B (en) | A kind of method of testing and test system of the statistical accuracy based on database | |
| CN105140810B (en) | The soft pressing plate of intelligent substation whole station, which is thrown, moves back status check system and method | |
| CN103227734A (en) | Method for detecting abnormity of OpenStack cloud platform | |
| CN103760394B (en) | Automatic processing method and device for measured data of oscilloscope | |
| CN109033322A (en) | A kind of test method and device of multidimensional data | |
| CN110163458A (en) | Data assets management and monitoring method based on artificial intelligence technology | |
| CN103365777B (en) | A kind of method for generating test case and system | |
| CN106777128A (en) | The data collecting system and collecting method of a kind of inspection project | |
| CN106341257A (en) | Method and tool for customizing log analysis rules and automatically analyzing logs | |
| Dressler et al. | Late Bloomer Galaxies: Growing Up in Cosmic Autumn | |
| CN112380533A (en) | Method for checking security baseline of computer terminal | |
| CN103793437A (en) | Wafer test data processing method and system | |
| CN104008107A (en) | Implement method of knowledge base on operation and maintenance management | |
| CN102546296A (en) | Automatic detecting method and device for electric power industry information system networking safety evaluation | |
| CN108334456A (en) | A kind of SDNS interfaces automatization test system and method | |
| CN103368970B (en) | A kind of automation safety detection method for network objectives | |
| CN111309791A (en) | Automatic data acquisition method for detection instrument | |
| CN105447261B (en) | A kind of instruments of inspection for intelligent substation void circuit |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170531 |
|
| RJ01 | Rejection of invention patent application after publication |