CN111582736B - MES system-based data processing method, electronic device and storage medium - Google Patents

MES system-based data processing method, electronic device and storage medium Download PDF

Info

Publication number
CN111582736B
CN111582736B CN202010398909.2A CN202010398909A CN111582736B CN 111582736 B CN111582736 B CN 111582736B CN 202010398909 A CN202010398909 A CN 202010398909A CN 111582736 B CN111582736 B CN 111582736B
Authority
CN
China
Prior art keywords
data
working
working data
mes system
queue
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202010398909.2A
Other languages
Chinese (zh)
Other versions
CN111582736A (en
Inventor
郭勤
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shenzhen Yihong Digital Technology Co ltd
Original Assignee
Shenzhen Yihong Digital Technology Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Shenzhen Yihong Digital Technology Co ltd filed Critical Shenzhen Yihong Digital Technology Co ltd
Priority to CN202010398909.2A priority Critical patent/CN111582736B/en
Publication of CN111582736A publication Critical patent/CN111582736A/en
Application granted granted Critical
Publication of CN111582736B publication Critical patent/CN111582736B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • 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/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; 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
    • G06F16/2282—Tablespace storage structures; Management thereof
    • 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/24—Querying
    • G06F16/242—Query formulation
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06K—GRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
    • G06K7/00—Methods or arrangements for sensing record carriers, e.g. for reading patterns
    • G06K7/10—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation
    • G06K7/10009—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation sensing by radiation using wavelengths larger than 0.1 mm, e.g. radio-waves or microwaves
    • G06K7/10019—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation sensing by radiation using wavelengths larger than 0.1 mm, e.g. radio-waves or microwaves resolving collision on the communication channels between simultaneously or concurrently interrogated record carriers.
    • G06K7/10029—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation sensing by radiation using wavelengths larger than 0.1 mm, e.g. radio-waves or microwaves resolving collision on the communication channels between simultaneously or concurrently interrogated record carriers. the collision being resolved in the time domain, e.g. using binary tree search or RFID responses allocated to a random time slot
    • 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
    • G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
    • G06Q50/04—Manufacturing
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30—Computing systems specially adapted for manufacturing

Landscapes

  • Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Human Resources & Organizations (AREA)
  • General Physics & Mathematics (AREA)
  • Strategic Management (AREA)
  • Health & Medical Sciences (AREA)
  • Economics (AREA)
  • General Health & Medical Sciences (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Toxicology (AREA)
  • General Business, Economics & Management (AREA)
  • Data Mining & Analysis (AREA)
  • Tourism & Hospitality (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Marketing (AREA)
  • Computer Vision & Pattern Recognition (AREA)
  • Game Theory and Decision Science (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Educational Administration (AREA)
  • Development Economics (AREA)
  • Manufacturing & Machinery (AREA)
  • Primary Health Care (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Artificial Intelligence (AREA)
  • Electromagnetism (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • Software Systems (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention relates to a data processing technology and provides a data processing method based on an MES system, an electronic device and a storage medium. The method comprises the steps of detecting whether an electronic tag sends working data in real time, judging whether the working data exists in a second data table or not based on attribute information of the working data when the electronic tag detects the working data, judging whether the working data exists in the first data table or not if the working data does not exist in the second data table, storing the working data into a first working queue if the working data does not exist in the first data table, generating a time stamp of the working data, adding the time stamp of the working data into the first data table, judging whether a state value of the working data is a preset value or not when the working data exists in the second data table, acquiring the time stamp of the working data from the first data table if the time stamp of the working data is larger than or equal to a preset duration, checking the working data if the time difference of the working data is larger than or equal to the preset duration, and storing the working data which passes the check into the second working queue. The invention can improve the accuracy of the working data transmitted into the MES system.

Description

MES system-based data processing method, electronic device and storage medium
Technical Field
The present invention relates to the field of data processing, and in particular, to a data processing method, an electronic device, and a storage medium based on an MES system.
Background
In order to facilitate the operation of workers and better automation in a manufacturing execution system (Manufacturing Execution System, MES), it is generally defaulted that the MES system receives the working data sent by the electronic tag of the station for the first time, indicating that the tooling plate is flowing into the station, and that the lot number starts the production operation. And the MES system receives the working data sent by the electronic tag of the station for the second time, and indicates that the working procedure operation of the station is completed, and the tooling plate should flow to the next station. Because the interception range of the RFID card reader is a sector area and interception is continuously carried out, the RFID electronic tag can send the same information to the MES system for a plurality of times when the RFID electronic tag follows the tooling plate to pass through the sector area, thereby affecting the accuracy of data and the scheduling of a production workshop.
Disclosure of Invention
In view of the above, the present invention provides a data processing method, an electronic device and a storage medium based on an MES system, which aims to solve the technical problem that in the prior art, the electronic tag will send the same information to the MES system multiple times, so as to affect the accuracy of data.
To achieve the above object, the present invention provides a data processing method based on an MES system, the method comprising:
A. detecting whether a preconfigured electronic tag transmits working data or not in real time, and judging whether the working data exists in a second data table which is created in advance or not based on attribute information of the working data when detecting that the electronic tag transmits the working data;
B. when judging that the working data does not exist in the second data table, judging whether the working data exists in a pre-created first data table, and when the working data does not exist in the first data table, storing the working data into a preset first working queue so as to enable an MES system to read the working data from the first working queue, generating a time stamp of the working data and adding the time stamp into the first data table;
C. when judging that the working data exists in the second data table, judging whether the state value of the working data in the second data table is a preset value, and when the state value of the working data in the second data table is the preset value, acquiring the timestamp of the working data from the first data table;
D. calculating whether the time difference between the time stamp of the working data and the current time is larger than or equal to a preset time length, checking the working data based on a preset check rule when the time difference is larger than or equal to the preset time length, and storing the checked working data to a preset second working queue for the MES system to read the checked working data from the second working queue.
Preferably, the attribute information of the working data includes:
product information corresponding to the electronic tag, station information corresponding to the electronic tag and an ID of the electronic tag.
Preferably, after the step D, the method includes:
acquiring a first quantity of work data which is stored in the second work queue and passes verification, and acquiring a second quantity of work data read from the second work queue by the MES system;
judging whether the first number is the same as the second number, if not, inquiring whether serial number identifiers of each working data of the MES system are continuous, and acquiring interrupted serial number identifiers when the serial number identifiers are inquired to be discontinuous;
and inquiring working data corresponding to the interrupted serial number identifier based on the interrupted serial number identifier, and sending the working data corresponding to the interrupted serial number identifier to the second work queue so that the MES system can read the working data corresponding to the interrupted serial number identifier from the second work queue.
Preferably, the verifying the working data based on a preset verification rule includes:
and respectively checking whether the product information corresponding to the electronic tag and the station information corresponding to the electronic tag are correct, and checking the working data when the product information corresponding to the electronic tag and the station information corresponding to the electronic tag are correct.
Preferably, before the step B, the method further includes:
the method comprises the steps of creating a first work queue and a second work queue in advance, reading log files of the first work queue and the second work queue, constructing a tree-shaped hierarchical storage structure, and respectively determining user names, passwords, access paths and port numbers of the first work queue and the second work queue;
and respectively sending the user name, the password, the access path and the port number to an MES system so that the MES system can read the working data from the first work queue and the second work queue according to the user name, the password, the access path and the port number.
In order to achieve the above object, the present invention also provides an electronic device including: the memory and the processor are used for storing a data processing program based on the MES system, the data processing program based on the MES system is executed by the processor, and the following steps are realized:
A. detecting whether a preconfigured electronic tag transmits working data or not in real time, and judging whether the working data exists in a second data table which is created in advance or not based on attribute information of the working data when detecting that the electronic tag transmits the working data;
B. when judging that the working data does not exist in the second data table, judging whether the working data exists in a pre-created first data table, and when the working data does not exist in the first data table, storing the working data into a preset first working queue so as to enable an MES system to read the working data from the first working queue, generating a time stamp of the working data and adding the time stamp into the first data table;
C. when judging that the working data exists in the second data table, judging whether the state value of the working data in the second data table is a preset value, and when the state value of the working data in the second data table is the preset value, acquiring the timestamp of the working data from the first data table;
D. calculating whether the time difference between the time stamp of the working data and the current time is larger than or equal to a preset time length, checking the working data based on a preset check rule when the time difference is larger than or equal to the preset time length, and storing the checked working data to a preset second working queue for the MES system to read the checked working data from the second working queue.
Preferably, the attribute information of the working data includes:
product information corresponding to the electronic tag, station information corresponding to the electronic tag and an ID of the electronic tag.
Preferably, after the step D, the MES system based data processing program is executed by the processor, and further implementing the following steps:
acquiring a first quantity of work data which is stored in the second work queue and passes verification, and acquiring a second quantity of work data read from the second work queue by the MES system;
judging whether the first number is the same as the second number, if not, inquiring whether serial number identifiers of each working data of the MES system are continuous, and acquiring interrupted serial number identifiers when the serial number identifiers are inquired to be discontinuous;
and inquiring working data corresponding to the interrupted serial number identifier based on the interrupted serial number identifier, and sending the working data corresponding to the interrupted serial number identifier to the second work queue so that the MES system can read the working data corresponding to the interrupted serial number identifier from the second work queue.
Preferably, before the step B, the MES system based data processing program is executed by the processor, and further implementing the following steps:
the method comprises the steps of creating a first work queue and a second work queue in advance, reading log files of the first work queue and the second work queue, constructing a tree-shaped hierarchical storage structure, and respectively determining user names, passwords, access paths and port numbers of the first work queue and the second work queue;
and respectively sending the user name, the password, the access path and the port number to an MES system so that the MES system can read the working data from the first work queue and the second work queue according to the user name, the password, the access path and the port number.
To achieve the above object, the present invention also provides a computer-readable storage medium including an MES system-based data processing program, which when executed by a processor, implements any of the steps of the MES system-based data processing method described above.
According to the MES-based data processing method, the electronic device and the storage medium, the problem of inaccurate data is avoided by checking the wage data when the time difference is greater than or equal to the preset time length, and related data is stored by creating the data table and the work queue, so that the data transmission speed is higher, and delayed response caused by overlarge data quantity is avoided.
Drawings
FIG. 1 is a schematic diagram of an electronic device according to a preferred embodiment of the invention;
FIG. 2 is a block diagram of a preferred embodiment of the MES based data processing system of FIG. 1;
FIG. 3 is a flow chart of a preferred embodiment of a MES-based data processing method according to the present invention;
the achievement of the objects, functional features and advantages of the present invention will be further described with reference to the accompanying drawings, in conjunction with the embodiments.
Detailed Description
The present invention will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present invention more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Referring to fig. 1, a schematic diagram of a preferred embodiment of an electronic device 1 according to the present invention is shown.
The electronic device 1 includes, but is not limited to: memory 11, processor 12, display 13, and network interface 14. The electronic device 1 is connected to a network via a network interface 14. The network may be a wireless or wired network such as the Internet (Internet), a 4G network, a 5G network, bluetooth (Bluetooth), wi-Fi, or a call network.
The memory 11 includes at least one type of readable storage medium including flash memory, hard disk, multimedia card, card memory (e.g., SD or DX memory, etc.), random Access Memory (RAM), static Random Access Memory (SRAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), programmable Read Only Memory (PROM), magnetic memory, magnetic disk, optical disk, etc. In some embodiments, the storage 11 may be an internal storage unit of the electronic device 1, such as a hard disk or a memory of the electronic device 1. In other embodiments, the memory 11 may also be an external storage device of the electronic apparatus 1, for example, a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a flash Card (FlashCard) or the like, which are equipped in the electronic apparatus 1. Of course, the memory 11 may also comprise both an internal memory unit and an external memory device of the electronic apparatus 1. In this embodiment, the memory 11 is typically used for storing an operating system and various application software installed in the electronic device 1, such as program codes of the data processing program 10 based on the MES system. Further, the memory 11 may be used to temporarily store various types of data that have been output or are to be output.
Processor 12 may be a central processing unit (Central Processing Unit, CPU), controller, microcontroller, microprocessor, or other data processing chip in some embodiments. The processor 12 is typically used for controlling the overall operation of the electronic device 1, e.g. performing data interaction or communication related control and processing, etc. In this embodiment, the processor 12 is configured to execute program code stored in the memory 11 or process data, such as program code of the MES system-based data processing program 10.
The display 13 may be referred to as a display screen or a display unit. The display 13 may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an Organic Light-Emitting Diode (OLED) touch device, or the like in some embodiments. The display 13 is used for displaying information processed in the electronic device 1 and for displaying a visual work interface, for example displaying the results of data statistics.
The network interface 14 may alternatively comprise a standard wired interface, a wireless interface (e.g. WI-FI interface), which network interface 14 is typically used for establishing a communication connection between the electronic apparatus 1 and other electronic devices.
Fig. 1 shows only an electronic device 1 with components 11-14 and a MES system based data processing program 10, but it is understood that not all of the illustrated components are required to be implemented, and that more or fewer components may alternatively be implemented.
Optionally, the electronic device 1 may further comprise a user interface, which may comprise a Display (Display), an input unit such as a Keyboard (Keyboard), and a standard wired interface, a wireless interface. Alternatively, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, or the like. The display may also be referred to as a display screen or display unit, as appropriate, for displaying information processed in the electronic device 1 and for displaying a visual user interface.
The electronic device 1 may further include Radio Frequency (RF) circuits, sensors and audio circuits, etc., which will not be described in detail herein.
In the above embodiment, the processor 12 may execute the MES system based data processing program 10 stored in the memory 11 by:
A. detecting whether a preconfigured electronic tag transmits working data or not in real time, and judging whether the working data exists in a second data table which is created in advance or not based on attribute information of the working data when detecting that the electronic tag transmits the working data;
B. when judging that the working data does not exist in the second data table, judging whether the working data exists in a pre-created first data table, and when the working data does not exist in the first data table, storing the working data into a preset first working queue so as to enable an MES system to read the working data from the first working queue, generating a time stamp of the working data and adding the time stamp into the first data table;
C. when judging that the working data exists in the second data table, judging whether the state value of the working data in the second data table is a preset value, and when the state value of the working data in the second data table is the preset value, acquiring the timestamp of the working data from the first data table;
D. calculating whether the time difference between the time stamp of the working data and the current time is larger than or equal to a preset time length, checking the working data based on a preset check rule when the time difference is larger than or equal to the preset time length, and storing the checked working data to a preset second working queue for the MES system to read the checked working data from the second working queue.
The storage device may be the memory 11 of the electronic apparatus 1, or may be another storage device communicatively connected to the electronic apparatus 1.
For a detailed description of the above steps, please refer to the following FIG. 2 for a block diagram of an embodiment of the MES system-based data processing program 10 and FIG. 3 for a flowchart of an embodiment of the MES system-based data processing method.
In other embodiments, the MES-based data processing program 10 can be divided into a plurality of modules that are stored in the memory 11 and executed by the processor 12 to complete the present invention. The invention may refer to a series of computer program instruction segments capable of performing a specified function.
Referring now to FIG. 2, a block diagram illustrating one embodiment of the MES based data processing program 10 of FIG. 1 is shown. In this embodiment, the MES system-based data processing program 10 can be divided into: the device comprises a detection module 110, a first judgment module 120, a second judgment module 130 and a processing module 140.
The detecting module 110 is configured to detect whether the preconfigured electronic tag sends working data in real time, and when detecting that the electronic tag sends the working data, determine whether the working data exists in the second data table created in advance based on attribute information of the working data.
In this embodiment, whether the preconfigured electronic tag transmits the working data is detected in real time, and when the electronic tag transmits the working data is detected, whether the working data exists in the second data table which is created in advance is judged based on the attribute information of the working data. Wherein, the attribute information of the working data includes: product information corresponding to the electronic tag, station information corresponding to the electronic tag and an ID of the electronic tag.
The second data table may be a hash table for storing work data during or after operation of the workstation process, and the hash table is used for storing relevant work data, which is faster in searching for corresponding work data. The first time the MES system receives the working data sent by the electronic tag of the station, the tool plate flows into the station, the batch number starts to carry out production operation, the second time the MES system receives the working data sent by the electronic tag of the station, the working procedure operation of the station is completed, the tool plate is required to flow to the next station, the electronic tag detection range is a sector area and is continuously detected, the electronic tag can be led to repeatedly send the same data into the MES system when the electronic tag follows the tool plate to pass through the area, and therefore whether the working data exist in a second data table or not can be judged according to the attribute information of the working data sent by the electronic tag, and further whether the working procedure of the station is in operation or is completed can be judged.
The first determining module 120 is configured to, when determining that the working data does not exist in the second data table, determine whether the working data exists in the first data table created in advance, and store the working data to a first preset work queue when the working data does not exist in the first data table, so that the MES system reads the working data from the first work queue, generates a timestamp of the working data, and adds the timestamp to the first data table.
In this embodiment, when it is determined that there is no working data sent by the electronic tag in the second data table, it is indicated that a tooling plate that may not be subjected to a working procedure is flowing into the station, and the working procedure needs to be performed on the tooling plate, so that it is required to determine whether there is the working data in the first data table created in advance, where the first data table is used to store a timestamp of the working data, when the working data does not exist in the first data table, it may be determined that the tooling plate that is not subjected to the working procedure is flowing into the station, in an actual application scenario, because a data volume of a production system is large, and the MES system may also receive data sent by the electronic tag for many times, so that a data storage pressure of the MES system is large, the working data may be stored in a preset first work queue, and the MES system may read the working data from the first work queue. It may be appreciated that when the working data exists in the first data table, the working queue may be a middleware in the process of executing the working procedure on the tooling plate corresponding to the tooling data.
In one embodiment, a first work queue and a second work queue can be created in advance, log files of the first work queue and the second work queue are read, a tree-shaped hierarchical storage structure is built, and user names, passwords, access paths and port numbers of the first work queue and the second work queue are respectively determined;
and respectively sending the user name, the password, the access path and the port number to an MES system so that the MES system can read the working data from the first work queue and the second work queue according to the user name, the password, the access path and the port number.
And the second judging module 130 is configured to, when judging that the working data exists in the second data table, judge whether the state value of the working data in the second data table is a preset value, and when the state value of the working data in the second data table is the preset value, obtain the timestamp of the working data from the first data table.
In this embodiment, when the working data is determined to exist in the second data table, it is further determined whether the state value of the working data in the second data table is a preset value, and when the state value of the working data in the data table is a preset value, the time stamp of the working data is obtained from the first data table and is used for calculating the time difference between the time stamp of the working data and the current time. The state value of the working data stored in the second data table indicates that the working procedure of the working station is in operation or has been completed, that is, the working procedure is still in operation when the preset value in this embodiment indicates that the working procedure is still in operation, and the state value may be represented by 0 or 1, for example, 0 indicates that the working procedure is completed in operation, and 1 indicates that the working procedure is completed in operation.
And the processing module 140 is configured to calculate whether a time difference between a time stamp of the working data and a current time is greater than or equal to a preset duration, and when the time difference is greater than or equal to the preset duration, check the working data based on a preset check rule, and store the checked working data to a preset second working queue, so that the MES system reads the checked working data from the second working queue.
In this embodiment, after the time stamp of the working data is obtained from the first data table, whether the time difference between the time stamp of the working data and the current time is greater than or equal to a preset duration is calculated, when the time difference is greater than or equal to the preset duration, the preset duration is the operation duration of the working procedure, and when the time difference between the time stamp of the working data and the current time is greater than or equal to the operation duration of the working procedure, the working procedure is completed, the working data corresponding to the completed working procedure can be checked, the working data can be checked based on a preset check rule, and the checked working data is stored in a preset second working queue, so that the MES system can read the checked working data from the second working queue.
Further, verifying the working data based on a preset verification rule includes:
and respectively checking whether the product information corresponding to the electronic tag and the station information corresponding to the electronic tag are correct, and checking the working data when the product information corresponding to the electronic tag and the station information corresponding to the electronic tag are correct.
In one embodiment, a first amount of work data stored in the second work queue that is verified may also be obtained, and a second amount of work data read from the second work queue by the MES system may be obtained;
judging whether the first number is the same as the second number, if not, inquiring whether serial number identifiers of each working data of the MES system are continuous, and acquiring interrupted serial number identifiers when the serial number identifiers are inquired to be discontinuous;
and inquiring working data corresponding to the interrupted serial number identifier based on the interrupted serial number identifier, and sending the working data corresponding to the interrupted serial number identifier to the second work queue so that the MES system can read the working data corresponding to the interrupted serial number identifier from the second work queue. The missing working data is screened out by inquiring whether the sequence number identifiers of the working data are continuous or not, meanwhile, the sequence number identifiers of the working data are compared, the interrupted sequence number identifiers are searched out, and the missing condition of the working data can be avoided.
In addition, the invention also provides a data processing method based on the MES system. Referring to FIG. 3, a method flow diagram of an embodiment of a MES system-based data processing method of the present invention is shown. The processor 12 of the electronic device 1 implements the following steps of the MES system based data processing method when executing the MES system based data processing program 10 stored in the memory 11:
step S10: detecting whether a preconfigured electronic tag transmits working data or not in real time, and judging whether the working data exists in a second data table which is created in advance or not based on attribute information of the working data when detecting that the electronic tag transmits the working data.
In this embodiment, whether the preconfigured electronic tag transmits the working data is detected in real time, and when the electronic tag transmits the working data is detected, whether the working data exists in the second data table which is created in advance is judged based on the attribute information of the working data. Wherein, the attribute information of the working data includes: product information corresponding to the electronic tag, station information corresponding to the electronic tag and an ID of the electronic tag.
The second data table may be a hash table for storing work data during or after operation of the workstation process, and the hash table is used for storing relevant work data, which is faster in searching for corresponding work data. The first time the MES system receives the working data sent by the electronic tag of the station, the tool plate flows into the station, the batch number starts to carry out production operation, the second time the MES system receives the working data sent by the electronic tag of the station, the working procedure operation of the station is completed, the tool plate is required to flow to the next station, the electronic tag detection range is a sector area and is continuously detected, the electronic tag can be led to repeatedly send the same data into the MES system when the electronic tag follows the tool plate to pass through the area, and therefore whether the working data exist in a second data table or not can be judged according to the attribute information of the working data sent by the electronic tag, and further whether the working procedure of the station is in operation or is completed can be judged.
Step S20: when judging that the working data does not exist in the second data table, judging whether the working data exists in a pre-created first data table, and when the working data does not exist in the first data table, storing the working data into a preset first working queue so as to enable an MES system to read the working data from the first working queue, generating a time stamp of the working data and adding the time stamp to the first data table.
In this embodiment, when it is determined that there is no working data sent by the electronic tag in the second data table, it is indicated that a tooling plate that may not be subjected to a working procedure is flowing into the station, and the working procedure needs to be performed on the tooling plate, so that it is required to determine whether there is the working data in the first data table created in advance, where the first data table is used to store a timestamp of the working data, when the working data does not exist in the first data table, it may be determined that the tooling plate that is not subjected to the working procedure is flowing into the station, in an actual application scenario, because a data volume of a production system is large, and the MES system may also receive data sent by the electronic tag for many times, so that a data storage pressure of the MES system is large, the working data may be stored in a preset first work queue, and the MES system may read the working data from the first work queue. It may be appreciated that when the working data exists in the first data table, the working queue may be a middleware in the process of executing the working procedure on the tooling plate corresponding to the tooling data.
In one embodiment, a first work queue and a second work queue can be created in advance, log files of the first work queue and the second work queue are read, a tree-shaped hierarchical storage structure is built, and user names, passwords, access paths and port numbers of the first work queue and the second work queue are respectively determined;
and respectively sending the user name, the password, the access path and the port number to an MES system so that the MES system can read the working data from the first work queue and the second work queue according to the user name, the password, the access path and the port number.
Step S30: when the working data is judged to exist in the second data table, whether the state value of the working data in the second data table is a preset value is judged, and when the state value of the working data in the second data table is the preset value, the timestamp of the working data is obtained from the first data table.
In this embodiment, when the working data is determined to exist in the second data table, it is further determined whether the state value of the working data in the second data table is a preset value, and when the state value of the working data in the data table is a preset value, the time stamp of the working data is obtained from the first data table and is used for calculating the time difference between the time stamp of the working data and the current time. The state value of the working data stored in the second data table indicates that the working procedure of the working station is in operation or has been completed, that is, the working procedure is still in operation when the preset value in this embodiment indicates that the working procedure is still in operation, and the state value may be represented by 0 or 1, for example, 0 indicates that the working procedure is completed in operation, and 1 indicates that the working procedure is completed in operation.
Step S40: calculating whether the time difference between the time stamp of the working data and the current time is larger than or equal to a preset time length, checking the working data based on a preset check rule when the time difference is larger than or equal to the preset time length, and storing the checked working data to a preset second working queue for the MES system to read the checked working data from the second working queue.
In this embodiment, after the time stamp of the working data is obtained from the first data table, whether the time difference between the time stamp of the working data and the current time is greater than or equal to a preset duration is calculated, when the time difference is greater than or equal to the preset duration, the preset duration is the operation duration of the working procedure, and when the time difference between the time stamp of the working data and the current time is greater than or equal to the operation duration of the working procedure, the working procedure is completed, the working data corresponding to the completed working procedure can be checked, the working data can be checked based on a preset check rule, and the checked working data is stored in a preset second working queue, so that the MES system can read the checked working data from the second working queue.
Further, verifying the working data based on a preset verification rule includes:
and respectively checking whether the product information corresponding to the electronic tag and the station information corresponding to the electronic tag are correct, and checking the working data when the product information corresponding to the electronic tag and the station information corresponding to the electronic tag are correct.
In one embodiment, a first amount of work data stored in the second work queue that is verified may also be obtained, and a second amount of work data read from the second work queue by the MES system may be obtained;
judging whether the first number is the same as the second number, if not, inquiring whether serial number identifiers of each working data of the MES system are continuous, and acquiring interrupted serial number identifiers when the serial number identifiers are inquired to be discontinuous;
and inquiring working data corresponding to the interrupted serial number identifier based on the interrupted serial number identifier, and sending the working data corresponding to the interrupted serial number identifier to the second work queue so that the MES system can read the working data corresponding to the interrupted serial number identifier from the second work queue. The missing working data is screened out by inquiring whether the sequence number identifiers of the working data are continuous or not, meanwhile, the sequence number identifiers of the working data are compared, the interrupted sequence number identifiers are searched out, and the missing condition of the working data can be avoided.
In addition, the embodiment of the invention also provides a computer readable storage medium, which can be any one or any combination of a plurality of hard disk, a multimedia card, an SD card, a flash memory card, an SMC, a read-only memory (ROM), an erasable programmable read-only memory (EPROM), a portable compact disc read-only memory (CD-ROM), a USB memory and the like. The computer readable storage medium includes a data processing program 10 based on an MES system, and the data processing program 10 based on the MES system realizes the following operations when being executed by a processor:
A. detecting whether a preconfigured electronic tag transmits working data or not in real time, and judging whether the working data exists in a second data table which is created in advance or not based on attribute information of the working data when detecting that the electronic tag transmits the working data;
B. when judging that the working data does not exist in the second data table, judging whether the working data exists in a pre-created first data table, and when the working data does not exist in the first data table, storing the working data into a preset first working queue so as to enable an MES system to read the working data from the first working queue, generating a time stamp of the working data and adding the time stamp into the first data table;
C. when judging that the working data exists in the second data table, judging whether the state value of the working data in the second data table is a preset value, and when the state value of the working data in the second data table is the preset value, acquiring the timestamp of the working data from the first data table;
D. calculating whether the time difference between the time stamp of the working data and the current time is larger than or equal to a preset time length, checking the working data based on a preset check rule when the time difference is larger than or equal to the preset time length, and storing the checked working data to a preset second working queue for the MES system to read the checked working data from the second working queue.
The embodiment of the computer readable storage medium of the present invention is substantially the same as the embodiment of the data processing method based on the MES system described above, and will not be described herein.
It should be noted that, the foregoing reference numerals of the embodiments of the present invention are merely for describing the embodiments, and do not represent the advantages and disadvantages of the embodiments. And the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, apparatus, article, or method that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, apparatus, article, or method. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, apparatus, article or method that comprises the element.
From the above description of the embodiments, it will be clear to those skilled in the art that the above-described embodiment method may be implemented by means of software plus a necessary general hardware platform, but of course may also be implemented by means of hardware, but in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a storage medium (e.g. ROM/RAM, magnetic disk, optical disk) as described above, comprising instructions for causing a terminal device (which may be a mobile phone, a computer, an electronic device, or a network device, etc.) to perform the method according to the embodiments of the present invention.
The foregoing description is only of the preferred embodiments of the present invention, and is not intended to limit the scope of the invention, but rather is intended to cover any equivalents of the structures or equivalent processes disclosed herein or in the alternative, which may be employed directly or indirectly in other related arts.

Claims (10)

1. A method for data processing based on an MES system, the method comprising:
A. detecting whether a preconfigured electronic tag transmits working data or not in real time, and judging whether a second data table which is created in advance exists the working data or not based on attribute information of the working data when detecting that the electronic tag transmits the working data, wherein the second data table is used for storing the working data in working procedure operation or after operation completion;
B. when judging that the working data does not exist in the second data table, judging whether the working data exists in a first data table which is created in advance, when the working data does not exist in the first data table, storing the working data into a first preset working queue, so that an MES system can read the working data from the first working queue, generating a time stamp of the working data and adding the time stamp into the first data table, wherein the first data table is used for storing the time stamp of the working data, and when the working data does not exist in the first data table, determining that a tooling plate which is not subjected to working procedure operation flows into a station, and the first working queue is used for storing the working data sent by an electronic tag;
C. when judging that the working data exists in the second data table, judging whether the state value of the working data in the second data table is a preset value, and when the state value of the working data in the second data table is the preset value, acquiring the timestamp of the working data from the first data table;
D. calculating whether the time difference between the time stamp of the working data and the current time is larger than or equal to a preset time length, checking the working data based on a preset check rule when the time difference is larger than or equal to the preset time length, and storing the checked working data to a preset second working queue for the MES system to read the checked working data from the second working queue, wherein the second working queue is used for storing the checked working data.
2. The MES system based data processing method according to claim 1, wherein the attribute information of the work data includes:
product information corresponding to the electronic tag, station information corresponding to the electronic tag and an ID of the electronic tag.
3. The MES system based data processing method according to claim 1, wherein after the step D, the method comprises:
acquiring a first quantity of work data which is stored in the second work queue and passes verification, and acquiring a second quantity of work data read from the second work queue by the MES system;
judging whether the first number is the same as the second number, if not, inquiring whether serial number identifiers of each working data of the MES system are continuous, and acquiring interrupted serial number identifiers when the serial number identifiers are inquired to be discontinuous;
and inquiring working data corresponding to the interrupted serial number identifier based on the interrupted serial number identifier, and sending the working data corresponding to the interrupted serial number identifier to the second work queue so that the MES system can read the working data corresponding to the interrupted serial number identifier from the second work queue.
4. The MES system based data processing method according to claim 2, wherein the verifying the working data based on a preset verification rule includes:
and respectively checking whether the product information corresponding to the electronic tag and the station information corresponding to the electronic tag are correct, and checking the working data when the product information corresponding to the electronic tag and the station information corresponding to the electronic tag are correct.
5. The MES system based data processing method according to claim 1, wherein prior to the step B, the method further comprises:
the method comprises the steps of creating a first work queue and a second work queue in advance, reading log files of the first work queue and the second work queue, constructing a tree-shaped hierarchical storage structure, and respectively determining user names, passwords, access paths and port numbers of the first work queue and the second work queue;
and respectively sending the user name, the password, the access path and the port number to an MES system so that the MES system can read the working data from the first work queue and the second work queue according to the user name, the password, the access path and the port number.
6. An electronic device, the electronic device comprising: the memory and the processor are used for storing a data processing program based on the MES system, the data processing program based on the MES system is executed by the processor, and the following steps are realized:
A. detecting whether a preconfigured electronic tag transmits working data or not in real time, and judging whether a second data table which is created in advance exists the working data or not based on attribute information of the working data when detecting that the electronic tag transmits the working data, wherein the second data table is used for storing the working data in working procedure operation or after operation completion;
B. when judging that the working data does not exist in the second data table, judging whether the working data exists in a first data table which is created in advance, when the working data does not exist in the first data table, storing the working data into a first preset working queue, so that an MES system can read the working data from the first working queue, generating a time stamp of the working data and adding the time stamp into the first data table, wherein the first data table is used for storing the time stamp of the working data, and when the working data does not exist in the first data table, determining that a tooling plate which is not subjected to working procedure operation flows into a station, and the first working queue is used for storing the working data sent by an electronic tag;
C. when judging that the working data exists in the second data table, judging whether the state value of the working data in the second data table is a preset value, and when the state value of the working data in the second data table is the preset value, acquiring the timestamp of the working data from the first data table;
D. calculating whether the time difference between the time stamp of the working data and the current time is larger than or equal to a preset time length, checking the working data based on a preset check rule when the time difference is larger than or equal to the preset time length, and storing the checked working data to a preset second working queue for the MES system to read the checked working data from the second working queue, wherein the second working queue is used for storing the checked working data.
7. The electronic device of claim 6, wherein the attribute information of the working data comprises:
product information corresponding to the electronic tag, station information corresponding to the electronic tag and an ID of the electronic tag.
8. The electronic device of claim 6, wherein after step D, the MES system based data processing program is executed by the processor, further implementing the steps of:
acquiring a first quantity of work data which is stored in the second work queue and passes verification, and acquiring a second quantity of work data read from the second work queue by the MES system;
judging whether the first number is the same as the second number, if not, inquiring whether serial number identifiers of each working data of the MES system are continuous, and acquiring interrupted serial number identifiers when the serial number identifiers are inquired to be discontinuous;
and inquiring working data corresponding to the interrupted serial number identifier based on the interrupted serial number identifier, and sending the working data corresponding to the interrupted serial number identifier to the second work queue so that the MES system can read the working data corresponding to the interrupted serial number identifier from the second work queue.
9. The electronic device of claim 6, wherein prior to step B, the MES system based data processing program is executed by the processor, further implementing the steps of:
the method comprises the steps of creating a first work queue and a second work queue in advance, reading log files of the first work queue and the second work queue, constructing a tree-shaped hierarchical storage structure, and respectively determining user names, passwords, access paths and port numbers of the first work queue and the second work queue;
and respectively sending the user name, the password, the access path and the port number to an MES system so that the MES system can read the working data from the first work queue and the second work queue according to the user name, the password, the access path and the port number.
10. A computer readable storage medium, characterized in that it comprises a data processing program based on an MES system, which, when being executed by a processor, implements the steps of the data processing method based on an MES system according to any one of claims 1 to 5.
CN202010398909.2A 2020-05-12 2020-05-12 MES system-based data processing method, electronic device and storage medium Active CN111582736B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010398909.2A CN111582736B (en) 2020-05-12 2020-05-12 MES system-based data processing method, electronic device and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010398909.2A CN111582736B (en) 2020-05-12 2020-05-12 MES system-based data processing method, electronic device and storage medium

Publications (2)

Publication Number Publication Date
CN111582736A CN111582736A (en) 2020-08-25
CN111582736B true CN111582736B (en) 2023-05-19

Family

ID=72118866

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010398909.2A Active CN111582736B (en) 2020-05-12 2020-05-12 MES system-based data processing method, electronic device and storage medium

Country Status (1)

Country Link
CN (1) CN111582736B (en)

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2010108117A (en) * 2008-10-29 2010-05-13 Hitachi High-Tech Control Systems Corp Production management system using rfid
RU2011129365A (en) * 2011-07-15 2013-01-20 Вячеслав Игоревич Крутелев METHOD FOR BUILDING AND CONTROL FOR PERFORMANCE OF PRODUCTION SCHEDULES AND SYSTEM OF DEVICES FOR IMPLEMENTATION OF THE METHOD
WO2013150702A1 (en) * 2012-04-02 2013-10-10 シャープ株式会社 Production management system
US9329915B1 (en) * 2012-05-08 2016-05-03 Amazon Technologies, Inc. System and method for testing in a production environment
JP2016212701A (en) * 2015-05-11 2016-12-15 株式会社 デジタルコラボレーションズ Information acquisition management device, terminal for information acquisition device, and program for information acquisition management device
WO2019034782A1 (en) * 2017-08-17 2019-02-21 Abb Schweiz Ag Scheduling manufacturing process of parallel machines

Family Cites Families (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP4258218B2 (en) * 2003-02-03 2009-04-30 トヨタ自動車株式会社 Production line delay process section detection system and method
JP4411177B2 (en) * 2004-10-15 2010-02-10 日本電気株式会社 RFID batch reader
JP5434455B2 (en) * 2009-10-08 2014-03-05 株式会社リコー Work time analysis support system and program
JP4905544B2 (en) * 2009-12-18 2012-03-28 ブラザー工業株式会社 Work management system and work management method
JP5803391B2 (en) * 2011-08-01 2015-11-04 大日本印刷株式会社 Work form creation program, work form creation system
US10852712B2 (en) * 2016-02-17 2020-12-01 Plataine Ltd. Tracking production in a production facility using searchable digital threads
US10438154B2 (en) * 2017-05-24 2019-10-08 Dell Products L.P. Guaranteed processing for performing a work item queuing operation using generational queues

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2010108117A (en) * 2008-10-29 2010-05-13 Hitachi High-Tech Control Systems Corp Production management system using rfid
RU2011129365A (en) * 2011-07-15 2013-01-20 Вячеслав Игоревич Крутелев METHOD FOR BUILDING AND CONTROL FOR PERFORMANCE OF PRODUCTION SCHEDULES AND SYSTEM OF DEVICES FOR IMPLEMENTATION OF THE METHOD
WO2013150702A1 (en) * 2012-04-02 2013-10-10 シャープ株式会社 Production management system
US9329915B1 (en) * 2012-05-08 2016-05-03 Amazon Technologies, Inc. System and method for testing in a production environment
JP2016212701A (en) * 2015-05-11 2016-12-15 株式会社 デジタルコラボレーションズ Information acquisition management device, terminal for information acquisition device, and program for information acquisition management device
WO2019034782A1 (en) * 2017-08-17 2019-02-21 Abb Schweiz Ag Scheduling manufacturing process of parallel machines

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
Reactive, model-based monitoring in RFID-enabled manufacturing;Yi Huang et al.;Computers in Industry;811-819 *

Also Published As

Publication number Publication date
CN111582736A (en) 2020-08-25

Similar Documents

Publication Publication Date Title
CN108427705B (en) Electronic device, distributed system log query method and storage medium
CN112235326B (en) Internet of things equipment data analysis method and device and electronic equipment
CN108416485B (en) User identity recognition method, electronic device and computer readable storage medium
CN110647471A (en) Interface test case generation method, electronic device and storage medium
CN108446171B (en) Electronic device, distributed system execution task allocation method and storage medium
CN111400380A (en) Method for checking table data, electronic device and storage medium
CN113448862B (en) Software version testing method and device and computer equipment
CN113761012A (en) Analysis visualization method of remote sensing data, server and storage medium
CN110267215B (en) Data detection method, equipment and storage medium
CN112631911A (en) Automatic testing method and device, computer equipment and storage medium
CN112506757A (en) Automatic test method, system, computer device and medium thereof
CN111459812A (en) Interface test case generation method, electronic device and storage medium
CN108650123B (en) Fault information recording method, device, equipment and storage medium
CN111582736B (en) MES system-based data processing method, electronic device and storage medium
CN111767262A (en) Log display method, device, equipment and storage medium
CN112634973A (en) Data rereading method and system of storage medium, terminal device and storage medium
CN113419949B (en) Abnormality detection method, device, equipment and storage medium for data processing
CN111756594B (en) Control method of pressure test, computer device and computer readable storage medium
CN116136950A (en) Chip verification method, device, system, electronic equipment and storage medium
CN110688315A (en) Interface code detection report generation method, electronic device, and storage medium
CN115481002A (en) Abnormal behavior identification method, device, equipment and storage medium
CN113259154B (en) Method and device for informing middle station data verification, computer equipment and storage medium
CN112416648A (en) Data verification method and device
CN111931161A (en) RISC-V processor based chip verification method, apparatus and storage medium
CN113590467B (en) Data comparison method, system, computer device and computer readable storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant