Method, system, and computer for analytical reporting and archiving of data
OwnerAhmir Hussain, James E. Blaauboer +1inventors
InventorsAhmir Hussain, James E. Blaauboer, Stephen P. Hodgin
Life of this patent
Estimating the term…
Abstract
A method for archiving and analyzing manufacturing execution data using a server coupled to a database, wherein the data includes database tables, database views, and/or database scripts. The method includes selecting at least one data source having the data stored in a database, extracting at least a selected portion of the data from the data source into the database without further input; automatically formatting the extracted data according to a predefined format; and analyzing the formatted data according to a predefined report structure.
Claims20
A method for archiving and analyzing manufacturing execution data using a server coupled to a database, said method comprising:
- selecting at least one data source having the manufacturing execution data stored in the database, the manufacturing execution data including at least one of database tables, database views, and database scripts;
- extracting at least a selected portion of the manufacturing execution data from the at least one data source into the database without further input;
- automatically formatting the extracted manufacturing execution data according to a predefined format;
- and
- analyzing the formatted manufacturing execution data according to a predefined report structure.
A network-based system for archiving and analyzing manufacturing execution data stored on at least one manufacturing data source database, said system comprising:
- a client system;
- a database for storing information;
- and
- a server system coupled to said client system and said database, said server system configured to:
- receive a user selection of the at least one manufacturing execution data source database having the manufacturing execution data stored thereon, the manufacturing execution data including at least one of database tables, database views, and database scripts;
- extract at least a selected portion of the manufacturing execution data from the at least one manufacturing execution data source database without further input from the user;
- store the extracted manufacturing execution data in said database;
- automatically format the stored manufacturing execution data in a predefined format;
- and
- analyze the formatted manufacturing execution data according to a predefined report format.
A computer coupled to a database for archiving and analyzing manufacturing execution data stored in at least one manufacturing data source database, said computer in communication with a client system, said computer programmed to:
- receive a user selection of the at least one manufacturing execution data source database having the manufacturing execution data stored thereon including at least one of database tables, database views, and database scripts;
- extract at least a selected portion of the manufacturing execution data from the at least one manufacturing execution data source database without further input from the user;
- store the extracted data in the database;
- automatically format the stored manufacturing execution data in a predefined format;
- and
- analyze the formatted manufacturing execution data according to a predefined report format.
A computer in accordance with claim 17, wherein said computer is programmed to aggregate the manufacturing execution data such that manufacturing execution data related to a single product manufactured at multiple sites is cross-referenced to form a single set of manufacturing execution data.
Dependencies are inferred from the claim text.