System and method for supply chain data mining and analysis

• US 8,370,181 B2
• Filed: 10/14/2009
• Issued: 02/05/2013
• Est. Priority Date: 10/14/2008
• Status: Active Grant

• Current Assignee: Siemens Industry Software Inc. (Siemens AG)
• Original Assignee: Camstar Systems, Inc. (Siemens AG)
• Inventors: Shah-Hosseini, Amin
• Primary Examiner(s): Nguyen, Nga B.
• Application Number:
  US12/579,106
• Publication Number:
  US 20100095158A1
• Time in Patent Office: 1,210 Days
• Field of Search: 705/7, 705/8, 705/9, 705/10
• US Class Current: 705/7
• CPC Class Codes: G06F 16/2465 Query processing support for facilitating data mining operations in structured databases
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Abstract

A method and system for supply chain data analysis. The method includes storing supply chain data including test data, genealogy data, repair data, some factors and some items, in one or more databases and selecting a portion of the factors from the stored data, and a time range for analysis. The method then selects one or more criterion for analysis; extracts a portion of the stored data; analyzes the extracted portion of the stored data to detect a combination of factors that result in a test failure, according to the selected factors, the time range, and the selected one or more criterion. The method then detects a root cause for the detected combination of factors; performs correlation analysis between the selected factors; and performs trend analysis on the selected factors.

Claims

1. A computer implemented method for supply chain data analysis, the method comprising:

storing supply chain data including test data, genealogy data including a component'"'"'s parent and its supplier and a component'"'"'s child and its supplier, repair data, a plurality of factors and a plurality of items, in one or more databases;

aggregating the stored supply chain data in a plurality of combinations including one or more items and one or more factors, by one or more computers;

selecting a portion of the plurality of factors from the stored data, and a time range for analysis;

selecting one or more criteria for analysis;

extracting a portion of the plurality of combinations according to selected one or more criteria, by the one or more computers;

analyzing said extracted portion of the plurality of combinations, by the one or more computers to detect a combination of factors and items that results in a test failure, according to said selected factors, said time range, and said extracted portion of the plurality of combinations;

detecting a root cause for said detected combination of factors and items, by the one or more computers;

performing correlation analysis between said extracted combinations, by the one or more computers;

performing trend analysis on said extracted combinations; and

making recommendation for promising combinations and range of test parameters to maximize a yield for the selected factors, by the one or more computers.

2. The method of claim 1, further comprising performing an entropy-based function that shows the variations between items for each selected factor.

3. The method of claim 1, further comprising allocating resources including one or more of stations, fixtures, and operators to maximize resource utilization.

4. The method of claim 1, wherein the factors include one or more of the group consisting of product, product category, product version, test, subtest, measurement, station, station type, operator, assembly line, site, building, software version, hardware version, component, join, board version, fail category, error message, component parent, component supplier, component child, fail code, defect code, repair type, component, location of a component on a product, part number, lot name, lot size, customer, site, product, call reason, operator, defect code, severity, and failed component.

5. The method of claim 1, wherein said detecting a root cause comprises braking down a test measurement based on related factors and items.

6. The method of claim 1, further comprising performing genealogy analysis by breaking down a product to its components in a parent-child structure.

7. The method of claim 1, further comprising creating production plans based on a required number of units to be tested in a period of time, test time, and failure rate.

8. The method of claim 1, further comprising extracting test data, return and maintenance data, and supplier data, from the stored data.

9. The method of claim 1, further comprising extracting data insights from the stored data collected from test, return and repair, and supply chain processes.

10. The method of claim 1, further comprising performing what-if analysis on the selected factors according to said detected combination of factors.

11. The method of claim 1, further comprising electronically allocating resources including one or more of stations, fixtures, and operators according to one or more desired functions selected by the user including one or more of minimize cost, minimize scrap, and minimize time-in-process, and outputting best one or more combinations that meet the selected desired functions.

12. The method of claim 1, wherein said extracting a portion of the plurality of combinations according to selected one or more criteria comprises retrieving factor properties from the stored data, integrating the retrieved factor properties to find different combinations of factors, retrieving subtest data to be matched with the different combinations, retrieving measurement data to be matched with the combinations, and determining genealogy, test structure, value structure and test limits.

13. The method of claim 1, further comprising accepting a threshold quantity and a threshold percentage for a group of data points that share same values for one or more of said selected factors, and displaying a bubble chart graph depicting a plurality of indicators with increasing sizes to illustrate more data in said group of data points.

14. A system for supply chain data analysis comprising:

one or more databases for storing supply chain data including test data, genealogy data including a component'"'"'s parent and its supplier and a component'"'"'s child and its supplier, a plurality of factors and a plurality of items;

an input device for selecting a portion of the plurality of factors from the stored data, and a time range for analysis, and selecting one or more criteria for analysis;

an extract &

calculate module electrically coupled to the one or more databases for aggregating the stored supply chain data in a plurality of combinations including one or more items and one or more factors, and extracting a portion of the plurality of combinations according to selected one or more criteria; and

a multi-dimensional failure analysis module for analyzing said extracted portion of the plurality of combinations to detect a combination of factors and items that result in a test failure, according to said selected factors, said time range and said selected one or more criteria, detecting a root cause for said detected combination of factors and items, performing correlation analysis between said extracted combinations, performing trend analysis on said extracted combinations and making recommendation for promising combinations and range of test parameters to maximize a yield for the selected factors.

15. The system of claim 14, wherein the multi-dimensional failure analysis module is configured to perform an entropy-based function that shows the variations between items for each selected factor.

16. The system of claim 14, further comprising a test configuration analysis module for finding promising configurations and range of test parameters to maximize a yield.

17. The system of claim 14, wherein the multi-dimensional failure analysis module is configured to perform genealogy analysis by breaking down a product to its components in a parent-child structure.

18. The system of claim 16, wherein the test configuration analysis module is configured to create production plans based on a required number of units to be tested in a period of time, test time, and failure rate.

19. The system of claim 14, wherein the extract &

calculate module is configured to extract data insights from the stored data collected from test, return and repair, and supply chain processes.

20. The system of claim 14, further comprising a production planning module for allocating resources including one or more of stations, fixtures, and operators according to one or more desired functions selected by the user including one or more of minimize cost, minimize scrap, and minimize time-in-process, and outputting best one or more combinations that meet the selected desired functions.

21. The system of claim 14, wherein the extract &

calculate module is further configured to retrieve factor properties from the stored data, integrate the retrieved factor properties to find different combinations of factors, retrieve subtest data to be matched with the different combinations, retrieve measurement data to be matched with the combinations, and determine genealogy, test structure, value structure and test limits.

22. The system of claim 14, wherein the input device is configured to accept a threshold quantity and a threshold percentage for a group of data points that share same values for one or more of said selected factors, the system further comprising a display for displaying a bubble chart graph depicting a plurality of indicators with increasing sizes to illustrate more data in said group of data points.