Implementation of notification capabilities in relational databases
US6041327A · kind A · utility
Assignee
Inventors
Key dates
| Filing date | Dec 12, 1997 |
| Grant date | Mar 21, 2000 |
| Priority date | — |
| Expiry date | Dec 12, 2017 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99945
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A client sends a first message (such as a stored procedure function call) to a server relational database identifying notifications concerning database access related events of interest. Responsive to this first message, logic within the server relational database monitors instances of database accesses, determines whether any of those accesses relate to events of interest, and then stores those determined events. The client also sends a second message (such as blocking stored procedure function call) requesting that it be notified of any stored events of interest. Responsive to this second message, the logic within the server relational database checks to see whether any events have been stored, sends a notification message containing an identification of those stored events to the client, and then clears the stored events. These notifications concerning external events of interest may then be processed by a service management application executed within the client.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.