Database server system with methods for alerting clients of occurrence of database server events of interest to the clients

• US 5,592,664 A
• Filed: 09/07/1994
• Issued: 01/07/1997
• Est. Priority Date: 07/29/1991
• Status: Expired due to Term

• Current Assignee: CodeGear (Idera, Inc.)
• Original Assignee: Borland International, Inc. (Open Text Corporation)
• Inventors: Starkey, James A.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Wang, Peter Y.
• Application Number:
  US08/276,739
• Time in Patent Office: 853 Days
• Field of Search: 395/600, 395/425, 395/650, 395/200
• US Class Current: 1/1
• CPC Class Codes: G06F 16/10 File systems; File servers
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

An event alerter system for notifying one application or process of a change in a database. A database management system includes an event generator that defines events to be reported, such as a change in a particular field of the database. Each time an change occurs, the event generator notifies an event manager of the name of the event. Whenever an event dependent process indicates an interest in a change in a field in a particular record or records in a database, it transfers a command to the event manager identifying each such record and change. When the event dependent process issues such a command, it enters a wait state to process the occurrence of an event in either a synchronous or asynchronous mode. The event manager converts such a command into entries in an event table that identifies, for that and other event dependent processes, the list of events in which a process has an interest. Thereafter, each time the event generator signals a change, the event manager examines the event table to determine which, if any, event dependent processes have an interest in that particular change and only three event dependent processes that have requests for being notified of the change pending. Then the event dependent process can obtain a message containing the status of each event in which it has an interest.

Claims

1. A multi-user computer system comprising:

a database server providing access to a database of information including at least one database field, said database server including a database manager for controlling said access to said database;

a first computer operating a process which requests modification of information stored in the database;

at least one second computer operating a process which is dependent on occurrence of a selected modification of information stored in the database such that a selected database field in the database attains a preselected value;

means for requesting that said database server notify said at least one said second computer upon occurrence of said selected modification of information; and

event alerting means, residing on the database server and operably coupled to the database manager, said event alerting means detecting modification of information stored in the database and notifying said at least one second computer upon occurrence of said selected modification of information.

2. The system of claim 1, wherein said first and second computer are coupled to said database server through a communication network.

3. The system of claim 1, wherein said database stores information as values in database fields, and wherein said modification of information includes changing a value of at least one database field.

4. The system of claim 3, wherein the process of said at least one second computer is dependent on a selected one of the database fields attaining a preselected value.

5. The system of claim 1, wherein said first computer includes means for posting a command to said database manager for modifying information stored in the database.

6. The system of claim 1, wherein said at least one second computer includes means for posting a command to said database manager for requesting notification of occurrence of said selected modification of information.

7. The system of claim 1, wherein said means for requesting includes means for requesting asynchronous notification of said selected modification of information whereby said at least one second computer operates other processes while awaiting said notification.

8. The system of claim 1, wherein said means for requesting includes means for requesting synchronous notification of said selected modification of information, whereby said at least one second computer suspends execution of said process which is dependent on occurrence of said selected modification of information while awaiting said notification.

9. In a multi-user computer system, the system including a relational database having data fields storing values which change in response to clients in communication with a database server, a method for notifying at least one client of a change occurring in the database, the method comprising:

(a) defining preselected changes to the database to comprise a set of events which are of interest to the clients, said events including an event of a data value stored in a selected threshold;

(b) registering with said database server a request from at least one of said clients to be notified upon occurrence of a selected one of the events;

(c) receiving at said database server a request to change a data value stored in one of the data fields;

(d) determining by said database server if the request to change a data value specifies a change that is one of said preselected changes defining an event of interest; and

(e) if the request to change a data value specifies a change that is one of said preselected changes defining an event of interest, notifying all clients registered with said database server of occurrence of the event of interest.

10. The system of claim 9, wherein said events further include an event of changing a value stored in a selected data field to a preselected value.

11. The system of claim 9, wherein said events include an event of changing a value stored in a selected data field to a value which greater than or equal to a preselected threshold.

12. The system of claim 9, wherein said events include an event of changing a value stored in a selected data field to a value which less than or equal to a preselected threshold.

13. The system of claim 9, wherein step (a) includes defining a procedure (trigger) for each of the preselected changes to the database, each trigger for posting an event signal upon occurrence of its preselected change.

14. The system of claim 9 wherein after step (c) further comprises:

suspending operation of at least one of said clients while awaiting synchronous notification of said selected event.

15. The system of claim 9, further comprising:

(f) upon receipt of notification, retrieving information describing said event of interest.

16. The system of claim 15, wherein said information describing said event of interest includes the value for a database field whose change constitutes the event.

17. The system of claim 9, wherein after step (c) further comprises:

switching operation of at least one of said clients to another task while awaiting asynchronous notification of said selected event.

24. The method of claim 16, wherein said set of events further includes an event which is defined to occur when a selected one of the data fields reaches a threshold value.

18. In a multi-user relational database management system, the system including a database server providing access to a database, the database server in communication with a plurality of clients, a method for notifying clients of particular events occurring in the database including information stored in data fields, the method comprising:

(a) defining a set of events indicating changes to the database which are of interest to at least one client, each of said at least one client requiring notification of occurrence of one of the events, and said set including an event which is defined to occur when a selected one of the data fields changes in value a preselected number of times;

(b) posting a transaction to the database server, said transaction specifying at least one of the events said at least one client requires notification of occurrence;

(c) upon occurrence of one of said events, determining by the database server which clients require notification of occurrence of said one of said events, said one of said events indicating a committed change in data in said database; and

(d) sending a notification from said database server to each said at least one client which requires notification of said one of said events which has occurred.

19. The method of claim 18, wherein after step (b) further comprises:

initiating by at least one client a transaction which requires occurrence of a selected one of the events before the transaction can be committed; and

committing the transaction upon notification that the selected event has occurred.

20. The method of claim 19, wherein said at least one client initiating the transaction enters a wait state while awaiting notification that the selected event has occurred.

21. The method of claim 19, wherein said at least one client initiating the transaction continues to process other transactions while awaiting notification that the selected event has occurred.

22. The method of claim 18, wherein step (d) includes:

transmitting an event message to each said at least one client requiring notification, said message including information describing a particular one of said events which has occurred.

23. The method of claim 22, wherein said database includes information stored in data fields, and wherein said message includes information describing a change in value of one of the data fields.

25. The method of claim 18, wherein said database includes information stored in data fields, and wherein said set of events includes an event which is defined to occur when a selected one of the data fields changes in value a preselected number of times.