Invention Grant
US09292587B2 Systems and methods for database notification interface to efficiently identify events and changed data
有权
用于数据库通知界面的系统和方法,可有效识别事件和更改的数据
- Patent Title: Systems and methods for database notification interface to efficiently identify events and changed data
- Patent Title (中): 用于数据库通知界面的系统和方法,可有效识别事件和更改的数据
-
Application No.: US12841003Application Date: 2010-07-21
-
Publication No.: US09292587B2Publication Date: 2016-03-22
- Inventor: Jong J. Kann , Pierre P. Rafiq
- Applicant: Jong J. Kann , Pierre P. Rafiq
- Applicant Address: US FL Fort Lauderdale
- Assignee: CITRIX SYSTEM, INC.
- Current Assignee: CITRIX SYSTEM, INC.
- Current Assignee Address: US FL Fort Lauderdale
- Agency: Foley & Lardner LLP
- Agent Christopher J. McKenna; Shabbi S. Khan
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Systems and methods for providing notifications of changes made in a database table to a remote application is presented. The system and methods manage change notification of a table in a database by notifying an application registered to receive notifications of changes made to a database table. A database manager executing on a device may receive a request to register an application to be notified when a first table of a plurality of tables in a database is changed. The database manager may establish a notification table comprising fields of the first table and one or more additional fields for managing notification. The database manager may establish a trigger on the first table to invoke a trigger procedure to copy a changed row of the first table to the notification table. The database manager may create a rule for the notification table to notify registered applications when a new row is inserted into the notification table.
Public/Granted literature
- US20120023077A1 SYSTEMS AND METHODS FOR DATABASE NOTIFICATION INTERFACE TO EFFICIENTLY IDENTIFY EVENTS AND CHANGED DATA Public/Granted day:2012-01-26
Information query