Methods for creating control charts using a computer system

• US 7,315,851 B2
• Filed: 07/25/2003
• Issued: 01/01/2008
• Est. Priority Date: 07/25/2003
• Status: Active Grant

• Current Assignee: Macronix International Co., Ltd.
• Original Assignee: Macronix International Co., Ltd.
• Inventors: Chou, Sheng-Chi, Cheng, Lai Meng
• Primary Examiner(s): Ali; Mohammad
• Assistant Examiner(s): Ehichioya; Fred I
• Application Number:
  US10/626,999
• Publication Number:
  US 20050021534A1
• Time in Patent Office: 1,621 Days
• Field of Search: 707/103.R, 707 1- 10, 707100-1041, 707200-205, 438/5, 700/90
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A method is disclosed for creating a new control chart in a basic record system that includes a server and a database coupled to the server. The method includes the steps of storing a number of SPC control charts and a number of tables in the database and determining whether information stored in at least one of the tables has changed. If the information has changed, the method then determines whether the changed information can be described by at least one of the SPC control charts. If the changed information can be described, then the method updates at least one of the SPC control charts with the changed information. If the changed information cannot be described, then the method creates a new control chart that can describe the changed information.

Claims

1. A method for creating a new control chart using a computer, the method comprising:

providing a database including a plurality of statistical process control (SPC) control charts and a plurality of tables;

determining that information stored in at least one of the plurality of tables has changed;

determining whether the changed information is describable by at least one of the plurality of SPC control charts;

updating the at least one of the plurality of SPC control Charts with the changed information using the computer, upon a determination that the changed information is describable by at least one of the plurality of SPC control charts;

creating a new control chart that can describe the changed information, upon a determination that the changed information cannot be described by at least one of the plurality of SPC control charts;

determining whether the new control chart is a new trend chart, which is a control chart that has not been previously used on tools of a type that is associated with the new control chart;

calculating a plurality of control limit values, for the new control chart, when the new control chart is a new trend chart;

determining whether the control limit values of the new control chart are the same as control limit values of at least one of the plurality of SPC control charts, when the new control chart is not a new trend chart;

using on-line values for the control limit values of the new control chart, when the control limit values are the same;

sending a command to the server for determining whether to

create the new control chart, and what control limit values to set for the new control chart, when the control limit values are not the same; and

applying the SPC control charts for monitoring production in manufacturing.

2. The method as set forth in claim 1, wherein:

providing the database includes storing the plurality of SPC control charts and the plurality of tables in the database; and

the new control chart is created in a basic record system that includes a server coupled to the database.

3. The method as set forth in claim 2, wherein the SPC control charts include information relating to the detection of abnormal process trends from the statistical behavior.

4. The method as set forth in claim 3, wherein:

the plurality of tables are selected from a group consisting of a primary route table, a sub route table, a tool table, a recipe table, a specification table, a measure field table, and a measure item table; and

the method further comprises verifying the format of the plurality of SPC control charts and the plurality of tables.

5. The method as set forth in claim 3, wherein the determining that information stored in at least one of the plurality of tables has changed is preceded by a step of determining when information stored in at least one of the plurality of tables has changed and by another step of, when the information has not changed, repeating the step of determining when information stored in at least one of the plurality of tables has changed.

6. The method as set forth in claim 2, wherein the method further comprises calculating a plurality of control limit values for the new trend chart by using one or more predetermined functions to obtain optimized control limit values, when the new control chart is a new trend chart.

7. The method as set forth in claim 6, wherein the one or more predetermined functions are selected from a group consisting of mathematics expressions.

8. The method as set forth in claim 2, further comprising determining whether the control limit values for the new control chart are the same as the control limit values of at least one of the plurality of SPC control charts, when the new control chart is not a new trend chart.

9. The method as set forth in claim 8, wherein each of the plurality of SPC control charts includes a plurality of control limit values.

10. The method as set forth in claim 8, wherein the method further comprises using on-line values for the control limit values of the new control chart, when control limit values for the new control chart are the same as the control limit values of the at least one of the plurality of SPC control charts.

11. The method as set forth in claim 8, wherein the method further comprises sending a command to the server for determining whether to create the new control chart, and what control limit values to set, when the control limit values are not the same.

12. The method as set forth in claim 11, and further comprising adding the new control chart and the plurality of control limit values to a negative list when the new control chart is not created.

13. The method as set forth in claim 1, further comprising verifying the format of the plurality of SPC control charts and the plurality of tables.

14. The method as set forth in claim 1, wherein the new trend chart is defined as a control chart that has not been previously used on tools of a type that is associated with the new control chart.

15. The method as set forth in claim 1, wherein the calculating of a plurality of control limit values uses one or more predetermined functions to obtain optimized control limit values.

16. The method as set forth in claim 15, wherein the one or more predetermined functions are selected from a group consisting of mathematics expressions.

17. The method as set forth in claim 1, further comprising adding the new control chart and the calculated plurality of control limit values to a negative list when the new control chart is not created.

18. A statistical process control (SPC) control chart building method for use with a computer, the method comprising:

checking data stored in a database that stores a plurality of SPC control charts and tables to ascertain whether any of the data has changed;

checking at least one of the plurality of tables and determining whether the changed data is describable by any of the plurality of SPC control charts, when any of the data has changed;

building a new control chart using the computer when the SPC control charts cannot describe the changed data;

determining whether the new control chart is a new trend charts which is a control chart that has not been previously used on tools of a type that is associated with the new control chart;

calculating values of a plurality of control limits of the new control chart using a predetermined function, when the new control chart is a new trend chart;

using on-line values to fit into the control limits of the new control chart, when the new control chart is not a new trend chart and the control limits of the new control chart are the same as the ones in the existing SPC control charts; and

generating an alarm, when the new control chart is not a new trend chart and the control limits of the new control chart are not the same as the ones in the existing SPC control charts.

19. The method as set forth in claim 18, wherein the checking and determining are performed automatically.