集成电路生产线EAP监控系统大数据量查询性能优化方法

Performance Optimization Methods of Querying Large Amount of Data by IC Production Line Monitoring System EAP

在集成电路生产线中,由于设备数量大,生产过程中产生了大量的历史数据。设备自动化程序(EAP)在对生产线生产情况进行监控时,需要从数据库中查询历史数据,由于数据量大,查询性能较低。查询性能直接影响着集成电路生产线EAP监控系统的整体性能以及用户的使用感受。所以提高查询性能,就成为了重中之重。描述了集成电路生产线EAP监控系统进行大数据量查询时,查询性能的优化方法。

In the IC production line,since a large number of devices,the production process produces a large amount of historical data.When Equipment Automation Program （EAP） monitoring production line situation,it needs querying historical data from the database,as the amount of data,query performance is low.Query performance directly affects the overall performance of EAP IC production lines as well as the using experience.Therefore,to improve query performance,has become a top priority.This paper describes the query performance optimization methods when EAP IC production line monitoring system querying large amounts of data.