Apparatus and method for maintaining multi-referenced stored data

• US 10,311,399 B2
• Filed: 11/04/2016
• Issued: 06/04/2019
• Est. Priority Date: 02/12/2016
• Status: Active Grant

• Current Assignee: Computational Systems Incorporated (Emerson Electric Company)
• Original Assignee: Computational Systems Incorporated (Emerson Electric Company)
• Inventors: Hilemon, Christopher G., Hayzen, Anthony J., Sells, William L., Williams, Viva C., Bass, David A.
• Primary Examiner(s): Hayles, Ashford S
• Application Number:
  US15/343,799
• Publication Number:
  US 20170236089A1
• Time in Patent Office: 942 Days
• Field of Search: 705 28
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders

Abstract

A system collects and manages sets of asset data that are indicative of operational performance of physical assets disposed at multiple physical locations in a plant. The system includes a database that associates each set of asset data to (1) a location at which the data was collected, (2) the asset for which the data was collected, and (3) the monitoring device that was used to collect the data. In this way, each location has its own history of all asset data ever collected on all assets disposed at that location, and its own history of all monitoring devices used to collect data at that location. Also, each asset has its own history of all asset data collected on that asset at all locations at which it was disposed and for all monitoring devices. This sort of asset data is referred to herein as multi-referenced data.

Claims

1. An asset data collection and management system comprising:

a plurality of physical assets disposed at a plurality of physical locations in a plant, each physical asset assigned a unique asset identifier;

a plurality of monitoring devices for collecting sets of asset data that are indicative of operational performance of the plurality of physical assets;

a communication network to which the plurality of monitoring devices are connected;

an asset data management computer in communication with the plurality of monitoring devices via the communication network, the asset data management computer for receiving the sets of asset data and for executing instructions that;

generate a plurality of location placeholders that are each associated with a unique one of the plurality of physical locations in the plant;

associate the unique asset identifiers with corresponding location placeholders, wherein association of a unique asset identifier to a location placeholder indicates that a physical asset to which the unique asset identifier is assigned is disposed at the physical location associated with the location placeholder; and

store each of the sets of asset data in association with at least one unique asset identifier and at least one location placeholder, wherein the unique asset identifier identifies the physical asset for which a set of asset data was collected, and wherein the location placeholder is uniquely associated with a physical location at which the set of asset data was collected; and

a database in which the sets of asset data are stored,

from which all sets of asset data collected at a particular physical location may be accessed, for all physical assets disposed at that particular physical location, and

from which all sets of asset data collected for a particular physical asset may be accessed, for all physical locations at which the particular physical asset was disposed.

2. The asset data collection and management system of claim 1 wherein:

each monitoring device is assigned a unique monitoring device identifier;

the asset data management computer executes instructions that bind the unique monitoring device identifiers to corresponding location placeholders, wherein the binding of a unique monitoring device identifier to a location placeholder creates an association between the location placeholder and the unique monitoring device identifier; and

all sets of asset data collected using a particular monitoring device may be accessed from the database, for all physical assets for which the particular monitoring device collected asset data, and at all physical locations at which the particular monitoring device collected asset data.

3. The asset data collection and management system of claim 1 wherein the plurality of monitoring devices comprise permanently installed monitoring devices or portable handheld monitoring devices or a combination of permanently installed monitoring devices and portable handheld monitoring devices.

4. The asset data collection and management system of claim 1 wherein the plurality of physical assets comprise machines and monitoring devices.

5. The asset data collection and management system of claim 4 further comprising sensors attached to the machines, wherein the monitoring devices collect the sets of asset data based on signals generated by the sensors.

6. The asset data collection and management system of claim 2 wherein the asset data management computer executes instructions that generate graphical representations of an asset inventory hierarchy, a location hierarchy and a network hierarchy on a display device, wherein

the asset inventory hierarchy comprises a hierarchal display of graphical representations of the physical assets,

