Plant maintenance control system

• US 4,383,298 A
• Filed: 04/10/1980
• Issued: 05/10/1983
• Est. Priority Date: 04/10/1980
• Status: Expired due to Term

• Current Assignee: Ciba-Geigy Corporation (Novartis Ag)
• Original Assignee: Ciba-Geigy Corporation (Novartis Ag)
• Inventors: O'Neill, John, Huff, Robert G.
• Primary Examiner(s): Boudreau, Leo H.
• Application Number:
  US06/139,041
• Time in Patent Office: 1,125 Days
• Field of Search: 364/300, 364/200 MS File, 364/900 MS File, 364/401, 364/403, 364/406, 364/464, 364/468, 364/496, 364/107
• US Class Current: 705/28
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G07C 3/00 Registering or indicating the condition or the working of machines or other apparatus, other than vehicles

Abstract

A plant maintenance control system designed to be effectuated through use of a computer; the basic aspect of the system relates to the unique results obtainable through particular operations performed by the computer based upon the unique organization and arrangement of the so-called data base complex, such that efficient and detailed control of maintenance expenses for a complicated chemical plant or the like can be readily established.

Claims

1. A plant maintenance control method by which control over maintenance expenses is established through a computer data base system, said method comprising:

providing a data base complex having at least four complete, non-redundant, individual data bases, each data base being composed of a plurality of data base records each of which is adapted to contain data in a hierarchical structure comprising a root segment and dependent or subordinate segments,

establishing logical pointer relationships between at least said first data base and each of said other three data bases;

routing data through said computer to and from said data base complex;

accessing data from said individual data bases by searching segments selectively in each of the data bases based on a preordained selection method and in accordance with said established logical pointer relationships.

2. A plant maintenance control system in which control over expenses is established through a computer data base system, said system comprising:

a computer;

a data base complex having at least four individual data bases, each containing data in a hierarchical structure, each of said hierarchical structures comprising a root segment and dependent or subordinate segments;

the first data base containing data with respect to maintenance requests for maintenance work to be performed on equipment in said plant;

the second data base containing data with respect to the project to which the maintenance work is assigned;

the third data base containing data with respect to the cost center responsible for particular maintenance requests;

the fourth data base, submod, containing data as to functional groupings of equipment;

a plurality of terminal devices for routing data through said computer to and from said data base complex;

means for establishing logical pointer relationships between at least said first data base and each of said other three data bases respectively;

means for accessing data from the individual data bases by searching said segments selectively in each of the data bases based on a preordained selection method in accordance with said established logical pointer relationships.

3. A system as defined in claim 2, further comprising means for establishing a logical pointer relationship between said cost center data base and said submod data base.

4. A system as defined in claim 3 in which two additional data bases are included:

a table data base and a foreman data base.

5. A system as defined in claim 4, further including an asset data base, and means for establishing logical pointer relationships between said asset data base and said maintenance request data base.

6. A system as defined in claim 5, further including a manufacturers table data base, and means for establishing a logical pointer relationship between said manufacturers table base and said asset data base.

7. A system as defined in claim 6, further including a maintenance inventory data base, and means for establishing a logical pointer relationship between said maintenance inventory data base and said manufacturers table data base.

8. A system as defined in claim 7, further including a sub-assembly data base, and means for establishing logical pointer relationships between said sub-assembly data base and said manufacturers table data base and maintenance inventory data base respectively.

9. A system as defined in claim 8, further including a buyer data base.

10. A system as defined in claim 9, further including a vendor data base, and means for establishing a logical pointer relationship between said vendor data base and said maintenance inventory data base.

11. A system as defined in claim 10, further including a commodity data base, and means for establishing logical pointer relationships between said commodity data base and said vendor data base, said maintenance inventory data base, and said buyer data base respectively.

12. A system as defined in claim 11, further including a purchase order data base, and means for establishing logical pointer relationships between said purchase order data base and said vendor data base, said buyer data base, said maintenance inventory data base, and said maintenance request data base.

13. A system as defined in claim 12, further including an audit data base.

14. A system as defined in claim 13, further including an inventory index data base, and means for establishing a logical pointer relationship between said inventory index data base and said maintenance inventory data base.

15. A system as defined in claim 2, in which said terminal devices accept data from input source documents containing data as to the maintenance request, cost center, project, service number and asset number.

16. A system as defined in claim 15, in which a source document provides data with respect to the maintenance request number and the like, and further provides data as to the work to be performed on a particular piece of equipment, the problem encountered with the equipment, and the part or parts involved.

17. A system as defined in claim 16, including means for recording the maintenance request data in detail with respect to labor, storeroom issues, outside materials, outside repair, outstanding commitments.

18. A system as defined in claim 2, in which each of said logical pointer relationships is established between a particular subordinate segment in one data base and the root segment of another data base.