Method of batching and analyzing of data from computerized process and control systems

• US 20060122812A1
• Filed: 12/04/2004
• Published: 06/08/2006
• Est. Priority Date: 12/04/2004
• Status: Active Grant

• Current Assignee: Lance David Tinseth
• Original Assignee: Lance David Tinseth
• Inventors: Tinseth, Lance David
• Granted Patent: US 7,398,187 B2
• Time in Patent Office: Days
• US Class Current: 702/188
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

The present invention is a solution for problems associated with batching, analyzing and viewing data from computerized and process control systems used in the manufacture of pharmaceutical products. Utilizing the hardware and software networking standards already implemented by a corporate IS/IT group as a platform, the present invention automatically captures (via 3^rd party software), processes, archives, reports on and distributes data for any computerized equipment at a facility. Data formats for all equipment regardless of manufacturer, plant location, or hardware/software platform used, are standardized. A single data repository is provide so that any authorized user connected to the company/facility network will have the ability to query this secure data and can generate any number of different reports. Once data is collected, it is batched or grouped according to user defined rules. A batch is given a distinct number, which will then be used to identify the data. Within seconds of batching, data is automatically analyzed using process macro code. This code can be simple or complex as needed to provide only the most important details about a batch. Such analyzation eliminates the manual processing of data, which is usually complex, time-consuming and prone to error. Via the Intranet or Internet, authorized users can view or trend data and access reports including adding electronic signatures. Additional process information such as standard operating procedures, and cycle descriptions may be uploaded and attached to a batch. Any action a user performs that creates, modifies or deletes data in the data repository will be audited.

Claims

1. A method of batching and analyzing data from computerized and process control systems comprising:

a web server;

web portal interface;

multi-user network;

application server;

process scheduler with means to control security and access to said application server;

data repository a company'"'"'s existing network and infrastructure;

automatically collecting, batching, archiving, analyzing data;

delivering data to a desktop computer;

storing data in a single repository;

performing a comprehensive analysis against specifications supplied by the user;

automatically disseminating results via email,

available process information can be supplemented with other information the user might desire;

a user can export information to other applications, print it out, or email it to interested parties;

analysis and graphing engines process data that can be charted and trended.

2. The method of batching and analyzing data from computerized and process control systems of claim 1 wherein data collection is based both on proprietary and industry standard.

3. The method of batching and analyzing data from computerized and process control systems of claim 1 wherein components to non-invasively connect to “

stand-alone”

based systems as well as standard industrial control systems.

4. The method of batching and analyzing data from computerized and process control systems of claim 1 further comprising a web interface enabling a web portal which allows any authorized user to view raw or summarized data, access reports, electronically sign reports, trend historical process data and associated meta data with specific batches.

5. The method of batching and analyzing data from computerized and process control systems of claim 1 wherein available process information can be supplemented with equipment pictures, standard operating procedures, cycle descriptions and other information the customer might desire.

6. The method of batching and analyzing data from computerized and process control systems of claim 1 further comprising a Process Scheduler that will:

continually search, collect, and catalog data for enabled processes;

supervise the triggering of data parsing and analysis for processes configured for full analyzation and reporting; and

enable user administration and audit trail functions.

7. The method of batching and analyzing data from computerized and process control systems of claim 1 further comprising a web portal, which provides access to specific functions of the system.

8. The method of batching and analyzing data from computerized and process control systems of claim 1 further comprising a universal analysis and reporting module enabling a user to create code to model process data in the data repository.

9. The method of batching and analyzing data from computerized and process control systems of claim 8 wherein a user has the ability to prepare a summary report detailing critical values from the results of the analysis and said report may be automatically e-mailed to appropriate personnel.

10. The method of batching and analyzing data from computerized and process control systems of claim 1 further comprising a Universal Parsing Module used to transform data from data files into the Data Repository.

11. The method of batching and analyzing data from computerized and process control systems of claim 1 further comprising a Web Portal Advanced Search Add-In enabling a user to perform an advanced search.

12. The method of batching and analyzing data from computerized and process control systems of claim 1 further comprising a passive system that builds and maintains its own data file.

13. The method of batching and analyzing data from computerized and process control systems of claim 1 further comprising an active system wherein data is captured directly.

14. The method of batching and analyzing data from computerized and process control systems comprising a passive system of claim 12 further comprising an archive system to process data files wherein user will have the ability to manually link an electronically captured printout from the system and associate it with a selected data file.

15. The method of batching and analyzing data from computerized and process control systems of claim 14 further comprising a Universal Parsing Module and Universal Analysis and Reporting module which enables;

additional functionality including but not limited to;

analysis, run status determination, reporting, report dissemination, electronic signatures, viewing/downloading of summary and detailed data statistical charting, and statistical trending of selected runs;

and the ability of a user to download all of the data directly to their desktop computer in various formats.

16. The method of batching and analyzing data from computerized and process control systems comprising an active system of claim 13 wherein a user may view and download detailed data and perform statistical charting.

17. The method of batching and analyzing data from computerized and process control systems of claim 16 further comprising a Universal Analysis and Reporting module which enables;

additional functionality including but not limited to;

analysis, run status determination, reporting, report dissemination, electronic signatures, viewing/downloading of summary and detailed data statistical charting, and statistical trending of selected runs; and

the ability of a user to download all of the data directly to their desktop computer in various formats.

18. The method of batching and analyzing data from computerized and process control systems of claim 1 further comprising an audit log wherein users can;

view audited events for any records in the system, change control status;

monitor a change control status;

enter comments about said change control status; and

view a detailed report of the audit log and comments entered therein.

19. The method of batching and analyzing data from computerized and process control systems of claim 1 further comprising a web portal accessible to remote users through a multi-user network wherein remote users are provided the tools to:

upload or download additional files that may be associated with a specific run;

view, save, print, and email raw and summarized production run data;

view and submit comments about production run;

create graphs and statistical charts based on data from individual runs or analytical parametera from multiple runs; and

view compliant electronic records and audit log records.