the location hierarchy comprises a hierarchal display of the physical locations in the plant in which physical assets are located, including graphical representations of the location placeholders associated with the physical locations, and

the network hierarchy comprises a hierarchal display of graphical representations of the monitoring devices connected to the communication network,

wherein each graphical representation comprises one or more graphical elements, or one or more textual elements, or a combination of one or more graphical elements and one or more textual elements.

7. The asset data collection and management system of claim 6 wherein the asset data management computer executes instructions that associate the unique asset identifier of a particular physical asset with a particular location placeholder based on dragging and dropping the graphical representation of the particular physical asset in the asset inventory hierarchy onto the graphical representation of the particular location placeholder in the location hierarchy.

8. The asset data collection and management system of claim 6 wherein the asset data management computer executes instructions that bind the unique monitoring device identifier of a particular monitoring device with a particular location placeholder based on dragging and dropping the graphical representation of the particular monitoring device in the network hierarchy onto the graphical representation of the particular location placeholder in the location hierarchy.

9. A method for collecting and managing asset data comprising:

(a) assigning a unique asset identifier to each of a plurality of physical assets disposed at a plurality of physical locations in a plant;

(b) connecting a plurality of monitoring devices to a communication network, the monitoring devices for collecting sets of asset data indicative of operational performance of the plurality of physical assets;

(c) generating a plurality of location placeholders, wherein each location placeholder is associated with a unique one of the plurality of physical locations in the plant;

(d) associating the unique asset identifiers with corresponding location placeholders, wherein association of a unique asset identifier to a location placeholder indicates that a physical asset to which the unique asset identifier is assigned is disposed at the physical location associated with the location placeholder;

(e) storing each of the sets of asset data in association with at least one of the unique asset identifiers and at least one of the location placeholders, wherein the unique asset identifier identifies the physical asset for which a set of asset data was collected, and wherein the location placeholder is uniquely associated with a physical location at which the set of asset data was collected;

(f) providing access to all sets of asset data collected at a particular physical location, for all physical assets disposed at that particular physical location; and

(g) providing access to all sets of asset data collected for a particular physical asset, for all physical locations at which the particular physical asset was disposed.

10. The method of claim 9 further comprising:

(h) assigning a unique monitoring device identifier to each of the plurality of monitoring devices;

(i) binding the unique monitoring device identifiers to corresponding location placeholders, wherein the binding of a unique monitoring device identifier to a location placeholder creates an association between the location placeholder and the unique monitoring device identifier;

(j) storing each of the sets of asset data in association with at least one of the unique monitoring device identifiers that uniquely identifies a monitoring device that collected the set of asset data;

step (f) further comprising providing access to all sets of asset data collected at a particular physical location, for all physical assets disposed at that particular physical location, and collected by all monitoring devices used at that particular physical location;

step (g) further comprising providing access to all sets of asset data collected for a particular physical asset, for all physical locations at which the particular physical asset was disposed, and for all monitoring devices that collected data for the particular physical asset; and

(k) providing access to all sets of asset data collected using a particular monitoring device, for all physical assets for which the particular monitoring device collected asset data, and at all physical locations at which the particular monitoring device collected asset data.

11. The method of claim 9 further comprising:

(h) generating a graphical representation of an asset inventory hierarchy comprising a hierarchal display of graphical representations of the physical assets; and

(i) generating a graphical representation of a location hierarchy comprising a hierarchal display of the physical locations in the plant in which physical assets are located, including graphical representations of the location placeholders associated with the physical locations,

wherein each graphical representation comprises one or more graphical elements, or one or more textual elements, or a combination of one or more graphical elements and one or more textual elements.

12. The method of claim 11 wherein the step (d) of associating the unique asset identifier of a particular physical asset with a particular location placeholder is based on dragging and dropping the graphical representation of the particular physical asset in the asset inventory hierarchy onto the graphical representation of the particular location placeholder in the location hierarchy.

