CN107403274A - Detection and supervision message Management System Data database table structure and service logic flow - Google Patents
Detection and supervision message Management System Data database table structure and service logic flow Download PDFInfo
- Publication number
- CN107403274A CN107403274A CN201710645813.XA CN201710645813A CN107403274A CN 107403274 A CN107403274 A CN 107403274A CN 201710645813 A CN201710645813 A CN 201710645813A CN 107403274 A CN107403274 A CN 107403274A
- Authority
- CN
- China
- Prior art keywords
- information
- product
- sop
- management system
- experiment
- 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 OR CALCULATING; 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/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0633—Workflow analysis
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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
- G06F16/2282—Tablespace storage structures; Management thereof
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Educational Administration (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Game Theory and Decision Science (AREA)
- Development Economics (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
A kind of system scheme of the one kind " centralized management; decentralised control " used the present invention relates to a kind of database data table structure in the database of design analysis testing agency and the information management system of supervision and administration organization, more particularly to the realization of trunk service logic in experiment detection and supervision and management, belong to computer software data structure and algorithm field, important last use is produced in the writing of information management system of analysis testing agency and supervision and administration organization, is its important technology part.
Description
Technical field
The present invention relates to a kind of in design analysis testing agency and the database of the information management system of supervision and administration organization
When a kind of system scheme of one kind " centralized management, decentralised control " that uses of database data table structure, and in particular to
The realization of trunk service logic, belongs to computer software data structure and algorithm field in experiment detection and supervision and management, is dividing
The information management system of analysis testing agency and supervision and administration organization writes the important last use of middle generation, is its important technology
Part.
Background technology
The applicant have submitted " detection and supervision message management system framework and the method for programming " simultaneously with today
Application for a patent for invention, the application are in " detection and supervision message management system framework and the method for programming " patent of invention Shen
On the basis of the technology essential factor that please be state, then the angle from experiment detection and the realization of trunk service logic in supervision and management, use
Data structure is addressed further under analyzing the hardware and software framework of the information management system of testing agency, specification analysis detection with algorithm
The data structure of laboratory information key element, make its generalization, standardization, and also to reach with administrative organizations at different levels of China to analysis
The technical management means that the technical supervision management of testing laboratory is constantly put into effect match, and the information management applied with it is soft
Part module is compatible, and providing one to analysis testing agency and regulator is advantageous to build supervisory organ's information management and laboratory
The information management framework design solution that both information managements blend.
The content of the invention
While the present inventor and present patent application are submitted, also have submitted " detection and supervision message management system framework and
The method of programming " application for a patent for invention and " detection and the physical structure of supervision message management system " utility model patent Shen
Please, these three patent applications are directed to the technical scheme of complete set and managed to solve current experiment room detecting system and supervision
Manage the following key problem of systems face：(1) information element for examining product expects the information element uniformity of management with supervision department；
(2) business publicity in advance is detected, supervises in thing, traces afterwards, ensures public credibility；(3) Rapid Popularization, examination criteria stream is popularized
Journey, improve detection level；(4) information management system of classification and digitlization Design of Laboratory Management System, to adapt to digital information
Technology and information administrative skill develops asynchronous.
The applicant is in " detection and supervision message management system framework and the method for programming " application for a patent for invention
Propose a complete technology essential factor：The centralized management of information, the scattered independent control of e-laboratory, detection and supervision
Information management system physical structure is as shown in Figure 1.Based on Fig. 1 information management system physical structures, so that " detection is believed with supervision
The information data structure design and information data proposed in breath management system framework and the method for programming " application for a patent for invention
The standardization of structure, in conjunction with the routine workflow of analysis detection, present patent application proposes " detection and supervision message
The basic definition of Management System Data database table structure and service logic flow ", therefore present patent application is and " detection and prison
The supporting sister patent application of the method for superintending and directing information management system framework and programming " application for a patent for invention, its technical characteristic
It is expressed as follows.
The technical program Global Information management system physical structure is planned to two parts, and a part is laboratory information
System (abbreviation LIS laboratory information system), wherein containing information center database, message tube
Reason system, location information management system client terminal A and satellite positioning information transceiver, its major function are resource managements,
SOP (Standard Operating Procedure standard operating procedures) information management of experimental implementation, sample message pipe
Reason, Work Process Management (task is audited, and is distributed)；Another part is mounted in the experimental implementation system in independent laboratory room
(abbreviation LOS Laboratory operation system), wherein contain data acquisition management system, experimental data base,
Experimental implementation management system, experimental facilities management control terminal, client and incidental experimental facilities and experiment sensor
Control and data acquisition, its major function is laboratory environment (equipment) data acquisition, experimental implementation record management, workflow
Thread management (experiment starts, and end is cleared out a gathering place).So-called independent laboratory room is defined as only with a set of experimental implementation management system
Unite the regional space of (LOS) management, can be a room, or an analysis detection basic equipment laboratory building module,
Can be multiple rooms or multiple analysis detection basic equipment laboratory building modules.
Information center database recommend the Orcale databases of Oracle, Microsoft Sql databases,
The database of the dBase databases price of IBM companies costly, but room front end data storehouse in laboratory recommends
Database this kind of free or cheap mysql, if having sufficient funds certainly or there are higher privacy requirements, use
The database of the prices such as Orcale, Sql, dBase costly is also extraordinary selection.Can between database and database
To carry out the synchronization of relevant information data by background program, the uniformity of information is kept.External mechanism can be by predefined
Interface realize authorize accessing database data.
Any one information management system has been required for a trunk flow architecture design, in the present invention, its information master
Dry flow scheme design should be the object around analysis detection：Inspection product/sample (sample), to examine the life cycle of product/sample
Workflow (work flow) in (life cycle) is the backbone architectures of this information system.The present invention state by
The information system (LIMS Laboratory Information Management System) of LIS+LOS two systems structure
In, it is necessary to which workflow in LIS and LOS the two systems in overall arrangement inspection product/sample life cycle, this is the present invention
The technical problem underlying to be solved.Used for those in the information system of analysis testing agency and supervisory organ
The information exchange for belonging to simple files classes and its information management, such as various files sign and issue management, data management, manpower
Resource management, the examination ＆ approval management of administrative things etc., have all formd the OA (office automation Office Automation) of oneself
The software module of framework, when the information management system of the LIS+LOS with the present invention is combined, the system has been run to these
The software module of OA frameworks is open, compatible, and these contents are not the problem to be solved in the present invention.Therefore the present invention to be solved
Certainly the main points of problem be make the information management system of supervisory organ the information management system of analysis institution is carried out real-time oversight and
The initial data of the information management system of analysis institution is traced to the source.To solve this Key technique problem, primary be will be in this hair
Built in bright relied on LIS+LOS information management system to examine the main-line program frame of the workflow in product life cycle
Structure, the technology essential factor of the invention to be stated are around this expansion.
First technology essential factor proposed by the present invention is on the basis of LIS and LOS system physical frameworks, designs following master
Want service logic flow：
Main process
Task packet stream journey is generated in LIS systems, Fig. 2 is that task bag generates service logic FB(flow block) in LIS systems.
In fig. 2, four roles are defined：Censorship side, handler, business director, test dispatcher.
The logical relation of four roles is as shown in Figure 3.Fig. 3 is task bag generation service logic FB(flow block).
Experimental implementation flow in LOS systems
Second technology essential factor proposed by the present invention is the generation experimental implementation flow in LOS systems, and defines a role：
Laboratory technician, the working service logical procedure diagram of the laboratory technician in LOS systems are as shown in Figure 4.
3rd technology essential factor proposed by the present invention is to realize above-mentioned service logic, and the present inventor designs the number of 5 cores
According to Ku Biao and their subordinate list, the data interaction of whole information system is around this 5 core database table expansion.
Table 1：Sample detection table
It is attached：Sample detection message code in the sample detection table of table 1, the coding method used is combinational code
Table 2：Sop (analysis examination criteria operating procedure) information table
It is attached：Sop message codes in table 2sop (analysis examination criteria operating procedure) information table, the coding method used for
Combinational code
Table 3：Consumable part table
It is attached：Consumable information code in the consumable part table of table 3, the coding method used is combinational code
Equipment list represented by table 4
It is attached：The equipment information code of equipment list represented by table 4, the coding method used is combinational code
The experimental record table of table 5
Concrete methods of realizing：It is divided into three phases：
First stage assigned tasks
4th technology essential factor proposed by the present invention is the service logic FB(flow block) of the first stage distribution task shown in Fig. 5
1：Handler, news file is established according to the censorship project of censorship side；News file mainly includes censorship side's information
With inspection product information, handler, according to designed Data Enter list, completes following Data Enter in LIS systems：
2：Above- mentioned information fills in completion, can automatically write database table (table 1：Sample detection table) in corresponding data item：
4：After the completion of Data Enter, submission task is accepted to business director；
5：Business director checks submitted sample information, and the related sop in SOP information tables is corresponded to according to censorship information searching
Standard and method；And shown in systems with following list
6：The existing SOP standards of business director's root and method, with reference to current experiment condition, select suitable SOP standards and side
Method；If not having alternative SOP standards and method in system, business director can increase conjunction according to present experiment condition
Suitable SOP standards and method；If existing experiment condition, testing requirements can not be met, external connection can be selected, or decline this
Testing requirements, and notify that handler passs on censorship side.
7：Business director completes the selection of SOP standards and method, it is believed that can be detected, system can update (the SOP of table 2
Information table) in sop message codes (sopxxdm) and (sample detection table) the sample detection message code of table 1 (ypjcxx) in phase
Off-position metamessage simultaneously updates table 1 (sample detection table) data item " SOP information is surveyed in product/inspection product examine ".
Table 1 (sample detection table)
8：Business director submits task to testing dispatcher；
9：The SOP standard and method that experiment dispatcher selects according to business director, setting required for preparing experiment environment
Standby and consumptive material；
* * * * * (needing to carry out some character express to following table)
System can update contiguous items in following tables：
The consumable part table of table 3
Consumable information code in the consumable part table of table 3
The equipment list of table 4
Equipment information code in the equipment list of table 4
10：Experiment dispatcher is assigned, and notifies business director, and experimental resources are ready；
11：Business director distributes a task bag；Task bag code is recorded in contiguous items in the sample detection table of table 1.
| Short name | Definition | Data type | Value rule | Explain |
| jcrwbdm | Task bag code | Character type | Free text |
" product/inspection product examine survey SOP information, equipment of the system in sample detection message code in the sample detection table of table 1
Information, material information, task Bale No. code " information, data table related is retrieved, association data record copies are come out, form one
Assignment file bag.
Second stage performs task
5th technology essential factor proposed by the present invention is that second stage as shown in Figure 6 performs task business logic flow frame
Figure
1：LIS systems active push task bag is to LOS systems；
2：LOS systems update data table related sample detection table, sop information tables, consumption according to the data message in task bag
Material table, associated data item in equipment list；
3：After laboratory technician logs in, Detection task and test experience resource are inquired about；
4：If experimental resources are unsatisfactory for requiring, to experiment dispatcher's application, after experiment dispatcher distributes confirmation, LIS systems
Consumable part table equipment list information in system can be synchronized to consumable part table and equipment list in LOS systems；
5：Experimental resources meet to require, start to test；
6：Operated and guided according to SOP, call different task form, complete information solicitation；
(1) equipment operation form is：
And it is automatically saved to contiguous items in experimental record table
(2) ingredients operation note form is：
And it is automatically saved to contiguous items in experimental record table
(3) weighing operation note form is：
And it is automatically saved to contiguous items in experimental record table
(4) experimental result record form is：
| A | B | C | D | * | * |
| Operation order encodes | Testing result title | As a result 1 | As a result 2 | ...... | As a result n |
| ...... |
And order charges to contiguous items in experimental record table.
Experimental record table
7：All experiment original records formed can play back reading during whole experiment, but can not repair
Change.While progress in proper order with analysis detection experiment, system is acquired and recorded to the service data for testing relevant device, shape
Into " the shadow address " (operation of associated equipment in the record experimentation supporting with experiment original record and laboratory report book
The record report of parameter, referred to as " shadow address ").Laboratory technician is in systems according to experiment original record and with reference to shadow address
Result of the test is analyzed, error correction (check), Pose Edit goes out to reflect laboratory report book that result of the test is the theme.
Laboratory technician is to LIS systems are submitted by laboratory report book, testing original record, shadow address, these three report combination after off-test
As the laboratory report of an entirety.
8：Experiment is cleared out a gathering place, and laboratory technician is cleared up and registered to experiment consumptive material, equipment, the equipment that is triggered by experimentation and
Consumptive material changes, after experiment terminates, in the consumptive material and facility information meeting synchronized update LIS systems in LOS systems.
Three phases task is assessed
Return to LIS systems
6th technology essential factor proposed by the present invention is that the three phases task of LIS systems as shown in Figure 7 assesses business
Logical procedure diagram
1：Business director examines laboratory report, after errorless, submits person approving；
2：Person approving checks, has no problem, confirmation can issue laboratory report；Such as pinpoint the problems, be then returned to business master
Appoint；
3：Data item in the location information table of initial table 6；Contiguous items in the sample detection table of table 1 is synchronized to table
Contiguous items in 6 location information tables.
The sample detection table of table 1
The location information table of table 6
4：After synchronization, the storage place and storage environment information for having been subjected to detection product can be recorded；
5：Location information management system
7th technology essential factor proposed by the present invention is the Business Stream of the location information management system in LIS as shown in Figure 8
Journey logic diagram
6：Product is a life cycle from stock to sale.Product orientation information management system is exactly the table around definition
6 product information tables, all event traces of the record product in a life cycle.
7：Orientation management system can be automatically with intelligent chip information exchange, and by starting point, transfer, terminal environmental data recorded
In location information table, complete documentation products in circulation process.
8：Technical characterstic in laboratory information system of the present invention is the increase in sampling (supervision) personnel motion
Track satellite positioning information management system and product global position system.The product refers to food, medicine, health products, cosmetic
Product, veterinary drug, agricultural chemicals, chemical fertilizer and environment supervise taken detection sample etc..Satellite positioning information receiving/the emitter
(abbreviation satellite positioning device) refers to utilize GPS (global navigation satellite system) or Big Dipper global navigation satellite positioning system
System, using by control chip (embedded main control chip, for controlling other hardware and running corresponding embedded software), the whole world
(GPS or Beidou satellite navigation positioning number can be achieved in navigation positioning system (GPS) or Beidou satellite navigation and positioning system locating module
According to collection), GPRS module (lead to by general wireless packet service system General Packet Radio System, achievable data
News, for the information communication between software program and satellite positioning information management system), humiture induction module (the warm and humid number of degrees
According to collection) the miniature electric geo-location mark of software and hardware system that is made up of main component, it is affixed to the bag of product
Load onto, the dispatching from the factory to consumption in product together with the product satellite positioning information management system in laboratory information system of the present invention
Products in circulation link between person implements satellite navigation locating and tracking information gathering to flowing through for product.It is particularly (outstanding to food
It is the chilled food for needing cold chain transportation), medicine (biological agent for especially needing cold chain), can effectively obtain
These products and are written into Database Systems, form complete product in the geo-location and humiture information of intermediate links
Circulation information chain.Administrative staff can easily log in the circulation situation of laboratory information system tracking and supervising product, be to ensure
Products in circulation link quality, prevent the effective means of fake products.Satellite navigation and location system locating module is matched in sample
Collection or enforcer of administration, can effectively understand the movement track of sample collection and administrative law enforcement at work, have very much
Beneficial to back-stage management personnel and the scheduling layout of front staff and the management of corresponding accident.Personnel's satellite fix can
Simply to use the satellite positioning functions of mobile phone to realize, but drawback, which is mobile phone, belongs to personal objects, is directly positioned with mobile phone
It is accused of exposing individual privacy, and lacks corresponding management system in information management system.Determined using the satellite navigation of work
Position system locating module, is worn, the non-working time is placed on Administrative Area, does not influence individual privacy, and valency at work
Lattice will be less than the price of mobile phone far away.Another feature of laboratory information system is led to by network and the information in the external world
News, it is that very important, basic way is that the excellent anti-firewall technology of selection comes really safely with extraneous network communication system
Protect the safety of itself.The application of information network security technology in the present invention is the usual way in professional domain, present specification
Just repeat no more.
9：The power issue during difficulty that satellite positioning information receiving/emitter faces at present, because as product
The locating and tracking of logistics links, satellite positioning information receiving/emitter needs to consume to be provided by rechargeable battery
Electric energy, and the guarantee of the electric energy of rechargeable battery has the time limit.Solution is to make satellite positioning information receiving/hair
The high power capacity as far as possible of the chip and electronic device and selection of low-power consumption under volume license is selected during injection device as far as possible
Rechargeable battery.Believe the progress with the Low-power Technology of electronic chip and the high density high-energy technology of rechargeable battery,
The volume of satellite positioning information receiving/emitter can be less and less, battery cruising ability can increasingly be grown, price can be more next
It is lower, tracked with the product orientation for meeting the more inner wrapping lower longer time.Instantly solution is first to believe satellite fix
Cease the product stream locating and tracking that receiving/emitter is applied to larger packaging even vehicle or whole counter, such as product
Middle packaging, the van cooler of cold chain transportation, vaccine, the freezing and refrigeration transport case etc. of strain and biological agent.With present core
Piece and battery technology, the cruising time for meeting two weeks is the technology generally used, therefore is that can meet most productions
The locating and tracking of product intermediate links.Satellite positioning information receiving/emitter is not expendable consumed product, when product transports purpose to
It can reclaim after ground, therefore not only can provide means for administrative supervision mechanism, can also be as the producing of product, wholesale enterprise
Track and localization of the industry in products in circulation field uses, and so supervises to be combined can with production and thus construct product and is circulating
The quality assurance net of link.With the satellite positioning module of supervisor the product of charger baby class can be used to solve electricity for sampling
Can problem.
10：There are one-dimension code, Quick Response Code and RFID (electronic tag) in the geolocation application field of product at present
Technology realizes GPS location function to product indirectly.One-dimension code, Quick Response Code must read data message by means of scanning machine,
RFID must read data message by means of ETC card reader (RFID reader).They are by the data message of reading
Pass through network transmission to central information management system.Because the geographical position of scanning machine or ETC card reader is in central information
Identify in management system, swept so can reads these in the terminal of central information management system by scanning machine or ETC
The geographical location information of the product for posting one-dimension code, Quick Response Code or electronic tag after retouching.Due to using by read one-dimension code,
Quick Response Code or electronic tag are come to obtain the premise of the geo-localisation information of product be scanning machine or the geographical position cloth of ETC card reader
Office, so the mode of this acquisition product geographical location information can be referred to as " passive product orientation " pattern by us.Passively
The shortcomings that product orientation pattern, is just to turn into product orientation tracking for the region of no layout scanning machine or ETC card reader
Blind spot, this is clearly that cannot ensure the supervision to track after product export.But the advantages of one-dimension code and Quick Response Code and RFID, is
Cheap, the price of especially one-dimension code and Quick Response Code is the price of paper, almost nil.The present invention recommend product orientation with
Track field received using satellite positioning information/and emitter belongs to " active product orientation " pattern, it there's almost no product orientation
Dead angle, so can almost realize tracking all standing of the product in intermediate links.But a disadvantage is that the supply of price, electric energy is gone back at present
It cannot be used for as electronic tag and one-dimension code, Quick Response Code on the minimum package of product, and may be only available for product
In or the packaging of FCL on.And be combined Quick Response Code with satellite positioning information receiving/emitter proposed by the present invention, will be
One perfect product orientation tracking scheme.Quick Response Code is namely attached to product (also including one-dimension code, first-elected Quick Response Code)
In all packagings, along with satellite positioning information receiving/emitter system is assigned in product or on case packing, in product satellite
Increase the information management content of Quick Response Code in location information management system, it is possible to by " active " and " passive " two kinds of product orientation
Function organically combines.Therefore the technology essential factor of " product satellite positioning information management system " described in the present inventor is to contain two dimension
The double technique that code information management is combined together with two technologies of satellite positioning information management.
Inventor is discussed to LIS and LOS main business logic flows, needs further to do what technology was explained herein
It is to sign to sign and issue examination ＆ approval link for inspection product reception link and report in the specific workflow in laboratory (work flow)
Flow and disunity, for example, some analysis testing agencies inspection product receive link, execution is the business head of the department and control laboratory
Director's two-stage is examined；Examination ＆ approval link is signed and issued to report by some analysis testing agencies, and what is adhered to is to examine chief of the office, business department
Director, the examination ＆ verification of quality authorization people three-level are signed and issued, and what some were performed is report verification, report review, examines head of the department's examination ＆ verification,
The business head of the department audits, the Pyatyi examination ＆ verification that quality authorization people signs and issues.The present inventor assesses business in statement assigned tasks and task
In logic, One function role (director) is only designed, because in the design for carrying out software architecture, emphasis considers general
Property, terseness；And in actual applications, multiple examination ＆ approval roles can be set according to customer demand, complete the examination ＆ approval that client needs
Service logic flow, illustrates hereby.
In summary, the present invention is special in " detection and supervision message management system framework and the method for programming " invention
The detection that its is proposed is managed with supervision message in the category of complete technology essential factor in profit application, from computer software data structure with
Algorithm angle, by the statement of database table structure and service logic flow, further perfect " detection and supervision message management system
The computer information management Software Architecture Design and specific procedure of system framework and the method for programming " write the phase just wanted inside the Pass
Hold, it is mainly technically characterized by building jointly in laboratory information system (LIS) and experimental implementation system (LOS) the two systems
Information management system (LIMS) on the basis of, pass through and generate that task bag generates operation flow and task is assessed in LIS systems
Operation flow, experimental implementation flow is generated in LOS systems, operation flow, business assess operation flow, experimental implementation flow is enclosed
Around the database table and their subordinate list progress information exchange of 5 cores, and inspection product/sample is realized by three phases
(sample) information management of whole life cycle workflow.
Brief description of the drawings
Fig. 1：Detection and supervision message management system physical structure figure
Fig. 2：Task bag generates service logic FB(flow block) in LIS systems
Fig. 3：The mutual logical relation block diagram of task bag product process block diagram
Fig. 4：The working service logical procedure diagram of laboratory technician in LOS systems
Fig. 5：First stage distributes the service logic FB(flow block) of task
Fig. 6：Second stage performs task business logical procedure diagram
Fig. 7：The three phases task of LIS systems assesses service logic FB(flow block)
Fig. 8：The service logic FB(flow block) of location information management system.
Claims (6)
1. detection and supervision message Management System Data database table structure and service logic flow, it is characterized in that in laboratory information system
Unite on the basis of (LIS) and experimental implementation system (LOS) system physical framework, generated by generating task bag in LIS systems
Operation flow and task assess operation flow, and experimental implementation flow is generated in LOS systems, task bag generation operation flow, is appointed
Business assessment operation flow, experimental implementation flow surround the database table and their subordinate list progress information exchange of 5 cores, and
The information management of inspection product whole life cycle workflow is realized by three phases, and the positioning letter generated in LIS systems
Cease the operation flow of management system.
2. according to claim 1 detection and supervision message Management System Data database table structure and service logic flow, it is characterized in that
The logic of task bag generation operation flow is handler, and news file, news file master are established according to the censorship project of censorship side
To include censorship side's information and inspection product information, handler, according to designed Data Enter list, completes letter in LIS systems
Typing is ceased, after the completion of Data Enter, submission task is accepted to business director,
Business director checks submitted sample information, and according to censorship information searching correspond to related SOP standards in SOP information tables and
Method, and show in systems,
Business director, with reference to current experiment condition, selects suitable SOP standards and method, such as according to existing SOP standards and method
There is no alternative SOP standards and method in fruit system, for business director according to present experiment condition, it is suitable to increase
SOP standards and method；If existing experiment condition, testing requirements can not be met, external connection can be selected, or decline this time to detect
It is required that and notify that handler passs on censorship side,
Business director completes the selection of SOP standards and method, it is believed that can be detected, system can be updated in SOP information tables
Relevant bits information is simultaneously in SOP message codes (sopxxdm) table and sample detection table sample product examine measurement information code (ypjcxx) table
" SOP information is surveyed in product/inspection product examine " of sample detection table data item is updated,
Business director submits task to testing dispatcher,
The standard and method for the SOP that experiment dispatcher selects according to business director, equipment and consumption required for preparing experiment environment
Material, experiment dispatcher are assigned, and notify business director, and experimental resources are ready,
Business director distributes a task bag；Task bag code is recorded in contiguous items in sample detection table, is wrapped in task bag
Containing operator message,
" product/inspection product examine survey SOP information, facility information, thing of the system in sample detection message code in sample detection table
Expect information, task Bale No. code " information, data table related is retrieved, association data record copies are come out, forms an assignment file
Bag.
3. according to claim 1 detection and supervision message Management System Data database table structure and service logic flow, it is characterized in that
The logic of experimental implementation flow is LIS systems active push task bag to LOS systems,
LOS systems update the data table sample detection table, SOP information tables, consumable part table, equipment according to the data message in task bag
Associated data item in table,
After laboratory technician logs in, Detection task and test experience resource are inquired about,
If experimental resources are unsatisfactory for requiring, to experiment dispatcher's application, after experiment dispatcher's distribution confirms, in LIS systems
Consumable part table equipment list information can be synchronized to consumable part table and equipment list in LOS systems,
Experimental resources meet requirement, start to test,
Operated and guided according to SOP, call different task form, complete information solicitation,
All experiment original records formed can play back reading during whole experiment, but can not change, with
While analysis detection experiment is carried out in proper order, system is acquired and recorded to the service data for testing relevant device, forms " shadow
Son report ", i.e., with experiment original record and laboratory report book, the operation of associated equipment is joined in supporting record experimentation
Several record reports, referred to as " shadow address ", laboratory technician according to experiment original record and refer to shadow address pair in systems
Result of the test is analyzed, error correction (check), Pose Edit go out to reflect laboratory report book that result of the test is the theme.Trying
Test laboratory technician after end and submitted to LIS systems and is combined into by laboratory report book, experiment original record, shadow address these three reports
For the laboratory report of an entirety,
Experiment is cleared out a gathering place, and laboratory technician is cleared up and registered to experiment consumptive material, equipment, and the equipment and consumptive material triggered by experimentation becomes
Change, after experiment terminates, in the consumptive material and facility information meeting synchronized update LIS systems in LOS systems.
4. according to claim 1 detection and supervision message Management System Data database table structure and service logic flow, it is characterized in that
The logic that task assesses operation flow is that business director examines laboratory report, after errorless, submits person approving,
Person approving checks, has no problem, and confirmation can issue laboratory report, such as pinpoint the problems, then be returned to business director,
Initialize the data item table in location information table；Contiguous items in sample detection table is synchronized in location information table
Contiguous items.
5. according to claim 1 detection and supervision message Management System Data database table structure and service logic flow, it is characterized in that 5
The database table of individual core and their subordinate list are：
The sample detection table of table 1
Sample detection message code in the subordinate list sample detection table of table 1, the coding method used is combinational code
Table 2：SOP (analysis examination criteria operating procedure) information table
Sop message codes in subordinate list SOP (analysis examination criteria operating procedure) information table of table 2, the coding method used for
Combinational code
Table 3：Consumable part table
Consumable information code in the subordinate list consumable part table of table 3, the coding method used is combinational code
The equipment list of table 4
The equipment information code of the subordinate list equipment list of table 4, the coding method used is combinational code
The experimental record table of table 5
The location information table of table 6
6. according to claim 1 detection and supervision message Management System Data database table structure and service logic flow, it is characterized in that
It is a life cycle that the logic of the operation flow of location information management system, which is product from stock to sale, product orientation information
Management system is exactly the location information table around definition, all event traces of the record product in a life cycle, is positioned
Management system can be automatically with intelligent chip information exchange, and by starting point, transfer, terminal environmental data recorded in location information table,
Complete documentation products in circulation process,
Technical characterstic in laboratory information system of the present invention is the increase in sampling (supervision) personnel motion trail and defended
Star location information management system and product global position system, the satellite positioning information receiving/emitter (abbreviation satellite
Position device) refer to utilize GPS (global navigation satellite system) or Big Dipper global navigation satellite system, using by controlling
Coremaking piece (embedded main control chip, for controlling other hardware and running corresponding embedded software), worldwide navigation positioning system
Unite (GPS) or Beidou satellite navigation and positioning system locating module (GPS or Beidou satellite navigation position data collecting can be achieved),
GPRS module (general wireless packet service system General Packet Radio System), humiture induction module are (warm and humid
Degrees of data gathers) the miniature electric geo-location of software and hardware system that is made up of main component identifies, it is affixed to product
Packaging on, together with the product satellite positioning information management system in laboratory information system of the present invention product dispatch from the factory to
Products in circulation link between consumer implements satellite navigation locating and tracking information gathering to flowing through for product, and LIS is obtaining this
A little products and are written into Database Systems, form complete product stream in the geo-location and humiture information of intermediate links
Logical message sense, administrative staff can log in the circulation situation of laboratory information system tracking and supervising product, satellite navigation positioned
System locating module is matched in sample collection or enforcer of administration, can effectively understand sample collection and administrative law enforcement in work
Movement track in work.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710645813.XA CN107403274A (en) | 2017-07-24 | 2017-07-24 | Detection and supervision message Management System Data database table structure and service logic flow |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710645813.XA CN107403274A (en) | 2017-07-24 | 2017-07-24 | Detection and supervision message Management System Data database table structure and service logic flow |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107403274A true CN107403274A (en) | 2017-11-28 |
Family
ID=60402649
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710645813.XA Pending CN107403274A (en) | 2017-07-24 | 2017-07-24 | Detection and supervision message Management System Data database table structure and service logic flow |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107403274A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111461642A (en) * | 2020-03-13 | 2020-07-28 | 国家电网有限公司 | Water and electricity technology supervision test data acquisition and analysis method and system |
| CN111861150A (en) * | 2020-06-30 | 2020-10-30 | 南京华盾电力信息安全测评有限公司 | Technical supervision standardization method, system and technical supervision plan formulation method |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101853305A (en) * | 2010-06-11 | 2010-10-06 | 湖南大学 | A method of constructing comprehensive agricultural environment information database |
| CN102591991A (en) * | 2012-01-19 | 2012-07-18 | 北京世纪东方国铁科技股份有限公司 | Train data acquisition and management method and train data acquisition and management system |
| CN104484375A (en) * | 2014-12-08 | 2015-04-01 | 深圳华大基因科技服务有限公司 | Method and system for automatically building database in item analysis process |
| CN104598625A (en) * | 2015-02-04 | 2015-05-06 | 中国人民解放军总后勤部军事交通运输研究所 | Data table storage method based on automatic identification identifier |
| CN105023225A (en) * | 2015-07-20 | 2015-11-04 | 杭州天夏科技集团有限公司 | Urban administrative law enforcement information system |
| CN105279817A (en) * | 2014-07-02 | 2016-01-27 | 北京世纪网盛科技有限公司 | New generation intelligent monitoring and tracing system for food safety |
| CN105447681A (en) * | 2015-11-22 | 2016-03-30 | 沈阳黎明航空发动机(集团)有限责任公司 | Physicochemical detection control and information management system |
| CN105761049A (en) * | 2016-02-01 | 2016-07-13 | 中国石油化工股份有限公司 | Oil field geology development experiment report publishing and management system |
| CN105912909A (en) * | 2016-04-20 | 2016-08-31 | 孙雨 | Monitoring and management system and method for construction project quality detection |
| CN206075365U (en) * | 2016-08-25 | 2017-04-05 | 成都慧途科技有限公司 | Public supply mains intelligent inspection system based on navigation positioning satellite |
-
2017
- 2017-07-24 CN CN201710645813.XA patent/CN107403274A/en active Pending
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101853305A (en) * | 2010-06-11 | 2010-10-06 | 湖南大学 | A method of constructing comprehensive agricultural environment information database |
| CN102591991A (en) * | 2012-01-19 | 2012-07-18 | 北京世纪东方国铁科技股份有限公司 | Train data acquisition and management method and train data acquisition and management system |
| CN105279817A (en) * | 2014-07-02 | 2016-01-27 | 北京世纪网盛科技有限公司 | New generation intelligent monitoring and tracing system for food safety |
| CN104484375A (en) * | 2014-12-08 | 2015-04-01 | 深圳华大基因科技服务有限公司 | Method and system for automatically building database in item analysis process |
| CN104598625A (en) * | 2015-02-04 | 2015-05-06 | 中国人民解放军总后勤部军事交通运输研究所 | Data table storage method based on automatic identification identifier |
| CN105023225A (en) * | 2015-07-20 | 2015-11-04 | 杭州天夏科技集团有限公司 | Urban administrative law enforcement information system |
| CN105447681A (en) * | 2015-11-22 | 2016-03-30 | 沈阳黎明航空发动机(集团)有限责任公司 | Physicochemical detection control and information management system |
| CN105761049A (en) * | 2016-02-01 | 2016-07-13 | 中国石油化工股份有限公司 | Oil field geology development experiment report publishing and management system |
| CN105912909A (en) * | 2016-04-20 | 2016-08-31 | 孙雨 | Monitoring and management system and method for construction project quality detection |
| CN206075365U (en) * | 2016-08-25 | 2017-04-05 | 成都慧途科技有限公司 | Public supply mains intelligent inspection system based on navigation positioning satellite |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111461642A (en) * | 2020-03-13 | 2020-07-28 | 国家电网有限公司 | Water and electricity technology supervision test data acquisition and analysis method and system |
| CN111861150A (en) * | 2020-06-30 | 2020-10-30 | 南京华盾电力信息安全测评有限公司 | Technical supervision standardization method, system and technical supervision plan formulation method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Sahara et al. | Real-time data integration of an internet-of-things-based smart warehouse: a case study | |
| Zheng et al. | Construct food safety traceability system for people’s health under the internet of things and big data | |
| Gharaibeh et al. | Toward digital construction supply chain-based Industry 4.0 solutions: scientometric-thematic analysis | |
| Hikmawati et al. | Improving data quality and data governance using master data management: a review | |
| CN104504543A (en) | Project investment control and management system and use method thereof | |
| Ikonen et al. | Use of embedded RFID tags in concrete element supply chains. | |
| CN102163306A (en) | Discrete manufacturing process product quality information management system based on RFID (radio frequency identification) | |
| CN202373029U (en) | Commodity circulation tracing system | |
| Zhang et al. | Real-time work-in-progress management for smart object-enabled ubiquitous shop-floor environment | |
| Wu | [Retracted] Optimization of E‐Commerce Supply Chain Management Process Based on Internet of Things Technology | |
| CN103390218A (en) | Three-chain coupling integrated emergency security system and method for emergencies | |
| CN109816317A (en) | Project Abroad logistic information management system | |
| Sharma et al. | A framework for hotel inventory control system for online travel agency using robotic process automation | |
| CN105868954A (en) | Raw material informatization management device | |
| Huang et al. | New business form of smart supply chain management based on “Internet of Things+ Blockchain” | |
| CN107403274A (en) | Detection and supervision message Management System Data database table structure and service logic flow | |
| Nasir et al. | Design and implementation a network mobile application for plants shopping center using QR code. | |
| Khan et al. | A Framework for automated reengineering of BPMN models by excluding inefficient activities | |
| Utami et al. | Implementation of Enterprise Resource Planning (ERP) Based Information System using odoo software | |
| CN118193813A (en) | Electronic document management method, device, computer equipment and storage medium | |
| Vitti et al. | Enhancing MRP adoption in SMEs: A python-based algorithmic approach | |
| Ghanem | Real-time construction project progress tracking: A hybrid model for wireless technologies selection, assessment, and implementation | |
| Sulaksono et al. | Implementation of enterprise resource planning (ERP) in the warehouse division | |
| Raisian et al. | Exploring Potential Factors in Green and Sustainable Software Product | |
| Osman et al. | Radio frequency identification system optimisation models for lifecycle of a durable product |
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 |