Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Dynamic deployment scheduling method based on ERP and MES data caching technology

A technology of dynamic deployment and scheduling method, applied in the field of ERP system, can solve the problem that the production line cannot meet the needs of competition, achieve the effect of good operation status and improve work efficiency

Pending Publication Date: 2022-03-29
深圳市固美特科技有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The current international popular enterprise informatization is an opportunity for Chinese enterprises to regain their leadership and a rare development opportunity. Therefore, informatization systems are widely used in various domestic enterprises. Enterprise resource systems, commonly known as The ERP system is one of the information systems that have been widely used in recent years, but at present most production lines have not adopted the modified system technology, which makes the production line unable to meet the increasingly complex and changeable competitive needs. ERP system for production efficiency

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0024] A dynamic deployment scheduling method based on ERP and MES data caching technology, including the following steps:

[0025] (a) Build the database of the ERP system, establish the database and its application system, so that it can effectively store data, and meet the user's information requirements and processing requirements, and use the structured analysis method to decompose from top to bottom and layer by layer Analyze the system, use the data flow diagram data dictionary to describe the system, divide it into data storage, data source and data output to classify the data flow in detail;

[0026] (b) The data flow diagram divides the data in the database into tables and partitions the base tables in the database. The data on a base table can be stored in multiple data files according to time. In the design of the database, the database can be Create partitions by quarter, keep three quarter partitions in the database, and set the current quarter, the previous quar...

Embodiment 2

[0031] A dynamic deployment scheduling method based on ERP and MES data caching technology, including the following steps:

[0032] (a) Build the database of the ERP system, establish the database and its application system, so that it can effectively store data, and meet the user's information requirements and processing requirements, and use the structured analysis method to decompose from top to bottom and layer by layer Analyze the system, use the data flow diagram data dictionary to describe the system, divide it into data storage, data source and data output to classify the data flow in detail;

[0033] (b) The data flow diagram divides the data in the database into tables and partitions the base tables in the database. The data on a base table can be stored in multiple data files according to time. In the design of the database, the database can be Create partitions by quarter, keep three quarter partitions in the database, and set the current quarter, the previous quar...

Embodiment 3

[0038] A dynamic deployment scheduling method based on ERP and MES data caching technology, including the following steps:

[0039] (a) Build the database of the ERP system, establish the database and its application system, so that it can effectively store data, and meet the user's information requirements and processing requirements, and use the structured analysis method to decompose from top to bottom and layer by layer Analyze the system, use the data flow diagram data dictionary to describe the system, divide it into data storage, data source and data output to classify the data flow in detail;

[0040] (b) The data flow diagram divides the data in the database into tables and partitions the base tables in the database. The data on a base table can be stored in multiple data files according to time. In the design of the database, the database can be Create partitions by quarter, keep three quarter partitions in the database, and set the current quarter, the previous quarte...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to the technical field of ERP (Enterprise Resource Planning) systems, in particular to a dynamic deployment scheduling method based on an ERP and MES (Manufacturing Execution System) data caching technology, which comprises the following steps of: firstly, constructing a database of the ERP system, and establishing the database and an application system thereof, so that the database and the application system can effectively store data and meet information requirements and processing requirements of a user; the data flow diagram performs table division on data in a database, after a base table in the database is partitioned, the data on one base table can be stored in a plurality of data files according to time, development of a control program is performed in the database, and a database program is portable by adopting an SQL language. Information in a database is sorted and classified to form an ERP strategic cost decision-making system, and operation cost control and management, an operation management center, data acquisition and processing, cost control, standard setting, real-time information and an operation execution unit system function module are carried out in the strategic cost decision-making system to achieve the effect of improving the working efficiency of a production line.

Description

technical field [0001] This application relates to the technical field of ERP systems, in particular to a dynamic deployment scheduling method based on ERP and MES data caching technology. Background technique [0002] Our country is in an unprecedented period of change. Although the formation of the globalized market has brought good development opportunities for Chinese enterprises, it also makes them bear the pressure of huge international market competition. At present, enterprises in developed countries have begun to adopt the most advanced information technology in the world, improve their product innovation capabilities and high-tech content, and realize "digital manufacturing" and "digital factories", that is, to realize the informatization of enterprises, to maximize Maximize the efficiency of the enterprise and maximize the profit of the enterprise. The current international popular enterprise informatization is an opportunity for Chinese enterprises to regain the...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F9/48G06F8/60
CPCG06F9/4881G06F8/60
Inventor 田金华
Owner 深圳市固美特科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products