13. The method of claim 10 further comprising:

(l) generating a graphical representation of a location hierarchy comprising a hierarchal display of the physical locations in the plant in which physical assets are located, including graphical representations of the location placeholders associated with the physical locations; and

(m) generating a graphical representation of a network hierarchy comprising a hierarchal display of graphical representations of the monitoring devices connected to the communication network,

wherein each graphical representation comprises one or more graphical elements, or one or more textual elements, or a combination of one or more graphical elements and one or more textual elements.

14. The method of claim 13 wherein the step (i) of binding the unique monitoring device identifier of a particular monitoring device with a particular location placeholder is based on dragging and dropping the graphical representation of the particular monitoring device in the network hierarchy onto the graphical representation of the particular location placeholder in the location hierarchy.

15. A system for collecting and managing sets of asset data that are indicative of operational performance of a plurality of physical assets disposed at a plurality of physical locations in a plant, wherein a unique asset identifier is assigned to each of the plurality of physical assets, wherein the sets of asset data are collected by a plurality of monitoring devices that are each assigned a unique monitoring device identifier, the system comprising:

an asset data management computer in communication with the plurality of monitoring devices via a communication network, the asset data management computer for receiving the sets of asset data and for executing instructions that;

generate a plurality of location placeholders, wherein each location placeholder is associated with a unique one of the plurality of physical locations in the plant;

associate the unique asset identifiers with corresponding location placeholders, wherein association of a unique asset identifier to a location placeholder indicates that a physical asset to which the unique asset identifier is assigned is disposed at the physical location associated with the location placeholder;

bind the unique monitoring device identifiers to corresponding location placeholders, wherein the binding of a unique monitoring device identifier to a location placeholder creates an association between the location placeholder and the unique monitoring device identifier; and

store each of the sets of asset data in association with at least one unique asset identifier, at least one location placeholder, and at least one unique monitoring device identifier, wherein the unique asset identifier identifies the physical asset for which a set of asset data was collected, wherein the location placeholder is uniquely associated with a physical location at which the set of asset data was collected, and the unique monitoring device identifier uniquely identifies a monitoring device that collected the set of asset data; and

a database in which the sets of asset data are stored,

from which all sets of asset data collected at a particular physical location may be accessed, for all physical assets disposed at that particular physical location, and collected by all monitoring devices used at that particular physical location,

from which all sets of asset data collected for a particular physical asset may be accessed, for all physical locations at which the particular physical asset was disposed, and for all monitoring devices that collected data for the particular physical asset, and

from which all sets of asset data collected using a particular monitoring device may be accessed, for all physical assets for which the particular monitoring device collected asset data, and at all physical locations at which the particular monitoring device collected asset data.

16. The system of claim 15 wherein the asset data management computer executes instructions that generate graphical representations of an asset inventory hierarchy, a location hierarchy and a network hierarchy on a display device, wherein

the asset inventory hierarchy comprises a hierarchal display of graphical representations of the physical assets,

the location hierarchy comprises a hierarchal display of the physical locations in the plant in which physical assets are located, including graphical representations of the location placeholders associated with the physical locations, and

the network hierarchy comprises a hierarchal display of graphical representations of the monitoring devices connected to the communication network,

wherein each graphical representation comprises one or more graphical elements, or one or more textual elements, or a combination of one or more graphical elements and one or more textual elements.

17. The system of claim 15 wherein the asset data management computer executes instructions that associate the unique asset identifier of a particular physical asset with a particular location placeholder based on dragging and dropping the graphical representation of the particular physical asset in the asset inventory hierarchy onto the graphical representation of the particular location placeholder in the location hierarchy.

18. The system of claim 15 wherein the asset data management computer executes instructions that bind the unique monitoring device identifier of a particular monitoring device with a particular location placeholder based on dragging and dropping the graphical representation of the particular monitoring device in the network hierarchy onto the graphical representation of the particular location placeholder in the location hierarchy.