Patent ID: 9292587
Filing Date: 2016-03-22
CPC Classification: G06F

Claim Text:
1. A method for managing a change notification of a table in a database, the method comprising: (a) receiving, by a database manager executing on a device, a request to register an application to be notified when a first table of a plurality of tables in a database is changed, the request comprising a schema name, a table name, a notification type and an application bit as input; (b) establishing, by the database manager, a notification table comprising copies of fields included in one or more entries of the first table and one or more additional fields for managing a notification, an additional field of the one or more additional fields comprising a bit-mask identifying one or more applications registered for notification of one or more tables, the notification table further comprising an update identifier including information corresponding to a particular update event corresponding to an update made to at least one entry of the first table and a transaction sequence field including a sequence of bits to record a sequence of update events occurring in a single transaction that caused the update made to at least one entry of the first table; (c) establishing, by the database manager, a trigger on the first table to invoke a trigger procedure to copy a changed row of the first table to the notification table; and (d) creating, by the database manager, a rule to notify the registered application when a new row is inserted into the notification table.