Automated Machine Station File Processing for Semiconductor Test Data
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current methods for processing machine station files in the semiconductor industry are inefficient due to manual exportation, which results in delayed and incomplete data acquisition, and require different EXCEL macros for various machines, failing to meet the demand for timely and accurate processing of chip test files.
Innovation Solution
A machine station file processing method utilizing an edge computing server to monitor and convert transaction data into model-layer data according to preset warehousing rules, then sending this data to a data warehouse server for further conversion into application-layer data, enabling real-time synchronization and visualization of test results.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If manual export and EXCEL macro processing is used, then flexibility in handling different machine formats is maintained, but processing speed and data acquisition timeliness deteriorate
Solution Approach 1:
The patent transforms the processing approach by changing the fundamental parameters of data handling: transitioning from manual file export to automated file system monitoring, from EXCEL macro processing to database-driven processing with preset warehousing rules. This parameter change enables both high-speed automated processing and adaptability through configurable rules that can handle different machine formats without manual intervention.
Solution Approach 2:
The patent introduces a data warehouse server as an intermediary between the machine station file system and the analysis tools. This intermediary automatically monitors file operations, converts transaction data according to preset warehousing rules, and manages data storage and retrieval. The intermediary eliminates the need for manual processing while maintaining format adaptability through rule-based conversion.
2Device complexity
If manual processing methods are used, then system complexity is reduced, but data acquisition completeness and timeliness worsen
Solution Approach 1:
The patent implements a self-service automated system where the data warehouse server independently monitors the file system for transaction files, automatically converts the data according to preset warehousing rules, and manages the complete data processing workflow without human intervention. This self-service capability eliminates time losses associated with manual processing while the modular architecture keeps system complexity manageable.
3Adaptability or versatility
If different EXCEL macros are used for various machines, then machine-specific requirements are met, but processing consistency and automation level worsen
Solution Approach 1:
The patent creates a universal data processing system through the data warehouse server that can handle multiple machine formats and requirements. The preset warehousing rules provide a unified framework that automatically adapts to different machine-specific needs through configurable conversion parameters, eliminating the requirement for separate EXCEL macros for each machine while maintaining full automation.
Data Source
Figure 1~3
Figure 4~5
Figure 6
AI summary
The present disclosure relates to a machine station file processing method and a machine station file processing system. The machine station file processing method comprises: monitoring operation of a file system of a machine station server and acquiring a transaction file generated by the operation, the transaction file comprising transaction data; converting a format of the transaction data according to preset warehousing rules to generate model-layer data; and sending, to a data warehouse server, the model-layer data and a data analysis request, the data analysis request is used to instruct the data warehouse server to acquire application-layer data according to the model-layer data.