MES Dispatcher Cache for Faster Semiconductor Production Planning
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The existing manufacturing execution systems (MES) in semiconductor plants face inefficiencies due to direct database command execution, which is slow and complicated, especially when generating production plans, requiring multiple round trips between the MES and the production database, leading to increased execution time.
Innovation Solution
A dispatcher system with an intermediate layer that caches the production database's current state, converts it into a key-indexed random access data structure, and provides an application programming interface for general-purpose programming languages, allowing for faster and more efficient generation of production plans by reducing direct database access.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If direct database command execution is used in existing MES systems, then data access is performed, but execution time increases and system efficiency decreases due to multiple round trips between MES and production database
Solution Approach 1:
The system performs preliminary actions by caching production database state information in a local cache database before it is needed for production plan generation. This advance preparation eliminates the need for multiple round trips to the production database during execution, significantly reducing execution time and improving productivity.
Solution Approach 2:
A cache database is introduced as an intermediary layer between the MES system and the production database. This intermediary stores frequently accessed state information locally, allowing the MES to retrieve data without directly querying the production database multiple times, thereby reducing communication overhead and execution time.
2Ease of operation
If multiple round trips between MES and production database are performed, then production plans can be generated, but the programming process becomes complicated and execution efficiency is reduced
Solution Approach 1:
The cache database serves as an intermediary that simplifies the programming process by providing a local, easily accessible data source. Programmers can retrieve production state information from the cache database without complex database connection management and transaction handling, reducing programming complexity.
Solution Approach 2:
The system creates a copy of the production database state information in the cache database. This copy can be accessed and processed locally without the complexity of direct database connections, simplifying the programming required for production plan generation while maintaining data accuracy.
Data Source
AI summary
A dispatcher system associated with a manufacture execution system (MES) of a plant, where the MES uses a production database storing a table containing state information of a plurality machines in the plant to manage operation of the plurality of machines, the dispatcher system including a cache device to store a random accessible data sheet mapped to the table; and a processing device to provide a user interface to receive a dispatch application constructed based on a plurality of dispatch rules, the dispatch application comprising a database command directed to access the state information stored in the production database, convert the database command into a key-based search instruction in a target programming language, execute the key-based search instruction using a key to access the random accessible data sheet to generate a production plan, and issue the production plan to the MES to manage the operation of the plurality of machines.