CN103390036A - History snapshot storage method applied to package test production line - Google Patents
History snapshot storage method applied to package test production line Download PDFInfo
- Publication number
- CN103390036A CN103390036A CN2013102988482A CN201310298848A CN103390036A CN 103390036 A CN103390036 A CN 103390036A CN 2013102988482 A CN2013102988482 A CN 2013102988482A CN 201310298848 A CN201310298848 A CN 201310298848A CN 103390036 A CN103390036 A CN 103390036A
- Authority
- CN
- China
- Prior art keywords
- snapshot
- variable
- data
- database
- production line
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- General Factory Administration (AREA)
Abstract
The invention discloses a history snapshot storage method applied to a package test production line. The method comprises the following steps of 1, establishing a table for storing the basic information of all variables in a database, storing a table for the snapshot data of the package test production line, and storing a table for a snapshot identity (ID) and a snapshot time; 2, connecting equipment, and storing the basic information of all variables into the variable basic information data table; 3, setting the variable information used as the snapshot; 4, acquiring the basic information of the snapshot variable; 5, operating the equipment, and enabling the equipment to report the snapshot data according to a fixed period; 6, storing the snapshot data uploaded by the equipment into a memory; 7, inserting the snapshot data and the snapshot time when the snapshot data in the memory reaches 1500 items. Due to the adoption of the method, the variables contained in the snapshot can be conveniently set according to different requirements of users on the snapshot data. The universality of the function and the storage performance can be improved. The method is applicable to the variability of the requirement on the snapshot function by a user.
Description
Technical field
The present invention discloses a kind of historical snapshot storage means that is applied to the packaging and testing production line, the present invention mainly provide for the packaging and testing production line pay close attention to need to be as the memory management method of the variable of snapshot historical data.
Background technology
In modern packaging and testing production line,, for the equipment in production line carries out remote-control, to reach, enhance productivity, the purpose of production standard, product quality, minimizing human cost.This just need to carry out Real-time Obtaining, storage, management to the production data of the equipment in the packaging and testing production line.And the variable information of equipment, due to characteristics such as data class are many, data volume is large, amount of redundancy is large, makes and how the equipment variables historical data is carried out effective management and control, just becomes a difficult point.
Summary of the invention
For the problems referred to above, the invention provides a kind of snapshot historical data storage method that is applied to the packaging and testing production line, equipment variables is carried out the requirement of effective management and control to adapt to the packaging and testing production line.
For achieving the above object, the technical solution used in the present invention is:
The database table of storage snapshot variable data is set at database.Choosing in database need to be as the variable of snapshot data.Obtain the snapshot data essential information, the equipment that arranges initiatively sends snapshot data.The snapshot data that the equipment that obtains sends, be stored in internal memory with snapshot data, and judgement is when full 1500 of the snapshot data in internal memory, and batch is inserted into the database snapshot tables of data, inserts the temporal information of this snapshot data and snapshot id information to the snapshot timetable.
Described a kind of historical snapshot storage means that is applied to the packaging and testing production line comprises the following steps:
Step 1, set up the table of storing all variable essential informations in database.The required table of storage enclosure test production line snapshot data, storage snapshot ID and the table of snapshot time.
Step 2, connection device, be stored in variable basic information database table with all variable essential informations.
Step 3, arranging need to be as the variable information of snapshot.
Step 4, obtain the essential information of snapshot variable.
Step 5,, to operate, make equipment upload snapshot data according to the fixed cycle.
Step 6, the snapshot data that equipment is uploaded is stored in internal memory.
Step 7, the snapshot data in internal memory often reach 1500, to database, insert snapshot data, insert the snapshot time.
In described step 1, set up the variable Basic Information Table of all variable essential informations of storage in database.The required SNAPSHOT INFO table of storage enclosure test production line snapshot data, storage snapshot ID and the tables of data of snapshot time.
In described step 2, connection device, be stored in variable basic information database table with all variable essential informations.After each database table in described step 1 establishes, the variable essential information is stored in the variable basic information database, comprises variable ID, variable name, management and control mode etc.
In described step 3, arranging need to be as the variable information of snapshot: in described step 2, need to be set to 1 as the management and control mode field value of the variable of snapshot data in the variable Basic Information Table.
In described step 4, obtain the essential information of snapshot variable.In described step 3, obtain management and control mode field value and be set to 1 data from the database variable Basic Information Table.
In described step 5,, to operate, be that equipment is uploaded snapshot data according to the fixed cycle.In described step 4, after obtaining snapshot variable essential information, the snapshot variable data of equipment active upload is set according to this information, comprise variable ID, variate-value that snapshot comprises.
In described step 6, the snapshot data that equipment is uploaded is stored in internal memory.In described step 5, the SNAPSHOT INFO that equipment is uploaded first is stored in internal memory, avoids too frequent to the write operation of database.
In described step 7, the snapshot data in internal memory often reaches 1500, to database, inserts snapshot data, inserts the snapshot time.In described step 6, when the data of storing reach 1500, carry out update in batches in internal memory, can improve like this writing speed of database.
Advantage of the present invention is:
The present invention realizes according to the different demands of user to snapshot data, the variable that snapshot comprises conveniently is set.Put forward H.D versatility, memory property.Adapt to the changeability of user to the snapshot functions demand.
Description of drawings:
Fig. 1 outline flowchart
Fig. 2 snapshot data setting procedure figure
Fig. 3 snapshot data Stored Procedure figure
Embodiment:
Described a kind of historical snapshot storage means that is applied to the packaging and testing production line comprises the following steps:
Step 1, set up the table of storing all variable essential informations in database.The required table of storage enclosure test production line snapshot data, storage snapshot ID and the table of snapshot time.
Step 2, connection device, be stored in variable essential information tables of data with all variable essential informations.
Step 3, arranging need to be as the variable information of snapshot.
Step 4, obtain the essential information of snapshot variable.
Step 5,, to operate, make equipment upload snapshot data according to the fixed cycle.
Step 6, the snapshot data that equipment is uploaded is stored in internal memory.
Step 7, the snapshot data in internal memory often reach 1500, to database, insert snapshot data, insert the snapshot time.
In described step 1, set up the table of all variable essential informations of storage in database.The required table of storage enclosure test production line snapshot data, storage snapshot ID and the table of snapshot time.
In described step 2, connection device, be stored in variable basic information database table with all variable essential informations.After each database table in described step 1 establishes, the variable essential information is stored in the variable basic information database, comprises variable ID, variable name, management and control mode etc.
In described step 3, arranging need to be as the variable information of snapshot: in described step 2, need to be set to 1 as the management and control mode field value of the variable of snapshot data in the variable Basic Information Table.
In described step 4, obtain the essential information of snapshot variable.In described step 3, obtain management and control mode field value and be set to 1 data from the database variable Basic Information Table.
In described step 5,, to operate, make equipment upload snapshot data according to the fixed cycle.In described step 4, after obtaining snapshot variable essential information, the snapshot variable data of equipment active upload is set according to this information, comprise variable ID, variate-value that snapshot comprises.
In described step 6, the snapshot data that equipment is uploaded is stored in internal memory.In described step 5, the SNAPSHOT INFO that equipment is uploaded first is stored in internal memory, avoids too frequent to the write operation of database.
In described step 7, the snapshot data in internal memory often reaches 1500, to database, inserts snapshot data, snapshot time.In described step 6, when the data of storing reach 1500, carry out update in batches in internal memory, can improve like this writing speed of database.
As shown in Figure 1, the general flow workflow graph is as follows:
1, set up and complete the required database table of this function in database,
2, connection device, be stored in variable basic information database table with all variable essential informations.
3, arranging need to be as the variable information of snapshot.
4, obtain the essential information of snapshot variable.
5,, to operate, make equipment upload snapshot data according to the fixed cycle.
6, the snapshot data that equipment is uploaded is stored in internal memory.
7, the snapshot data in internal memory often reaches 1500, to database, inserts snapshot data, snapshot time.
As shown in Figure 2, snapshot data setting procedure figure
1, set up the table of storing all variable essential informations in database.
2, the required table of newly-built storage enclosure test production line snapshot data in database.
3, newly-built storage snapshot ID and the table of snapshot time in database.
4, connection device, be stored in variable basic information database table with all variable essential informations.
5, hold database is operated by Web, in the variable Basic Information Table, need to add the management and control banner word segment value of the variable record of snapshot to be set to 1.
As shown in Figure 3, snapshot data Stored Procedure figure
1, from the variable Basic Information Table, obtain the essential information of snapshot variable.
2,, to operate, make equipment upload snapshot data according to the fixed cycle.
3, receive snapshot data.
4, whether the database table that judgement is used for the storage snapshot data is empty, if be empty, the snapshot ID that receives for the first time is 1.If be not empty, obtain maximum snapshot ID, local reception to the ID of snapshot be that the maximal value that gets adds 1.
5, the snapshot data that receives is kept in internal memory.
6, with the snapshot ID that distributes, and the time that receives this snapshot deposit internal memory in.
7, when the snapshot data that receives reaches 1500, the batch data in internal memory is inserted the database table that is used for the storage snapshot data.
8, snapshot ID and snapshot time are inserted in corresponding database table.
Claims (10)
1. historical snapshot storage means that is applied to the packaging and testing production line is characterized in that:
The database table of storage snapshot variable data is set at database; Choosing in database need to be as the variable of snapshot data; Obtain the snapshot data essential information, the equipment that arranges initiatively sends snapshot data; The snapshot data that the equipment that obtains sends, be stored in internal memory with snapshot data, and judgement is when full 1500 of the snapshot data in internal memory, and batch is inserted into the database snapshot tables of data, inserts the temporal information of this snapshot data and snapshot id information to the snapshot timetable.
2., according to a kind of historical snapshot storage means that is applied to the packaging and testing production line claimed in claim 1, it is characterized in that, comprise the following steps:
Step 1, set up the table of storing all variable essential informations in database, the required table of storage enclosure test production line snapshot data, storage snapshot ID and the table of snapshot time;
Step 2, connection device, be stored in variable basic information database table with all variable essential informations;
Step 3, arranging need to be as the variable information of snapshot;
Step 4, obtain the essential information of snapshot variable;
Step 5,, to operate, make equipment upload snapshot data according to the fixed cycle;
Step 6, the snapshot data that equipment is uploaded is stored in internal memory;
Step 7, the snapshot data in internal memory often reach 1500, to database, insert snapshot data, snapshot time.
3., according to a kind of historical snapshot storage means that is applied to the packaging and testing production line claimed in claim 2, it is characterized in that, in described step 1, set up the Basic Information Table of all variable essential informations of storage in database; The required SNAPSHOT INFO table of storage enclosure test production line snapshot data, storage snapshot ID and the tables of data of snapshot time.
4., according to a kind of historical snapshot storage means that is applied to the packaging and testing production line claimed in claim 2, it is characterized in that, in described step 2, connection device, be stored in variable basic information database table with all variable essential informations; After each database table in described step 1 establishes, the variable essential information is stored in variable essential information tables of data, comprises variable ID, variable name, management and control mode etc.
5., according to a kind of historical snapshot storage means that is applied to the packaging and testing production line claimed in claim 2, it is characterized in that, in described step 3, arranging need to be as the variable information of snapshot.
6., according to a kind of historical snapshot storage means that is applied to the packaging and testing production line claimed in claim 2, it is characterized in that, in described step 2, need to be set to 1 as the management and control mode field value of the variable of snapshot data in the variable Basic Information Table.
7., according to a kind of historical snapshot storage means that is applied to the packaging and testing production line claimed in claim 2, it is characterized in that, in described step 4, obtain the essential information of snapshot variable; In described step 3, obtain management and control mode field value and be set to 1 data from the database variable Basic Information Table.
8., according to a kind of historical snapshot storage means that is applied to the packaging and testing production line claimed in claim 2, it is characterized in that, in described step 5,, to operate, make equipment upload snapshot data according to the fixed cycle; In described step 4, after obtaining snapshot variable essential information, the snapshot variable data of equipment active upload is set according to this information, comprise variable ID, variate-value that snapshot comprises.
9., according to a kind of historical snapshot storage means that is applied to the packaging and testing production line claimed in claim 2, it is characterized in that, in described step 6, the snapshot data that equipment is uploaded is stored in internal memory; In described step 5, the SNAPSHOT INFO that equipment is uploaded first is stored in internal memory, avoids too frequent to the write operation of database.
10., according to a kind of historical snapshot storage means that is applied to the packaging and testing production line claimed in claim 2, it is characterized in that, in described step 7, the snapshot data in internal memory often reaches 1500, to database, inserts snapshot data, inserts the snapshot time; In described step 6, when the data of storing reach 1500, carry out update in batches in internal memory, can improve like this writing speed of database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013102988482A CN103390036A (en) | 2013-07-16 | 2013-07-16 | History snapshot storage method applied to package test production line |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013102988482A CN103390036A (en) | 2013-07-16 | 2013-07-16 | History snapshot storage method applied to package test production line |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103390036A true CN103390036A (en) | 2013-11-13 |
Family
ID=49534308
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2013102988482A Pending CN103390036A (en) | 2013-07-16 | 2013-07-16 | History snapshot storage method applied to package test production line |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103390036A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107656992A (en) * | 2017-09-14 | 2018-02-02 | 上海交通大学 | Towards the snapshot method for edition management in more insertion sources |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1393808A (en) * | 2001-06-29 | 2003-01-29 | 鸿富锦精密工业（深圳）有限公司 | Information acquiring and monitoring method and system for production situ |
| CN1527984A (en) * | 2001-07-13 | 2004-09-08 | Database system and method for industrial automation services | |
| CN101667147A (en) * | 2009-07-27 | 2010-03-10 | 浪潮电子信息产业股份有限公司 | Multitasking controllable automatic snapshot method |
| US20130166552A1 (en) * | 2011-12-21 | 2013-06-27 | Guy Rozenwald | Systems and methods for merging source records in accordance with survivorship rules |
-
2013
- 2013-07-16 CN CN2013102988482A patent/CN103390036A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1393808A (en) * | 2001-06-29 | 2003-01-29 | 鸿富锦精密工业（深圳）有限公司 | Information acquiring and monitoring method and system for production situ |
| CN1527984A (en) * | 2001-07-13 | 2004-09-08 | Database system and method for industrial automation services | |
| CN101667147A (en) * | 2009-07-27 | 2010-03-10 | 浪潮电子信息产业股份有限公司 | Multitasking controllable automatic snapshot method |
| US20130166552A1 (en) * | 2011-12-21 | 2013-06-27 | Guy Rozenwald | Systems and methods for merging source records in accordance with survivorship rules |
Non-Patent Citations (1)
| Title |
|---|
| 秦军 等: "实时管理信息系统在工厂生产管理中的应用", 《自动化仪表》, vol. 25, no. 5, 31 May 2004 (2004-05-31), pages 66 - 68 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107656992A (en) * | 2017-09-14 | 2018-02-02 | 上海交通大学 | Towards the snapshot method for edition management in more insertion sources |
| CN107656992B (en) * | 2017-09-14 | 2021-09-21 | 上海交通大学 | Multi-insertion-source-oriented snapshot version management method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20180129191A1 (en) | Industrial automation system machine analytics for a connected enterprise | |
| CN110677317B (en) | Test method, test device, test equipment and storage medium | |
| CN107689982A (en) | Multi-data source method of data synchronization, application server and computer-readable recording medium | |
| KR20130124328A (en) | System and method for monitoring tooling activities | |
| CN103961928A (en) | Filter element condition monitoring device, filter element condition monitoring method and intelligent water machine | |
| CN103200247B (en) | A kind of data download method and PC download client | |
| CN102394780A (en) | Equipment management system and method | |
| CN112766655B (en) | Automatic scheduling method, device, equipment and computer readable storage medium | |
| CN110262796A (en) | Data processing method, device and electronic equipment based on java | |
| CN106790975A (en) | Medication monitoring method, equipment and system based on mobile terminal | |
| CN104778538A (en) | Agricultural product cellphone tracing method based on NFC | |
| CN105574130A (en) | Data transmission method and service system | |
| CN112561447B (en) | Intelligent factory logistics management method and device based on big data | |
| CN103390036A (en) | History snapshot storage method applied to package test production line | |
| CN103986620A (en) | Monitoring item management method and system based on XML mode | |
| TW201525917A (en) | Method and device for marking in interrelated applications with operable icons | |
| CN103401701A (en) | Network management device and method | |
| CN103116826A (en) | Medicine production traceability system based on display board technology | |
| CN105159997A (en) | Report form processing method and report form processing system | |
| CN203759850U (en) | Machinery equipment monitoring system | |
| CN104050100B (en) | A kind of data flow memory management method and system suitable for big data environment | |
| CN110751892A (en) | Discrete manufacturing demonstration system and demonstration method, demonstration device and storage medium | |
| CN104284006A (en) | Method for internetwork regularly reminding of smart phones | |
| CN103400219A (en) | Statistical form intelligent management method applied to packaging production line | |
| CN203630597U (en) | Digital farm production management system based on Internet of Things sensing technology |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20131113 |
|
| WD01 | Invention patent application deemed withdrawn after publication |