US5918191A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for managing data for an equipment calibration laboratory
Assignee: Certified Measurements Inc
•
Filing: 1997-03-11
•
Granted: 1999-06-29
•
Expires: 2017-03-11
Abstract
Abstract A system and method for managing data in calibration laboratory is disclosed. The system includes a database server, a database management system (DBMS) executing on the database server, and at least one client program coupled to the DBMS through a communication network. The client program queries the DBMS for data and sends data to the DBMS for storage on a database managed by the DBMS. The database managed by the DBMS includes at least an equipment tracking table and a work order table that may link a plurality of work orders in the work order table to a single equipment record in the equipment tracking table. This structure reduces the need for multiple identifications of a test instrument in the database. In a preferred implementation of the present invention, technical data records in a technical data table and administrative data records in an administrative data table are separately linked to a work order record in the work order table. In this way, the administrative data and technical data in the system are separately maintained. In another aspect of the preferred implementation, a standards used table contains standards used records which are linked to a work order record in the work order table to identify the calibration standards used for a calibration job on a test instrument. This structure facilitates measurement traceability for a test instrument. In a most preferred aspect of the system, an automated calibration procedure (ACP) program is implemented to use operating system interface commands for transferring data collected during a calibration procedure to the client program. The client program them sends the collected data to the DBMS for storage in the database. In the most preferred implementation, the ACP and client program use a Dynamic Data Exchange (DDE) of the Windows operating system to transfer collected data from the ACP to the client program.
Inventors
- 👤 Tracy L. Patel
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-24 01:35
CPC Classifications
G; G06; G06Q; G06Q10/00; G06Q10/06
Claims Analysis
Total Claims: 29
Claim 1
Independent Claim
169 words
A system for managing calibration laboratory data comprising: a database server for managing a database comprised of an equipment tracking table containing equipment tracking records, each equipment tracking record having an unique equipment identifier for each test instrument serviced by a calibration laboratory and a work order table containing calibration work order records having at least a calibration work order identifier that uniquely identifies a calibration job performed by the calibration laboratory, a plurality of said calibration work order records being linked to one of said unique identifiers for one of said test instruments serviced by the calibration laboratory so that equipment identification data for a test instrument is only entered once in the system for all calibration jobs performed on the test instrument; and at least one client terminal for receiving data generated during calibration of a test instrument and communicating the received data with the database server so that the database server stores the received data within the equipment tracking records and the calibration work order records.
Claim 2
Independent Claim
169 words
A system for managing calibration laboratory data comprising: a database server for managing a database comprised of an equipment tracking table containing equipment tracking records, each equipment tracking record having an unique equipment identifier for each test instrument serviced by a calibration laboratory and a work order table containing calibration work order records having at least a calibration work order identifier that uniquely identifies a calibration job performed by the calibration laboratory, a plurality of said calibration work order records being linked to one of said unique identifiers for one of said test instruments serviced by the calibration laboratory so that equipment identification data for a test instrument is only entered once in the system for all calibration jobs performed on the test instrument; and at least one client terminal for receiving data generated during calibration of a test instrument and communicating the received data with the database server so that the database server stores the received data within the equipment tracking records and the calibration work order records.
Claim 3
Dependent Claim
159 words
The system of claim 1 wherein the client terminal receives technical data generated during calibration of a test instrument and administrative data for a customer corresponding to the test instrument; and the database server stores the technical data received from the client terminal in technical data records a technical data table; and the administrative data received from the client terminal is stored in administrative data records in an administrative data table; and said technical data table records and said administrative data table records for one of the calibration jobs performed by the calibration laboratory are linked to one of said equipment tracking records in said equipment tracking table by said calibration work order record having said calibration work order identifier that identifies one of said calibration jobs performed on said test instrument so that said administrative data records and said technical data records for each said calibration job performed by the calibration laboratory are maintained separately in the system.
Claim 4
Dependent Claim
75 words
The system of claim 2 wherein said database server stores unique test, measuring and diagnostic equipment (TMDE) identifiers for each type of test instrument and calibration standard stored in said system, the TMDE identifiers being stored m the TMDE records contained in a TMDE table so that technical data in said technical data tables for each test instrument and each calibration standard which corresponds to one of said TMDE identifiers may be retrieved and analyzed.
Claim 5
Dependent Claim
61 words
The system of claim 1 wherein the database server stores standards work order identifiers and calibration work order identifiers in standards used records contained in a standards used table so that laboratory standards used for a calibration job on a test instrument may be traced by using standards work order identifiers and calibration work order identifiers without reference to date information.
Claim 6
Dependent Claim
155 words
The system of claim 4 wherein said database server stores unique equipment identifiers for standards used by the calibration laboratory in the equipment tracking records in said equipment tracking table; said database server stores technical data for calibration jobs performed on said standards in the technical data records in said technical data table; said database server stores administrative data for a calibration laboratory in administrative data records in said administrative data table; and said database server links one of said calibration work order records in the work order table to one of said standards used records in said standards used table for each calibration work order identifier so that each laboratory standard used for a calibration job is linked to one of said calibration work orders stored in said work order table by its standards work order identifier whereby each laboratory standard may be traced to one of another laboratory standard and a "golden mean".
Claim 7
Dependent Claim
48 words
The system of claim 5 wherein said database server links one of said calibration work order records in said work order table to: a National Institute of Standards and Technology(NIST) standard record for identifying a NIST report corresponding to an equipment tracking records linked to said NIST record.
Claim 8
Dependent Claim
69 words
The system of claim 1 said client terminal further comprising: an automated calibration procedure (ACP) having a real-time interface for sending data collected during a calibration job to a technical data record corresponding to said calibration work order record having a work order identifier that links said work order record to one of said equipment tracking records corresponding to the test instrument from which said technical data was collected.
Claim 9
Dependent Claim
38 words
The system of claim 7 wherein said real-time interface of said client terminal forwards technical data received from said ACP to said database server for maintaining the database containing said equipment tracking table and said work order table.
Claim 10
Dependent Claim
27 words
The system of claim 8 wherein said client terminal includes a Dynamic Data Exchange (DDE) server in which technical data collected during a calibration job is stored.
Claim 11
Independent Claim
66 words
A method for managing calibration laboratory data comprising the steps of: linking an equipment tracking record having an unique equipment identifier for a test instrument serviced by a calibration laboratory to a plurality of calibration work order records, said calibration work order records having at least a calibration work order identifier that uniquely identifies each calibration job performed by the calibration laboratory for the test instrument.
Claim 12
Independent Claim
66 words
A method for managing calibration laboratory data comprising the steps of: linking an equipment tracking record having an unique equipment identifier for a test instrument serviced by a calibration laboratory to a plurality of calibration work order records, said calibration work order records having at least a calibration work order identifier that uniquely identifies each calibration job performed by the calibration laboratory for the test instrument.
Claim 13
Dependent Claim
69 words
The method of claim 10 further comprising the steps of: separately linking technical data records generated from one of the calibration jobs for the test instrument and administrative data records for a customer that send the test instrument to the calibration laboratory for the calibration jobs so that said administrative data records and said technical data records for each calibration job performed on the test instrument are separately maintained.
Claim 14
Dependent Claim
67 words
The method of claim 10 further comprising the steps of: linking a standards used record having standards work order identifiers and calibration work order identifiers to each calibration work order in said plurality of work orders so that calibration standards used for one of the calibration jobs on the test unit may be identified by one of said standards work order identifiers in said standards used record.
Claim 15
Dependent Claim
78 words
The method of claim 12 further comprising the steps of: generating equipment tracking records having unique equipment identifiers for calibration standards used by the calibration laboratory; and linking each said equipment tracking record for said calibration standards to at least one calibration work order record and a corresponding standards used record so that instrument standards used to calibrate one of said calibration standards identified by one of said equipment tracking records may be traced to a golden mean.
Claim 16
Dependent Claim
48 words
The method of claim 13 further comprising the steps of: linking a National Institute of Standards and Technology(NIST) standard records to said work order record for one of said equipment tracking records corresponding to one of said calibration standards to identify a NIST report for said calibration standard.
Claim 17
Dependent Claim
71 words
The method of claim 10 further comprising: linking a test, measuring and diagnostic equipment (TMDE) record having unique TMDE identifiers for each type of test unit and calibration standard stored by said method to a plurality of equipment tracking records so that technical data collected for calibration jobs performed on said test instruments corresponding to said equipment tracking records in said plurality may be retrieved and analyzed for predictive maintenance scheduling.
Claim 18
Dependent Claim
67 words
The system of claim 10 further comprising the steps of: sending technical data collected during a calibration job by an automated calibration procedure (ACP) in real-time to a technical record linked to said work order record having a work order identifier that links said work order record to one of said equipment tracking records corresponding to the test unit from which said ACP collected the technical data.
Claim 19
Dependent Claim
31 words
The method of claim 16, further comprising the steps of: forwarding the technical data received from said ACP to a database server which stores said technical records in a relational database.
Claim 20
Dependent Claim
39 words
The method of claim 16 wherein said sending step is comprised of the steps of: sending the technical data to a Dynamic Data Exchange (DDE) server; and forwarding the technical data from the DDE server to a database server.
Claim 21
Dependent Claim
134 words
An automated calibration procedure (ACP) for transferring data collected during a calibration procedure in real-time to a laboratory management system comprising: a client terminal having a real-time interface for transferring data between an operating system and an application program said transferred data including a server identifier, a data value, and a data location; a client program executing within said client terminal for communicating with a database management system (DBMS) of a database server for a laboratory management system, the client program being identified with said server identifier; and an ACP program executing operating system commands within said client terminal to place said server identifier, a collected data value, and a location for said collected data value in said real-time interface so that said client terminal may transfer said collected data to said client program.
Claim 22
Dependent Claim
134 words
An automated calibration procedure (ACP) for transferring data collected during a calibration procedure in real-time to a laboratory management system comprising: a client terminal having a real-time interface for transferring data between an operating system and an application program said transferred data including a server identifier, a data value, and a data location; a client program executing within said client terminal for communicating with a database management system (DBMS) of a database server for a laboratory management system, the client program being identified with said server identifier; and an ACP program executing operating system commands within said client terminal to place said server identifier, a collected data value, and a location for said collected data value in said real-time interface so that said client terminal may transfer said collected data to said client program.
Claim 23
Dependent Claim
48 words
The system of claim 19 further comprising: a calibration datasheet stored within said client terminal; and said client program executing in said client terminal stores said collected data transferred from said ACP in said calibration datasheet at a location corresponding to said location placed in said real-time interface.
Claim 24
Dependent Claim
32 words
The system of claim 20 wherein said client program executing within said client terminal is a Dynamic Data Exchange (DDE) server and said operating system commands in said ACP are DDE commands.
Claim 25
Independent Claim
94 words
A method for implementing an automated calibration procedure (ACP) for transferring data collected during a calibration procedure in real-time to a laboratory management system comprising the steps of: identifying a client program as a server with an operating system, the client program being for communicating with a database management system (DBMS) of a laboratory management system; and transferring data from an ACP to a real-time interface of the operating system with an identifier corresponding to said client program so that the operating system transfers said data from said real-time interface to said client program.
Claim 26
Independent Claim
94 words
A method for implementing an automated calibration procedure (ACP) for transferring data collected during a calibration procedure in real-time to a laboratory management system comprising the steps of: identifying a client program as a server with an operating system, the client program being for communicating with a database management system (DBMS) of a laboratory management system; and transferring data from an ACP to a real-time interface of the operating system with an identifier corresponding to said client program so that the operating system transfers said data from said real-time interface to said client program.
Claim 27
Dependent Claim
25 words
The method of claim 22, said transferring data step further comprising the steps of: identifying a location for said transferred data in said client program.
Claim 28
Dependent Claim
33 words
The method of claim 23 further comprising the steps of: sending a calibration datasheet from the DBMS to the client program; and said location identifying step identifies a location in the calibration datasheet.
Claim 29
Dependent Claim
50 words
The method of claim 24 further comprising the steps of: returning the calibration datasheet having data transferred from the ACP to the DBMS for storage. wherein said client program is a Dynamic Data Exchange (DDE) server for said ACP and said operating system commands in said ACP are DDE commands.
References Cited (Backward Citations)
US4404639A
Cited
US4967381A
Cited
US4841456A
Cited
US5021997A
Cited
US4878179A
Cited
US5245554A
Cited
US5265247A
Cited
US5333183A
Cited
US5551022A
Cited
US5392209A
Cited
US5625816A
Cited
US5657252A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-06-28 | 2002-12-28 | 2003-06-29 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-06-28 | 2006-12-28 | 2007-06-29 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-06-28 | 2010-12-28 | 2011-06-29 | $7700.00 | Window Closed / Lapsed |