CN111582736A - 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
CN111582736A
CN111582736A CN202010398909.2A CN202010398909A CN111582736A CN 111582736 A CN111582736 A CN 111582736A CN 202010398909 A CN202010398909 A CN 202010398909A CN 111582736 A CN111582736 A CN 111582736A
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.)
Granted
Application number
CN202010398909.2A
Other languages
Chinese (zh)
Other versions
CN111582736B (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—Information and communication technology [ICT] specially adapted for implementation of business processes of 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 includes the steps that whether an electronic tag sends working data or not is detected in real time, when the working data are detected, whether the working data exist in a second data table or not is judged based on attribute information of the working data, if the working data do not exist, whether the working data exist in a first data table or not is judged, if the working data do not exist, the working data are stored in a first working queue, a timestamp of the working data is generated and added to the first data table, when the working data exist in the second data table, whether a state value of the working data is a preset value or not is judged, if yes, the timestamp of the working data is obtained from the first data table, whether a time difference between the time and the current time is larger than or equal to a preset duration or not is calculated, if yes, the working data are verified, and the working data which pass the verification are stored in the second working queue. The invention can improve the accuracy of the work 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 based on an MES system, an electronic device, and a storage medium.
Background
In order to facilitate the operation of workers and better automation in a Manufacturing Execution System (MES), it is generally default that the MES System receives the work data sent by the electronic tag of the station for the first time, which indicates that the tooling plate flows into the station, and the lot number starts to perform 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 operation of the working procedure of the station is finished and the tooling plate should flow to the next station. Because the monitoring range of the RFID card reader is a sector area and the RFID card reader continuously monitors, the RFID electronic tag can send the same information to the MES for many times when passing through the area along with the tooling plate, thereby influencing the accuracy of data and the dispatching 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, and aims to solve the technical problem that the accuracy of data is affected by sending the same information to the MES system by an electronic tag many times in the prior art.
In order to achieve the above object, the present invention provides a data processing method based on MES system, the method includes:
A. detecting whether a pre-configured electronic tag sends working data or not in real time, and judging whether the working data exists in a pre-created second data table or not based on attribute information of the working data when the working data sent by the electronic tag is detected;
B. when the second data table is judged not to have the working data, judging whether the pre-established first data table has the working data, and when the first data table does not have the working data, storing the working data into a preset first working queue for an MES system to read the working data from the first working queue, generating a timestamp of the working data and adding the timestamp to the first data table;
C. when the working data exist 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 a timestamp of the working data from the first data table;
D. and calculating whether the time difference between the timestamp of the working data and the current time is greater than or equal to a preset time length, checking the working data based on a preset checking rule when the time difference is greater than or equal to the preset time length, and storing the checked working data into 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:
the product information corresponding to the electronic tag, the station information corresponding to the electronic tag and the ID of the electronic tag.
Preferably, after the step D, the method comprises:
acquiring a first quantity of the work data which are stored in the second work queue and pass the verification, and acquiring a second quantity of the work data read from the second work queue by the MES system;
judging whether the first quantity is the same as the second quantity, if not, inquiring whether the serial number identification of each piece of working data of the MES system is continuous, and acquiring an interrupted serial number identification when the serial number identification is not continuous;
and inquiring the working data corresponding to the interrupted serial number identification based on the interrupted serial number identification, and sending the working data corresponding to the interrupted serial number identification to the second work queue so that the MES system can read the working data corresponding to the interrupted serial number identification from the second work queue.
Preferably, the verifying the working data based on the 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 or not, and when the product information corresponding to the electronic tag and the station information corresponding to the electronic tag are both correct, checking the working data to pass.
Preferably, before the step B, the method further comprises:
pre-creating a first work queue and a second work queue, 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 reads the work 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 an electronic device, including: the MES system-based data processing program is stored on the memory and executed by the processor, and the method comprises the following steps:
A. detecting whether a pre-configured electronic tag sends working data or not in real time, and judging whether the working data exists in a pre-created second data table or not based on attribute information of the working data when the working data sent by the electronic tag is detected;
B. when the second data table is judged not to have the working data, judging whether the pre-established first data table has the working data, and when the first data table does not have the working data, storing the working data into a preset first working queue for an MES system to read the working data from the first working queue, generating a timestamp of the working data and adding the timestamp to the first data table;
C. when the working data exist 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 a timestamp of the working data from the first data table;
D. and calculating whether the time difference between the timestamp of the working data and the current time is greater than or equal to a preset time length, checking the working data based on a preset checking rule when the time difference is greater than or equal to the preset time length, and storing the checked working data into 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:
the product information corresponding to the electronic tag, the station information corresponding to the electronic tag and the ID of the electronic tag.
Preferably, after the step D, the MES system-based data processing program is executed by the processor, and further implements the steps of:
acquiring a first quantity of the work data which are stored in the second work queue and pass the verification, and acquiring a second quantity of the work data read from the second work queue by the MES system;
judging whether the first quantity is the same as the second quantity, if not, inquiring whether the serial number identification of each piece of working data of the MES system is continuous, and acquiring an interrupted serial number identification when the serial number identification is not continuous;
and inquiring the working data corresponding to the interrupted serial number identification based on the interrupted serial number identification, and sending the working data corresponding to the interrupted serial number identification to the second work queue so that the MES system can read the working data corresponding to the interrupted serial number identification from the second work queue.
Preferably, before the step B, the MES system-based data processing program is executed by the processor, and further implements the steps of:
pre-creating a first work queue and a second work queue, 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 reads the work 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 further provides a computer readable storage medium, which includes an MES system based data processing program, and when the MES system based data processing program is executed by a processor, the MES system based data processing program implements any step of the MES system based data processing method as described above.
According to the MES system-based data processing method, the electronic device and the storage medium, the problem of inaccurate data is solved by checking the payroll data with the time difference larger than or equal to the preset time, the data table and the work queue are created to store the related data, so that the data transmission speed is higher, and the delayed response caused by the overlarge data amount is avoided.
Drawings
FIG. 1 is a diagram of an electronic device according to a preferred embodiment of the present invention;
FIG. 2 is a block diagram of a preferred embodiment of the MES-based data processing program of FIG. 1;
FIG. 3 is a flow chart of a preferred embodiment of the MES system-based data processing method of the present invention;
the implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, a schematic diagram of an electronic device 1 according to a preferred embodiment of the 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 apparatus 1 is connected to a network through a network interface 14. The network may be a wireless or wired network such as the Internet, a 4G network, a 5G network, Bluetooth (Bluetooth), Wi-Fi, a communication network, and the like.
The memory 11 includes at least one type of readable storage medium including a flash memory, a hard disk, a multimedia card, a card type memory (e.g., SD or DX memory, etc.), a Random Access Memory (RAM), a Static Random Access Memory (SRAM), a Read Only Memory (ROM), an Electrically Erasable Programmable Read Only Memory (EEPROM), a Programmable Read Only Memory (PROM), a magnetic memory, a magnetic disk, an 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, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a flash Card (FlashCard), and the like, which are equipped with the electronic apparatus 1. Of course, the memory 11 may also comprise both an internal memory unit of the electronic apparatus 1 and an external memory device thereof. In this embodiment, the memory 11 is generally used for storing an operating system and various application software installed in the electronic device 1, such as program codes of the MES system based data processing program 10. Further, the memory 11 may also 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 (CPU), controller, microcontroller, microprocessor, or other data Processing chip in some embodiments. The processor 12 is generally used for controlling the overall operation of the electronic device 1, such as performing data interaction or communication related control and processing. In this embodiment, the processor 12 is configured to execute the program code or process data stored in the memory 11, for example, execute the program code of the MES system based data processing program 10.
The display 13 may be referred to as a display screen or display unit. In some embodiments, 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 screen, or the like. The display 13 is used for displaying information processed in the electronic device 1 and for displaying a visual work interface, for example, results of data statistics.
The network interface 14 may optionally comprise a standard wired interface, a wireless interface (e.g. WI-FI interface), the network interface 14 typically being used for establishing a communication connection between the electronic apparatus 1 and other electronic devices.
Fig. 1 shows only the electronic device 1 with components 11-14 and an MES system based data processing program 10, but it is to be understood that not all shown components are required to be implemented, and that more or less components may be implemented instead.
Optionally, the electronic device 1 may further comprise a user interface, the user interface may comprise a Display (Display), an input unit such as a Keyboard (Keyboard), and the optional user interface may further comprise 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, which may also be referred to as a display screen or display unit, is suitable for displaying information processed in the electronic apparatus 1 and for displaying a visualized user interface.
The electronic device 1 may further include a Radio Frequency (RF) circuit, a sensor, an audio circuit, and the like, which are not described in detail herein.
In the above embodiment, the processor 12 executing the MES system-based data processing program 10 stored in the memory 11 can implement the following steps:
A. detecting whether a pre-configured electronic tag sends working data or not in real time, and judging whether the working data exists in a pre-created second data table or not based on attribute information of the working data when the working data sent by the electronic tag is detected;
B. when the second data table is judged not to have the working data, judging whether the pre-established first data table has the working data, and when the first data table does not have the working data, storing the working data into a preset first working queue for an MES system to read the working data from the first working queue, generating a timestamp of the working data and adding the timestamp to the first data table;
C. when the working data exist 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 a timestamp of the working data from the first data table;
D. and calculating whether the time difference between the timestamp of the working data and the current time is greater than or equal to a preset time length, checking the working data based on a preset checking rule when the time difference is greater than or equal to the preset time length, and storing the checked working data into 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 description of fig. 2 regarding an embodiment of the MES system based data processing program 10 and fig. 3 regarding a flowchart of an embodiment of the MES system based data processing method.
In other embodiments, the MES system-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 accomplish the present invention. The modules referred to herein are referred to as a series of computer program instruction segments capable of performing specified functions.
Referring to FIG. 2, a block diagram of an embodiment of the MES system 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 detecting module 110, the first determining module 120, the second determining module 130 and the processing module 140.
The detecting module 110 is configured to detect whether a pre-configured electronic tag sends working data in real time, and when the electronic tag sends the working data, determine whether the working data exists in a pre-created second data table based on attribute information of the working data.
In this embodiment, whether a pre-configured electronic tag sends working data is detected in real time, and when it is detected that the electronic tag sends the working data, whether the working data exists in a pre-created second data table is determined based on attribute information of the working data. Wherein, the attribute information of the working data comprises: the product information corresponding to the electronic tag, the station information corresponding to the electronic tag and the ID of the electronic tag.
The second data table can be a hash table and is used for storing working data in the working procedure operation or completed operation of the station, and the hash table is used for storing relevant working data, so that the speed is faster when the corresponding working data is searched. The MES system receives the working data sent by the electronic tag of the station for the first time, namely the tooling plate flows into the station, the batch number starts to carry out production operation, the MES system receives the working data sent by the electronic tag of the station for the second time, which indicates that the operation of the station process is finished, the tooling plate should flow to the next station, and as the detection range of the electronic tag is a sector area and the detection is ceaselessly carried out, the electronic tag can transmit the same data to the MES system for a plurality of times when passing through the area along with the tooling plate, so that whether the working data exist in the second data table can be judged through the attribute information of the working data sent by the electronic tag, and the station process is judged to be in operation or finished.
The first determining module 120 is configured to determine whether the working data exists in a pre-created first data table when it is determined that the working data does not exist in the second data table, and store the working data into a preset first 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 the second data table does not have the working data sent by the electronic tag, it indicates that a tooling board that may not be operated by a working process flows into the workstation, and a working process operation needs to be performed on the tooling board, and therefore, it needs to be determined whether the working data exists in a pre-created first data table, where the first data table is used to store a timestamp of the working data, and when the working data does not exist in the first data table, it may be determined that a tooling board that is not operated by a working process flows into the workstation, and in an actual application scenario, because the data size of the production system is large, and the MES system also receives the data sent by the electronic tag many times, the data storage pressure of the MES system is large, the working data may be stored in the preset first working queue, and the MES system may read the working data from the first working queue, and in a high concurrency scenario, the MES system is relieved of data storage pressure, and thereafter, a timestamp of the working data is generated and added to the first data table. It is understood that, when the work data exists in the first data table, the work queue may be a middleware in the process operation being performed on the tooling plate corresponding to the tooling data.
In an embodiment, a first work queue and a second work queue may also be created in advance, log files of the first work queue and the second work queue are read, a tree-like hierarchical storage structure is constructed, 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 reads the work 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.
A second determining module 130, configured to determine whether the state value of the working data in the second data table is a preset value when the working data exists in the second data table, and obtain the timestamp of the working data from the first data table when the state value of the working data in the second data table is the preset value.
In this embodiment, when the working data exists in the second data table, it is 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 the preset value, the timestamp of the working data is obtained from the first data table, and is used for calculating a time difference between the timestamp of the working data and the current time. The status value of the working data stored in the second data table indicates that the working position process is in operation or has been completed, the preset value of this embodiment indicates that the process is still in operation and is not completed, and the status value may be 0 or 1, for example, 0 indicates that the process operation is in operation, and 1 indicates that the process operation is completed.
The processing module 140 is configured to calculate whether a time difference between the timestamp of the working data and the current time is greater than or equal to a preset duration, check the working data based on a preset check rule when the time difference is greater than or equal to the preset duration, and store the working data that passes the check to a preset second working queue, so that the MES system reads the working data that passes the check from the second working queue.
In this embodiment, after the timestamp of the working data is obtained from the first data table, whether a time difference between the timestamp of the working data and the current time is greater than or equal to a preset time length is calculated, when the time difference is greater than or equal to the preset time length, the preset time length is an operation time length of the process, when the time difference between the timestamp of the working data and the current time is greater than or equal to the operation time length of the process, the operation of the process is completed, payroll data corresponding to the process that can be completed by the operation is verified, the working data is verified based on a preset verification rule, and the working data that is verified is stored in a preset second working queue, so that the MES system can read the working data that is verified 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 or not, and when the product information corresponding to the electronic tag and the station information corresponding to the electronic tag are both correct, checking the working data to pass.
In one embodiment, the first amount of the work data which is stored in the second work queue and passes the check is further obtained, and the second amount of the work data which is read from the second work queue by the MES system is obtained;
judging whether the first quantity is the same as the second quantity, if not, inquiring whether the serial number identification of each piece of working data of the MES system is continuous, and acquiring an interrupted serial number identification when the serial number identification is not continuous;
and inquiring the working data corresponding to the interrupted serial number identification based on the interrupted serial number identification, and sending the working data corresponding to the interrupted serial number identification to the second work queue so that the MES system can read the working data corresponding to the interrupted serial number identification from the second work queue. The omitted working data are screened out by inquiring whether the serial number identification of the working data is continuous or not, and meanwhile, the serial number identification of the working data is compared, so that the interrupted serial number identification is searched out, and the condition that the working data is omitted can be avoided.
In addition, the invention also provides a data processing method based on the MES system. Fig. 3 is a schematic method flow diagram of an embodiment of the data processing method based on the MES system according to the present invention. When the processor 12 of the electronic device 1 executes the MES system based data processing program 10 stored in the memory 11, the following steps of the MES system based data processing method are implemented:
step S10: and detecting whether a pre-configured electronic tag sends working data or not in real time, and judging whether the working data exists in a pre-created second data table or not based on the attribute information of the working data when the working data sent by the electronic tag is detected.
In this embodiment, whether a pre-configured electronic tag sends working data is detected in real time, and when it is detected that the electronic tag sends the working data, whether the working data exists in a pre-created second data table is determined based on attribute information of the working data. Wherein, the attribute information of the working data comprises: the product information corresponding to the electronic tag, the station information corresponding to the electronic tag and the ID of the electronic tag.
The second data table can be a hash table and is used for storing working data in the working procedure operation or completed operation of the station, and the hash table is used for storing relevant working data, so that the speed is faster when the corresponding working data is searched. The MES system receives the working data sent by the electronic tag of the station for the first time, namely the tooling plate flows into the station, the batch number starts to carry out production operation, the MES system receives the working data sent by the electronic tag of the station for the second time, which indicates that the operation of the station process is finished, the tooling plate should flow to the next station, and as the detection range of the electronic tag is a sector area and the detection is ceaselessly carried out, the electronic tag can transmit the same data to the MES system for a plurality of times when passing through the area along with the tooling plate, so that whether the working data exist in the second data table can be judged through the attribute information of the working data sent by the electronic tag, and the station process is judged to be in operation or finished.
Step S20: when the second data table is judged not to have the working data, whether the working data exist in a pre-established first data table is judged, and when the working data do not exist in the first data table, the working data are stored into a preset first working queue so that an MES system can read the working data from the first working queue, generate a timestamp of the working data and add the timestamp to the first data table.
In this embodiment, when it is determined that the second data table does not have the working data sent by the electronic tag, it indicates that a tooling board that may not be operated by a working process flows into the workstation, and a working process operation needs to be performed on the tooling board, and therefore, it needs to be determined whether the working data exists in a pre-created first data table, where the first data table is used to store a timestamp of the working data, and when the working data does not exist in the first data table, it may be determined that a tooling board that is not operated by a working process flows into the workstation, and in an actual application scenario, because the data size of the production system is large, and the MES system also receives the data sent by the electronic tag many times, the data storage pressure of the MES system is large, the working data may be stored in the preset first working queue, and the MES system may read the working data from the first working queue, and in a high concurrency scenario, the MES system is relieved of data storage pressure, and thereafter, a timestamp of the working data is generated and added to the first data table. It is understood that, when the work data exists in the first data table, the work queue may be a middleware in the process operation being performed on the tooling plate corresponding to the tooling data.
In an embodiment, a first work queue and a second work queue may also be created in advance, log files of the first work queue and the second work queue are read, a tree-like hierarchical storage structure is constructed, 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 reads the work 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: and when the working data exist 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.
In this embodiment, when the working data exists in the second data table, it is 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 the preset value, the timestamp of the working data is obtained from the first data table, and is used for calculating a time difference between the timestamp of the working data and the current time. The status value of the working data stored in the second data table indicates that the working position process is in operation or has been completed, the preset value of this embodiment indicates that the process is still in operation and is not completed, and the status value may be 0 or 1, for example, 0 indicates that the process operation is in operation, and 1 indicates that the process operation is completed.
Step S40: and calculating whether the time difference between the timestamp of the working data and the current time is greater than or equal to a preset time length, checking the working data based on a preset checking rule when the time difference is greater than or equal to the preset time length, and storing the checked working data into 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 timestamp of the working data is obtained from the first data table, whether a time difference between the timestamp of the working data and the current time is greater than or equal to a preset time length is calculated, when the time difference is greater than or equal to the preset time length, the preset time length is an operation time length of the process, when the time difference between the timestamp of the working data and the current time is greater than or equal to the operation time length of the process, the operation of the process is completed, payroll data corresponding to the process that can be completed by the operation is verified, the working data is verified based on a preset verification rule, and the working data that is verified is stored in a preset second working queue, so that the MES system can read the working data that is verified 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 or not, and when the product information corresponding to the electronic tag and the station information corresponding to the electronic tag are both correct, checking the working data to pass.
In one embodiment, the first amount of the work data which is stored in the second work queue and passes the check is further obtained, and the second amount of the work data which is read from the second work queue by the MES system is obtained;
judging whether the first quantity is the same as the second quantity, if not, inquiring whether the serial number identification of each piece of working data of the MES system is continuous, and acquiring an interrupted serial number identification when the serial number identification is not continuous;
and inquiring the working data corresponding to the interrupted serial number identification based on the interrupted serial number identification, and sending the working data corresponding to the interrupted serial number identification to the second work queue so that the MES system can read the working data corresponding to the interrupted serial number identification from the second work queue. The omitted working data are screened out by inquiring whether the serial number identification of the working data is continuous or not, and meanwhile, the serial number identification of the working data is compared, so that the interrupted serial number identification is searched out, and the condition that the working data is omitted can be avoided.
Furthermore, the embodiment of the present invention also provides a computer-readable storage medium, which may be any one or any combination of a 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 an MES system based data processing program 10, and when executed by a processor, the MES system based data processing program 10 implements the following operations:
A. detecting whether a pre-configured electronic tag sends working data or not in real time, and judging whether the working data exists in a pre-created second data table or not based on attribute information of the working data when the working data sent by the electronic tag is detected;
B. when the second data table is judged not to have the working data, judging whether the pre-established first data table has the working data, and when the first data table does not have the working data, storing the working data into a preset first working queue for an MES system to read the working data from the first working queue, generating a timestamp of the working data and adding the timestamp to the first data table;
C. when the working data exist 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 a timestamp of the working data from the first data table;
D. and calculating whether the time difference between the timestamp of the working data and the current time is greater than or equal to a preset time length, checking the working data based on a preset checking rule when the time difference is greater than or equal to the preset time length, and storing the checked working data into 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, and will not be described herein again.
It should be noted that the above-mentioned numbers of the embodiments of the present invention are merely for description, and do not represent the merits 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 an … …" does not exclude the presence of other like elements in a process, apparatus, article, or method that includes the element.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solution of the present invention essentially or contributing to the prior art can be embodied in the form of a software product, which is stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) as described above and includes several instructions for enabling a terminal device (such as a mobile phone, a computer, an electronic device, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.

Claims (10)

1. A data processing method based on MES system, the method comprising:
A. detecting whether a pre-configured electronic tag sends working data or not in real time, and judging whether the working data exists in a pre-created second data table or not based on attribute information of the working data when the working data sent by the electronic tag is detected;
B. when the second data table is judged not to have the working data, judging whether the pre-established first data table has the working data, and when the first data table does not have the working data, storing the working data into a preset first working queue for an MES system to read the working data from the first working queue, generating a timestamp of the working data and adding the timestamp to the first data table;
C. when the working data exist 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 a timestamp of the working data from the first data table;
D. and calculating whether the time difference between the timestamp of the working data and the current time is greater than or equal to a preset time length, checking the working data based on a preset checking rule when the time difference is greater than or equal to the preset time length, and storing the checked working data into a preset second working queue for the MES system to read the checked working data from the second working queue.
2. The MES system-based data processing method of claim 1, wherein the attribute information of the job data comprises:
the product information corresponding to the electronic tag, the station information corresponding to the electronic tag and the ID of the electronic tag.
3. The MES system-based data processing method of claim 1, wherein after step D, the method comprises:
acquiring a first quantity of the work data which are stored in the second work queue and pass the verification, and acquiring a second quantity of the work data read from the second work queue by the MES system;
judging whether the first quantity is the same as the second quantity, if not, inquiring whether the serial number identification of each piece of working data of the MES system is continuous, and acquiring an interrupted serial number identification when the serial number identification is not continuous;
and inquiring the working data corresponding to the interrupted serial number identification based on the interrupted serial number identification, and sending the working data corresponding to the interrupted serial number identification to the second work queue so that the MES system can read the working data corresponding to the interrupted serial number identification from the second work queue.
4. The MES system-based data processing method of claim 2, wherein the verifying the working data based on the predetermined verification rule comprises:
and respectively checking whether the product information corresponding to the electronic tag and the station information corresponding to the electronic tag are correct or not, and when the product information corresponding to the electronic tag and the station information corresponding to the electronic tag are both correct, checking the working data to pass.
5. The MES system-based data processing method of claim 1, wherein prior to step B, the method further comprises:
pre-creating a first work queue and a second work queue, 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 reads the work 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, comprising: the MES system-based data processing program is stored on the memory and executed by the processor, and the method comprises the following steps:
A. detecting whether a pre-configured electronic tag sends working data or not in real time, and judging whether the working data exists in a pre-created second data table or not based on attribute information of the working data when the working data sent by the electronic tag is detected;
B. when the second data table is judged not to have the working data, judging whether the pre-established first data table has the working data, and when the first data table does not have the working data, storing the working data into a preset first working queue for an MES system to read the working data from the first working queue, generating a timestamp of the working data and adding the timestamp to the first data table;
C. when the working data exist 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 a timestamp of the working data from the first data table;
D. and calculating whether the time difference between the timestamp of the working data and the current time is greater than or equal to a preset time length, checking the working data based on a preset checking rule when the time difference is greater than or equal to the preset time length, and storing the checked working data into a preset second working queue for the MES system to read the checked working data from the second working queue.
7. The electronic device of claim 6, wherein the attribute information of the working data comprises:
the product information corresponding to the electronic tag, the station information corresponding to the electronic tag and the ID of the electronic tag.
8. The electronic device of claim 6, wherein after said step D, said MES system-based data processing program is executed by said processor, further implementing the steps of:
acquiring a first quantity of the work data which are stored in the second work queue and pass the verification, and acquiring a second quantity of the work data read from the second work queue by the MES system;
judging whether the first quantity is the same as the second quantity, if not, inquiring whether the serial number identification of each piece of working data of the MES system is continuous, and acquiring an interrupted serial number identification when the serial number identification is not continuous;
and inquiring the working data corresponding to the interrupted serial number identification based on the interrupted serial number identification, and sending the working data corresponding to the interrupted serial number identification to the second work queue so that the MES system can read the working data corresponding to the interrupted serial number identification from the second work queue.
9. The electronic device of claim 6, wherein prior to said step B, said MES system-based data processing program is executed by said processor, further implementing the steps of:
pre-creating a first work queue and a second work queue, 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 reads the work 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, wherein the computer readable storage medium comprises an MES system based data processing program, and wherein the MES system based data processing program when executed by a processor implements the steps of the MES system based data processing method 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 true CN111582736A (en) 2020-08-25
CN111582736B 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 (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2004240512A (en) * 2003-02-03 2004-08-26 Toyota Motor Corp Production line delaying process part detection system and method
JP2006113901A (en) * 2004-10-15 2006-04-27 Nec Corp Rfid batch reading device, and article manufacturing system
JP2010108117A (en) * 2008-10-29 2010-05-13 Hitachi High-Tech Control Systems Corp Production management system using rfid
JP2011081682A (en) * 2009-10-08 2011-04-21 Ricoh Co Ltd Working time analysis support system and program
JP2011129000A (en) * 2009-12-18 2011-06-30 Brother Industries Ltd System and method for managing work
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
JP2013033349A (en) * 2011-08-01 2013-02-14 Dainippon Printing Co Ltd Work sheet creation program and work sheet creation system
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
US20180196409A1 (en) * 2016-02-17 2018-07-12 Plataine Ltd. Tracking production in a production facility using searchable digital threads
US20180341900A1 (en) * 2017-05-24 2018-11-29 Dell Products L.P. Guaranteed Processing with Generational Queues
WO2019034782A1 (en) * 2017-08-17 2019-02-21 Abb Schweiz Ag Scheduling manufacturing process of parallel machines

Patent Citations (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2004240512A (en) * 2003-02-03 2004-08-26 Toyota Motor Corp Production line delaying process part detection system and method
JP2006113901A (en) * 2004-10-15 2006-04-27 Nec Corp Rfid batch reading device, and article manufacturing system
JP2010108117A (en) * 2008-10-29 2010-05-13 Hitachi High-Tech Control Systems Corp Production management system using rfid
JP2011081682A (en) * 2009-10-08 2011-04-21 Ricoh Co Ltd Working time analysis support system and program
JP2011129000A (en) * 2009-12-18 2011-06-30 Brother Industries Ltd System and method for managing work
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
JP2013033349A (en) * 2011-08-01 2013-02-14 Dainippon Printing Co Ltd Work sheet creation program and work sheet creation system
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
US20180196409A1 (en) * 2016-02-17 2018-07-12 Plataine Ltd. Tracking production in a production facility using searchable digital threads
US20180341900A1 (en) * 2017-05-24 2018-11-29 Dell Products L.P. Guaranteed Processing with Generational Queues
WO2019034782A1 (en) * 2017-08-17 2019-02-21 Abb Schweiz Ag Scheduling manufacturing process of parallel machines

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
YI HUANG ET AL.: "Reactive, model-based monitoring in RFID-enabled manufacturing", COMPUTERS IN INDUSTRY *
刘明周;马靖;赵志彪;王强;张淼;: "物联网环境下的机械产品管控一体智能装配系统建模" *
吴志华;曾喜娟;: "基于RFID的MES数据采集终端的实现" *

Also Published As

Publication number Publication date
CN111582736B (en) 2023-05-19

Similar Documents

Publication Publication Date Title
CN108427705B (en) Electronic device, distributed system log query method and storage medium
CN108491301B (en) Electronic device, abnormality early warning method based on redis and 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
CN107835520B (en) Wifi hotspot connection method and device and storage medium
CN111290742A (en) Parameter verification method and device, electronic equipment and readable storage medium
CN111427803A (en) Automated random test method, apparatus, computer device and medium
CN110267215B (en) Data detection method, equipment and storage medium
CN108491304B (en) electronic device, business system risk control method and storage medium
CN112130936B (en) Data calling method, device, equipment and storage medium based on polling
CN109491733B (en) Interface display method based on visualization and related equipment
CN111767262A (en) Log display method, device, equipment and storage medium
CN111460496A (en) Permission configuration method based on user role, electronic device and storage medium
CN112631911A (en) Automatic testing method and device, computer equipment and storage medium
CN112634973A (en) Data rereading method and system of storage medium, terminal device and storage medium
CN113128168A (en) Pad parameter checking and correcting method and device, computer equipment and storage medium
CN113076112A (en) Database deployment method and device and electronic equipment
CN111582736B (en) MES system-based data processing method, electronic device and storage medium
CN113419949B (en) Abnormality detection method, device, equipment and storage medium for data processing
CN112181479A (en) Method and device for determining difference between code file versions and electronic equipment
CN110837500A (en) Data screening method and device based on local embedded window and computer equipment
CN111077859B (en) Production process control method, device and system
CN113342600B (en) Method and device for monitoring program dependent plug-in
CN115890004A (en) Laser marking method based on image recognition and related device
CN114968822A (en) Interface testing method and device, computer equipment and 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