System for generating unsolicited messages on high-tier communication link in response to changed states at station-level computers

• US 4,972,367 A
• Filed: 10/23/1987
• Issued: 11/20/1990
• Est. Priority Date: 10/23/1987
• Status: Expired due to Term

• Current Assignee: Allen-Bradley Company Milwaukee WI
• Original Assignee: Allen-Bradley Company (Rockwell Automation, Inc.)
• Inventors: Burke, Thomas J.
• Primary Examiner(s): Shaw, Gareth D.
• Assistant Examiner(s): KULIK, PAUL V
• Application Number:
  US07/112,958
• Time in Patent Office: 1,124 Days
• Field of Search: 364/140, 364/141, 364/130-134, 364/136, 364/138, 364/148, 364/200 MS, 364/900 MS
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: H04L 67/12 specially adapted for proprietary or special-purpose networking environments, e.g. medical networks, sensor networks, networks in vehicles or remote metering networks
• CPC Class Codes: H04L 69/329 in the application layer [OSI layer 7]
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

In a method for monitoring and collecting data in a multi-tier computer system, a database operation message, referred to as an "open" message is transmitted to a database cache computer with a list of data items in the database cache computer to be monitored on a change-of-state basis. The database cache computer responds by monitoring the data items and returning unsolicited "change data" messages containing only states for data items which have changed over the monitoring period. The change data messages are sent back periodically without the need for polling by a higher-level computer. The monitoring process is terminated by closing data records in the higher-level computer which generates a "close" message to the database computer to terminate the transmission of the change data messages. Also disclosed is a database cache computer and a user interface computer for carrying out the method.

Claims

1. A database cache computer for connection in a factory automation system for improving communication between a user interface computer and a plurality of station-level computers located at a corresponding plurality of stations, the database cache computer comprising:

database means for storing a database of data items collected from the plurality of station-level computers;

first communication means coupled to the database means for communicating the data items through a first communication link to and from the user interface computer via a message including data items from a plurality of station level computers;

second communication means coupled to the database means for collecting the data items through a second communication link from the station-level computers; and

wherein an improvement comprises;

means in the database cache computer responsive to a first message from the user interface computer to designate data items as being subject to change-of-state monitoring;

means in the database cache computer for detecting changes in states of the designated data items collected through the second communication link from the plurality of station-level computers; and

means in the database cache computer responsive to changes in the states of the designated data items collected through the second communication link from the plurality of station-level computers for assembling and transmitting an unsolicited message to the user interface computer, wherein the unsolicited message includes the changed states originating at a plurality of station-level computers for a plurality of the designated data items.

2. The database cache computer of claim 1, wherein the means responsive to changes in the states of the designated data items generates the unsolicited message to the user interface computer after a monitoring period defined by a time period or defined by the acquisition of a certain number of data items for which states have changed since a previous monitoring period, whichever occurs first.

3. The database cache computer of claim 1, further comprising means responsive to a second message from the user interface computer to delete certain data items in the database cache computer as being subject to change-of-state data monitoring.

4. The database cache computer of claim 1 in which each data item is identified in part by a field of alphanumeric tag data and in which the means for assembling and transmitting the unsolicited message includes means for retrieving the data items from the database means by hash decoding of the alphanumeric tag data.

5. The database cache computer of claim 1, wherein the first communication link is a first local area network.

6. The database cache computer of claim 1, wherein the second communication link is a second local area network.

7. A method for collecting and monitoring data in a multi-tier computer system while reducing message traffic, the method comprising:

opening a data record by executing an application program in a supervisory computer, wherein the data record includes data items to e monitored at one or more station-level computers that are remote from the supervisory computer;

in response to the opening of a data record in the supervisory computer, generating an "open" message from the supervisory computer to a database cache computer that stores a database of data items to be monitored at the one or more station-level computers that are remote form the supervisory computer, wherein the "open" message includes a list of data items to be monitored, and wherein the "open" message identified the data items as being subject to change-of-state monitoring in which only states that have changed for data items within the database within a monitoring period are transmitted back to the supervisory computer;

in response to receiving the "open" message at the database cache computer, monitoring those data items which have been identified in the "open" message as being subject to change-of-state monitoring by receiving update messages from the station-level computers and detecting those states which have changed from last states stored in the database; and

transmitting a change data message from the database cache computer to the supervisory computer, wherein the change data message includes only states of data items that have changed since the beginning of the monitoring period.

8. The method of claim 7, wherein in response to the "open" message, those data items which have been identified in the "open" message are monitored for a monitoring period, and wherein the monitoring period is defined as a certain period of time or is defined by the acquisition of a number of data items for which states have changed during the monitoring period, whichever occurs first.

9. The method of claim 7, wherein changed states include initial values, and further comprising the step of collecting initial values for those data items which have been identified in the "open" message and wherein the initial values are included in an initial change data message that is communicated from the database cache computer to the supervisory computer in response to the "open" message.

10. The method of claim 7, further comprising the step of generating a "close" message from the supervisory computer to the database cache computer to delete certain data items in the database cache computer as being subject to change-of-state monitoring.

11. The method of claim 7, wherein the supervisory computer includes a user interface for opening a data record and for viewing the states of data items that have changed since the beginning of the monitoring period.