CN109636256B - MAC address management method of MES system - Google Patents
MAC address management method of MES system Download PDFInfo
- Publication number
- CN109636256B CN109636256B CN201910094000.5A CN201910094000A CN109636256B CN 109636256 B CN109636256 B CN 109636256B CN 201910094000 A CN201910094000 A CN 201910094000A CN 109636256 B CN109636256 B CN 109636256B
- Authority
- CN
- China
- Prior art keywords
- mac address
- number segment
- address number
- data
- pool
- 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
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/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
-
- 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
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Theoretical Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- General Physics & Mathematics (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Educational Administration (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Game Theory and Decision Science (AREA)
- Development Economics (AREA)
- Manufacturing & Machinery (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Small-Scale Networks (AREA)
Abstract
The invention discloses a MAC address management method of an MES system, which comprises the following steps: recording the MAC address number segment in the MES system and comparing the MAC address number segment with data in an MAC address number segment check pool, if no repeated data exists, passing the data, and storing the address number segment data into the MAC address check pool of the MES system; if the repeated data exists, the prompt that the repeated data exists is sent out; the MAC address number segment in the production process is imported into an MES system, and is compared with an MAC address check pool, if repeated data exist, the repeated data do not pass, and a prompt of data error of the MAC address number segment is sent; if the repeated data does not exist, the check is passed, the MAC address number segment is converted into a 10-system, the formed interval is compared with the interval formed by all the number segments in the number segment, and if an overlapped area exists, the check is not passed and a prompt for importing the repeated data of the MAC address number segment is sent; if the overlapping region does not exist, the verification is passed, a cursor is set for the address number segment, the address number segment is marked as unused, and the address number segment is stored in an MAC address number segment pool; a work order is created and the required MAC address is assigned.
Description
Technical Field
The invention relates to the technical field of intelligent manufacturing, in particular to an MAC address management method of an MES system.
Background
Manufacturing Execution System (MES), which is a manufacturing process Execution system of a manufacturing enterprise, is a set of production information management system facing to a manufacturing enterprise workshop Execution layer. The MES can provide management modules for enterprises, such as manufacturing data management, planning and scheduling management, production scheduling management, inventory management, quality management, work center/equipment management project billboard management, production process control, bottom data integration analysis, upper data integration decomposition and the like, and creates a solid, reliable, comprehensive and feasible manufacturing cooperative management platform for the enterprises. In an enterprise producing network module products, a large number of MAC (media Access Control address) addresses need to be managed, the MAC address production verification efficiency in a system needs to be guaranteed, the uniqueness of the MAC addresses needs to be realized, the data volume is huge, the pressure born by a server can be great, the natural efficiency can be increased, and the MES system is challenged.
Disclosure of Invention
The invention aims to provide a method for managing an MAC address of an MES system, which is used for solving the problems that in the prior art, a large number of MAC addresses need to be managed in an enterprise for producing network module products, the production verification efficiency of the MAC addresses in the system needs to be ensured, the uniqueness of the MAC addresses needs to be realized, the data volume is extremely large, and the pressure born by a server is very large.
The invention solves the problems through the following technical scheme:
a MAC address management method of an MES system, the method comprising the steps of:
step 1: recording an MAC address number segment in the MES system, comparing the MAC address number segment with data in an MAC address number segment check pool, if no repeated data exists, passing the data, and storing the address number segment data in the MAC address check pool of the MES system; if the repeated data exist, the repeated data do not pass, and a prompt that the data of the MAC address number segment have the repetition is sent;
step 2: the MAC address number segment in the production process is imported into an MES system, and is compared with an MAC address check pool, if repeated data exist, the repeated data do not pass, and a prompt of data error of the MAC address number segment is sent; if the repeated data does not exist, the check is passed, and the MAC address number segment is converted into a 10-system;
and step 3: comparing the interval formed by the 10-system number obtained in the step (2) with the interval formed by all the number segments in the number segment, if an overlapping area exists, the check is not passed and a prompt of importing the MAC address number segment data for repetition is sent out; if the overlapped area does not exist, the verification is passed, a cursor is set for the address number segment, the address number segment is marked as unused, and the address number segment is stored in an MAC address number segment pool;
and 4, step 4: a work order is created and the required MAC address is assigned.
The method adopts a number segment mode to store the MAC address, and the MAC address is also distributed in a number segment mode when being distributed to the work order, when the network modules produced by a factory are hundreds of millions, the method can greatly reduce the storage space of the MAC address, improve the inquiry efficiency of the MAC address and the comparison time of the validity check of the work order MAC address, and well solve the problems of large pressure and low efficiency when an MES server faces huge data volume.
Preferably, the MAC address number segment includes a start MAC address and an end MAC address, whether formats of the start MAC address and the end MAC address are correct needs to be checked before checking the MAC address, and the corresponding number segment can be found according to the real MAC address and the end MAC address without searching one by one, thereby simplifying an intermediate process.
Preferably, the MAC address number segment pool in the MES system database comprises a starting MAC address, an ending MAC address, a starting MAC address decimal value, an ending MAC address decimal value, a vernier value and a number segment state identifier, and by the design, the state of the MAC address can be known according to the vernier, and the MAC address is converted into the decimal system, so that the use is more convenient.
Preferably, the step 4 of allocating the MAC address to the work order includes the following steps:
step 4.1: acquiring an MAC address number segment related to the work order from an MAC address number segment pool;
step 4.2: reading the current cursor of the selected MAC address number segment, adding the cursor value to the work order plan number, and setting the cursor value as a new cursor value;
step 4.3: judging whether the cursor value is equal to the decimal value of the ending MAC address, and if so, setting the state flag of the MAC address number segment to be fully used; if not, the current state of the MAC address number segment is saved.
Preferably, a distributed lock is added to the selected MAC address number segment when the MAC address is allocated to the work order in step 4.
Compared with the prior art, the invention has the following advantages and beneficial effects:
(1) the invention adopts the number segment mode to store the MAC address, and the MAC address is also distributed in the number segment mode when being distributed to the work order, when the network module number produced by a factory is hundred million, the method can greatly reduce the storage space of the MAC address, improve the inquiry efficiency of the MAC address and the comparison time of the validity check of the work order MAC address, and well solve the problems of large pressure and low efficiency when the MES server faces huge data volume.
(2) The MAC address number segment comprises a starting MAC address and an ending MAC address, whether the formats of the starting MAC address and the ending MAC address are correct or not needs to be checked before the MAC address is checked, the corresponding number segment can be found according to the real MAC address and the ending MAC address, one-by-one searching is not needed, and the intermediate process is simplified.
(3) The MAC address number segment pool in the MES system database comprises a starting MAC address, an ending MAC address, a starting MAC address decimal value, an ending MAC address decimal value, a vernier value and a number segment state identifier.
Drawings
FIG. 1 is a flow chart of an MAC address number field entry implementation;
FIG. 2 is a flow chart of the MAC address number segment import implementation;
fig. 3 is a flow chart of a MAC address number segment assignment implementation.
Detailed Description
The present invention will be described in further detail with reference to examples, but the embodiments of the present invention are not limited thereto.
Example 1:
referring to fig. 1, a MAC address management method of an MES system, the method comprising the steps of:
step 1: recording an MAC address number segment in the MES system, comparing the MAC address number segment with data in an MAC address number segment check pool, if no repeated data exists, passing the data, and storing the address number segment data in the MAC address check pool of the MES system; if the repeated data exist, the repeated data do not pass, and a prompt that the data of the MAC address number segment have the repetition is sent;
step 2: the MAC address number segment in the production process is imported into an MES system, and is compared with an MAC address check pool, if repeated data exist, the repeated data do not pass, and a prompt of data error of the MAC address number segment is sent; if the repeated data does not exist, the check is passed, and the MAC address number segment is converted into a 10-system;
and step 3: comparing the interval formed by the 10-system number obtained in the step (2) with the interval formed by all the number segments in the number segment, if an overlapping area exists, the check is not passed and a prompt of importing the MAC address number segment data for repetition is sent out; if the overlapped area does not exist, the verification is passed, a cursor is set for the address number segment, the address number segment is marked as unused, and the address number segment is stored in an MAC address number segment pool;
and 4, step 4: creating a work order and distributing a needed MAC address, and adding a distributed lock to a selected MAC address number segment when distributing the MAC address for the work order, wherein the method comprises the following steps:
step 4.1: acquiring an MAC address number segment related to the work order from an MAC address number segment pool;
step 4.2: reading the current cursor of the selected MAC address number segment, adding the cursor value to the work order plan number, and setting the cursor value as a new cursor value;
step 4.3: judging whether the cursor value is equal to the decimal value of the ending MAC address, and if so, setting the state flag of the MAC address number segment to be fully used; if not, the current state of the MAC address number segment is saved.
The method adopts a number segment mode to store the MAC address, and the MAC address is also distributed in a number segment mode when being distributed to the work order, when the network modules produced by a factory are hundreds of millions, the method can greatly reduce the storage space of the MAC address, improve the inquiry efficiency of the MAC address and the comparison time of the validity check of the work order MAC address, and well solve the problems of large pressure and low efficiency when an MES server faces huge data volume.
In the method, the MAC address number segment comprises a starting MAC address and an ending MAC address, whether the formats of the starting MAC address and the ending MAC address are correct or not needs to be verified before the MAC address is verified, the corresponding number segment can be found according to the real MAC address and the ending MAC address, one-by-one searching is not needed, and the intermediate process is simplified. The MAC address number segment pool in the MES system database comprises a starting MAC address, an ending MAC address, a starting MAC address decimal value, an ending MAC address decimal value, a vernier value and a number segment state identifier.
Although the present invention has been described herein with reference to the illustrated embodiments thereof, which are intended to be preferred embodiments of the present invention, it is to be understood that the invention is not limited thereto, and that numerous other modifications and embodiments can be devised by those skilled in the art that will fall within the spirit and scope of the principles of this disclosure.
Claims (3)
1. A MAC address management method of an MES system, the method comprising the steps of:
step 1: recording an MAC address number segment in the MES system, comparing the MAC address number segment with data in an MAC address number segment check pool, if no repeated data exists, passing the data, and storing the address number segment data in the MAC address check pool of the MES system; if the repeated data exist, the repeated data do not pass, and a prompt that the data of the MAC address number segment have the repetition is sent; the MAC address number segment pool in the MES system database comprises a starting MAC address, an ending MAC address, a starting MAC address decimal value, an ending MAC address decimal value, a vernier value and a number segment state identifier;
step 2: the MAC address number segment in the production process is imported into an MES system, and is compared with an MAC address check pool, if repeated data exist, the repeated data do not pass, and a prompt of data error of the MAC address number segment is sent; if the repeated data does not exist, the check is passed, and the MAC address number segment is converted into a decimal system;
and step 3: comparing the interval formed by the decimal numbers obtained in the step (2) with the interval formed by all number segments in the number segment pool, if an overlapping area exists, the check is not passed and a prompt of importing MAC address number segment data for repetition is sent out; if the overlapped area does not exist, the verification is passed, a cursor is set for the address number segment, the address number segment is marked as unused, and the address number segment is stored in an MAC address number segment pool;
and 4, step 4: creating a work order and distributing a required MAC address; the step 4 of allocating the MAC address to the work order comprises the following steps:
step 4.1: acquiring an MAC address number segment related to the work order from an MAC address number segment pool;
step 4.2: reading the current cursor of the selected MAC address number segment, adding the cursor value to the work order plan number, and setting the cursor value as a new cursor value;
step 4.3: judging whether the cursor value is equal to the decimal value of the ending MAC address, and if so, setting the state identifier of the MAC address number segment to be fully used; if not, the current state of the MAC address number segment is saved.
2. A MAC address management method of MES system according to claim 1, characterized in that it comprises the following steps: the MAC address number field comprises a starting MAC address and an ending MAC address, and whether the formats of the starting MAC address and the ending MAC address are correct or not needs to be verified before the MAC address is verified.
3. The MAC address management method of MES system of claim 1, wherein: and adding a distributed lock to the selected MAC address number segment when the MAC address is distributed to the work order in the step 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910094000.5A CN109636256B (en) | 2019-01-30 | 2019-01-30 | MAC address management method of MES system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910094000.5A CN109636256B (en) | 2019-01-30 | 2019-01-30 | MAC address management method of MES system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109636256A CN109636256A (en) | 2019-04-16 |
| CN109636256B true CN109636256B (en) | 2022-04-12 |
Family
ID=66064262
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910094000.5A Active CN109636256B (en) | 2019-01-30 | 2019-01-30 | MAC address management method of MES system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109636256B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113283747B (en) * | 2021-05-24 | 2022-08-12 | 福州国电远控科技开发有限公司 | Production information control method and device based on MES |
Family Cites Families (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP3176894B2 (en) * | 1999-04-07 | 2001-06-18 | 株式会社ソリトンシステムズ | Collective wiring repeater |
| CN1696926A (en) * | 2004-05-15 | 2005-11-16 | 鸿富锦精密工业（深圳）有限公司 | MAC system of automatic assigning addresses and method |
| CN102340551B (en) * | 2010-07-27 | 2016-02-03 | 中国电信股份有限公司 | A kind of method and system building IPv6 address pool |
| CN102469170B (en) * | 2010-11-03 | 2014-04-16 | 英业达集团(天津)电子技术有限公司 | Method for generating static Internet protocol (IP) address under disk operating system (DOS) |
| WO2012109864A1 (en) * | 2011-07-29 | 2012-08-23 | 华为技术有限公司 | Message forwarding method and device |
| CN103002430B (en) * | 2011-09-09 | 2016-05-25 | 中国移动通信集团公司 | Method, the Apparatus and system of a kind of terminal applies and termination number binding |
| CN103259875A (en) * | 2012-02-16 | 2013-08-21 | 鸿富锦精密工业（深圳）有限公司 | Method for detecting server IP addresses |
| CN103259726B (en) * | 2012-02-21 | 2017-04-12 | 华为技术有限公司 | Method, device and system for storing and sending MAC address table entries |
| CN103606086A (en) * | 2013-11-05 | 2014-02-26 | 上海优思通信科技有限公司 | Anti-counterfeit method of mobile intelligent terminal |
| CN103841526B (en) * | 2014-03-14 | 2018-07-06 | 迈普通信技术股份有限公司 | A kind of method and system of arrival reminding |
| CN105337766A (en) * | 2015-10-12 | 2016-02-17 | 安徽皖通邮电股份有限公司 | Network element automatic discovery method and system based on DHCP |
| CN105227372A (en) * | 2015-10-20 | 2016-01-06 | 四川长虹电子部品有限公司 | The method of configuration Internet of Things WIFI module |
| CN106982092B (en) * | 2016-01-18 | 2021-01-08 | 中兴通讯股份有限公司 | Abnormal message capturing method of optical network terminal and optical network terminal |
| CN106412996B (en) * | 2016-09-30 | 2019-09-06 | 杭州迪普科技股份有限公司 | The method and device to E-Packet |
| CN106534113B (en) * | 2016-11-09 | 2021-02-09 | 海信视像科技股份有限公司 | SSH connection establishment method and device |
| CN108712518A (en) * | 2018-05-29 | 2018-10-26 | 郑州云海信息技术有限公司 | A kind of distribution method and system of end product MAC Address |
-
2019
- 2019-01-30 CN CN201910094000.5A patent/CN109636256B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN109636256A (en) | 2019-04-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101504672B (en) | Method and system for dynamically configuring physical data table | |
| CN103067463B (en) | user root authority centralized management system and management method | |
| CN104794123A (en) | Method and device for establishing NoSQL database index for semi-structured data | |
| CN103902698A (en) | Data storage system and data storage method | |
| CN111582885A (en) | Block chain-based vaccine management method and storage medium | |
| CN109636256B (en) | MAC address management method of MES system | |
| CN100527131C (en) | Interdynamic access method and tool of IMS data base | |
| US9513997B2 (en) | Test data management | |
| CN101963993B (en) | Method for fast searching database sheet table record | |
| CN112948473A (en) | Data processing method, device and system of data warehouse and storage medium | |
| US11893028B2 (en) | System and method for interactive and automated data processing from disparate data sources | |
| CN110633267B (en) | Method and system capable of supporting multi-service report function | |
| CN112860954A (en) | Real-time computing method and real-time computing system | |
| CN113568909B (en) | Data updating method and system for structural tree | |
| CN113656504A (en) | Block chain transaction submitting, editing and inquiring method based on time sequence attribute | |
| CN113377979A (en) | Method for comparing, generating and optimizing train running scheme based on Mercker tree | |
| CN105956099A (en) | HBase high table-based primary key design method | |
| CN116881953B (en) | Data isolation method, device and medium based on virtual space | |
| CN103218450B (en) | A kind of many application real-time data base method of data synchronization | |
| CN111667217B (en) | Warehouse network information storage method | |
| CN102339422A (en) | Method and system for modeling service object | |
| CN112948250B (en) | Structure detection method and system based on data standard | |
| CN117689265A (en) | Method, device, equipment and storage medium for configuring index multi-dimensional target value | |
| CN117312272A (en) | Data migration solution method and system based on multi-source heterogeneous data scene | |
| CN117971809A (en) | Data migration method and system based on heterogeneous database |
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 |