Network appliance for data collection and processing from multiple locations and data schema therefor

• US 7,739,305 B1
• Filed: 07/28/2005
• Issued: 06/15/2010
• Est. Priority Date: 07/28/2005
• Status: Active Grant

• Current Assignee: Xilinx, Inc. (Advanced Micro Devices, Inc.)
• Original Assignee: Xilinx, Inc. (Advanced Micro Devices, Inc.)
• Inventors: Ling, Christopher Lanseng, Manicle, Noel John, Flynn, Andrew John, Simmons, Michael Leonard
• Primary Examiner(s): Wong; Don
• Assistant Examiner(s): Nguyen; Kim T
• Application Number:
  US11/192,344
• Time in Patent Office: 1,783 Days
• Field of Search: 707/101, 707/104.1
• US Class Current: 707/793
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Abstract

A network appliance, and a system and user interface therefor, are described. The network appliance includes a file capture module is to obtain files transmitted via a network and to load data from the files into a database. A user interface for communicating with the server includes a first set of fields and a second set of fields. The first set of fields are for selecting data from the database and the second set of fields are for selecting indices for charting the data selected with the first set of fields. A data processing module is configured to retrieve data from the database responsive to the data selected with the first set of fields, to chart the data retrieved responsive to the indices selected with the second set of fields, and to output a graph of the data charted to a server having access to the database.

Claims

1. A network appliance, comprising:

a database stored in a memory;

a file capture module configured to obtain manufacturing data files transmitted via a first network and to load data from the manufacturing data files into the database;

a data processing module configured to retrieve data from the database responsive to data selected with a first set of fields, to chart the data retrieved responsive to indices selected by a client system using a second set of fields, and to output a graph of the data charted to a web server, the web server sending the graph to the client system via a second network, and wherein the first set of fields comprises a first field and second field of the first set of fields;

wherein the data processing module is further configured to display respective sets of selectors corresponding each of the first and second fields, and in response to user selection of a selector in the respective selector set of the first field, the data processing module displays only selectors of the respective set of selectors of the second that are hierarchically related to the selected selector;

wherein the data is loaded into respective tables of the database, the tables being associated with the first set of fields;

wherein the data loaded is stored in the tables according to a wafer identifier for a wafer, a parameter, and a data set for rows of the tables; and

wherein the data set includes values associated with a parameter for the IC dies on a die-by-die basis for the wafer.

2. The network appliance according to claim 1, wherein the web server is internal to the network appliance.

3. The network appliance according to claim 1, wherein the first and second networks are part of one network.

4. The network appliance according to claim 1, wherein the graph is a graph object embeddable in a Hypertext Transport Protocol and wherein the data processing module includes a Preprocessing Hypertext script.

5. The network appliance according to claim 1, wherein the first set of fields includes a device family field and a device type field, the device family field and the device type field having a hierarchical dependency.

6. The network appliance according to claim 5, wherein the first set of fields includes a fabrication facility field, the fabrication facility field and the device family field having a hierarchical dependency.

7. The network appliance according to claim 6, wherein the second set of fields includes a time range field and report type field.

8. The network appliance according to claim 7, wherein the second set of fields includes an x-axis parameter field.

9. The network appliance according to claim 1, further comprising a scheduler to cause the file capture module to obtain the manufacturing data files on a schedule from manufacturing facilities coupled to the file capture module via the first network.

10. The network appliance according to claim 9, further comprising:

an alert controller for storing manufacturing control indicators and configured to generate email notices responsive to the data loaded into the database; and

an email server configured to send the email notices.

11. The network appliance according to claim 10, wherein the scheduler is configured to cause the alert controller to generate the email notices according to another schedule.

15. The network appliance according to claim 1, wherein the second set of fields includes an X-axis field and the X-axis field includes a plurality of X-axis selectors, each X-axis selector corresponding to a different X-axis for a chart, and the data processing module is further configured to display the X-axis selectors and in response to user selection of one of the X-axis selectors, generate the graph of the data charted with an X-axis corresponding to the selected one of the X-axis selectors.

12. A computer readable storage medium having computer-executable instructions for performing a method to analyze manufacturing data, the method comprising;

receiving manufacturing information related to fabrication of a plurality of semiconductor dies and storing the manufacturing information in a database;

displaying on a graphical user interface, as part of a Web based system, a plurality of choices under each of a plurality of fields;

in response to user selection of one of the choices under a first field of the plurality of fields, limiting user selectable choices under a second field of the plurality of fields to choices that are hierarchically related to the selected one of the choices under the first field;

responsive to selected one or more of the plurality of choices, generating a graph using the database indicating a trend for at least part of the manufacturing information;

displaying the graph on the graphical user interface;

loading data in a plurality of data formats into respective tables of the database, the tables being associated with the plurality of interdependent fields;

storing the data in the tables according to a wafer identifier for a wafer, a parameter, and a data set for rows of the tables,

wherein the data set includes values associated with a parameter for IC dies on a die-by-die basis for the wafer.

13. The storage medium of claim 12 wherein the plurality of interdependent fields is selected from a group consisting of a fabrication field, a family field, a device field, and a lot field.

14. The storage medium of claim 12, wherein the plurality of fields includes an X-axis field, and each choice under the X-axis field corresponds to a different X-axis for a chart, and the method further including, in response to user selection of one of choices under the X-axis field, generating the graph with an X-axis corresponding to the selected one of the X-axis choices.